MS SQL Server / Azure DBA - Contract - Remote - 1 year + Job at Resource 1, United States

  • Resource 1
  • United States

Job Description

MS SQL Server / Azure DBA - Contract - Remote - 1 year +
Base pay range

$75.00/hr - $90.00/hr

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 the 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.
  • 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)
Seniority level
  • Mid‑Senior level
Employment type
  • Contract
Job function
  • Information Technology
  • Analyst
  • Strategy/Planning
Industries
  • IT Services and IT Consulting
  • Food and Beverage Services
  • Food and Beverage Manufacturing
#J-18808-Ljbffr

Job Tags

Contract work, Remote work

Similar Jobs

SEE Eyewear

Store Manager, Full-Time Job at SEE Eyewear

Job Description Job Description STORE MANAGER NAPERVILLE, IL SEE Eyewear | New Store Opening | Full-Time | Leadership BE THE STAR OF SOMETHING BRAND NEW We're opening a brand-new SEE Eyewear boutique in Naperville, IL and we're looking for a star to ...

University of Florida

Scientific Laboratory Manager - Pediatric Child Health Research Institute (CHRI) Job at University of Florida

 ...bacterial communities, with findings applied to diagnostics and public health interventions. Beyond benchwork, the role includes substantial...  ...for making the world a better place through the tools of science and medicine, especially for marginalized populations globally... 

Bureau of Prisons / Federal Prison System

Supervisory Correctional Officer (Lieutenant) Job at Bureau of Prisons / Federal Prison System

Corrections professionals who foster a humane and secure environment and ensure public safety by preparing individuals for successful reentry into our communities.Education GL-09 and GS-11: There is no substitution of education for specialized experience for this position...

HHS

Hybrid Part-Time Registered Dietitian Job at HHS

 ...Part-Time Registered Dietitian at Hardtner Medical Center in Olla, LA Starting Rate: $32.50/hr (Negotiable based on experience)16 hours/week HYBRID schedule available! Complete nutritional assessments and provide interventions using evidence-based practices... 

Flaherty & Collins Properties in

Assistant Property Manager Job at Flaherty & Collins Properties in

 ...Assistant Property Manager (Project Management)Creating Value Through Vibrant CommunitiesWith expertise in market-rate, affordable, and mixed-use communities, we specialize in innovative public and private partnerships. Since 1993, we've delivered over $3 billion in...