Enterprise SQL DBA - Full-Stack & HA/DR Expert (NYC Onsite)

Smart IT Frame LLC; New York (NY); On-site; USD 83,000 - 124,000; Full time

Job summary

Smart IT Frame LLC in New York seeks a Microsoft SQL DBA with full stack capabilities to manage enterprise SQL Server environments across development, testing, and production. The contract role emphasizes high availability, performance tuning, and data security while collaborating with development teams.

Youll work onsite in NYC, implementing HA/DR, SSIS/SSRS tooling, and PowerShell automation, supporting 24/7 production needs, and guiding migrations to Azure SQL where applicable.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 3–5+ years of dedicated experience as a SQL Server DBA in an enterprise environment.
• Microsoft Certified: Azure Database Administrator Associate or legacy credentials (MCTS / MCITP)

Responsibilities

• Install, configure, patch, and upgrade SQL Server instances (on-premises or cloud).
• Design, implement, and maintain HA/DR solutions such as Always On and Failover Clustering.
• Monitor performance using SSMS, Extended Events, and Profiler; optimize queries and indexes.
• Manage user access, roles, permissions, encryption, and auditing for compliance.
• Automate processes with PowerShell or T-SQL; manage SQL Server Agent jobs.
• Assist development teams with data modeling, complex queries, and ETL/SSIS deployments; provide 24/7 on-call support.

Skills

T-SQL

PowerShell

Education

Bachelor’s degree in Computer Science / IT

Tools

SSMS

SSIS

SSRS

Windows Server

Active Directory

Networking

Azure SQL Database

Azure SQL Managed Instance

AWS

Job description

Smart IT Frame LLC in New York seeks a Microsoft SQL DBA with full stack capabilities to manage enterprise SQL Server environments across development, testing, and production. The contract role emphasizes high availability, performance tuning, and data security while collaborating with development teams.

Youll work onsite in NYC, implementing HA/DR, SSIS/SSRS tooling, and PowerShell automation, supporting 24/7 production needs, and guiding migrations to Azure SQL where applicable.