Database Administrator

Key Responsibilities:

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

Minimum Qualifications:

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

Educational qualifications meeting at least one of the following levels:
 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.