SQL Server Database Administrator

Full-time - Mid Level

MD

About the position

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.

Responsibilities

• 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

• 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 related experience required.

Nice-to-haves

• 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.

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