About this role
Job description for Senior DBA
Job description
We are looking for a Senior DBA with strong, hands-on expertise across both Oracle and Microsoft SQL Server environments. The ideal candidate will manage database availability, performance, and resiliency across on-premises, Oracle Cloud (OCI) infrastructure and AWS with a strong focus on disaster recovery, performance tuning, migration and routine operational database activities.
Key Responsibilities
-
Database Administration
-
Administer, monitor, and maintain Oracle (11g/12c/19c/21c) and MS SQL Server (2016/2019/2022) databases in production, staging, and development environments.
-
Perform installation, configuration, patching, and upgrades for both database platforms.
-
Manage database security, user roles, privileges, and access controls.
-
Disaster Recovery (DR)
-
Design, configure, and maintain DR setups including Oracle Data Guard (Physical/Logical Standby) and SQL Server Always On Availability Groups, Log Shipping, and Mirroring.
-
Conduct regular DR drills, failover/switchover testing, and document RTO/RPO compliance.
-
Troubleshoot replication lag, sync issues, and DR failover incidents.
-
Oracle Cloud Infrastructure (OCI)
-
Manage and support databases hosted on Oracle Cloud (Base Database Service, Exadata Cloud Service, Autonomous Database as applicable).
-
Handle OCI DBCS provisioning, backup configuration, patching, and monitoring.
-
Work with OCI networking, storage, and security constructs as they relate to database hosting.
-
Performance & Tuning
-
Perform SQL query tuning, execution plan analysis, and index optimization across both Oracle and SQL Server.
-
Monitor and tune instance-level parameters, memory, I/O, and wait events.
-
Proactively identify and resolve performance bottlenecks.
-
Routine DBA Operations
-
Perform database cloning (RMAN duplicate, Data Pump, SQL Server backup/restore-based cloning) for refresh and non-production environment builds.
-
Execute periodic database refresh activities between environments (Production → UAT/Dev), including data masking where required.
-
Configure, manage, and troubleshoot database links (Oracle DB Links, SQL Server Linked Servers) for cross-database/cross-platform connectivity.
-
Manage backup and recovery strategies (RMAN, native SQL backups) and validate recovery readiness.
-
Other
-
Experience in Migrating Database from On premises to Cloud, Cloud to Cloud, SQL to Oracle. Etc,.
-
Maintain documentation for configurations, DR runbooks, and standard operating procedures.
-
Collaborate with application, infrastructure, and cloud teams on database-related requirements.
-
Participate in on-call/rotational support as needed.
-
Required Skills & Qualifications
-
9+ years of hands-on DBA experience, with solid depth in both Oracle and MS SQL Server (not just exposure to one).
-
Strong experience setting up and managing DR solutions (Data Guard, Always On, Log Shipping, or equivalent).
-
Working knowledge of Oracle Cloud Infrastructure (OCI) for database hosting and management.
-
Proven expertise in database performance tuning (query, instance, and infrastructure level).
-
Practical experience with database cloning and database refresh processes.
-
Strong understanding of database links / linked servers and cross-platform connectivity.
-
Solid grasp of backup/recovery tools (RMAN, native SQL Server backup/restore).
-
Good understanding of database security, patching, and upgrading methodologies.
-
Strong troubleshooting and incident-resolution skills under production pressure.
-
Bachelor’s degree in computer science, Information Technology, or a related field (or equivalent practical experience).
-
Preferred / Nice to Have
-
Oracle OCP / Microsoft SQL Server certification.
-
Exposure to Exadata or Autonomous Database.
-
Scripting skills (Shell, PowerShell, or Python) for automation of DBA tasks.
-
Experience with monitoring tools (OEM, SolarWinds, Zabbix, etc.).
-
Experience working in a managed services / multi-client support environment.
-
Soft Skills
-
Strong communication skills to work with cross-functional and client teams.
-
Ability to independently own and drive DR and performance initiatives.
-
Comfortable working in a fast-paced, production-support environment.
-
Strong ownership mindset with the ability to prioritize under pressure during incidents.