Database Administrator

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

Position: Microsoft SQL DBA with Full stack

Location: NYC, NY (Onsite)

Duration: Contract

Note: Microsoft SQL DBA with full stack skill (Java, Dot net, python anything) but should be Knowing Angular/React

Job Summary

The MS SQL DBA will manage enterprise-level Microsoft SQL Server database environments across multiple product lifecycles (development, testing, and production). The ideal candidate ensures maximum uptime, implements robust disaster recovery plans, optimizes database performance, and safeguards critical organizational data.

Core Responsibilities

• Database Management & Maintenance: Install, configure, patch, and upgrade MS SQL Server instances (on-premises or cloud/Azure environments). Perform routine health checks, index defragmentation, and statistics updates.
• High Availability & Disaster Recovery (HA/DR): Design, implement, and maintain database backup and recovery strategies. Manage HA/DR solutions including Always On Availability Groups, Failover Clustering, Log Shipping, and Replication.
• Performance Tuning & Optimization: Proactively monitor system health using tools like SQL Server Management Studio (SSMS), Extended Events, and Profiler. Troubleshoot and resolve bottlenecks, optimize slow-running T-SQL queries, refine schemas, and manage indexing strategies.
• Security & Compliance: Manage user access control, roles, and permissions. Enforce data security best practices, auditing, and encryption mechanisms to comply with industry regulations.
• Automation & Scripting: Refine and automate repetitive operational processes using PowerShell or T-SQL scripts. Manage SQL Server Agent jobs.
• Collaboration & Support: Assist development teams with data modeling, complex query refinement, and ETL/SSIS deployments. Provide 24/7 on-call production support for critical system outages.

Required Technical Skills

• DBMS: Proficient in Microsoft SQL Server (recent versions such as 2016 through 2022).
• Languages: Strong command of Transact-SQL (T-SQL) and PowerShell scripting.
• Tools: SSMS, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).
• Infrastructure: Solid understanding of Windows Server management, Active Directory, and basic networking.
• Cloud Platforms: Experience migrating or managing databases in Microsoft Azure (SQL Managed Instance, Azure SQL Database) or AWS is highly preferred.

Qualifications & Experience

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