Jobs and Careers

Senior DBA and Data Architect

General Dynamics Information Technology

USA AL Home Office (ALHOME), United States, United Statesfull_timeVerifiedPosted 5 Mar 2025

💰 $149,500/yr($110,614/yr – $149,500/yr)

About the role

Type of Requisition:

Regular

Clearance Level Must Currently Possess:

None

Clearance Level Must Be Able to Obtain:

None

Public Trust/Other Required:

NACI (T1)

Job Family:

Data Science

Job Qualifications:

Skills:

Business Intelligence (BI), Data Integration, Data Management

Certifications:

None

Experience:

7 + years of related experience

US Citizenship Required:

Job Description:

GDIT is seeking a Senior DBA and Data Architect to join our team supporting our client at CDC. This is a technical role focused on defining and implementing Database and Data solutions. The person will conduct full lifecycle activities to include requirements analysis and design, develop analysis and reporting capabilities, and continuously monitor performance and quality control plans. This work involves designing and administering data collection tools, cleaning, merging, and managing new and existing data sets as well as establishing and maintaining data quality procedures to ensure accuracy and timeliness of data.

Responsibilities:

Monitor and report system resource consumptions to assure databases meet requirements
Identify, analyze, and interpret trends or patterns in complex data sets
Identify and define database processes improvement opportunities
Coordinate with the database developers and ensure implementation of standards and modular structures
Design & administer all schemas in SQL Server databases; includes management of all database objects & dependencies
Create and manage the Data Flow & Data Modeling for multiple systems
Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements
Responsible for monitoring, verifying & tracking all structure changes in SQL Server and other databases through source control
Manage & update the entity relationship diagrams (ERDs) (logical & physical) for SQL Server and other databases
Review, update, & manage data dictionaries for all schemas in SQL Server

Conduct high-level data interpretation and analysis of data using a data analytics platform
Collection and analysis of data volume metrics to support database sizing, tuning, capacity planning and data retention activities 
Exhibit competency in problem solving, data analysis, business rule validation, data integration, data quality.  
Provide technical assistance in data management, analysis, and visualizations.
Prepare written summaries and presentations that reflect the results of the data analysis and present findings to agency leadership
Support a wide array of data management technologies, storage platforms, data management systems, data warehouses, data marts, data lakes, data farming tools, data repositories, registries, data analytical technologies, business intelligence (BI) tools, applications data sources and data cloud technologies and services.

QUALIFICATIONS:

Required skills and experience:

Bachelor’s degree and 10+ years’ experience. (Degree in Computer Science, Information Systems or related area is preferred)
7+ years of current experience as a database architect with Microsoft SQL Server
Extensive experience in the development of databases objects including stored procedures, triggers, views and functions
Experience with trouble shooting database performance issues including optimization
Extensive experience with packaging and delivering database updates for production releases
Experience with creating database documentation including ERD’s, data dictionaries and architecture diagrams.
Experience in data management technologies, and data cloud technologies and services.
Must have extensive experience in implementing and supporting CDC cloud activities and data engineering initiatives.

Desired skills and experience: 