Oracle Core DBA

Job Summary:

Skill Sets Required (Must Have):

• Hands-on Experience on 12c, 19c and above
• Cross-platform Upgrade experience (Linux, UNIX, Windows)
• Manage RAC DB in the aspect of (installation, support, troubleshooting).
• Manage DR / Active DataGuard replication (installation, support, troubleshooting).
• Write new shell scripts, able to easily understand and update existing shell scripts.
• Highly skilled in Troubleshooting techniques especially performance related issues, ability to analyze explain plans, AWRs, ability to use SQL Plan Baselines.
• Refresh of non-prod environments using RMAN & data pump tools.
• Review daily DB health check reports, alerts, audit breaches to proactively spot, highlight and fix defects, and apply security hardening before the system get impacted.
• Work on incidents and reported problems coming from ITSD and different departments.
• Experience with OEM Configuration across multiple databases
• Expertise in Performance Tuning
• Data migration from/to EC2 & RDS AWS instances.

• Manage all aspects of Goldengate replication (installation, support, troubleshooting).
• Ability to reproduce production issues related to performance, RAC and Goldengate on non-prod environments and experiment and test the solutions.
• Hands on experience on SQL Server is a plus to handle daily SQL Server tasks.

• Write detailed, easy to follow technical documents.
• Having the skill of sharing knowledge and can easily convey technical details during technical discussions.
• On-call support and availability for attending application deployments early morning.
• Manage Oracle databases on RDS.
• Understand PL/SQL codes.

• Min. 5yrs relevant experience
• B.Tech Comp. Sc / MCA Graduates preferred
• Oracle Certified Professionals (OCP) Certification preferred