SQL DBA

• Install, configure, patch, upgrade, and maintain SQL Server environments across production, staging, and development systems.
• Monitor database performance, troubleshoot issues, optimize queries, tune indexes, and resolve blocking or deadlock situations.
• Design, implement, and maintain backup, recovery, High Availability (HA), and Disaster Recovery (DR) solutions, including Always On Availability Groups, Log Shipping, Failover Clustering, and Replication.
• Administer Azure SQL Database, Azure SQL Managed Instance, and SQL Server running on Azure Virtual Machines.
• Develop and maintain database architectures that support business requirements, scalability, security, and operational efficiency.
• Configure and support Azure monitoring, backup, migration, disaster recovery, and security solutions.
• Collaborate with application developers and architects to review database designs, schemas, stored procedures, functions, triggers, and complex T-SQL code.
• Implement role-based security models, database permissions, encryption, and compliance standards.
• Create and maintain comprehensive technical documentation, standards, procedures, and best practices.
• Automate maintenance activities using T-SQL, PowerShell, and scripting tools.
• Provide Tier III support for complex database incidents and critical production issues.
• Work closely with IT leadership, architects, and security teams to align database environments with organizational standards and State of Ohio security requirements.
• Mentor junior staff and contribute to database strategy, planning, and operational excellence initiatives.

Major Technologies

• Microsoft SQL Server
• Azure SQL Database
• Azure SQL Managed Instance
• SQL Server on Azure Virtual Machines
• SQL Server Management Studio (SSMS)
• Transact-SQL (T-SQL)
• SQL Server Integration Services (SSIS)
• Azure Monitor & Log Analytics
• Microsoft Entra ID
• Azure Key Vault
• Azure Backup
• Azure RBAC
• Always On Availability Groups
• Log Shipping
• Failover Clustering
• Database Replication
• PowerShell
• Redgate and Third-Party Monitoring Tools

• 5+ years of hands-on experience administering enterprise Microsoft SQL Server environments.
• Advanced SQL Server performance tuning, monitoring, troubleshooting, and optimization experience.
• Strong expertise in T-SQL development, stored procedures, functions, indexing, and database design.
• Experience implementing and supporting HA/DR solutions.
• Experience managing Azure SQL platforms and hybrid cloud environments.
• Knowledge of database security, encryption, access controls, compliance, and auditing.
• Experience with database migration, integration, and ETL processes using SSIS.
• Strong scripting and automation skills using PowerShell and T-SQL.
• Excellent analytical, troubleshooting, documentation, and communication skills., * Bachelor//’s degree in Computer Science, Information Technology, or a related technical field (or equivalent experience).
• Experience with Azure database migrations and cloud modernization initiatives.
• Familiarity with cost optimization, scalability planning, and Azure networking concepts.
• Experience with Redgate or similar database monitoring and backup tools.
• Experience supporting Disaster Recovery, Incident Response, or Business Continuity operations.

This position is ideal for a senior SQL Server DBA who can manage both on-premises and Azure database environments, drive performance and reliability improvements, implement robust security and disaster recovery solutions, and provide technical leadership for enterprise database platforms.