Discovery Database Administrator, Top Secret Clearance Required
CGS Federal (Contact Government Services)
full-time
Posted on:
Location Type: Hybrid
Location: Boston • Massachusetts • United States
Visit company websiteExplore more
Salary
💰 $142,100 - $192,850 per year
Tech Stack
About the role
- Provide database administration support
- Assist in managing Microsoft SQL Server environments
- Apply best practices for optimizing databases
- Create and maintain databases in clustered environments
- Implement data modeling and integration solutions
- Facilitate cloud infrastructure migration
- Upgrade SQL Servers and develop reporting server capabilities
Requirements
- Database administration support including managing Microsoft SQL Server 2019 and 2022
- Setting up security, creating tables, indexes, stored procedures
- Designing SQL reports and creating maintenance jobs
- Creating and maintaining databases in a Clustered Server environment
- Knowledge of data lakes, data warehouse and data mart architectures
- Familiarity with metadata and data modeling, data flow, and entity relationship diagram
- Knowledge of mirroring database servers and log shipping
- Facilitating migration to cloud infrastructure
- Upgrading SQL Servers and creating reports using Microsoft SQL Server Reporting Services (SSRS)
Benefits
- Health, Dental, and Vision
- Life Insurance
- 401k
- Flexible Spending Account (Health, Dependent Care, and Commuter)
- Paid Time Off and Observance of State/Federal Holidays
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
database administrationMicrosoft SQL Server 2019Microsoft SQL Server 2022data modelingdata integration solutionsSQL reportingcreating tablescreating indexesstored proceduresmaintenance jobs