Highstreet IT Solutions
Website:
highstreetit.com
Job details:
Job Description
Job description for Senior DBA
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
We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.
Click on Apply to know more.
