Senior Microsoft SQL Server DBA – On-Premises

Maitsys; United States; On-site; USD 90,000 - 140,000; Full time

Job summary

Maitsys is seeking a seasoned SQL Server DBA to manage on-premises SQL Server environments and support .NET applications. You will handle provisioning, capacity planning, maintenance, security, and performance tuning across multiple environments.

Ideal candidates have 5+ years of hands-on DBA experience with SQL Server 2022+, HA/DR implementations, and strong collaboration with development teams. On-prem role with responsibility for backups, monitoring, and incident response.

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 versions 2022 and above.

Responsibilities

• Install, configure, upgrade, and maintain on-premises SQL Server instances.
• Manage database provisioning, capacity planning, and storage across physical/virtual servers.
• Perform routine maintenance: index rebuilds, statistics updates, integrity checks, and patching.
• Administer user roles, permissions, and security policies per least privilege.
• Monitor performance and resolve bottlenecks; optimize queries and T-SQL.
• Configure and manage SQL Server Agent jobs, alerts, and monitoring.
• Design, test, and implement backups and disaster recovery strategies.
• Maintain High Availability solutions (Always On, Clustering, Replication, Log Shipping).
• Collaborate with development teams to support day-to-day SQL builds across environments.

Skills

SQL Server DBA

On-premises administration

Performance tuning

HA/DR

.NET application support

Tools

SSMS

SQL Profiler

Extended Events

SQL Server Agent

Windows Server

Active Directory

Job description

Key Responsibilities

• Install, configure, upgrade, and maintain on-premises Microsoft SQL Server instances (2022 or later).
• Manage database provisioning, capacity planning, and storage allocation across physical/virtual servers.
• Perform routine maintenance including index rebuilding, statistics updates, integrity checks (DBCC), and patching.
• Administer user roles, permissions, and security policies following the principle of least privilege.
• Monitor database performance and proactively identify and resolve bottlenecks.
• Optimize T-SQL queries, stored procedures, functions, and views (often those originating from the .NET application).
• Analyze and tune execution plans, indexing strategies, and query performance.
• Configure and manage SQL Server Agent jobs, alerts, and automated monitoring.
• Design, implement, and test robust backup and disaster recovery (DR) strategies.
• Manage High Availability solutions such as Always On Availability Groups, Failover Clustering, log shipping, or replication.
• Perform point-in-time recovery and regularly validate restore processes.
• Collaborate with development teams to support day to day SQL database builds across multiple environments and support necessary of the .NET application.
• Troubleshoot database connectivity, connection pooling, and performance issues originating from the application (e.g., Entity Framework, ADO.NET).
• Review and optimize database code and schema changes deployed through application releases.
• Assist with deployment of database changes across development, testing, and production environments.
• Support application configuration related to database connections (connection strings, IIS/app server integration).
• Implement and maintain database security, encryption (TDE, Always Encrypted), and auditing.
• Ensure compliance with relevant data protection regulations and internal governance policies.
• Manage vulnerability remediation and apply security patches.
• Maintain comprehensive documentation of database architecture, configurations, and procedures.
• Provide on-call support for critical database and application issues (rotational, as needed).
• Participate in incident, problem, and change management processes.

Experience

• 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 versions 2022 and above.
• Expert knowledge of SQL (writing, debugging, and optimizing).
• Strong understanding of database internals, indexing, and performance tuning.
• Hands-on experience with High Availability / Disaster Recovery (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 Active Directory integration.
• Understanding of how .NET applications connect to and consume SQL Server data (ADO.NET, Entity Framework, connection strings, IIS).
• Experience with backup/recovery tools and monitoring solutions (e.g., Redgate ( recommended)).
• Experience with SSIS, SSRS, and SSAS.

Technical Skills:

Advanced SQL Server Administration

• Microsoft SQL Server 2012/2014/2016/2019/2022
• SQL Server Always On Availability Groups
• Failover Clustering. Database Mirroring , Log Shipping and Replication
• SQL Server Agent, SQL Server Profiler and Extended Events

Database Design

• Normalization and Denormalization
• Data Modeling and design & support complex Database Architecture with supporting of 10+ TB of data
• OLTP, Data Warehouse Design and Capacity Planning

Automation

• PowerShell, SQL Agent Jobs, T-SQL Scripting