What are the responsibilities and job description for the SQL Server Database Administrator with Security Clearance position at Spalding, a Saalex company?
Description Spalding, a Saalex Company 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
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