Senior SQL Server DBA - On-Prem, HA/DR & Performance Expert

Maitsys Inc.; United States; On-site; USD 110,000 - 140,000; Full time

Job summary

Maitsys Inc. is seeking an experienced SQL Server DBA to install, configure, and maintain on-premises SQL Server instances across environments. You will work with .NET applications, ensure high availability, and implement security and backup strategies.

The role requires 5+ years hands-on DBA experience, deep knowledge of T-SQL, performance tuning, HA/DR, and familiarity with Windows Server and AD integration. You will collaborate with development teams and provide on-call support.

Qualifications

• 5+ years of hands-on experience as a SQL Server DBA in an on-premise environment.
• Proven experience supporting .NET applications and their backend databases.
• Strong experience with SQL Server 2022 and newer.
• Expert knowledge of SQL including writing, debugging, and optimization.
• Experience with High Availability/DR (Always On, Clustering, Replication, Log Shipping).
• Proficiency with SQL Server tools: SSMS, SQL Profiler, Extended Events, SQL Server Agent.
• Familiarity with Windows Server administration and AD integration.
• Understanding of how .NET apps connect to SQL Server (ADO.NET, EF, connection strings, IIS).
• Experience with backup/recovery tools and monitoring solutions (e.g., Redgate).
• Experience with SSIS, SSRS, and SSAS.

Responsibilities

• Install, configure, upgrade, and maintain on-premises SQL Server instances.
• Manage provisioning, capacity planning, and storage across servers.
• Perform routine maintenance: index rebuilds, statistics updates, integrity checks, and patching.
• Administer user roles, permissions, and security per least-privilege.
• Monitor performance and resolve bottlenecks.
• Optimize T-SQL queries, stored procedures, functions, and views from the .NET app.
• Analyze and tune execution plans, indexing, and query performance.
• Configure and manage SQL Server Agent jobs, alerts, and monitoring.
• Design and test backup and disaster recovery strategies.
• Manage High Availability: Always On, clustering, replication, log shipping.
• Perform point-in-time recovery and validate restores.
• Collaborate with development teams for day-to-day DB builds across environments.
• Troubleshoot connectivity and performance issues from the app (EF, ADO.NET).
• Review and optimize code and schema changes deployed via releases.
• Assist with deployment of database changes across environments.
• Support app configuration related to DB connections (connection strings, IIS).
• Implement and maintain DB security, encryption, and auditing.
• Ensure compliance with data protection and governance policies.
• Manage vulnerability remediation and apply security patches.
• Maintain documentation of architecture, configurations, and procedures.
• Provide on-call support (rotational).
• Participate in incident, problem, and change management.

Skills

T-SQL

Performance tuning

High availability

Windows Server

.NET integration

SSMS

SQL Profiler

Extended Events

Always On

Replication

Tools

SSMS

SQL Profiler

Extended Events

Always On

Failover Clustering

Replication

PowerShell

Job description

Maitsys Inc. is seeking an experienced SQL Server DBA to install, configure, and maintain on-premises SQL Server instances across environments. You will work with .NET applications, ensure high availability, and implement security and backup strategies.

The role requires 5+ years hands-on DBA experience, deep knowledge of T-SQL, performance tuning, HA/DR, and familiarity with Windows Server and AD integration. You will collaborate with development teams and provide on-call support.