Database Administrator

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)