General Dynamics Information Technology, Inc.
• $111K — $150K *Qualifications
Responsibilities
Benefits
Type of Requisition:
PipelineClearance Level Must Currently Possess:
NoneClearance Level Must Be Able to Obtain:
NonePublic Trust/Other Required:
NoneJob Family:
IT Infrastructure and OperationsJob Qualifications:
Skills:
Amazon Web Services (AWS), Cloud Computing, Data MigrationsCertifications:
NoneExperience:
7 + years of related experienceUS Citizenship Required:
NoJob 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).
The Database Analyst/ Administrator will execute the following responsibilities:
· Provides production support for mission‑critical database environments, including shift‑based coverage and on‑call support to ensure high availability and timely issue resolution.
· Monitors database performance, responds to incidents, troubleshoots production issues, and coordinates with development and operations teams to restore service quickly.
· Performs root‑cause analysis for production defects and contributes to long‑term stability improvements.
· 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 purpose 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.
· Experience supporting production database systems, including shift-based coverage and on‑call responsibilities.
· Database or cloud certification preferred such as AWS Certified Database – Specialty, AWS Solutions Architect Associate/Professional, or equivalent industry‑recognized cloud/database certification.
· Proficient experience with AWS database technologies such as Amazon Aurora PostgreSQL and other AWS-managed data services.
· Experience with Databricks
· 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.
***Must be able to provide on-call support and/or follow a flexible work schedule as needed***
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 $111,155 - $150,385. 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:
40Travel Required:
NoneTelecommuting Options:
RemoteWork Location:
Any Location / RemoteAdditional Work Locations:
Our team will look into this right away.