Job Description
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.
