Senior SQL & Discovery DBA – Data Lakes & Cloud Migrations

CGS Federal; Los Angeles (CA); On-site; USD 183,000 - 264,000; Full time

Benefits offered by this job

Health, Dental, and Vision

Life Insurance

401k

Flexible Spending Account

Paid Time Off and Holidays

Job summary

CGS Federal is seeking a Senior Discovery Database Administrator (DBA) to join our Legal department. The role focuses on administering Microsoft SQL Server 2019 and 2022, ensuring security, performance, and high availability, while shaping data models and reporting capabilities for government-related accounts.

The Senior DBA will design databases, develop maintenance jobs, and support cloud migration initiatives.

Qualifications

• Proven experience administering MS SQL Server 2019/2022 with security, performance tuning, and high availability.
• Experience designing and maintaining data models, schemas, tables, indexes, and reports.
• Experience migrating systems to cloud environments and managing SSRS reports.

Responsibilities

• Provide database administration support for Microsoft SQL Server 2019/2022.
• Manage security, backups, restores, and maintenance jobs.
• Develop and maintain SSRS reports and data models.
• Support data lake/warehouse/data mart architectures and cloud migration.

Skills

SQL Server

Security configuration

Tables & indexes

Stored procedures

SSRS

Maintenance jobs

Clustered Server environment

Data lake/warehouse/data mart

Data modeling

Backup & recovery

Cloud migration

Job description

CGS Federal is seeking a Senior Discovery Database Administrator (DBA) to join our Legal department. The role focuses on administering Microsoft SQL Server 2019 and 2022, ensuring security, performance, and high availability, while shaping data models and reporting capabilities for government-related accounts.

The Senior DBA will design databases, develop maintenance jobs, and support cloud migration initiatives.