Senior Oracle Database Engineer – Assistant Manager

Overview

As an Oracle Database Engineer and Performance Tuning Specialist, provide SME support for in-house ETL applications, resolve developer problems, and maintain application resiliency.

What you'll do

• Analyze, troubleshoot, and optimize complex SQL queries to improve database performance.
• Perform advanced SQL and PL/SQL code reviews and tuning activities.
• Identify and resolve database bottlenecks, locking issues, deadlocks, and performance degradation.
• Monitor database performance using Oracle tools such as AWR, ASH, ADDM, and execution plans.
• Design, develop, test, and maintain complex SQL queries, stored procedures, packages, functions, triggers, and views.
• Develop scalable and efficient PL/SQL solutions adhering to coding standards and best practices.
• Support database design, data modelling, and schema optimization initiatives.
• Design, configure, implement, and support Oracle GoldenGate replication solutions.
• Monitor and troubleshoot replication processes, latency issues, and data synchronization challenges.
• Ensure data integrity and consistency across source and target.
• Provide production support for database-related incidents.
• Conduct root cause analysis and implement preventive measures.
• Participate in on-call support and critical issue resolution when required.
• Collaborate with application teams and infrastructure teams.

What you'll need

• 10+ years of hands-on experience in Oracle database technologies.
• Bachelor's degree in computer science or a related field.
• Expert Oracle programming and DDL & DML knowledge.
• Excellent knowledge of Oracle database objects, especially indexes, partitioning, and views, database architecture, and various components.
• Proven expertise in Oracle SQL performance tuning and query optimization.
• Hands-on experience with Oracle GoldenGate implementation and support.
• Strong experience in Oracle SQL and PL/SQL programming.
• Strong working knowledge of Exadata and cloud environments.
• Experience in troubleshooting complex databases and application performance issues.
• Strong written and verbal communication skills.
• Strong partnership and relationship-building skills.
• Exceptional organizational skills and attention to detail.
• Strong problem-solving ability.
• Excellent analytical, problem-solving, and communication skills.

Nice to have

• Knowledge of Azure and Snowflake services is a plus.
• Knowledge in the financial domain is a plus.

Details

• Location: Hyderabad, India.
• Hybrid work environment.
• On-call support and critical issue resolution may be required.