Senior SQL DBA - Migration & High Availability Expert

Cloud Analytics Technologies, LLC; Madison (WI); Presencial; USD 89.000 - 126.000; Tempo integral

Resumo da vaga

Cloud Analytics Technologies, LLC is seeking an experienced SQL DBA for Madison, WI. The role requires 6-8 years of MS SQL Server administration across modern versions, with strong emphasis on high availability, disaster recovery, upgrades, and performance tuning.

You will manage backups, migrations, and security configurations while leveraging SSMS, Profiler, and PowerShell for automation. The position is on-site in Madison, WI with an 8-month+ extension outlook.

Qualificações

• 6-8 years of Microsoft SQL Server DBA experience across 2008R2 through 2022.
• Installation, configuration and troubleshooting of SQL Server 2012–2022.
• Migration from older SQL Server versions to 2014–2022.
• Upgrading SQL Server versions and applying service packs/patches.
• Proficient with SSMS, Enterprise Manager, and SQL Server job scheduling.
• DB maintenance plans, index rebuilds/reorganize and integrity checks.
• Backup/Restore/Recovery, linked servers, and maintenance plans.
• HA/DR: Always On AGs, Replication, Log Shipping, Mirroring, Clustering.
• Replication models: Snapshot, Transactional, Merge; Always On in multiple versions.
• WSFC installation/configuration on Windows Server SQL Server 2012+.
• Auditing config and security; performance tuning with various tools.
• Automation via PowerShell and SQL scripting.

Conhecimentos

Microsoft SQL Server Administration

SQL Server upgrades

Backup and Recovery

High Availability and DR

Performance tuning

PowerShell scripting

Automation

Troubleshooting queries

Replication/Always On

WSFC configuration

Ferramentas

SQL Server Management Studio

SQL Profiler

Query Analyzer

Windows Performance Monitor

DMVs

Crystal Reports

SQL Agent/Job Scheduling

Descrição da vaga

Cloud Analytics Technologies, LLC is seeking an experienced SQL DBA for Madison, WI. The role requires 6-8 years of MS SQL Server administration across modern versions, with strong emphasis on high availability, disaster recovery, upgrades, and performance tuning.

You will manage backups, migrations, and security configurations while leveraging SSMS, Profiler, and PowerShell for automation. The position is on-site in Madison, WI with an 8-month+ extension outlook.