Database Administrator

Diversified Systems is searching for a Database Administrator responsible for implementing, configuring, maintaining, and ensuring the performance and availability of Microsoft SQL Server systems across on-premises and Azure-based environments. The selected consultant will support database maintenance, performance monitoring and tuning, backup and disaster recovery, security and compliance, developer support, automation, Azure database administration, and Tier III technical issue resolution.

Remote (May eventually be onsite)

• 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.
• Optimize database performance by writing or refining indexes, tuning complex queries, and resolving blocking or deadlock issues.
• Design, test, and execute database backup and recovery policies.
• Implement High Availability (HA) and Disaster Recovery (DR) solutions including Always On Availability Groups, Log Shipping, Failover Cluster Instances, and database replication.
• Perform performance tuning and system configuration across multiple DBMS platforms.
• Collaborate with IT development staff to design DBMS architecture and establish standards for data exchange and data security models.
• Develop standards and best practices utilizing business intelligence concepts.
• Create documentation covering installation procedures, monitoring, security policies, configuration changes, migration processes, 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 (RBAC), manage user logins and database permissions, and configure encryption at rest and in transit.
• Assist development teams with schema refinement, table design, data type selection, and code reviews for stored procedures, triggers, functions, and complex T‑SQL queries.
• Develop T‑SQL, Power Shell, and command‑line scripts to automate database maintenance tasks including index maintenance, integrity checks, statistics updates, backups, monitoring, and reporting.
• Develop and orchestrate Azure and on‑premises DBMS architectures.
• Administer Azure SQL Database, Azure SQL Managed Instance, and SQL Server hosted on Azure Virtual Machines.
• Design, configure, and deploy HA/DR solutions and manage database replication processes.
• Configure and support Azure database backup, monitoring, security, migration, and disaster recovery solutions.
• Use Azure Monitor to monitor database performance and availability.
• Use Azure Key Vault to securely store passwords and sensitive information.
• Collaborate with IT Architecture staff, the Chief Information Officer, and IT Managers to develop solutions that meet agency requirements.
• Contribute to analysis and development of solution design business cases.
• Provide Tier III resolution for critical technical issues.
• Develop database strategies to meet business needs and apply project planning principles, theories, practices, and techniques.
• Conduct formal mentorship activities for peers and lower-level staff through verbal instruction and technical documentation.
• Serve on a Disaster Recovery/Business Resumption Team, Incident Response Team, or similar response team when assigned.

• 4-year college degree in Computer Science, Information Technology, or an equivalent technical field, or equivalent work experience required.
• 5+ years of dedicated hands‑on experience managing enterprise‑level Microsoft SQL Server database environments, including on‑premises and…