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. 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. 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 /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.
