Manage Oracle and Microsoft SQL Server databases across on-premises and OCI environments. Responsibilities include administration, patching, upgrades, security, performance tuning, backup and recovery, cloning, refreshes, database links, and disaster recovery using Data Guard and SQL Server availability technologies. Conduct DR testing, troubleshoot production incidents, maintain runbooks, collaborate with technical teams, and participate in on-call support.
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.
Similar Jobs
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Build and scale machine learning systems for search, including ranking models, feature engineering, model deployment, monitoring, experimentation, and online inference. Design fault-tolerant distributed infrastructure, optimize search latency and throughput, and develop reliable ML services from proof of concept through production. Collaborate across engineering and product teams, communicate technical decisions, review code, document systems, and mentor junior engineers.
Top Skills:
AWSAzureCi/CdDistributed SystemsGCPGoJavaKotlinMachine LearningMlopsPythonTypescript
Digital Media • Information Technology • News + Entertainment
Designs and customizes software applications, manages releases, gathers requirements, and improves functionality and user experience. Collaborates with stakeholders, QA, and cross-functional teams to deliver reliable solutions. Tracks performance metrics, maintains technical documentation, researches industry trends, and leads development, prototyping, and design sessions. Mentors junior engineers and exercises independent judgment while supporting variable work schedules.
.jpeg)
Artificial Intelligence • Hardware • Information Technology • Machine Learning
Manage SSD quality and reliability during high-volume production, including reliability evaluations, deviation management, containment, failure analysis, data analysis, and outgoing quality monitoring. Develop evaluation plans, assess material dispositions, analyze MES data, report reliability metrics, and collaborate with engineering, manufacturing, quality, and customer teams globally. Provide technical consultation, training, audit and customer support, while using generative and agentic AI tools to improve engineering workflows.
Top Skills:
Agentic AiChatgptClaudeDevice PhysicsGenerative AiMamMicron Manufacturing Execution System (Mes)Microsoft CopilotNandNvmePcieSataSemiconductor Reliability StatisticsSolid State Drives (Ssd)Wafer Fabrication
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
