Senior SQL Server DBA – Always On, Migrations & Automation

Valiant Technologies LLC; Weehawken (NJ); On-site; USD 110,000 - 160,000; Full time

Job summary

Valiant Technologies LLC in Weehawken, NJ is seeking a seasoned MS SQL Server DBA with 6-8 years of experience to manage, optimize, and scale SQL Server environments (2008R2 through 2022).

The role covers installation, upgrades, migrations, HA/DR, backups, security, and automation using PowerShell and T-SQL. You will work on maintaining high availability, performance tuning, and responding to incidents to ensure database reliability for our clients.

Qualifications

• 6-8 years of MS SQL Server database administration experience.
• Extensive experience with SQL Server 2008R2 through 2022.
• Experience migrating and upgrading across major SQL Server versions.
• Strong backup, restore, and recovery capabilities.
• Experience with Always On, replication, log shipping, mirroring, and clustering.
• Strong performance tuning using DMVs, Profiler, and Query Store.

Responsibilities

• Install, configure, and maintain SQL Server instances across environments.
• Migrate databases between versions and upgrade servers with service packs.
• Design and implement maintenance plans, index maintenance, and integrity checks.
• Develop and automate DB administration tasks using PowerShell and SQL scripts.
• Manage high availability and disaster recovery solutions (Always On, Replication, LSR).
• Monitor system performance and tune queries to optimize workloads.

Skills

SQL Server Admin

Migration to newer SQL Server versions

Backup & Recovery

High Availability & DR

Performance Tuning

PowerShell & SQL Scripting

Index maintenance

Security & Auditing

Tools

SQL Server Management Studio

SQL Server Agent

SQL Profiler

Database Tuning Advisor

Linked Servers

WSFC

Query Analyzer

Crystal Reports

Job description

Valiant Technologies LLC in Weehawken, NJ is seeking a seasoned MS SQL Server DBA with 6-8 years of experience to manage, optimize, and scale SQL Server environments (2008R2 through 2022).

The role covers installation, upgrades, migrations, HA/DR, backups, security, and automation using PowerShell and T-SQL. You will work on maintaining high availability, performance tuning, and responding to incidents to ensure database reliability for our clients.