SQL Server Database Administrator
Core
Install, configure, upgrade, and administer SQL Server database engine and related tools (SSIS, SSAS, SSRS) in on-premises and AWS cloud environments for government clients.
Role type
Senior SQL Server Database Administrator
Builds
Production database infrastructure and cloud migration solutions for government contracts
Domain
Government contracting / Cloud migration / Database Administration
Deliverable
Production ML models | product features | dashboards & analysis | infrastructure
Required skills
SQL Server administration (2016, 2019, 2022), performance tuning, query optimization, CompTIA Security+ certification, active SECRET clearance, T-SQL scripting, PowerShell scripting, database backup and restore, cloud migration planning, STIG compliance configuration
Preferred skills
SQL Server Management Studio (SSMS), SQL Server Profiler, SQL high-availability solutions (FCI, AAG), Rubrik, AWS RDS, Sybase, Oracle, other RDBMS platforms, SQL Server certifications, TS/SSBI clearance
Technologies
AWS, Oracle, PowerShell, SSAS, SSIS, SQL Server, Rubrik, RDS, Sybase
Responsibilities
Install, configure, upgrade, and administer SQL Server database engine and related tools; Configure SQL Server instances to meet DoD STIG compliance requirements; Partner with systems administration, storage, networking, and web teams to resolve connection and performance problems; Collaborate with software engineers to set up and test databases, accounts, mail, jobs, and related components; Troubleshoot databases, schemas, and user accounts; Configure and restore database backups; Perform daily health checks on databases, backups, exports, jobs, and storage; Maintain team documentation including inventories, security plans, SOPs, guides, and STIG checklists; Support the re-platforming and migration of government on-premises databases and schemas to cloud environments; Coordinate with cloud migration SMEs, system and web administrators, and data center personnel to validate and update migration plans, specifications, actions, and task assignments; Create and maintain SQL Server cloud migration documentation including detailed SOPs and checklists; Follow cloud migration timelines and schedules; Track, document, and report progress on database cloud migrations; Escalate issues and risks to the cloud project manager