SQL Database Administrator
ARCHIVED
We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.
Position Summary:
Resolve Tech Solutions (RTS) is seeking an experienced SQL Database Administrator (SQL DBA) to manage, maintain, secure, and optimize Microsoft SQL Server database environments supporting mission-critical enterprise applications. This role is responsible for database administration, performance tuning, backup and recovery, high availability, disaster recovery, security, monitoring, and lifecycle management of SQL Server databases across on-premises and cloud environments. The ideal candidate has strong experience administering enterprise SQL Server environments and collaborates closely with infrastructure, application development, cloud, DevOps, and business teams to ensure database reliability, scalability, security, and optimal performance. Key ResponsibilitiesSQL Server Database Administration Install, configure, upgrade, and maintain Microsoft SQL Server environments. Administer SQL Server instances across Development, QA, UAT, and Production environments. Configure and maintain SQL Server Always On Availability Groups, Failover Cluster Instances (FCI), and replication technologies. Perform database provisioning, migrations, cloning, and lifecycle management. Monitor database health, storage utilization, availability, and system performance. Manage SQL Server Agent jobs, maintenance plans, and scheduled tasks. Support SQL Server environments hosted on-premises and in Microsoft Azure or AWS.Performance Monitoring & Optimization Monitor and optimize SQL Server performance. Analyze execution plans and optimize slow-running queries. Identify blocking, deadlocks, and resource bottlenecks. Perform index maintenance and optimization. Optimize database design, partitioning, and storage utilization. Monitor CPU, memory, I/O, TempDB, and transaction log performance. Recommend improvements to database architecture for scalability and efficiency.
Backup, Recovery & Disaster Recovery:
Develop and maintain enterprise backup and recovery strategies.
Configure and manage full, differential, and transaction log backups.
Perform database restores and validate recovery procedures.
Support disaster recovery planning and annual DR testing.
Ensure Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO) are consistently met.
Implement and maintain backup automation and retention policies.
Security & Compliance:
Implement SQL Server security best practices.
Manage database users, roles, permissions, and authentication.
Configure Transparent Data Encryption (TDE), Always Encrypted, and SSL/TLS encryption where applicable.
Monitor database auditing and compliance requirements.
Support vulnerability remediation and security patching.
Ensure databases comply with organizational governance and regulatory standards.
System Maintenance:
Apply SQL Server service packs, cumulative updates, and patches.
Perform regular database health checks and preventative maintenance.
Monitor database growth and capacity planning.
Manage storage expansion and optimize file configurations.
Perform database consistency checks using DBCC utilities.
Coordinate maintenance activities with infrastructure and application teams.
Troubleshooting & Support:
Diagnose and resolve SQL Server performance and availability issues.
Support production incidents and participate in on-call rotations as required.
Perform root cause analysis for recurring database issues.
Troubleshoot replication, Always On, backup, restore, and connectivity issues.
Collaborate with infrastructure, cloud, networking, and application teams to resolve complex technical problems.
Documentation & Continuous Improvement:
Develop and maintain SQL Server administration documentation.
Create operational runbooks and standard operating procedures.
Identify opportunities for automation using PowerShell, T-SQL, or Azure Automation.
Recommend database modernization initiatives and cloud migration strategies.
Participate in continuous improvement initiatives focused on database reliability and operational excellence.
Required Qualifications:
- Experience4–7 years of Microsoft SQL Server database administration experience.
- Experience supporting enterprise production SQL Server environments.
- Experience implementing or supporting SQL Server migrations and upgrades.
- Experience working with High Availability and Disaster Recovery (HA/DR) solutions.
- Experience supporting business-critical databases in 24x7 production environments.
- Technical SkillsStrong experience administering Microsoft SQL Server 2016, 2019, and/or 2022.Expertise in:
- SQL Server Installation and ConfigurationSQL Server Always On Availability Groups
- Failover Cluster Instances (FCI)
- Database Replication
- Backup and Recovery
- Database Security
- Performance Monitoring and TuningIndex Optimization
- Query Performance Analysis
- Database Maintenance PlansSQL Server AgentSSMS (SQL Server Management Studio)SQL Server Profiler
- Extended Events
- Dynamic Management Views (DMVs)T-SQL development and troubleshooting
- Experience with Windows Server administration.
- Familiarity with Active Directory authentication and service accounts.
- Experience with virtualization technologies such as VMware or Hyper-V.Knowledge of storage, networking, and enterprise infrastructure concepts.
Preferred Qualifications:
- Microsoft Certified: Azure Database Administrator Associate (DP-300) or equivalent SQL Server certifications.
- Experience administering Azure SQL Database, Azure SQL Managed Instance, or SQL Server on Azure Virtual Machines.
- Experience with AWS RDS for SQL Server.
- Experience with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).Knowledge of PowerShell, T-SQL scripting, Python, or automation frameworks.
- Experience with database monitoring tools such as:
- Redgate SQL Monitor
- SolarWinds Database Performance Analyzer
- SentryOneQuest Foglight
- Familiarity with DevOps pipelines and CI/CD processes involving database deployments.
- Experience supporting cloud migration and database modernization initiatives.