Oracle PL/SQL Engineer

Roles & Responsibilites:

• Database Development: Design, build, and maintain high-performance Oracle (11g/19c) and IBM DB2 stored procedures, functions, packages, and triggers.
• Performance Engineering: Analyze execution plans, identify bottlenecks, and resolve indexing gaps to optimize high-volume queries (with a proven ability to significantly reduce query response times).
• ETL & Data Pipelines: Build and maintain reliable ETL pipelines using PL/SQL, Informatica, and modern cloud data warehouses like Snowflake.
• Automation & CI/CD: Write Python and Unix shell scripts for data processing and workflow automation. Integrate database deployments into CI/CD pipelines using Jenkins and Bitbucket.
• Data Modeling: Design ER diagrams and normalized schemas to minimize redundancy, maintain data integrity, and support high-volume transaction processing.
• Reporting & Compliance Develop comprehensive MIS and regulatory reports coveri...