Sr. SQL Server DBA

Resource 1 is seeking a senior, production-tested SQL Server DBA for a 3–6 month contract opportunity. This individual must be able to step in quickly, keep critical systems stable, support ongoing development work, and operate confidently in a high-availability, enterprise environment. This is a hands-on role focused on owning and supporting live production databases.

Responsibilities:

• Provide hands-on administration of production SQL Server environments
• Monitor and resolve performance and availability issues including blocking, deadlocks, failed jobs, and resource contention
• Execute and validate:
• Backup and restore operations
• Index and statistics maintenance
• High availability and disaster recovery readiness
• Participate in on-call and off-hours support as needed
• Support ongoing development work by:
• Creating and modifying database objects (tables, views, stored procedures, indexes)
• Reviewing database designs and tuning for performance
• Assisting with releases and production deployments
• Partner with application, infrastructure, and operations teams to maintain system stability

Required Skills/Experience:

• 5+ years of hands-on SQL Server DBA experience
• Strong experience supporting enterprise production systems
• Proven ability to independently troubleshoot performance and availability issues
• Experience working in High Availability (HA) environments
• Experience with DR, backup/restore, indexing, and database security
• Comfortable participating in on-call and after-hours support
• Strong communication and collaboration skills

Nice-to-Have Skills/Experience:

• Experience with Azure SQL or SQL Server on Azure VMs
• Exposure to modern analytics platforms (e.g., Microsoft Fabric)
• Experience in regulated or high-availability environments

Technical Environment:

• SQL Server 2016–2022
• Primarily on-prem SQL Server, with some Azure-hosted VMs
• Environments include Dev, QA, UAT, and Production
• High-availability, business-critical systems

Medical insurance and a 401(k) plan is offered to all eligible W2 employees.