Oracle PL SQL Developer

Job Title Senior Oracle PL/SQL Developer | Oracle Database | SQL | Performance Tuning | Data Integration Professional Summary Highly experienced Senior Oracle PL/SQL Developer with 11+ years of expertise in designing, developing, optimizing, and maintaining enterprise‑grade database solutions using Oracle technologies. Extensive experience in developing complex PL/SQL packages, stored procedures, functions, triggers, views, materialized views, and advanced SQL queries for high-volume transactional and data warehouse environments. Strong expertise in Oracle Database Administration support, performance tuning, query optimization, data migration, ETL processes, database security, and production support. Proven ability to collaborate with cross‑functional teams, understand complex business requirements, and deliver scalable, high‑performance database solutions across Finance, Banking, Insurance, Healthcare, Retail, Telecom, and Government domains. Experienced in the complete Software Development Life Cycle (SDLC) including requirement analysis, design, development, testing, deployment, production support, and performance optimization. Adept at troubleshooting critical production issues and implementing reliable, secure, and maintainable database solutions. Key Responsibilities Design, develop, test, deploy, and maintain complex Oracle PL/SQL applications. Develop high-performance Stored Procedures, Packages, Functions, Triggers, Cursors, Views, Materialized Views, and Sequences. Write efficient SQL queries for large-scale enterprise applications. Perform SQL and PL/SQL performance tuning using Explain Plan, SQL Trace, TKPROF, AWR, and Oracle tuning techniques. Optimize database performance through indexing strategies, partitioning, and query rewriting. Develop and maintain ETL processes for data migration and transformation. Build reusable database components following coding standards and best practices. Work with Oracle Forms, Reports, and Oracle APEX applications when required. Design normalized and denormalized database models. Develop data validation, auditing, logging, and exception‑handling mechanisms. Implement database security using roles, privileges, encryption, and auditing. Participate in database release management and deployment activities. Support production issues, perform root cause analysis, and provide timely resolutions. Collaborate with Business Analysts, Architects, QA teams, and application developers. Participate in Agile/Scrum ceremonies and sprint planning. Perform code reviews and mentor junior developers. Create technical design documents and database documentation. Ensure data integrity, consistency, and high availability of Oracle databases. Work with version control systems such as Git, SVN, or Azure DevOps. Support cloud-based Oracle database environments when applicable. Required Technical Skills Oracle Database Oracle 11g Oracle 12c Oracle 18c Oracle 19c Oracle 21c SQL & PL/SQL Advanced SQL Complex Joins Subqueries CTE Analytical Functions Window Functions MERGE Dynamic SQL Bulk Collect FORALL Collections Ref Cursor Exception Handling Packages Procedures Functions Triggers Materialized Views Views Sequences Performance Tuning Explain Plan SQL Trace TKPROF AWR Reports ASH Reports SQL Tuning Advisor Index Optimization Query Optimization Partitioning Parallel Processing Database Design Data Modeling ER Modeling Normalization Denormalization Constraints Referential Integrity ETL & Data Integration Oracle SQL Loader External Tables Oracle Data Pump Shell Scripting Informatica (Preferred) ODI (Preferred) Oracle Development Oracle Forms Oracle Reports Oracle APEX (Preferred) XML JSON REST APIs DevOps & Version Control Git SVN Azure DevOps Jenkins CI/CD Operating Systems Linux UNIX Windows Server Cloud (Preferred) Oracle Cloud (OCI) AWS RDS Oracle Azure Oracle Solutions Core Competencies Oracle PL/SQL Development Advanced SQL Programming Database Performance Tuning Query Optimization Data Migration ETL Development Production Support Database Design Data Warehousing Root Cause Analysis Release Management SDLC Agile Scrum Code Review Technical Leadership Stakeholder Communication Problem Solving Analytical Thinking Preferred Qualifications Bachelor''s or Master''s degree in Computer Science, Information Technology, or a related field. Oracle Certified Professional (OCP) certification is a plus. Experience working with Banking, Finance, Insurance, Healthcare, Retail, Telecom, or Government projects. Experience with Oracle Cloud Infrastructure (OCI) is preferred. Knowledge of DevOps and CI/CD practices is an advantage. #J-18808-Ljbffr