Database Administrator

Job Title: Database Administrator

Job Code: OH 813265 Client: State of Ohio – Department of Rehabilitation and Correction (DRC) Location: Columbus, Ohio – Initially Remote, Eventually Onsite Work Location: 1221 McKinley Avenue, Columbus, OH Duration: Contract through 06/30/2027 Interview: Microsoft Teams Closing Date: 10/14/2026

Position Overview

The State of Ohio DRC is seeking a Database Administrator 3 (DBA3) with 5+ years of hands-on enterprise Microsoft SQL Server experience across on-premises and Azure environments. The DBA3 will be responsible for database administration, performance tuning, backup/recovery, HA/DR, security, Azure database platforms, automation, and developer support.

Required Skills

• 5+ years of hands-on experience managing enterprise-level Microsoft SQL Server environments.

• Strong experience with SQL Server Management Studio (SSMS) and database internals.

• Advanced T-SQL skills.

• Performance monitoring and tuning, including indexing, query optimization, blocking, and deadlock resolution.

• Backup, recovery, High Availability (HA), and Disaster Recovery (DR).

• Experience with Always On Availability Groups, Log Shipping, Failover Cluster Instances, or Replication.

• Strong Security & Compliance experience, including RBAC, database permissions, encryption, and access management.

• Experience supporting Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs.

• Experience with Azure Monitor, Log Analytics, Microsoft Entra ID, Azure Key Vault, Azure Backup, and Azure RBAC.

• Experience migrating and integrating databases between on-premises SQL Server and Azure.

• Experience with SSIS/ETL workflows.

• Strong developer support and code review experience involving stored procedures, triggers, functions, and complex T-SQL.

• Scripting experience with T-SQL, PowerShell, or command-line tools.

• Strong analytical, troubleshooting, documentation, and communication skills.

Education

• Bachelor’s degree in Computer Science, Information Technology, or a related technical field, or equivalent work experience.

Key Responsibilities

• Install, configure, patch, upgrade, and maintain SQL Server instances across production, staging, and development environments.

• Monitor and optimize database performance, system health, and resource utilization.

• Design, implement, and test backup, recovery, HA, and DR solutions.

• Administer Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs.

• Configure Azure database backup, monitoring, security, migration, and disaster recovery solutions.

• Use Azure Monitor and Log Analytics for database monitoring and troubleshooting.

• Manage database security, RBAC, permissions, encryption, and sensitive credentials using Azure Key Vault.

• Support developers with schema design, table structures, data types, stored procedures, triggers, functions, and complex queries.

• Develop automation scripts for index maintenance, integrity checks, statistics updates, backups, monitoring, and reporting.

• Provide Tier III technical support for critical database issues.

• Develop database strategies and contribute to solution architecture and business-case development.

• Create and maintain technical documentation covering installation, monitoring, security, configuration, migration, and best practices.

• Mentor junior staff and provide technical guidance.

• Collaborate with IT Architecture, CIO, IT Managers, and security teams to meet agency requirements.

Primary Skills

Microsoft SQL Server, Azure SQL Database, Azure SQL Managed Instance, T-SQL, SSMS, Performance Tuning, HA/DR, Always On, Backup & Recovery, Azure, RBAC, Security & Compliance, SSIS/ETL, Azure Monitor, Log Analytics, Microsoft Entra ID, Azure Key Vault, Azure Backup, Database Migration, Developer Support & Code Review, PowerShell

 

This is a remote position.