Database Administrator

Job Title: Database Administrator

Job Code: OH 814652 Client: State of Ohio – Department of Rehabilitation and Correction (DRC) Location: Columbus, Ohio (Initially Remote, Eventually Onsite) Contract Duration: Through June 30, 2027 (7 Months) Work Location: 1221 McKinley Avenue, Columbus, OH Closing Date: November 4, 2026, at 4:00 PM Interview: Microsoft Teams

Position Overview

The State of Ohio – Department of Rehabilitation and Correction (DRC) is seeking an experienced Database Administrator 4 (DBA4) to manage, maintain, and optimize enterprise-level Microsoft SQL Server and Azure database environments.

The selected candidate will be responsible for database administration, performance tuning, security, backup and recovery, high availability, disaster recovery, and database architecture across on-premises and Azure-based platforms. The role also involves supporting development teams, resolving complex database issues, implementing security standards, and ensuring database availability, performance, and reliability.

Key Responsibilities

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

• Performance Monitoring & Tuning: Monitor database health, optimize resource allocation, tune complex queries, improve indexes, and resolve blocking and deadlock issues.

• Backup & Disaster Recovery: Design, implement, and test backup and recovery strategies, including Always On Availability Groups, Log Shipping, Failover Cluster Instances, and database replication.

• Database Architecture: Develop and maintain Azure and on-premises DBMS architectures, ensuring scalability, availability, and performance.

• Security & Compliance: Implement Role-Based Access Control (RBAC), manage database permissions, and configure encryption at rest and in transit.

• Azure Database Management: Administer Azure SQL Database, Azure SQL Managed Instance, and SQL Server hosted on Azure Virtual Machines.

• Developer Support & Code Review: Assist development teams with schema design, table structures, data types, stored procedures, triggers, functions, and complex T-SQL queries.

• Automation & Scripting: Develop T-SQL, PowerShell, and command-line scripts to automate database maintenance, backups, integrity checks, monitoring, and reporting.

• Database Monitoring: Use Azure Monitor and Log Analytics to monitor database performance and availability.

• Security Tools: Utilize Microsoft Entra ID and Azure Key Vault to manage access and securely store sensitive information.

• Database Migration & Integration: Support migrations and integrations between on-premises SQL Server and Azure environments.

• Technical Support: Provide Tier III support and resolve complex database issues to maintain system stability and continuity.

• Documentation: Maintain technical documentation covering installation, configuration, monitoring, security, migrations, and development best practices.

• Collaboration: Work with IT Architecture, the CIO, IT Managers, and the State Chief Information Security Officer to implement database solutions and security standards.

• Mentoring: Provide technical guidance and mentorship to peers and junior-level staff.

Required Skills & Qualifications

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

• 5+ years of hands-on experience managing enterprise-level Microsoft SQL Server database environments, including on-premises and Azure platforms.

• Strong expertise in SQL Server Management Studio (SSMS) and database internals.

• Advanced knowledge of Transact-SQL (T-SQL).

• Experience with SQL Server Integration Services (SSIS) and ETL workflows.

• Experience with 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 RBAC.

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

• Understanding of Azure database security, networking, scalability, cost optimization, and HA/DR capabilities.

• Experience with performance monitoring and tuning, RBAC, and developer support/code reviews.

• Strong analytical, troubleshooting, communication, and problem-solving skills.

Preferred Skills

• Experience with Linux and Windows database environments.

• Experience with third-party database monitoring and backup tools, such as Redgate.

• Knowledge of database replication and high-availability solutions.

• Experience with PowerShell and database automation.

• Experience supporting enterprise application development teams.

Primary Skills

Microsoft SQL Server, SQL Server DBA, Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VMs, T-SQL, SSMS, SSIS, Database Administration, Database Architecture, Performance Monitoring & Tuning, High Availability, Disaster Recovery, Always On Availability Groups, Log Shipping, Database Replication, Backup & Recovery, RBAC, Azure Monitor, Log Analytics, Microsoft Entra ID, Azure Key Vault, Azure Backup, PowerShell, ETL, Database Migration, Systems Integration, Developer Support, Code Review, Tier III Support.

This is a remote position.