CGS Federal (Contact Government Services)

Senior Discovery Database Administrator, DBA

CGS Federal (Contact Government Services)

full-time

Posted on:

Location Type: Hybrid

Location: Los Angeles • California • 🇺🇸 United States

Visit company website
AI Apply
Apply

Salary

💰 $182,700 - $263,900 per year

Job Level

Senior

Tech Stack

CloudMS SQL ServerSQL

About the role

  • Provide database administration support for legal accounts and company portfolio
  • Manage Microsoft SQL Server 2019 and 2022: security, tables, indexes, stored procedures, SQL reports, maintenance jobs
  • Create and maintain databases in a Clustered Server environment
  • Design, develop, and maintain data models and related components
  • Integrate data lakes, warehouses and data marts with legacy infrastructure using metadata and data modeling
  • Implement mirroring, log shipping, redundancy, high availability, and backup/recovery strategies
  • Facilitate migration of systems into cloud infrastructure
  • Upgrade SQL Server instances and develop SSRS reports
  • Setup and manage reporting server and perform DBA functions and report development
  • Collaborate within the legal department and support government contracting work

Requirements

  • Top Secret Clearance Required
  • Manage Microsoft SQL Server 2019 and 2022 including security, tables, indexes, stored procedures, SQL reports, and maintenance jobs
  • Apply best practices for optimizing databases
  • Create and maintain databases in a Clustered Server environment
  • Expert knowledge of design, development and maintenance of various data models and their components
  • Working knowledge of data lakes, data warehouse and data mart architectures, metadata and data modeling, data flow, entity relationship diagram, schema architectures and query languages
  • Implement database mirroring, log shipping, redundancy, high availability, and full backup and recovery for SQL Server 2019/2022
  • Facilitate migration of systems into cloud infrastructure
  • Upgrade SQL Servers from lower versions to 2019+ and create reports using SSRS
  • Setup reporting server and perform all DBA functions and report development
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
Microsoft SQL Server 2019Microsoft SQL Server 2022database administrationdata modelingSSRSdatabase mirroringlog shippinghigh availabilitybackup and recoveryClustered Server environment
Soft skills
collaborationcommunication
Certifications
Top Secret Clearance
CGS Federal (Contact Government Services)

Senior Database Administrator

CGS Federal (Contact Government Services)
Seniorfull-time$89k–$121k / yearCalifornia · 🇺🇸 United States
Posted: 10 hours agoSource: jobs.lever.co
ASP.NETAWSAzureCloudMS SQL Server.NETPostgresSDLCSQLVMware
CGS Federal (Contact Government Services)

Senior Discovery Database Administrator

CGS Federal (Contact Government Services)
Seniorfull-time$183k–$264k / yearCalifornia · 🇺🇸 United States
Posted: 10 hours agoSource: jobs.lever.co
CloudMS SQL ServerSQL
CGS Federal (Contact Government Services)

Discovery Database Administrator, DBA

CGS Federal (Contact Government Services)
Mid · Seniorfull-time$142k–$193k / yearCalifornia · 🇺🇸 United States
Posted: 23 hours agoSource: jobs.lever.co
CloudMS SQL ServerSQL
CGS Federal (Contact Government Services)

Senior Discovery Database Administrator

CGS Federal (Contact Government Services)
Seniorfull-time$183k–$264k / yearCalifornia · 🇺🇸 United States
Posted: 1 day agoSource: jobs.lever.co
CloudMS SQL ServerSQL