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.
Skills Required
- 9+ years of hands-on database administration experience
- Strong hands-on experience with both Oracle and Microsoft SQL Server
- Experience implementing and managing disaster recovery solutions, including Data Guard, Always On, Log Shipping, or equivalent
- Working knowledge of Oracle Cloud Infrastructure for database hosting and management
- Expertise in database performance tuning at query, instance, and infrastructure levels
- Practical experience with database cloning and refresh processes
- Experience with database links, linked servers, and cross-platform connectivity
- Knowledge of RMAN and native SQL Server backup and restore tools
- Understanding of database security, patching, and upgrade methodologies
- Strong troubleshooting and production incident-resolution skills
- Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent practical experience
- Oracle OCP or Microsoft SQL Server certification
- Exposure to Exadata or Autonomous Database
- Scripting experience with Shell, PowerShell, or Python
- Experience with monitoring tools such as OEM, SolarWinds, or Zabbix
- Experience in a managed services or multi-client support environment
What We Do
Highstreet provides enterprise application, cloud enablement, and managed services – on premises, in the cloud or hybrid. At Highstreet, we know that you hire us to solve business problems. Our unmatched application expertise, technical know-how and results-driven approach have enabled more than 800 organizations to modernize their applications and infrastructure without disrupting their businesses. Take advantage of our unmatched application expertise and other resources to modernize your enterprise applications without disrupting your business. • Maximize the benefits of your enterprise applications • Optimize user competencies and skills • Ensure smooth transition to the cloud or new/upgraded applications Consulting Overview Highstreet, an Oracle Platinum Partner and Oracle Cloud Standard Partner, develops, integrates, and delivers comprehensive business and technology solutions for on-premise, cloud, and/or hybrid deployments. Highstreet’s experience spans over 20 years of hands-on planning, building, and managing PeopleSoft and Oracle EBS applications. From implementations and upgrades, cloud applications, hosting and managed services, to strategic roadmaps for your future state, our elite team of consultants supports you throughout the lifecycle of your applications. Managed Services Overview We offer a full range of managed services from hosting & infrastructure management to application operations and software support. Our service portfolio covers the entire IT operation stack and can help you manage the delivery of application services whether hosted at your facility, in our data centers, or on a public cloud. Our managed service offerings provide proactive control of your IT infrastructure and offload a significant burden of your day-to-day activities. We have more than two decades of demonstrated experience to help you maximize productivity, enhance efficiencies, and drive cost savings.
.jpeg)
