Job Summary Role: Oracle L2 Database Administrator Location: Atlanta, GA & Dallas, TX Support Model: 24/7 Operations Experience: 6-10 years Education: - Candidate must have bachelor's degree. (Mandatory)
Skills and Experience - Hands-on experience administering Oracle databases in production environments, including instance startup/shutdown, parameter tuning, and routine operational maintenance.
- Strong working knowledge of Oracle operational maintenance, including RMAN full and incremental backups, restore operations, archive log management, optimizer statistics gathering, and scheduled health checks.
- Ability to perform routine Oracle health diagnostics and remediation, including identifying tablespace and storage growth risks, validating database integrity, and proactively addressing common availability and performance issues.
- Ability to execute approved Oracle changes (installations, upgrades, PSU/patch application, and configuration updates) by following documented runbooks, validation steps, and rollback procedures.
- Working understanding of ITSM processes using ServiceNow, including Incident, Problem, Change, and Request Management, with accurate ticket documentation and timely escalation to L3 Oracle DBAs.
- Practical experience with Oracle performance monitoring and basic tuning, including AWR/ASH analysis, slow SQL identification, wait-event diagnostics, and monitoring CPU, memory, and I/O contention.
- Ability to package and escalate complex SQL, optimizer, and performance issues to L3 DBAs with relevant diagnostics and supporting analysis.
- Hands-on execution of Oracle backup validation and restore activities, including support for recovery and disaster recovery exercises under L3 guidance.
- Experience supporting Oracle security operations, including user and role management, privilege administration, password and profile enforcement, and execution of approved security controls.
- Experience supporting audit and compliance activities for Oracle env., including evidence collection, remediation execution, and controlled documentation updates.
- This role requires providing 24x7 operational support and working in rotational shifts
Recommended Certifications - Oracle Database Administration Certified Professional (OCP 19c)
- Oracle Cloud Infrastructure (OCI) Database Specialist is an advantage
- Windows 2019/22/ Redhat Linux 8.x/9.x
- ITIL V4
The pay range for this role is $85,000- $95,000 per annum including any bonuses or variable pay. Tech Mahindra also offers benefits like medical, vision, dental, life, disability insurance and paid time off (including holidays, parental leave, and sick leave, as required by law). Ask our recruiters for more details on our Benefits package. The exact offer terms will depend on the skill level, educational qualifications, experience and location of the candidate.
