What are the responsibilities and job description for the SQL Server Database Administrator position at Spalding?
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.
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.
- 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
