Senior Oracle PL/SQL Developer

Day to Day :

• Architect, design, and implement robust, scalable, and high-performance Oracle database solutions to support mission-critical business applications.

• Develop, maintain, and optimize complex PL/SQL packages, stored procedures, functions, and triggers using advanced features such as bulk collections, dynamic SQL, autonomous transactions, analytical functions, partitioning, and materialized views.

• Perform advanced SQL and PL/SQL performance tuning by analyzing execution plans and leveraging tools such as AWR, ASH, ADDM, SQL Trace, and Explain Plan to resolve performance bottlenecks.

• Design and maintain logical and physical data models, ensuring adherence to normalization standards, indexing strategies, constraints, and data governance policies.

• Develop and manage ETL processes and data migration strategies for large volumes of data, including the use of tools such as Talend and SQL Loader.

• Manage data replication and distributed database environments through materialized views and Oracle-supplied packages.

• Participate actively in Agile ceremonies including sprint planning, daily stand-ups, sprint reviews, and retrospectives, while managing assignments through Jira and Confluence.

• Lead database-related activities across the full Software Development Life Cycle (SDLC), from requirements gathering and design through development, testing, deployment, and post-implementation support.

• Provide advanced Level 3 production support, including root cause analysis and real-time resolution of critical database issues.

• Utilize UNIX shell scripting for automation, scheduling, and operational support tasks.

• Evaluate and implement detailed business, functional, and non-functional requirements, including performance, recovery, audit, data security, and scalability considerations.

• Conduct code reviews and mentor junior and mid-level developers, promoting best practices and maintaining high development standards.

• Collaborate with cross-functional teams including IT risk, security, infrastructure, legal, and finance to ensure compliance and operational alignment.

• Ensure all database solutions comply with regulatory requirements, data governance standards, and internal risk management frameworks.

• Proactively identify risks, highlight potential concerns, and recommend mitigation strategies to safeguard system stability and data integrity.

• Continuously evaluate emerging Oracle technologies and industry trends, recommending improvements to enhance database architecture, performance, and data engineering practices.