Senior DBA and Data Architect

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:

No

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:  

• Experience with Microsoft SQL Server technologies  
• Experience with development of SQL Server Integration Services (SSIS) packages 
• Microsoft Azure Cloud 

GDIT IS YOUR PLACE:

• Full-flex work week to own your priorities at work and at home
• 401K with company match
• Comprehensive health and wellness packages
• Internal mobility team dedicated to helping you own your career
• Professional growth opportunities including paid education and certifications
• Cutting-edge technology you can learn from
• Rest and recharge with paid vacation and holidays

The likely salary range for this position is $110,614 - $149,500. This is not, however, a guarantee of compensation or salary. Rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range.

Scheduled Weekly Hours:

40

Travel Required:

Less than 10%

Telecommuting Options:

Remote

Work Location:

Any Location / Remote

Additional Work Locations:

Total Rewards at GDIT:

Our benefits package for all US-based employees includes a variety of medical plan options, some with Health Savings Accounts, dental plan options, a vision plan, and a 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match. To encourage work/life balance, GDIT offers employees full flex work weeks where possible and a variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave. GDIT typically provides new employees with 15 days of paid leave per calendar year to be used for vacations, personal business, and illness and an additional 10 paid holidays per year. Paid leave and paid holidays are prorated based on the employee’s date of hire. The GDIT Paid Family Leave program provides a total of up to 160 hours of paid leave in a rolling 12 month period for eligible employees. To ensure our employees are able to protect their income, other offerings such as short and long-term disability benefits, life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance are provided or available. We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most.

We are GDIT. A global technology and professional services company that delivers consulting, technology and mission services to every major agency across the U.S. government, defense and intelligence community. Our 30,000 experts extract the power of technology to create immediate value and deliver solutions at the edge of innovation. We operate across 30 countries worldwide, offering leading capabilities in digital modernization, AI/ML, Cloud, Cyber and application development. Together with our clients, we strive to create a safer, smarter world by harnessing the power of deep expertise and advanced technology.

We connect people with the most impactful client missions, creating an unparalleled work experience that allows them to see their impact every day. We create opportunities for our people to lead and learn simultaneously. From securing our nation’s most sensitive systems, to enabling digital transformation and cloud adoption, our people are the ones who make change real.

Equal Opportunity Employer / Individuals with Disabilities / Protected Veterans