Oracle Core DBA

ECS | Enterprise Change Specialists; Hyderabad; On-site; INR 2,500,000 - 4,000,000; Full time

Job summary

ECS | Enterprise Change Specialists is seeking an experienced Oracle Core DBA to join our Oracle practice team in Hyderabad. You will be responsible for managing, maintaining, and optimizing Oracle databases to ensure high availability, performance, and security.

The ideal candidate has 5+ years of relevant experience with 12c/19c+, RAC, Data Guard, RMAN/Data Pump, and strong shell scripting abilities along with performance tuning expertise.

Qualifications

• Min. 5 years of relevant Oracle DB experience.
• Exposure to 12c/19c and above versions.
• Strong RAC, Data Guard, RMAN and Data Pump expertise.
• Shell scripting ability to automate tasks.
• Proficient in performance tuning with AWR analysis.
• Experience with security hardening and health checks.
• Knowledge of Oracle OEM for monitoring/management.
• Data migration to/from AWS RDS/EC2 is a plus.

Responsibilities

• Manage, maintain and optimize Oracle databases for availability and performance.
• Administer RAC databases, including installation, support and troubleshooting.
• Handle DR and Active DataGuard replication setup and support.
• Write and update shell scripts; analyze explain plans and tune performance.
• Review daily health checks, alerts and audit breaches; implement fixes.
• Handle incidents from ITSD and other departments; provide on-call support.
• Manage Oracle databases on RDS, and understand PL/SQL codes.

Skills

Oracle 12c/19c

RAC Management

Data Guard

Shell scripting

Performance tuning

AWR analysis

RMAN & Data Pump

Security hardening

OEM configuration

Cloud AWS RDS/EC2

PL/SQL knowledge

Education

B.Tech Comp. Sc / MCA

OCP Certification

Tools

Goldengate

RMAN

Data Pump

Oracle OEM

RDS/AWS

SQL Server (nice-to-have)

Job description

Job Summary:

We are seeking an experienced and skilled mid-Senior Oracle Core Database Administrator (DBA) to join our Oracle practice team. The ideal candidate will be responsible for the management, maintenance, and optimization of our Oracle databases, ensuring high availability, performance, and security.

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.

Skill Sets Required (Good-To-Have):

• 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.

Other Responsibilities:

• 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.

Qualifications & Experience:

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