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 including security, schema, stored procedures, and maintenance jobs
  • Create and maintain databases in a Clustered Server environment and apply expert data model design
  • Integrate solutions with legacy infrastructure using data lakes, data warehouses, and data marts
  • Implement database redundancy and high availability (mirroring, log shipping) and perform full backup/recovery
  • Facilitate migration of systems into cloud infrastructure and upgrade SQL Server versions
  • Setup reporting servers and develop reports using Microsoft SQL Server Reporting Services (SSRS)
  • Be responsible for all DBA functions and report development utilizing software systems architecture and design

Requirements

  • Top Secret Clearance required
  • Experience 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 design, development and maintenance of various data models
  • Working knowledge of data lakes, data warehouse and data mart architectures
  • Metadata and data modeling, data flow, entity relationship diagrams, schema architectures
  • Experience with query languages and SQL optimization best practices
  • Database redundancy and high availability techniques (mirroring, log shipping)
  • Full backup and recovery capabilities for Microsoft SQL Server 2019/2022
  • Experience facilitating migration of systems into cloud infrastructure
  • Upgrading SQL Servers from lower versions to 2019+ and using SSRS
  • Setup reporting servers and perform 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 model designSQL optimizationdata lakesdata warehousesdata martsbackup and recoveryreport development
Certifications
Top Secret Clearance