INTERVIEW= Onsite / Virtual
JOB TYPE= Onsite
SCOPE
The Contractor will provide an experienced Senior Database Administrator to:
" 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.
