INTERVIEW= Onsite / Virtual
JOB TYPE= Onsite
SCOPE
- 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 SQL Server, 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
Current Microsoft certifications relevant to Azure Database Administrator, Azure Data Engineer, Azure Solutions Architect, or related database technologies are preferred.