Database Administrator
Smart IT Frame LLC · New York, New York, United States
FULL TIMEpermanent
Job Description
Position: Microsoft SQL DBA with Full stackLocation: NYC, NY (Onsite)Duration: Contract
The following information provides an overview of the skills, qualities, and qualifications needed for this role.
Note: Microsoft SQL DBA with full stack skill (Java, Dot net, python anything) but should be Knowing Angular/React
Job SummaryThe 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 ResponsibilitiesDatabase 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 SkillsDBMS: 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 & ExperienceEducation: Bachelor’s degree in Computer Science, Information Technology, or a related field. xzbcwsv 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)
Apply today or share profiles at
The following information provides an overview of the skills, qualities, and qualifications needed for this role.
Note: Microsoft SQL DBA with full stack skill (Java, Dot net, python anything) but should be Knowing Angular/React
Job SummaryThe 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 ResponsibilitiesDatabase 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 SkillsDBMS: 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 & ExperienceEducation: Bachelor’s degree in Computer Science, Information Technology, or a related field. xzbcwsv 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)
Apply today or share profiles at
Details
| Company | Smart IT Frame LLC |
| Location | New York, New York, United States |
| Type | FULL TIME |
| Niche | general |
| Experience | permanent |