Databricks AWS Database Administrator-
About The Position
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.
Requirements
- 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.
- 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
Nice To Haves
- Database or cloud certification preferred such as AWS Certified Database – Specialty, AWS Solutions Architect Associate/Professional, or equivalent industry‑recognized cloud/database certification.
- Experience creating and managing database reports, visualizations, and dashboards.
- Knowledge of court operations and law enforcement business data.
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.
- Documents complex workflow designs to present to project team and stakeholders.
- Works 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.
- Uses 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.
- Indexes system and application logs in to the Splunk system monitoring application.
- Creates dashboards, alerts, and reports from those logs.
Benefits
- 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.
- 15 days of paid leave per calendar year to be used for vacations, personal business, and illness
- an additional 10 paid holidays per year.
- 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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
