[Hiring] Databricks AWS Database Administrator @General Dynamics Information Technology

Role 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.
• 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 star 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 into the Splunk system monitoring application, then creates dashboards, alerts, and reports from those logs.

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

Benefits

• A variety of medical plan options, some with Health Savings Accounts.
• Dental plan options.
• A vision plan.
• 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.
• Full flex work weeks where possible.
• A variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement, and jury duty leave.
• Typically provides new employees with 15 days of paid leave per calendar year 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.
• 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.