- Install, configure, administer, patch, upgrade, and monitor Microsoft SQL Server and Azure SQL environments.
- Manage database instances, storage, access controls, service accounts, encryption, auditing, jobs, alerts, and monitoring.
- Optimize database performance through query analysis, execution plans, indexing, statistics, capacity planning, and resource allocation.
- Implement, test, and document backup, restore, high availability, disaster recovery, and database integrity procedures.
- Develop and maintain logical and physical data models, schemas, data dictionaries, tables, stored procedures, views, and functions.
- Build and troubleshoot ETL/ELT and data integration processes, including mapping, transformation, validation, scheduling, and error handling.
- Support Windows Services, scheduled tasks, application connectivity, approved Azure services, and hybrid integrations.
- Gather and translate stakeholder requirements into secure, maintainable database solutions.
- Resolve incidents, perform root-cause analysis, and implement corrective changes.
- Maintain assessments, modernization plans, integration roadmaps, architecture documentation, runbooks, and SOPs.
- Provide knowledge transfer, mentoring, weekly status reports, and monthly time reports.
Required 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 administration of Azure SQL Database, Azure SQL Managed Instance, or SQL Server hosted in Microsoft Azure.
- Experience with installation, configuration, patching, upgrades, security, monitoring, performance tuning, capacity planning, backup, recovery, and high availability.
- Strong T-SQL, database design, indexing, stored procedures, views, functions, execution plans, and query optimization skills.
- Experience designing and supporting ETL/ELT and integration processes, including data mapping, validation, scheduling, and error handling.
- Experience troubleshooting Windows Services and scheduled processes interacting with SQL Server, Azure SQL, Power BI, or enterprise applications.
- Preferred Qualifications
- Experience with Azure services supporting integration, monitoring, security, storage, automation, or data processing.
- Experience eliciting, analyzing, documenting, and validating business and technical requirements.
- Government or regulated-environment experience, including role-based access, auditing, encryption, least privilege, and data protection.
- Familiarity with Azure DevOps, source control, deployment pipelines, Infrastructure as Code, PowerShell, or database automation.
- Current Microsoft certifications relevant to Azure database administration, Azure data services, or SQL Server.
Education
Bachelor’s or master’s degree in Computer Science, Information Systems, or a related field, or equivalent work experience.