What are the responsibilities and job description for the SQL Server Database Administrator with Security Clearance position at Spalding Consulting, Inc., a Saalex company?
Description Spalding Consulting, Inc. is seeking a SQL Server Database Administrator in Patuxent River, MD. Spalding Consulting, Inc. is a professional services company delivering cutting-edge solutions to the Department of Defense since 2001. Our expert-level solutions include software development, information technology, program management, financial management and business intelligence services. Spalding Consulting offers competitive compensation, career development, flexible work schedules and excellent benefits. Position Type : Full-Time Salary Range : $120k - $145k (depending on experience)
Work Location : Hybrid remote / in-office (see on-site requirements below)
- On-Site Requirements : Candidates are required to work onsite at PAX approximately 3 days per week and must reside within 90 miles of Patuxent River, MD. Future on-site / telework requirements / schedules may change as additional client direction is received. Essential Functions :
- 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 or required. Requirements Required :
- 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 degree and 3 years related experience OR AA / AS degree and 7 years related experience OR HS and 9 years relatedexperience required. 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 / Experience : BS / BA degree and 3 years related experience OR AA / AS degree and 7 years related experience 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
- 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 Plan
Salary : $120,000 - $145,000
