Database Administrator

• Manage, monitor, maintain, and support enterprise Microsoft SQL Server and Azure SQL databases in production and non-production environments.
• Install, configure, patch, upgrade, and administer database platforms, instances, databases, storage, access, and security in accordance with Department standards.
• Perform performance monitoring and tuning, including query analysis, indexing, execution plan review, capacity planning, and resource allocation.
• Design, implement, test, maintain, backup, restore, high-availability, disaster recovery, and database integrity processes.
• Develop and maintain logical and physical data designs, database schemas, data dictionaries, stored procedures, views, functions, and related database objects.
• Design, develop, support, and troubleshoot data transformation and integration processes using SQLServer, Azure services, ETL/ELT tools, APIs, files, and other approved technologies.
• Support and troubleshoot Windows Services and scheduled processes that interact with databases, integrations, and enterprise applications.
• Collaborate with business and technical stakeholders to elicit, analyze, document, validate, and translate business requirements into database and data solutions.
• Ensure database availability, performance, security, integrity, accessibility, and compliance with Department policies and applicable regulatory standards.

• 5+ years of recent experience administering enterprise Microsoft SQL Server environments, including production and non-production systems of medium to high complexity.
• Hands-on experience administering Azure SQL Database, Azure SQL Managed Instance, or SQL Server hosted in Microsoft Azure.
• Demonstrated experience with database installation, configuration, patching, upgrades, security administration, monitoring, performance tuning, capacity planning, backup, recovery, and high availability.
• Strong experience with T-SQL, schema and physical database design, indexing, stored procedures, views, functions, execution plans, and query optimization.
• Experience designing and supporting data transformation and integration processes, including ETL/ELT, data mapping, validation, scheduling, and error handling.
• Experience supporting or troubleshooting Windows Services and scheduled processes that interact with Microsoft SQL Server, Azure SQL, Power BI, or enterprise applications.

Preferred Experience:

• Experience with Azure services that support database, integration, monitoring, security, storage, automation, or data processing workloads.
• Experience eliciting, analyzing, documenting, and validating business and technical requirements with stakeholders.
• Experience supporting regulated or government environments and implementing role-based access, auditing, encryption, least privilege, and data protection practices.
• Familiarity with Azure DevOps, source control, deployment pipelines, Infrastructure as Code, PowerShell, or other database automation and release-management practices.
• Current Microsoft certifications relevant to Azure database administration, Azure data services, or SQL Server are preferred., * Bachelor’s or master’s degree in Computer Science, Information Systems, or related field; or equivalent work experience.
• Bachelor’s or master’s degree in Computer Science, Information Systems, or a related field; or equivalent work experience.