← Back to jobs
Boston, MA, USA
No related jobs found
Key Responsibilities
1. Install, configure, administer, and maintain Microsoft SQL Server instances.
2. Perform database upgrades, patching, migrations, and version transitions across SQL Server environments.
3. Monitor database health, availability, capacity, and overall system performance.
4. Implement, maintain, and support high-availability and disaster recovery solutions, including:
o Always On Availability Groups
o Failover Clustering
o Replication
o Log Shipping
5. Manage database security, including logins, roles, permissions, and Active Directory (AD) group integration.
6. Troubleshoot database-related issues and perform root cause analysis.
7. Optimize database performance through indexing strategies, query tuning, and performance monitoring.
8. Collaborate closely with application development teams, infrastructure teams, and system administrators to support business-critical applications.
9. Support production environments, including participation in on-call rotations as needed.
10. Develop and maintain database administration documentation, standards, and best practices.
Required Qualifications
1. Bachelor's degree in Computer Science, Information Technology, or equivalent experience.
2. Minimum 5+ years of hands-on experience as a SQL Server Database Administrator.
3. Strong experience with Microsoft SQL Server 2016, 2019, and 2022.
4. Proven expertise in SQL Server installation, configuration, patching, upgrades, and migrations.
5. Strong knowledge of:
o T-SQL
o Indexing strategies
o Query tuning
o Performance optimization
6. Experience implementing and supporting:
o Always On Availability Groups
o Failover Clustering
o Replication
o Log Shipping
7. Experience supporting mission-critical production environments with high availability requirements.
8. Strong troubleshooting and problem-solving skills.
9. Excellent communication and collaboration skills.
Preferred Qualifications
1. Experience with PowerShell scripting and SQL automation.
2. Experience with SSIS and SSRS.
3. Experience using SQL Sentry for monitoring and performance management.
4. Familiarity with enterprise infrastructure and cloud-integrated SQL environments.
Required Technical Skills
• Microsoft SQL Server (2016/2019/2022)
• SQL Server Management Studio (SSMS)
• T-SQL
• PowerShell
• SSIS
• SSRS
• Always On Availability Groups
• Failover Clustering
• Replication
• Log Shipping
• Database Performance Tuning
• Security Administration
Bachelor's degree
No related jobs found
← Back to jobs