Position : Oracle PL/SQL Developer

Experience : 5+ Years

Location : Bangalore - Onsite

Employment Type : Full-Time

- Immediate joiners, Serving Notice Only

- Local to Bangalore Only

- Interview Mode: Virtual

Role Overview :

Looking for an experienced Oracle PL/SQL Developer with 5+ years of expertise in Oracle database development, SQL query optimization, and performance tuning. The candidate will be responsible for designing, developing, and maintaining scalable database solutions, optimizing complex SQL queries, and supporting large-scale data processing and ETL operations in an enterprise environment.

The ideal candidate should have strong hands-on experience in PL/SQL programming, database performance optimization, data migration, and production support.

Key Responsibilities :

- Design, develop, and maintain Oracle PL/SQL programs, including stored procedures, functions, packages, and triggers.

- Write, optimize, and troubleshoot complex SQL queries to improve database performance.

- Perform database performance tuning using AWR reports, Explain Plans, indexing, and query optimization techniques.

- Develop and maintain scalable database solutions for enterprise applications.

- Design and implement data models and database structures.

- Work on ETL development, bulk data processing, and large-scale data migration activities.

- Utilize PL/SQL bulk processing techniques such as BULK COLLECT and FORALL.

- Troubleshoot and resolve production database issues, ensuring system stability and performance.

- Develop and maintain Unix/Linux shell scripts to automate database-related operations.

- Participate in code reviews and follow database development best practices.

- Collaborate with developers, QA teams, business analysts, and other stakeholders.

- Support database enhancements, performance improvements, and ongoing application maintenance.

- Mentor junior developers and provide technical guidance wherever required.

Required Technical Skills :

- Strong hands-on experience in Oracle SQL and PL/SQL development.

- Expertise in stored procedures, functions, packages, and triggers.

- Strong understanding of SQL query optimization and performance tuning.

- Experience with AWR reports, Explain Plan, indexing, and execution plan analysis.

- Good knowledge of database design, data modeling, and database optimization.

- Experience in ETL development, data migration, and large-volume data processing.

- Hands-on experience with BULK COLLECT and FORALL.

- Working knowledge of Unix/Linux shell scripting.

- Experience with version control tools such as Git or SVN.

- Strong debugging, troubleshooting, and analytical skills.

- Candidates with strong hands-on experience in Oracle PL/SQL development, complex SQL query optimization, database performance tuning, and large-scale ETL/data migration projects will be preferred.