Database Administrator

S R INTERNATIONAL INC

6d•Remote

About The Position

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 role covers database administration, performance tuning, security, backup and recovery, high availability, disaster recovery, and database architecture across on-premises and Azure platforms. The DBA will support development teams, resolve complex database issues, implement security standards, and help ensure database availability, performance, and reliability. The position is initially remote and eventually onsite at 1221 McKinley Avenue in Columbus, Ohio; the posting also describes it as a remote position. The contract runs through June 30, 2027. The role provides Tier III support and collaborates with IT Architecture, the CIO, IT Managers, and the State Chief Information Security Officer, while providing guidance and mentorship to peers and junior-level staff.

Requirements

Bachelor's degree in Computer Science, Information Technology, or a related technical field, or equivalent work experience.
At least 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 high availability/disaster recovery capabilities.
Experience with performance monitoring and tuning, RBAC, and developer support/code reviews.
Strong analytical, troubleshooting, communication, and problem-solving skills.

Nice To Haves

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.

Responsibilities

Install, configure, patch, upgrade, and maintain Microsoft SQL Server instances across production, staging, and development environments.
Monitor database health, optimize resource allocation, tune complex queries, improve indexes, and resolve blocking and deadlock issues.
Design, implement, and test backup and recovery strategies, including Always On Availability Groups, Log Shipping, Failover Cluster Instances, and database replication.
Develop and maintain Azure and on-premises DBMS architectures for scalability, availability, and performance.
Implement Role-Based Access Control (RBAC), manage database permissions, and configure encryption at rest and in transit.
Administer Azure SQL Database, Azure SQL Managed Instance, and SQL Server hosted on Azure Virtual Machines.
Assist development teams with schema design, table structures, data types, stored procedures, triggers, functions, and complex T-SQL queries.
Develop T-SQL, PowerShell, and command-line scripts to automate database maintenance, backups, integrity checks, monitoring, and reporting.
Use Azure Monitor and Log Analytics to monitor database performance and availability.
Use Microsoft Entra ID and Azure Key Vault to manage access and securely store sensitive information.
Support migrations and integrations between on-premises SQL Server and Azure environments.
Provide Tier III support and resolve complex database issues to maintain system stability and continuity.
Maintain technical documentation covering installation, configuration, monitoring, security, migrations, and development best practices.
Collaborate with IT Architecture, the CIO, IT Managers, and the State Chief Information Security Officer to implement database solutions and security standards.
Provide technical guidance and mentorship to peers and junior-level staff.