OH -Database Administrator 4 - 814652

<>Database Maintenance & Configuration

• Install, configure, patch, upgrade, and maintain Microsoft SQL Server instances across production, staging, and development environments.
• Manage server storage, system databases, database files, and filegroup structures.
• Administer Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.
• Develop, configure, and support Azure-based backup, monitoring, migration, security, and disaster recovery solutions.
• Plan and implement database migrations between on-premises and Azure environments.

<>Performance Monitoring & Optimization

• Monitor database health, server performance, resource utilization, and availability.
• Analyze and resolve performance bottlenecks, blocking, deadlocks, and resource contention issues.
• Optimize database performance through query tuning, index optimization, and database configuration improvements.
• Utilize Azure Monitor and Log Analytics to proactively track performance and system reliability.
• Perform performance tuning and configuration management across multiple DBMS platforms.

<>High Availability, Backup & Disaster Recovery

• Design, implement, test, and maintain database backup and recovery strategies.
• Develop and execute High Availability (HA) and Disaster Recovery (DR) architectures.
• Configure and support:
• Always On Availability Groups
• Log Shipping
• Failover Cluster Instances (FCI)
• Database Replication
• Lead HA/DR solution deployments and replication management efforts.
• Participate in Disaster Recovery, Business Resumption, Incident Response, or similar emergency response teams when required.

<>Database Architecture & Strategy

• Design and orchestrate Azure and on-premises DBMS architectures that are scalable, secure, and resilient.
• Collaborate with application development teams to establish DBMS architecture standards and data exchange frameworks.
• Define database strategies aligned with business objectives and long-term organizational goals.
• Apply business intelligence concepts and best practices when developing database standards.
• Assist in solution design, business case development, and technical planning activities.

<>Security & Compliance

• Implement and manage role-based access control (RBAC), database permissions, and user authentication.
• Configure database encryption both at rest and in transit.
• Support Microsoft Entra ID integration and Azure RBAC implementations.
• Utilize Azure Key Vault for secure credential and secrets management.
• Partner with the Chief Information Security Officer (CISO) to enforce security standards established by the State of Ohio and the Ohio Department of Rehabilitation and Correction.
• Ensure compliance with organizational security policies and regulatory requirements.

<>Developer Support & Database Development

• Support development teams with:
• Schema design and refinement
• Table design and normalization
• Data type selection and optimization
• Database coding standards
• Review and optimize:
• Stored Procedures
• Functions
• Triggers
• Complex T-SQL queries
• Support SSIS package development and ETL workflows.

<>Automation & Administration

• Develop and maintain T-SQL, PowerShell, and command-line scripts for DBA automation.
• Automate routine maintenance tasks, including:
• Index maintenance
• Database integrity checks
• Statistics updates
• Backup management
• Monitoring and alerting
• Reporting
• Provide Tier III support for complex database and infrastructure issues.

<>Documentation & Governance

• Create and maintain documentation for:
• Installation procedures
• Database configurations
• Security standards
• Monitoring processes
• Migration procedures
• HA/DR configurations
• Operational best practices
• Establish and maintain database administration standards and governance processes.

<>Collaboration & Leadership

• Work closely with:
• IT Architecture teams
• Chief Information Officer (CIO)
• IT Management
• Application Development teams
• Information Security teams
• Mentor junior database administrators and technical staff through formal and informal training.
• Provide technical leadership and guidance for enterprise database initiatives.

• Bachelor’s degree in Computer Science, Information Technology, or a related technical discipline; or equivalent professional experience.

<>Experience

• 5+ years of hands-on experience administering enterprise Microsoft SQL Server environments.
• Experience supporting both on-premises and Azure-based database platforms.
• Experience designing and implementing enterprise HA/DR solutions.

<>Technical Skills

• Advanced expertise with SQL Server Management Studio (SSMS).
• Strong knowledge of SQL Server architecture and database internals.
• Advanced proficiency in Transact-SQL (T-SQL).
• Experience with SQL Server Integration Services (SSIS) and ETL processes.
• Experience with:
• Azure SQL Database
• Azure SQL Managed Instance
• SQL Server on Azure Virtual Machines
• Knowledge of:
• Azure Monitor
• Log Analytics
• Microsoft Entra ID
• Azure Key Vault
• Azure Backup
• Azure RBAC
• Experience with on-premises to Azure database migration projects.
• Understanding of Azure database security, networking, scalability, cost management, and HA/DR capabilities.
• Experience using third-party database tools such as Redgate.

<>Soft Skills

• Strong analytical and troubleshooting abilities.
• Excellent problem-solving and critical thinking skills.
• High attention to detail.
• Strong written and verbal communication skills.
• Ability to explain technical database concepts to non-technical stakeholders.
• Ability to work effectively in collaborative, cross-functional environments.