Job description

*** Webcam interview *** Long term contract *** Onsite (2 - 3days per week onsite) at columbus-OH***Initially Remote then hybrid*** Job Description: Database Maintenance & Configuration • Install, configure, patch, and upgrade SQL Server instances across production, staging, and development environments. • Manage server storage, system databases, and data file structures. Performance Monitoring & Tuning • Proactively 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. Backup & Disaster Recovery • Design, test, and execute reliable database backup and recovery policies. • Implement High Availability (HA) and Disaster Recovery (DR) solutions, such as Always On Availability Groups, Log Shipping, Failover Cluster Instances, or database replication. • Perform performance tuning and system configuration across multiple DBMS platforms. Architecture & Collaboration • Throughout the application lifecycle, collaborate with IT development staff to design DBMS architecture and establish standards for data exchange, including robust data security models. • Apply an understanding of business intelligence concepts when developing standards and best practices. • Create comprehensive documentation covering installation procedures, monitoring, security policies, configuration changes, migration processes, and best practices for development teams. • Work closely 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. Security & Compliance • Implement strict role-based access control (RBAC), manage user logins and database permissions, and configure encryption at rest and in transit to maintain data integrity and regulatory compliance. Developer Support & Code Review • Assist development teams with schema refinement, table design, efficient data type selection, and code reviews for stored procedures, triggers, functions, and complex T-SQL queries. Automation & Scripting • Write T-SQL, PowerShell, or command-line scripts to automate routine DBA maintenance tasks, including index maintenance, integrity checks, statistics updates, backups, monitoring, and reporting. Role Overview The SQL Server DBA provides server administration for Microsoft SQL Server database products. The DBA3 will be responsible for implementing, configuring, maintaining, and ensuring the performance and availability of SQL Server systems to keep corporate applications available and running smoothly. Soft Skills • Sharp analytical and troubleshooting skills, strong attention to detail, and the ability to explain complex database issues to non-technical stakeholders. Azure & DBMS Architecture • Develops and orchestrates both Azure and on-premises Database Management System (DBMS) architectures, ensuring robust and scalable solutions. • Administers Azure SQL Database, Azure SQL Managed Instance, and SQL Server hosted on Azure Virtual Machines. • Oversees the implementation and configuration of these DBMS platforms, aligning them with organizational objectives. High Availability & Disaster Recovery Strategy • Designs and plans comprehensive High Availability and Disaster Recovery (HA/DR) strategies, including careful hardware selection and recommendations tailored to system needs. • Takes the lead in configuring and deploying HA/DR solutions and managing replication processes to ensure data integrity and accessibility. Azure Solutions & Monitoring • Configures and supports Azure database backup, monitoring, security, migration, and disaster recovery solutions. • Uses Azure Monitor to monitor database performance and availability, and Azure Key Vault to securely store passwords and other sensitive information. Performance Optimization & Collaboration • Regularly monitors and fine-tunes DBMS performance to optimize efficiency and reliability. • Collaborates closely with IT Architecture staff, the Chief Information Officer, and IT Managers to devise solutions that fulfill agency requirements. • Contributes to the analysis and development of the solution design's business case, authoring relevant sections to support decision-making. Technical Support & Leadership • Handles complex technical challenges by providing Tier III resolution for critical issues, reinforcing system stability and continuity. • Develops database strategies to meet business needs and applies project planning principles, theories, practices, and techniques. • Conducts formal mentorship activities for peers and lower-level staff, providing guidance through verbal instruction or technical documentation. Emergency Response & On-Call Duties • When assigned, serves as a member of a Disaster Recovery/Business Resumption Team, Incident Response Team, or similar public health response team, which may require 24/7 operations at remote locations. Education Bachelor's degree in Computer Science, Information Technology, or an equivalent technical field, or equivalent work experience. Experience • 5+ years of dedicated hands-on experience managing enterprise-level Microsoft SQL Server database environments, including on-premises and Azure-based platforms. Technical Proficiencies • Deep expertise in SQL Server Management Studio (SSMS) and underlying database internals. • Advanced command of Transact-SQL (T-SQL) language syntax. • Experience implementing SQL Server Integration Services (SSIS) packages and Extract, Transform, Load (ETL) workflows. • Experience supporting 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 role-based access control. • Experience migrating and integrating databases between on-premises SQL Server and Azure environments. • Understanding of Azure database security, networking, scalability, cost optimization, and HA/DR capabilities. • Hands-on familiarity with third-party monitoring and backup tools, such as Redgate. Skills/Requirements Skill Required Years Bachelor’s degree in Finance, Data Analytics, Information Systems, or related field. Required 4 Years Advanced level of proficiency in Power BI, including Power Query and DAX, Excel (advanced), and data visualization best practices. Required 6 Years Some data modeling and data manipulation skills to maintain data sets from multiple, heterogenous sources Required 5 Years High familiarity with Azure cost management, Apptio, and cloud billing structures. Required 5 Years Understanding of server migration strategies and workload cost modeling. Required 5 Years Ability to translate technical data into insights for technical teams and managers Required 5 Years Ability to work independently and apply critical thinking to analyze complex financial data and develop actionable recommendations. Required 4 Years Proficiency in Power BI, including independently updating data, performing queries, and managing and analyzing datasets with little to no assistance. Required 6 Years Ability to translate complex data into clear, accurate, and actionable information for leadership and decision-making. Required 4 Years

Requirements

Must-haves

Webcam interview *** Long term contract *** Onsite (2 - 3days per week onsite) at columbus-OH***Initially Remote then hybrid***
Database Maintenance & Configuration
Install, configure, patch, and upgrade SQL Server instances across production, staging, and development environments.
Manage server storage, system databases, and data file structures.
Performance Monitoring & Tuning
Proactively 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.
Backup & Disaster Recovery
Design, test, and execute reliable database backup and recovery policies.
Implement High Availability (HA) and Disaster Recovery (DR) solutions, such as Always On Availability Groups, Log Shipping, Failover Cluster Instances, or database replication.
Perform performance tuning and system configuration across multiple DBMS platforms.
Architecture & Collaboration
Throughout the application lifecycle, collaborate with IT development staff to design DBMS architecture and establish standards for data exchange, including robust data security models.
Apply an understanding of business intelligence concepts when developing standards and best practices.
Create comprehensive documentation covering installation procedures, monitoring, security policies, configuration changes, migration processes, and best practices for development teams.
Work closely 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.
Security & Compliance
Implement strict role-based access control (RBAC), manage user logins and database permissions, and configure encryption at rest and in transit to maintain data integrity and regulatory compliance.
Developer Support & Code Review
Assist development teams with schema refinement, table design, efficient data type selection, and code reviews for stored procedures, triggers, functions, and complex T-SQL queries.
Automation & Scripting
Write T-SQL, PowerShell, or command-line scripts to automate routine DBA maintenance tasks, including index maintenance, integrity checks, statistics updates, backups, monitoring, and reporting.
Sharp analytical and troubleshooting skills, strong attention to detail, and the ability to explain complex database issues to non-technical stakeholders.
Azure & DBMS Architecture

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlrestazureaccessibility

Platform: careers-html
Effort: medium