Database Administration Engineer

L2 Operations Engineer Database (DBA)

Support level: L2 Operations Domain: Database Administration

Scope: Oracle, SQL Server, and Cloud Databases – hosted on public cloud (AWS preferred; Azure/GCP acceptable), via IaaS or PaaS/managed services; Patching, Backup & Recovery, Capacity & Performance

Support the client's databases in the public cloud (AWS preferred; Azure or GCP also considered), whether self-managed on IaaS or running as managed/PaaS services, in a 24x7 operations environment. Resolve L2 incidents and escalate to L3 when needed.

Process

• End-to-end incident management, from L1/L1.5 escalation to closure, following documented runbooks and SOPs.
• Monitor database and infrastructure alerts; triage and respond per standard procedures.
• Participate in On-Call/shift rotation for 24x7 coverage.
• Keep the database inventory aligned with the CMDB.
• Build, install, and configure new database instances (EC2-hosted or PaaS) from service requests to client standards. Run QA checks and document exceptions for client review.
• Patch databases on the client's rollout schedule, including urgent patches for critical vulnerabilities. Carry out minor upgrades, migrations, and fix packs.
• Perform patching and dev/test clones for Oracle E-Business Suite, where applicable.
• Run backups and restores (point-in-time and object-level). Report and fix backup failures immediately; participate in periodic restore/DR testing.
• Tune databases, SQL, and schemas, including indexes. Troubleshoot job failures and space alerts.
• Support capacity planning; FinOps Efforts, provide monthly capacity and performance reports.
• Run proactive database health checks as part of routine operations.
• Provision and manage access as per standard guidelines, and maintain audit/security logs, documenting exceptions as needed.
• Build scripts to automate routine database changes.
• Raise and implement changes through the client's change management process.
• Keep ServiceNow tickets current, with clear resolution and closure notes.
• Join RCA reviews; update SOPs and knowledge-base articles.
• Support migration of workloads into cloud-managed database services.
• Decommission databases per process.

Tools/Databases

• Oracle Database (EC2-hosted or RDS)
• Microsoft SQL Server (EC2-hosted or RDS)
• Oracle E-Business Suite (EC2)
• AWS managed database services (RDS/Aurora or equivalent) ; Azure or GCP managed database services also considered
• PostgreSQL, Amazon DocumentDB, OpenSearch (preferred)
• Databricks, BigQuery exposure (a plus)
• Backup and recovery tools (Quest LiteSpeed, RMAN, AWS Backups/Snapshots)
• Enterprise monitoring tools (DataDog)
• ServiceNow

Technologies

• Oracle and/or SQL Server administration (EC2 and/or PaaS)
• Cloud database operations (AWS preferred; Azure/GCP acceptable)
• Backup and recovery
• Patching and upgrades
• Performance tuning
• Capacity planning
• Database security and audit
• Basic FinOps / cost-optimization awareness (a plus)
• SQL, PL/SQL, PowerShell, Shell, or Python scripting

Experience

• 10+ years of hands-on database administration experience, with recent experience operating cloud database infrastructure on IaaS and PaaS/managed services (AWS preferred; Azure or GCP also acceptable)
• Experience working in a 24x7 support environment
• Experience with ITSM tools and incident/problem/change processes
• Clear written and spoken English

Certifications

AWS foundational certification or equivalent (e.g., Cloud Practitioner) is a nice-to-have.