Senior DBA
Description
Position Summary
The Senior Database Administrator is responsible for the architecture, administration, security, performance, and availability of Resolve Tech Solutions' enterprise database environments. This role leads the management of Microsoft SQL Server databases supporting business-critical applications across on-premises and cloud platforms, ensuring high availability, disaster recovery readiness, optimal performance, and compliance with organizational standards. The Senior Database Administrator partners closely with Infrastructure, Cloud, Application Development, DevOps, Security, and business stakeholders to design scalable database solutions, troubleshoot complex issues, automate administrative processes, and drive continuous improvement initiatives that enhance reliability, security, and operational efficiency.
Key Responsibilities
- Administer, configure, upgrade, and maintain enterprise Microsoft SQL Server environments across Development, QA, UAT, and Production
- Design, implement, and support high availability and disaster recovery solutions, including Always On Availability Groups, Failover Cluster Instances (FCI), replication, backup, recovery, and disaster recovery testing
- Monitor and optimize database performance through proactive tuning of queries, indexes, execution plans, storage, memory, CPU, I/O, TempDB, and transaction logs
- Lead database lifecycle activities including provisioning, migrations, upgrades, patching, capacity planning, database cloning, and decommissioning
- Implement and maintain database security by managing authentication, permissions, encryption, auditing, vulnerability remediation, and compliance with organizational security standards
- Troubleshoot complex database performance, availability, replication, backup, restore, and connectivity issues, performing root cause analysis and implementing long-term corrective actions
- Develop automation solutions utilizing T-SQL, PowerShell, or similar scripting technologies to improve operational efficiency, monitoring, maintenance, and database administration
- Collaborate with Infrastructure, Cloud, Networking, DevOps, and Application Development teams to support new implementations, cloud migrations, database modernization efforts, and enterprise initiatives
- Develop and maintain technical documentation, operational procedures, disaster recovery documentation, and database administration standards
- Evaluate emerging database technologies, recommend architectural improvements, and mentor junior database administrators and technical team members on database best practices
- Other duties as assigned
Qualifications
- Bachelor's degree in Computer Science, Information Technology, or a related field, or an equivalent combination of education and experience.
- 7+ years of experience administering enterprise Microsoft SQL Server environments supporting business-critical applications.
- Advanced knowledge of SQL Server administration, performance tuning, backup and recovery, high availability, disaster recovery, security, and database optimization.
- Experience with SQL Server Always On Availability Groups, Failover Cluster Instances, replication, T-SQL, and SQL Server Management Studio (SSMS).
- Experience supporting SQL Server in on-premises and cloud environments, including Microsoft Azure and/or AWS.
- Working knowledge of Windows Server, Active Directory, scripting/automation (PowerShell or T-SQL), and enterprise infrastructure concepts.
- Strong analytical, troubleshooting, communication, and organizational skills, with the ability to lead complex database initiatives and mentor junior team members.
- Microsoft SQL Server and/or Azure database certifications are preferred.
- Alignment with RTS Core Values
Skills
Sign in to read and join the discussion.