Senior Oracle PL/SQL Developer

Senior Oracle PL/SQL Developer

Job Summary

We are seeking an experienced Senior Oracle PL/SQL Developer with 12+ years of expertise in designing, developing, optimizing, and maintaining enterprise-level database applications using Oracle technologies. The ideal candidate should possess strong hands-on experience in Oracle Database, PL/SQL programming, performance tuning, data modeling, ETL processes, and database administration support within large-scale environments.

Key Responsibilities

• Design, develop, test, and maintain complex Oracle PL/SQL programs, packages, procedures, functions, triggers, and views.
• Develop high-performance database solutions for mission-critical business applications.
• Analyze business requirements and translate them into technical database solutions.
• Create and optimize SQL queries for large-volume transactional and data warehouse systems.
• Perform query optimization and database performance tuning.
• Develop and support ETL processes for data integration and migration activities.
• Design logical and physical data models based on business requirements.
• Collaborate with business analysts, architects, developers, QA teams, and stakeholders.
• Conduct code reviews and ensure adherence to coding standards and best practices.
• Troubleshoot production issues and provide root cause analysis.
• Support database deployments, release management, and change control processes.
• Develop and maintain technical documentation.
• Participate in Agile/Scrum development activities.
• Mentor junior developers and provide technical leadership.

Required Qualifications

• Bachelor''s Degree in Computer Science, Information Systems, Engineering, or related field.
• 12+ years of experience in Oracle Database Development.
• Strong expertise in Oracle PL/SQL programming.
• Extensive experience with:
  • Stored Procedures
  • Functions
  • Packages
  • Triggers
  • Cursors
  • Materialized Views
  • Collections
  • Dynamic SQL
  • Exception Handling
• Strong SQL query writing and optimization skills.
• Experience with Oracle Database versions 11g, 12c, 18c, 19c, and higher.
• Expertise in Performance Tuning using:
  • Explain Plans
  • AWR Reports
  • SQL Trace
  • TKPROF
  • SQL Tuning Advisor
• Strong understanding of:
  • Data Modeling
  • Data Warehousing Concepts
  • Normalization and Denormalization
  • Indexing Strategies
• Experience working with large-scale databases containing millions of records.

Preferred Skills

• Oracle Forms and Reports.
• Oracle APEX Development.
• Oracle BI Publisher.
• Shell Scripting (Unix/Linux).
• Python Scripting.
• ETL Tools:
  • Informatica PowerCenter
  • IICS
  • ODI (Oracle Data Integrator)
  • Talend
• Cloud Platforms:
  • Oracle Cloud Infrastructure (OCI)
  • AWS
  • Azure
• Experience with REST APIs and Web Services integration.
• Git, Jenkins, CI/CD implementation.
• Knowledge of Data Migration and Data Governance frameworks.

Database Expertise

• Oracle RAC
• Oracle ASM
• Partitioning
• Data Guard
• GoldenGate
• Database Security
• Backup and Recovery Concepts

Soft Skills

• Excellent communication and stakeholder management skills.
• Strong analytical and problem-solving abilities.
• Ability to work independently and lead technical initiatives.
• Experience working in Agile/Scrum environments.
• Strong documentation and presentation skills.

Nice to Have Certifications

• Oracle Certified Professional (OCP)
• Oracle Database SQL Certified Associate
• Oracle Cloud Infrastructure Certification