Experienced SQL Server DBA needed for 1-year contract to manage day-to-day operations, support mission-critical databases, and provide guidance on database best practices in a 24x7 environment.
Key Highlights
Technical Skills Required
Benefits & Perks
Job Description
Resource 1 is seeking an experienced SQL Server DBA for a 1-year contract with our client who has recently migrated most of their SQL Server databases to Azure VM. This role is 100% remote and requires a collaborative professional who can work with existing DBA to manage day-to-day operations, support mission critical databases (including off-hours support), and provide guidance on database best practices. The ideal candidate will have deep expertise in MS SQL Server, strong problem-solving skills, and a proactive approach to performance, availability, and security in a 24x7 environment.
Database Monitoring & Availability:
- Monitor SQL Server databases in an Always On environment using tools like Idera and Nagios.
- Diagnose and resolve issues with Availability Group (AG) health and related replication or failover challenges.
- Identify and resolve long-running processes that are consuming excessive CPU or resources.
Database Replication:
- Manage transactional replication between Always On systems.
- Ensure replication processes are healthy, performant, and reliable.
Performance Tuning:
- Analyze and optimize slow-running queries, stored procedures, and database jobs.
- Optimize backups, restores, and other scheduled maintenance tasks.
Patching & Maintenance:
- Apply MS SQL Server and Windows patches in a 24x7 production environment.
- Ensure database systems remain up-to-date, secure, and compliant with organizational standards.
Data Refresh & Environment Management:
- Execute development and test database refreshes from production backups.
- Maintain consistency and data integrity across environments.
Best Practices:
- Provide guidance on SQL Server best practices, processes, architecture improvements and potentially a future migration to MI (Managed Instance).
Qualifications:
- Strong experience with MS SQL Server, including administration, monitoring, and tuning.
- Hands-on experience with Always On Availability Groups and troubleshooting replication issues.
- Proficient in performance tuning, query optimization, and resource management.
- Experience with transactional replication.
- Proven ability to manage patching and maintenance in 24x7 production environments.
- Experience performing database refreshes for development or test environments.
- Familiarity with backup, restore, and disaster recovery strategies.
- Willingness to participate in non-business hour support for critical events.
Pluses:
- Experience implementing or advising on SQL Server best practices
- Migrating from on-prem SQL Server to Azure VM to MI (Managed Instance)
- Microsoft certification in Azure Database Administration
Similar Jobs
Explore other opportunities that match your interests