Job Description
Title: Oracle PL/SQL developer
Location 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 datasets
- Debug 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 required
Required Skills & Qualifications:
- Bachelors 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 necessary
- Experience 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).
Job Tags
Part time, Local area,