Senior Oracle PL SQL Developer

Responsibilities

• Design, develop, and maintain complex Oracle database applications using PL/SQL.
• Develop and enhance Stored Procedures, Functions, Packages, Triggers, Collections, Dynamic SQL, Analytical Functions, and Autonomous Transactions.
• Perform advanced SQL and PL/SQL performance tuning using tools such as AWR, ADDM, ASH, SQL Trace, and Explain Plan.
• Design scalable database architectures, schema structures, indexing strategies, partitioning models, and high-availability solutions.
• Lead data modelling activities, including logical and physical data design, normalization, constraints, indexes, and governance standards.
• Design and implement ETL processes and data integration solutions for large-volume data environments.
• Manage Materialized Views, replication mechanisms, and distributed database environments.
• Execute data migration initiatives and large-scale data loading activities using SQL Loader...