Senior Oracle PL/SQL Developer

Job Title: Senior Oracle PL/SQL Developer
Experience: 12+ Years
Location: [Onsite/Hybrid/Remote]

Job Summary

We are seeking an experienced Senior Oracle PL/SQL Developer with 12+ years of hands-on experience in designing, developing, optimizing, and supporting enterprise-grade database applications. The ideal candidate should possess deep expertise in Oracle Database, PL/SQL programming, performance tuning, data migration, and complex SQL development. Experience working in Agile environments and collaborating with cross-functional teams is highly desirable.

Key Responsibilities

• Design, develop, test, and maintain complex Oracle PL/SQL programs, packages, procedures, functions, triggers, and views.
• Develop and optimize high-performance SQL queries for large-scale transactional and analytical systems.
• Perform database performance tuning, query optimization, and troubleshooting using Oracle tools and best practices.
• Analyze business requirements and translate them into efficient database solutions.
• Design and implement data models and database objects based on application requirements.
• Support data migration, ETL processes, and integration activities involving Oracle databases.
• Conduct code reviews, enforce coding standards, and mentor junior developers.
• Collaborate with application developers, business analysts, QA teams, and DBAs throughout the software development lifecycle.
• Create and maintain technical design documents, deployment guides, and support documentation.
• Participate in production support activities, root cause analysis, and issue resolution.
• Ensure database security, data integrity, and compliance with organizational standards.
• Contribute to release planning, estimation, and Agile ceremonies.

Required Qualifications

• Bachelor''s degree in Computer Science, Information Technology, Engineering, or a related field.
• 12+ years of experience in Oracle database development.
• Strong expertise in Oracle PL/SQL, including packages, procedures, functions, triggers, collections, and exception handling.
• Extensive experience in writing complex SQL queries, joins, subqueries, and analytical functions.
• Hands-on experience with performance tuning using execution plans, SQL Trace, TKPROF, AWR, and Oracle tuning techniques.
• Experience working with Oracle 11g/12c/19c environments.
• Strong understanding of database design principles, normalization, and indexing strategies.
• Experience with data migration, bulk data processing, and ETL methodologies.
• Proficiency in using version control systems such as Git or similar tools.
• Excellent analytical, troubleshooting, and problem-solving skills.
• Strong verbal and written communication abilities.

Preferred Qualifications

• Experience with Oracle Forms and Reports.
• Knowledge of Shell Scripting and Linux/Unix environments.
• Experience with Oracle Data Integrator (ODI) or other ETL tools.
• Familiarity with Oracle APEX development.
• Exposure to cloud platforms such as Oracle Cloud Infrastructure (OCI) or AWS.
• Experience working in Agile/Scrum development environments.
• Oracle certifications will be an added advantage.

Technical Skills

• Oracle Database (11g/12c/19c)
• Oracle PL/SQL
• Advanced SQL
• Performance Tuning & Query Optimization
• Data Modeling
• Stored Procedures, Packages, Triggers, Functions
• AWR, TKPROF, Explain Plan
• SQL Loader / External Tables
• Shell Scripting (Preferred)
• Git / Version Control
• ETL Concepts and Data Migration

Soft Skills

• Leadership and mentoring capabilities
• Strong stakeholder management skills
• Ability to work independently and manage multiple priorities
• Excellent communication and collaboration skills
• Detail-oriented with a focus on delivering high-quality solutions

Preferred Experience: Candidates with experience supporting large-scale enterprise applications in banking, healthcare, insurance, government, or retail domains will be highly preferred.