We are seeking an experienced Oracle PL/SQL Developer with strong expertise in Oracle database development, performance tuning, and SQL optimization. The ideal candidate will be responsible for designing, developing, and maintaining scalable database solutions while collaborating with application development and business teams to deliver high-quality enterprise applications.
Roles and Responsibilities
- Design, develop, test, and maintain complex Oracle PL/SQL packages, procedures, functions, triggers, and views.
- Develop and optimize complex SQL queries for high-performance enterprise applications.
- Analyze business requirements and translate them into efficient database solutions.
- Perform database performance tuning, query optimization, and execution plan analysis.
- Design and implement data models, database objects, and ETL processes.
- Develop and maintain stored procedures, indexes, materialized views, and database jobs.
- Support data migration, data validation, and database deployment activities.
- Troubleshoot production issues and resolve database-related defects.
- Collaborate with application developers, QA teams, business analysts, and DBAs throughout the software development lifecycle.
- Participate in code reviews and ensure adherence to database development standards and best practices.
- Create and maintain technical documentation for database objects and processes.
Required Skills
- 8–12 years of hands-on experience in Oracle Database development.
- Strong expertise in Oracle SQL and PL/SQL programming.
- Experience developing packages, procedures, functions, triggers, cursors, collections, and exception handling.
- Strong understanding of database design, normalization, and data modeling.
- Experience with query optimization, indexing strategies, and performance tuning.
- Knowledge of Oracle execution plans, SQL Trace, AWR, and performance diagnostics.
- Experience with Oracle versions 12c/19c or later.
- Experience in data migration, data integration, and ETL processes.
- Familiarity with Oracle Scheduler and database security concepts.
- Experience with version control tools such as Git or SVN.
- Strong debugging, analytical, and problem-solving skills.
Preferred Skills
- Experience with Oracle Forms & Reports (if applicable).
- Knowledge of Shell Scripting or Python for automation.
- Familiarity with Unix/Linux environments.
- Experience with cloud database platforms such as Oracle Cloud or AWS RDS for Oracle.
- Exposure to CI/CD pipelines and DevOps practices.
- Experience working in Agile/Scrum environments.
Qualifications
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
- Oracle Database certification is a plus.