Senior Discovery DBA: SQL Server, Data Warehousing & Cloud

Cgsfederal; Los Angeles (CA); On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Health, Dental, and Vision

Life Insurance

401k

Flexible Spending Account (FSA)

Job summary

CGS seeks a Senior Discovery Database Administrator to join a fast-paced team supporting legal accounts and portfolio services. You will provide DBA functions, security, table/index design, and maintenance jobs within SQL Server environments.

The role requires designing data models, data lakes/warehouses, and implementing high availability with backups. You will migrate systems to cloud infrastructure and develop reports using SSRS.

Qualifications

• Extensive experience administering Microsoft SQL Server 2019/2022.
• Experience with data lakes, data warehouses and data marts.
• Ability to implement high availability, backup and recovery strategies.
• Experience migrating systems to cloud infrastructure.
• Strong report development using SSRS.

Responsibilities

• Provide database administration support, including security setup, tables, indexes, and stored procedures.
• Manage SQL Server 2019/2022 environments and maintain maintenance jobs.
• Design and maintain databases in clustered server environments and data models.
• Apply data warehouse architectures, metadata, data modeling and data flows.
• Mirror servers, implement log shipping, and ensure full backup/recovery capabilities.

Skills

SQL Server

Database design

Backup and recovery

Performance tuning

Data warehousing

Tools

SSRS

SSMS

Job description

CGS seeks a Senior Discovery Database Administrator to join a fast-paced team supporting legal accounts and portfolio services. You will provide DBA functions, security, table/index design, and maintenance jobs within SQL Server environments.

The role requires designing data models, data lakes/warehouses, and implementing high availability with backups. You will migrate systems to cloud infrastructure and develop reports using SSRS.