Senior Discovery Database Administrator (DBA) (Top Secret Clearance Required)

CGS Federal (Contact Government Services); San Francisco (CA); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Health, Dental, and Vision

Life Insurance

401k

Flexible Spending Account (Health, Dep

Paid Time Off and Holidays

Job summary

Contact Government Services (CGS) seeks a Senior Discovery Database Administrator (DBA) to support legal accounts and manage MS SQL Server environments. The role emphasizes security, backups, reports, and high availability across 2019 and 2022 platforms.

You will design data models, work with data lakes/warehouses, and migrate systems to cloud infrastructure while developing SSRS reports and maintaining the reporting server.

Qualifications

• Experience administering Microsoft SQL Server 2019/2022.
• Maintain security, backups, indexing, and reports.
• Design data models and data warehouse related tasks.

Responsibilities

• Provide database administration support for MS SQL Server 2019/2022.
• Set up security, create tables, indexes, and stored procedures.
• Design data models, data lakes, and data warehouses integration.
• Migrate systems to cloud infrastructure and ensure high availability.
• Develop SSRS reports and maintain reporting server.

Skills

SQL Server Administration

Database maintenance

Cloud migration

SSRS reporting

Tools

SQL Server 2019

SQL Server 2022

SSRS

Job description

Senior Discovery Database Administrator (DBA)

Employment Type: Full-Time, Executive-Level

Department: Legal

CGS is seeking a dedicated Senior Discovery Database Administrator to join a fast-paced and hard-working team to assist with any legal accounts. As a Senior Discovery Database Administrator, you will play a key role in supporting various aspects of the company's portfolio.

CGS brings motivated, highly skilled, and creative people together to solve the government’s most dynamic problems with cutting-edge technology. To carry out our mission, we are seeking candidates who are excited to contribute to government innovation, appreciate collaboration, and can anticipate the needs of others. Here at CGS, we offer an environment in which our employees feel supported, and we encourage professional growth through various learning opportunities.

Skills and attributes for success:

• The Contractor shall provide database administration support to include, but not limited to the following activities:
• Contractor shall assist in managing Microsoft SQL Server 2019 and 2022 to include setting up security, creating tables, indexes, stored procedures, designing SQL reports, and creating maintenance jobs etc. Must apply best practices for optimizing databases;
• Contractor shall assist in creating and maintaining databases in a Clustered Server environment. Must apply expert knowledge of the design, development and maintenance of various data models and their components;
• Contractor shall apply 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 to integrate a seamless solution within legacy infrastructure;
• Contractor shall mirror database servers, log shipping, latest techniques for Database redundancy and high Availability, and full backup and recovery capabilities of the Microsoft SQL Server 2019 and 2022 platform;
• Contractor shall facilitate the migration of system into cloud infrastructure
• Contractor shall upgrade SQL Servers from lower versions to the latest version (version 2019 and up), and create reports using Microsoft SQL Server Reporting Services (SSRS);
• Contractor shall setup a reporting server and be responsible for all DBA functions and report development utilizing Software Systems development Architecture and Design

Our Commitment:

Contact Government Services (CGS) strives to simplify and enhance government bureaucracy through the optimization of human, technical, and financial resources. We combine cutting-edge technology with world-class personnel to deliver customized solutions that fit our client’s specific needs. We are committed to solving the most challenging and dynamic problems.

For the past seven years, we’ve been growing our government-contracting portfolio, and along the way, we’ve created valuable partnerships by demonstrating a commitment to honesty, professionalism, and quality work.

Here at CGS we value honesty through hard work and self-awareness, professionalism in all we do, and to deliver the best quality to our consumers mending those relations for years to come.

We care about our employees. Therefore, we offer a comprehensive benefits package.

• Health, Dental, and Vision
• Life Insurance
• 401k
• Flexible Spending Account (Health, Dependent Care, and Commuter)
• Paid Time Off and Observance of State/Federal Holidays

Contact Government Services, LLC is an Equal Opportunity Employer. Applicants will be considered without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Join our team and become part of government innovation!

For more information about CGS please visit: https://www.cgsfederal.com or contact:

Phone: [phone]Email: [e-mail]

#CJ

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.