Database Administrator
Remote (May eventually be onsite)
Description:
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.
Responsibilities:
- 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, PowerShell, 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.
Requirements:
- 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 Azure-based platforms required.
- 5 years of Performance Monitoring and Tuning experience required.
- 5 years of Security and Compliance experience, including implementing role-based access control (RBAC), required.
- 5 years of Developer Support and Code Review experience required.
- Deep expertise in SQL Server Management Studio (SSMS) and underlying database internals required.
- Advanced knowledge of Transact-SQL (T-SQL) required.
- Experience implementing SQL Server Integration Services (SSIS) packages and Extract, Transform, Load (ETL) workflows required.
- Experience supporting Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines required.
- Knowledge of Azure Monitor, Log Analytics, Microsoft Entra ID, Azure Key Vault, Azure Backup, and Azure role-based access control required.
- Experience migrating and integrating databases between on-premises SQL Server and Azure environments required.
- Understanding of Azure database security, networking, scalability, cost optimization, and HA/DR capabilities required.
- Sharp analytical and troubleshooting skills required.
- Strong attention to detail required.
- Ability to explain complex database issues to non-technical stakeholders required.
Desired Skills:
- Hands-on familiarity with third-party monitoring and backup tools such as Redgate preferred.
About Diversified Systems
Founded in 1990, Diversified Systems is an award-winning Technology Services corporation providing all levels of IT project consulting services nationwide. DSI is headquartered in Columbus, Ohio with regional offices in the American Midwest and East Coast. We offer our consultants a number of flexible and competitive compensation benefit packages.
Diversified Systems is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations.
Diversity, Equity and Inclusion
DSI values authenticity and is committed to making sure our employees and partners are valued and respected. At DSI, we believe building a diverse culture is important because we know when people work together, we can achieve better results as a team. DSI realizes that everyone comes from various backgrounds. We celebrate these differences because our employees are our greatest asset as we strive to best meet the needs of those we serve. As part of our ongoing efforts, DSI is focused on advancing equality, diversity, and inclusion by setting high standards to continually evolve our culture. This includes but is not limited to recruiting, community involvement, client delivery, and career development.
