Senior Oracle PL SQL Developer

<p></p> <h3>Key Responsibilities</h3> <ul data-spread="false"> <li>Design, develop, and maintain complex Oracle database applications using PL/SQL.</li> <li>Develop and enhance Stored Procedures, Functions, Packages, Triggers, Collections, Dynamic SQL, Analytical Functions, and Autonomous Transactions.</li> <li>Perform advanced SQL and PL/SQL performance tuning using tools such as AWR, ADDM, ASH, SQL Trace, and Explain Plan.</li> <li>Design scalable database architectures, schema structures, indexing strategies, partitioning models, and high-availability solutions.</li> <li>Lead data modelling activities, including logical and physical data design, normalization, constraints, indexes, and governance standards.</li> <li>Design and implement ETL processes and data integration solutions for large-volume data environments.</li> <li>Manage Materialized Views, replication mechanisms, and distributed database environments.</li> <li>Execute data migration initiatives and large-scale data loading activities using SQL Loader and Oracle migration utilities.</li> <li>Develop and maintain UNIX shell scripts for automation, batch processing, and operational support.</li> <li>Support application database deployments, environment setup, release management, monitoring, backup, recovery, and production support activities.</li> <li>Provide L3 production support, perform root cause analysis, and resolve critical incidents within SLA timelines.</li> <li>Participate throughout the full Software Development Life Cycle (SDLC), from requirements gathering to post-production support.</li> <li>Work closely with business users, infrastructure teams, security, risk, compliance, legal, and finance stakeholders.</li> <li>Lead code reviews, establish development standards, and mentor junior developers.</li> <li>Produce technical documentation, solution designs, operational procedures, and governance artifacts.</li> <li>Drive database modernization initiatives and recommend innovative solutions to improve system performance, scalability, and reliability.</li> </ul> <h3>Mandatory Requirements</h3> <h4>Technical Skills</h4> <ul data-spread="false"> <li>Minimum 10 years of Oracle database development experience.</li> <li>Minimum 8 years of advanced PL/SQL development experience.</li> <li>Strong experience with Oracle 10g, 11g, 12c, 19c, and preferably Oracle Autonomous Database (ADB).</li> <li>Minimum 7 years of hands-on performance tuning and optimization experience.</li> <li>Strong expertise in database architecture, schema design, partitioning, indexing, and high-volume database solutions.</li> <li>Minimum 6 years of data modelling experience (logical and physical).</li> <li>Minimum 5 years of ETL and data integration experience; Talend exposure is advantageous.</li> <li>Experience managing Materialized Views and replication strategies.</li> <li>Strong experience with SQL Loader and database migration projects.</li> <li>Proven experience performing database migrations to Oracle environments.</li> <li>Minimum 4 years of UNIX Shell Scripting experience.</li> <li>Strong Application DBA exposure, including deployment, monitoring, backup, recovery, and production support.</li> <li>Minimum 5 years of L3 production support experience in mission-critical environments.</li> </ul> <p></p>