Database Administrator (Onsite)

Main Sail•Columbus, OH

1d•Onsite

About The Position

The Database Administrator (DBA3) provides server administration for Microsoft SQL Server database products and is responsible for implementing, configuring, maintaining, and ensuring the performance and availability of SQL Server systems so corporate applications remain available and run smoothly. The role develops and orchestrates Azure and on-premises DBMS architectures, including administration of Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines. Responsibilities include installing, configuring, patching, and upgrading SQL Server instances; managing storage and data files; monitoring and tuning database performance; and designing, testing, and executing backup, high availability, and disaster recovery solutions. The administrator supports database security and compliance, Azure monitoring and backup capabilities, database migrations, replication, and secure handling of credentials. The position also collaborates with development and IT architecture staff on database architecture, standards, business cases, application needs, and code reviews, and provides Tier III resolution for critical issues. The DBA creates technical documentation and automation scripts, mentors peers and lower-level staff, and works with agency leadership and security personnel to implement organizational and State of Ohio security standards. When assigned to a disaster recovery, incident response, or similar team, the role may require 24/7 operations at remote locations. The candidate must live in Ohio.

Requirements

Bachelor’s degree in Computer Science, Information Technology, or an equivalent technical field, or equivalent work experience.
At least 5 years of dedicated hands-on experience managing enterprise-level Microsoft SQL Server database environments, including on-premises and Azure-based platforms.
At least 5 years of performance monitoring and tuning experience.
At least 5 years implementing role-based access control for security and compliance.
At least 5 years of developer support and code review experience.
Deep expertise in SQL Server Management Studio (SSMS) and SQL Server database internals.
Advanced command of Transact-SQL (T-SQL).
Experience implementing SQL Server Integration Services (SSIS) packages and ETL workflows.
Experience supporting Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.
Knowledge of Azure Monitor, Log Analytics, Microsoft Entra ID, Azure Key Vault, Azure Backup, and Azure role-based access control.
Experience migrating and integrating databases between on-premises SQL Server and Azure environments.
Understanding of Azure database security, networking, scalability, cost optimization, and HA/DR capabilities.
Hands-on familiarity with third-party monitoring and backup tools such as Redgate.
Must live in Ohio.
Sharp analytical and troubleshooting skills, strong attention to detail, and ability to explain complex database issues to non-technical stakeholders.
College degree is required; the posting lists 4 years for this requirement.

Responsibilities

Install, configure, patch, and upgrade SQL Server instances across production, staging, and development environments.
Manage server storage, system databases, and data file structures.
Monitor system health, resource allocation, and server metrics; tune performance through indexing, query optimization, and resolution of blocking or deadlocks.
Design, test, and execute database backup and recovery policies.
Implement and manage high availability and disaster recovery solutions, including Always On Availability Groups, Log Shipping, Failover Cluster Instances, and replication.
Perform performance tuning and system configuration across multiple DBMS platforms.
Collaborate with IT development staff throughout the application lifecycle to design DBMS architecture and establish data exchange and data security standards.
Apply business intelligence concepts when developing standards and best practices.
Document installation, monitoring, security policies, configuration changes, migrations, and development best practices.
Work with the State Chief Information Security Officer to implement and enforce security standards established by the State of Ohio and the Ohio Department of Rehabilitation and Correction.
Implement role-based access control, manage database logins and permissions, and configure encryption at rest and in transit.
Support development teams with schema refinement, table design, data type selection, and code reviews of stored procedures, triggers, functions, and T-SQL queries.
Write T-SQL, PowerShell, or command-line scripts to automate maintenance, integrity checks, statistics updates, backups, monitoring, and reporting.
Develop and administer Azure and on-premises DBMS architectures, including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.
Configure and support Azure database backup, monitoring, security, migration, and disaster recovery solutions; use Azure Monitor and Azure Key Vault as appropriate.
Plan and deploy HA/DR strategies, including hardware selection and replication processes.
Collaborate with IT Architecture staff, the Chief Information Officer, and IT Managers to develop solutions that meet agency requirements.
Contribute to solution-design business case analysis and author relevant sections to support decision-making.
Provide Tier III resolution for critical technical issues.
Develop database strategies to meet business needs and apply project planning principles, theories, practices, and techniques.
Mentor peers and lower-level staff through verbal instruction and technical documentation.
When assigned, serve on a Disaster Recovery/Business Resumption Team, Incident Response Team, or similar public health response team, potentially requiring 24/7 operations at remote locations.