Senior SQL DBA – HA, Migration & Performance Expert

Artifintech; Madison (WI); On-site; USD 89,000 - 126,000; Full time

Job summary

Artifintech is seeking an experienced SQL DBA with LifePro experience in Madison, WI for an 8-month engagement. The candidate will handle SQL Server administration across multiple versions, perform migrations, and support high availability and disaster recovery setups.

The role requires 6-8 years of hands-on SQL Server experience, strong scripting (PowerShell), and the ability to optimize performance and manage backups/restore operations. C2C arrangements are preferred.

Qualifications

• 6-8 years of Microsoft SQL Server Database Administration experience across versions 2008 R2 to 2022.
• Installation, configuration, and troubleshooting of SQL Server across multiple versions.
• Migrations from older SQL Server versions to newer ones (e.g., 2012 to 2014/2016/2019/2022).
• Upgrading SQL Server versions and applying service packs and patches.
• Proficient with SSMS, Enterprise Manager, and Query Analyzer; managing SQL Server jobs.

Responsibilities

• Create and manage DB maintenance plans, index rebuilds/reorganizes, and integrity checks.
• Backup, restore, disaster recovery planning and high-availability configurations (Always On, log shipping, mirroring, clustering).
• Implement replication models (Snapshot, Transactional, Merge) and Always On in supported versions.
• Install, configure, and maintain WSFC in Windows Server environments.

Skills

SQL Server Administration

PowerShell scripting

Performance tuning

Backup and recovery

Tools

SQL Server

SSMS

SQL Profiler

Windows Server

WSFC

Log Shipping

Replication

Linked Servers

Job description

Artifintech is seeking an experienced SQL DBA with LifePro experience in Madison, WI for an 8-month engagement. The candidate will handle SQL Server administration across multiple versions, perform migrations, and support high availability and disaster recovery setups.

The role requires 6-8 years of hands-on SQL Server experience, strong scripting (PowerShell), and the ability to optimize performance and manage backups/restore operations. C2C arrangements are preferred.