Senior Database Analyst/Administrator

GD Information Technology, Inc.; Virginia; Hybrid; USD 108,000 - 138,000; Full time

Job summary

General Dynamics Information Technology (GDIT) is seeking a Database Analyst/Administrator to support the AOUSC Mission Support Systems Division. The role involves agile development, data modeling, ETL, and cloud DB work across multiple platforms including SQL Server, Informix, and Oracle.

You will collect and analyze large data sets, develop data visualizations, and collaborate with stakeholders to map business requirements to technical solutions.

Qualifications

• At least seven (7+) years of server database maintenance and analysis.
• Bachelor's degree in Computer Science, Computer Programming, Computer Engineering or related field; equivalent experience considered.
• DB/cloud certification preferred (e.g., Microsoft Azure DB Admin, Azure Solutions Architect)
• Proficient with Microsoft SQL Server, Informix, Oracle.
• Experience with Snowflake and Azure cloud platform.
• Experience with DB environment installation, configuration, and ongoing admin support.
• Strong data warehouse understanding; adept at data modeling, mapping, and data marts.
• Experience with cloud-based DB solutions and data migration to multi-cloud/hybrid platforms.
• Ability to work independently, prioritize, and deliver.
• Strong analytical, technical, and communication skills.

Responsibilities

• Operate within an Agile development environment with daily scrums and sprint planning.
• Develop standards for performance, security, scalability, and maintainability.
• Define and coordinate data elements, relationships, and standards across systems.
• Develop and implement database management policies and quality controls.
• Collaborate with Product Owners to map business requirements to technical specs.
• Engage with agency leaders to develop innovative data analysis techniques.
• Document complex workflow designs for project teams and stakeholders.
• Analyze large data sets to guide business decisions and create data visualizations.
• Develop stored procedures, views, and ETL processes in SQL Server.
• Design dimensional data models and data marts to support BI solutions.
• Deploy ETL packages using CI/CD pipelines and manage version control.

Skills

SQL Server

Snowflake

Azure Cloud

Data Modeling

ETL

CI/CD

Splunk

Data Warehousing

Analytics

SAFe / Agile

Education

Bachelor's degree in CS/related field

Cloud or DB certification

Tools

Microsoft SQL Server

Informix

Oracle

Snowflake

Azure

CI/CD tooling

Atlassian Suite

Splunk

Job description

Database Analyst / Administrator

GDIT has an opportunity for a dynamic and talented candidate to join our team supporting the Administrative Office of the US Courts (AOUSC) Mission Support Systems Division (MSSD) in one of its mission-critical applications that is used by all federal courts’ community. MSSD has a mature agile practice using the Scaled Agile Framework (SAFe) and supports a broad range of complex business systems which are instrumental to the AOUSC mission.

Responsibilities

• Works within an Agile solution development environment with daily scrums, biweekly sprint planning and quarterly Program Increment planning.
• Develops operating standards and best practices, including performance, security, scalability, and maintainability.
• Ensures the proper definition, control, and coordination of data elements and standards, and the facilitation of efficient data relationships, systems integration, and physical structure.
• Participates in the development and implementation of database management policies and standards for efficient quality control and data administration.
• Collaborates with Product Owners and users to gather business requirements and define and maps them to technical requirements.
• Meets with agency leaders and stakeholders, collaborating with other consultants and program/agency personnel regarding the development of innovative data analysis techniques.
• Demonstrates ability to document complex workflow designs to present to project team and stakeholders.
• Demonstrates ability to work on complex problems where analysis of situations or data requires an in-depth evaluation of multiple factors and frequently contributes to the development of new business strategy, ideas, and methods adhering to best practices within the Agile framework.
• Collects, analyzes, and interprets large amounts of data to help guide business decisions.
• Experience with using advanced statistical analysis, data mining, and predictive modeling techniques.
• Synthesizes disparate information and recognizes patterns and relationships across data; synthesizes large sets of data from multiple sources, develops data visualizations for the purposes of tracking key performance indicators and other critical metrics tied to program outcomes.
• Hosts and conducts peer reviews of the code of other developers on the team.
• Performs data validation and ensures data accuracy and integrity.
• Develops stored procedures, jobs, views, tables, and other database objects in SQL Server Management Studio.
• Designs and develops dimensional data models including start and snowflake schemas, fact and dimension tables, and enterprise data marts to support analytics, reporting and business intelligence solutions.
• Develops and deploys ETL packages using CI/CD pipeline.
• Exposure to core configuration management systems for version control.
• Works with Atlassian Suite of software development management tools.
• Indexes system and application logs in to the Splunk system monitoring application, then creates dashboards, alerts, and reports from those logs.

Required Qualifications

• At least seven (7+) years of Server database maintenance and database analysis or similar role.
• Bachelor's degree in Computer Science, Computer Programming, Computer Engineering or relevant computer-based major. Experience may be considered in lieu of degree.
• Database or cloud certification preferred such as Microsoft Certified Azure Database Administrator Associate, Microsoft Azure Solutions Architect Expert or equivalent industry recognized database certification.
• Proficient experience with Databases like Microsoft SQL Server, Informix, Oracle.
• Experience with Snowflake and exposure to cloud platforms, Azure cloud platform.
• Experienced with completing database environment installation, configuration, on-going administration support.
• Demonstrated understanding of standard Data warehouse concepts.
• Adept with data modeling, data mapping, data flow diagrams and data marts.
• Previous experience architecting and implementing cloud-based database solutions on various platforms.
• Experience with Data migration from legacy on-premises database to multi-cloud/hybrid cloud platforms.
• Proven ability to spearhead and work independently, prioritize, and get things done.
• Strong analytical, technical, problem-solving skills.
• Excellent organization and time management skills and ability to identify priorities to accomplish a variety of tasks on schedule.
• Excellent written and oral communication skills and ability to work with people at every level.
• Comfortable writing down ideas, implementation plans and status reports.

Preferred Qualifications

• Experience creating and managing database reports, visualizations, and dashboards.
• Knowledge of court operations and law enforcement business data.

The likely salary range for this position is $107,744 - $138,000. 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: None

Telecommuting Options: Remote

Work Location: USA VA Home Office (VAHOME)

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. 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.

Our Identity Verification Process: As part of the hiring process, we will ask you to complete an identity verification process that leverages advanced biometrics and artificial intelligence to ensure authenticity and protect against identity fraud. You are expected to be on camera during virtual interviews. We reserve the right to take your picture to verify your identity and prevent fraud. By proceeding, you authorize the collection, processing, and use of your biometric data for identity verification and security purposes.

About Our Work: We are GDIT. A global technology and professional services company that delivers technology solutions and mission services to every major agency across the U.S. government, defense and intelligence community. Our 26,000 experts extract the power of technology to create immediate value and deliver solutions at the edge of innovation. We operate across 50+ countries worldwide, offering leading mission-ready capabilities in AI, cloud, cyber and software development. Equal Opportunity Employer / Individuals with Disabilities / Protected Veterans Opportunity Owned From working with technologies like AI, cyber and cloud to careers in intelligence and health, we offer endless opportunities to apply your expertise to create a safer, smarter world.