Part-time Weekend SQL Server DBA

XTIVIA, Inc.; Northern (KY); Hybrid; USD 48,000 - 76,000; Part time

Benefits offered by this job

401(k) with company match

EAP for you and family

Paid time off (80 hours/yr) for hourly

Job summary

XTIVIA, Inc. is seeking a Jr-level SQL Server DBA for weekend coverage to support multiple clients. This remote, part-time role focuses on keeping production workloads online, optimized, and secure during weekend hours.

You will handle live sessions, troubleshoot on the fly, and perform critical maintenance tasks. Required 2–5 years of production support DBA experience, hands-on SQL Server 2012–2025 knowledge, and strong T‑SQL skills.

Qualifications

• 2-5 years working as a production support SQL Server DBA.
• 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: write T‑SQL from scratch and read execution plans; identify parameter sniffing, resolve deadlocks, rewrite poorly performing queries, stored procedures, and triggers.
• Core DBA Tasks: backups, point‑in‑time restores, file management, patching instances.
• High Availability: experience with Always On AGs and WSFC.
• Data Integration: familiarity with SSIS packages.
• Communication: excellent verbal and written skills to explain complex engine behaviors to non‑DBA clients.
• Education: High school diploma or equivalent required.

Responsibilities

• Urgent Response: first line of defense for SQL Server Agent alerts and urgent customer calls.
• Weekend Operations: applying CUs, index/statistics rebuilds, DBCC CHECKDB, and deploying schema changes.
• Clearing the Queue: work through ticket backlog and handoffs from weekday DBA team.
• Staying Connected: manage time remotely and communicate clearly in team channels during shift.
• Admin Tasks: record ticket and timesheet entries for client billing.

Skills

SQL Server DBA

Production Support

T-SQL

Performance Tuning

Always On

WSFC

SSIS

Education

High school diploma or equivalent

Tools

SQL Server 2012-2025

SSRS

Job description

Work Location

Remote (U.S. Based)

Duration

Part-time, Saturdays (17 hours/week)

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, ensuring 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. You need to be comfortable dealing with everything from sudden tempdb contention to fixing broken replication while keeping the customer calm and informed.

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, including 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, such as 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. You must be comfortable working a 13-hour weekend shift.

• Friday: Up to 2 hours of preparation
• Saturday: 8:00 AM - 9:00 PM Mountain Time
• Sunday: Up to 2 hours for handoff

There may also be opportunities to cover the other weekend shift when the team member assigned to that shift is out or unavailable.

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 and read execution plans. You should be able to 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 and root‑cause analyses clearly to non‑DBA clients.
• Education: High school diploma or equivalent required.

How you add even MORE value

• Demonstrated knowledge and skills typically acquired through an Associate’s or Bachelor’s degree in Computer Science, Information Technology, or a related field, or through relevant professional experience.
• Experience migrating or managing SQL Server workloads in the Cloud (AWS RDS/EC2 or Azure SQL/Managed Instance).
• 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 APIs as well as digital experience CMS solutions. If you can imagine the business outcome, XTIVIA can create it with technology.

XTIVIA has offices in Colorado, New York, New Jersey, Texas, and Virginia. xtivia.com

How we take care of our team members

For XTIVIA to recruit- and retain the most experienced and talented people, we offer a competitive benefits package designed to support our team members' professional and personal well-being. Our employees are our corporate family, and we believe in treating people the way we would like to be treated. For this part-time role, we provide a 401(k) plan with a company match, an Employee Assistance Program (EAP) for you and your family, and comprehensive identity and fraud protection. To promote a healthy work‑life balance, XTIVIA offers flexible work options and a specialized paid time off program for our hourly team members, providing 80 hours (10 days) of PTO annually to help you recharge without worrying about accruals. In addition, we encourage ongoing career development by offering paid training and certification opportunities to help you stay at the forefront of SQL Server technology. Our benefits are designed around our culture and core values, contributing to XTIVIA being certified 5 years in a row as a Great Place to Work.

This position has an expected salary range of $35.00 - $55.00/hour.Your compensation is based on your skills and experience.

What We Promise

At XTIVIA, we are committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants and team members without regard to race, color, religion, age, sex, national origin, disability status, genetics, military and veteran status, sexual orientation, gender identity or expression, marital status, parental status, and any other characteristic protected by applicable laws. XTIVIA believes that diversity and inclusion among our team members are critical to our success as a global company, and we seek to recruit, develop and retain the most talented people from a diverse candidate pool. Selection is based solely on individual merit and qualifications directly related to professional competence.