Senior SQL DBA — HA/DR, Automation & PowerShell

Cloud Analytics Technologies, LLC; Weehawken (NJ); On-site; USD 120,000 - 150,000; Full time

Job summary

Cloud Analytics Technologies, LLC invites a skilled SQL Server DBA to join our team in New Jersey. The role focuses on administration of SQL Server databases across versions 2008R2–2022, with responsibilities for upgrades, migrations, and performance tuning.

You will implement high-availability options such as Always On, configure backups, security, and recovery strategies, and automate tasks with PowerShell.

Qualifications

• 6–8 years of MS SQL Server DBA experience.
• Experience with SQL Server 2008R2–2022.
• Installation, configuration and troubleshooting of SQL Server.
• Migration from older versions to newer versions.
• Automation with PowerShell and SQL scripting.
• Backup, restore, recovery and maintenance planning.

Responsibilities

• Maintain and administer SQL Server databases across multiple versions.
• Plan and execute upgrades and migrations with minimal downtime.
• Implement and manage High Availability and DR solutions (Always On, Replication, Log Shipping, Mirroring, Clustering).
• Monitor performance, tune queries, and manage security configurations.
• Automate routine tasks using PowerShell and SQL scripting.

Tools

SQL Management Studio

SQL Profiler

PowerShell

SSMS Automation

Query Tuning

WSFC

Backup & Recovery

Replication

High Availability

Job description

Cloud Analytics Technologies, LLC invites a skilled SQL Server DBA to join our team in New Jersey. The role focuses on administration of SQL Server databases across versions 2008R2–2022, with responsibilities for upgrades, migrations, and performance tuning.

You will implement high-availability options such as Always On, configure backups, security, and recovery strategies, and automate tasks with PowerShell.