Part-time Weekend SQL Server DBA

Description

Work Location Hybrid Remote - Must reside in the greater Colorado Springs, CO area for initial training and periodic office access

Duration Part-time, weekends (17 hours/week)
Travel Occasional - up to 25%
Status Non-Exempt

How you will make a difference
We are looking for a Jr-level SQL Server DBA to join XTIVIA’s support team. This role is built specifically for high-density weekend coverage, acting as the first line of defense for critical SQL Server Agent alerts and urgent customer calls. You will ensure our customers' production workloads stay online, optimized, and secure while the weekday team is off. You will connect to multiple clients, handle live screen-share sessions, and troubleshoot issues on the fly-from sudden tempdb contention to fixing broken replication-keeping the customer calm and informed throughout the process.

What you will be doing

• Urgent Response: Acting as the first line of defense for critical SQL Server Agent alerts, severity errors, and urgent customer calls regarding issues with their SQL Server Systems.
• Weekend Operations: Executing scheduled maintenance windows—examples of requests: applying Cumulative Updates (CUs), managing index/statistics rebuilds, running DBCC CHECKDB, and safely deploying schema changes.
• Clearing the Queue: Working through the ticket backlog and picking up specific handoffs (like monitoring a long-running migration) from the weekday DBA team.
• Staying Connected: Since this is a remote role, you will need to manage your own time, stay proactive, and communicate clearly in our team channels throughout your shift.
• Admin Tasks: Accurately recording ticket and timesheet entries for client billing.
  

The Schedule

This is a part-time role requiring a total of 17 hours per week. The hours are distributed as follows:

• The Weekend Shift (13 Hours): We are currently hiring for two separate weekend schedules:
  • Shift 1: Saturday (8:00 AM - 9:00 PM)
  • Shift 2: Sunday (8:00 AM - 9:00 PM)
• Additional Coordination Hours: In addition to the weekend shift, you will be responsible for:
  • Prep: Up to 2 hours of preparation.
  • Handoff: Up to 2 hours of coordination/handoff.

Requirements

What you bring to your new team 

• Experience: 2-5 years working as a production support SQL Server DBA.
• Platform Knowledge: Hands-on experience administering SQL Server 2012 through 2025, including instance-level best practices (MAXDOP, cost threshold, max server memory) and security protocols.
• T-SQL & Performance Tuning: Ability to write T-SQL from scratch, read execution plans, identify parameter sniffing, resolve deadlocks, and rewrite poorly performing queries, stored procedures, and triggers.
• Core DBA Tasks: A solid grasp of native backups and point-in-time restores, database file management, and patching instances.
• High Availability: Practical experience building, troubleshooting, and failing over Always On Availability Groups (AGs) and Windows Server Failover Clusters (WSFC).
• Data Integration: Familiarity with deploying, executing, and troubleshooting SSIS packages.
• Communication: Excellent verbal and written skills with the ability to explain complex engine behaviors to non-DBA clients.

How you add even MORE value

• An Associate’s or Bachelor’s degree in Computer Science, Information Technology, or a related field; alternatively, 2+ years of demonstrated technical competency through relevant hands-on career experience.
• Experience migrating or managing SQL Server workloads in the Cloud (AWS RDS/EC2 or Azure SQL/Managed Instance).
• Active Microsoft Certifications (e.g., Azure Data Fundamentals, Azure Database Administrator Associate).
• Experience configuring and deploying SQL Server Reporting Services (SSRS).
• A background in technical support or call center support.

Get to know XTIVIA 

XTIVIA is an innovative B2B technology enterprise solutions company committed to providing integrated technology solutions and services, delivering measurable results as a trusted industry thought leader for 30 years. Our services include managed services and business solutions, DevOps, CRM, and ITSM; database support and management; application solutions, including mobile apps; ERP solutions for GovCon and the private sector; and platform integration, with