Database Administrator
Description
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
- 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.
- 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.
- 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.
This is a remote position.
About SR International INC.
Who We Are
We Are Leading IT Based Solution Providers
Our Vision.