SQL Server Database Administrator
Role details
Job location
Tech stack
Job description
-
Install, configure, upgrade, and administer SQL Server database engine, SSIS, SSAS, SSRS and related products in on premise and AWS cloud environments.
-
Configure SQL Server instances to ensure compliance to DoD STIGs.
-
Work with systems administration, storage, networking and web teams to resolve connection and performance issues.
-
Work with software engineers to configure and test databases, accounts, mail, jobs, etc.
-
Troubleshoot databases, schemas, and user accounts.
-
Configure and recover database backups.
-
Perform daily checks of databases, backups, exports, jobs, and storage.
-
Maintain team documentation, including inventory, security plans, SOPs, guides and STIG checklists.
-
Assist with re-platforming and migration of government on-premise databases and schemas to cloud environments:
-
Communicate and work with cloud migration SMEs, system/web administrators, and data center personnel to verify and update database migration plan, specifications, actions, and tasking.
-
Create and maintain SQL Server database cloud migration documentation including detailed SOPs and checklists.
-
Adhere to cloud migration schedules.
-
Track, document, and provide progress on database migrations.
-
Report issues and risks to cloud project manager.
Other duties as assigned.
Requirements
- Systems-level 2016/2019/2022 SQL Server administration experience required.
- Experience with performance tuning and query optimization required.
- CompTIA Security+ certification required (must show proof of cert prior to interview).
- BS/BA or AA/AS degree and 7+ years related experience OR OR HS and 9 years related experience.
Desired:
- Experience with SQL Server Management Studio (SSMS) and SQL Server Profiler preferred.
- Experience with scripting (T-SQL, PowerShell) preferred.
- Experience with HA solutions for SQL including FCI and AAG a plus.
- Experience with migrating existing SQL Server databases to cloud-based (AWS) environments a plus.
- Experience with Rubrik, AWS RDS, Sybase, Oracle, and other RDBMS' a plus.
Education:
- BS/BA or AA/AS degree and 7+ years related experience OR OR HS and 9 years relatedexperience.
Security Clearance:
- Active TS/SSBI clearance desired or active Secret clearance with the ability to obtain TS/SSBI. Requirements to obtain a clearance include US Citizenship, security investigation, etc.
Benefits & conditions
- Health Care Plan (Medical, Dental & Vision)
- Retirement Plan (401k, IRA)
- Life Insurance (Basic, Voluntary & AD&D)
- Paid Time Off (Vacation, Sick & Public Holidays)
- Short Term & Long Term Disability
- Training & Development
- Wellness Resources
- Stock Option Benefit