Senior Oracle Developer

Sass Innovations; Pune District, Chennai; Hybrid; INR 1,500,000 - 2,200,000; Full time

Job summary

Sass Innovations in Pune, Maharashtra, India is seeking an experienced Oracle PL/SQL developer to design and optimize database solutions for banking applications.

The role requires hands-on coding, complex SQL, performance tuning, and strong data integrity controls. Onsite work arrangement includes three days per week in the office and collaboration with distributed teams.

Qualifications

• 8+ years of hands-on Oracle development with strong PL/SQL coding expertise.
• Advanced SQL, query optimization, indexing, execution-plan analysis, and performance tuning.
• Experience handling complex data logic and troubleshooting enterprise database applications.
• Strong attention to data integrity, auditability, secure handling, and controlled releases.
• Mandatory banking/financial-services domain experience.

Responsibilities

• Develop and maintain PL/SQL packages, procedures, functions, triggers, cursors, and exception-handling logic.
• Write complex SQL queries using joins, CTEs, analytical functions, and data manipulation operations.
• Analyze execution plans and tune queries through indexing, query rewrites, and efficient data-access strategies.
• Implement data validation, reconciliation, transaction handling, and data-integrity controls.
• Investigate database defects, identify root causes, and implement tested fixes in coordination with application teams.
• Work with business, QA, and engineering stakeholders to convert requirements into reliable database solutions.

Skills

Oracle PL/SQL

Advanced SQL

Performance tuning

Data integrity

Banking domain experience

Job description

ROLE OVERVIEW

Develop and optimize Oracle database solutions supporting banking and financial-services applications. This is a hands‑on coding role requiring strong PL/SQL development, complex SQL, performance tuning, and the ability to work with critical business data.

KEY RESPONSIBILITIES

• Develop and maintain complex PL/SQL packages, procedures, functions, triggers, cursors, and exception-handling logic.
• Write complex SQL queries using joins, CTEs, analytical functions, and data manipulation operations.
• Analyze execution plans and tune queries through indexing, query rewrites, and efficient data-access strategies.
• Implement data validation, reconciliation, transaction handling, and data-integrity controls.
• Investigate database defects, identify root causes, and implement tested fixes in coordination with application teams.
• Work with business, QA, and engineering stakeholders to convert requirements into reliable database solutions.

REQUIRED SKILLS & EXPERIENCE

• 8+ years of hands‑on Oracle development with strong PL/SQL coding expertise.
• Advanced SQL, query optimization, indexing, execution-plan analysis, and performance tuning.
• Experience handling complex data logic and troubleshooting enterprise database applications.
• Strong attention to data integrity, auditability, secure handling, and controlled releases.
• Mandatory banking/financial-services domain experience.

Work Arrangement: Candidates must be available to work onsite three days per week and collaborate with distributed teams.