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.