Oracle PL/SQL Developer

Senior Oracle Developer – Banking Client
Experience: 8-12 Years
Location: chennai/Pune
Employment Type: Full-Time
Industry: Banking / Financial Services
Job Summary
We are looking for a Senior Oracle Developer with strong hands-on experience in Oracle Development, Advanced SQL, PL/SQL, and Data Modeling to work on enterprise banking applications. The candidate will be responsible for designing and developing database solutions, building complex data-processing logic, optimizing performance, and supporting critical production applications.
Key Responsibilities
Design, develop, and maintain Oracle database solutions for enterprise banking applications.
Develop complex SQL and PL/SQL programs, including stored procedures, functions, packages, triggers, and cursors.
Design and maintain logical and physical data models based on business and application requirements.
Develop complex queries, joins, subqueries, CTEs, analytical functions, and data transformations.
Perform SQL/PLSQL performance tuning, query optimization, indexing, and execution-plan analysis.
Work with application teams to design efficient database interfaces and data flows.
Perform data analysis, reconciliation, validation, and troubleshooting of data-related issues.
Participate in requirements analysis, technical design, development, testing, deployment, and production support.
Troubleshoot production issues and perform root-cause analysis for database and application-related problems.
Ensure database solutions meet enterprise standards for performance, scalability, security, data quality, and reliability.
Collaborate with architects, application developers, QA, business teams, and offshore/onshore stakeholders in an Agile environment.
Required Skills
7+ years of strong Oracle Development experience.
Excellent hands-on experience with Oracle SQL and PL/SQL.
Strong experience with Data Modeling, including logical and physical data models.
Strong knowledge of database design, normalization, relationships, constraints, indexes, and partitioning.
Experience with complex SQL query optimization and performance tuning.
Strong understanding of stored procedures, packages, functions, triggers, cursors, and exception handling.
Experience working with large-volume enterprise data.
Strong debugging and production support experience.
Good understanding of SDLC and Agile/Scrum methodologies.
Strong communication and stakeholder collaboration skills.
Good to Have
Banking / Financial Services domain experience.
Experience with Oracle RAC, partitioning, performance tuning, or high-volume transaction systems.
Exposure to ETL/data integration and enterprise data platforms.
Experience working with distributed/onshore-offshore teams.
Knowledge of Unix/Linux scripting and Git/CI-CD.
Ideal Candidate
The ideal candidate should be a hands-on Senior Oracle Developer, not just a database support resource, with strong expertise in:
Oracle Development | SQL | PL/SQL | Data Modeling | Performance Tuning | Database Design | Production Support | Banking

Work arrangement
Hybrid