Oracle PL/SQL developer

Title: Oracle PL/SQL developerLocation – Houston, Texas (Onsite position)(Local candidates are more preferrable)Role Summary:We are looking for a seasoned Oracle PL/SQL developer with 8+ years of experience to design, develop, optimize, and maintain backend database logic — strictly on Oracle + PL/SQL + SQL. This is not a UI/reporting or forms-based role; the focus is purely on database backend, data processing, stored procedures, and performance.Key Responsibilities:Design, develop, test, and maintain complex PL/SQL code — packages, procedures, functions, triggers — as required by business logic.Write, optimize and maintain SQL queries (complex joins, bulk operations, set operations) for high performance and scalability.Design and maintain database schema: tables, indexes, views, constraints. Assist in logical/physical data modeling as needed.Analyze and translate business requirements into technical design and PL/SQL/SQL implementation. Interact with business stakeholders / functional leads / business analysts for requirement gathering.Perform performance tuning and optimization — reviewing execution plans, rewriting slow queries, adding proper indexing / partitioning / optimizations for large datasetsDebug and troubleshoot production issues, data integrity problems, and performance bottlenecks. Provide support and maintenance for database-related defects/incidents.Work with cross-functional teams (other developers, QA/testers, operations/DBA teams) to integrate backend logic with application layers, but not UI or reporting layers — strictly database/backend logic.Follow SDLC — from requirements gathering to design, development, testing (unit/integration), deployment, documentation, and maintenance/production support.(Optional / Depending on project) Handle data-migration, ETL or bulk data loading operations via PL/SQL or Oracle utilities (e.g. SQL*Loader, Data Pump) if requiredRequired Skills & Qualifications:Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent).Minimum 8 years of hands-on experience in Oracle database development using PL/SQL and strong SQL. (Preferably including writing packages, procedures, complex queries, triggers, functions, etc.)Deep understanding of relational database concepts, Oracle database architecture, schema design, indexing, performance optimization.Strong skills in writing clean, maintainable, efficient PL/SQL and SQL code. Ability to optimize queries and PL/SQL for performance and scalability (bulk operations, collections, proper indexing, partitioning where necessaryExperience in debugging, troubleshooting, and resolving production database issues; excellent problem-solving and analytical skills.Familiarity with SDLC practices, code reviews, technical documentation, version control, deployment processes.Good communication skills — ability to understand business requirements and collaborate across teams.Nice-to-Have:Previous experience working on large-scale/enterprise-level applications or high-volume DB systems.Experience with Oracle utilities and tools like SQL*Loader, Data Pump, or database migration tools (for data migration/ETL).Experience in database performance tuning, index management, partitioning, and optimizing PL/SQL for large data sets.Familiarity with UNIX/Linux environment and shell scripting (if project involves batch jobs or OS-level scripting).Experience mentoring or leading a team of developers (for senior / lead roles).