This role supports the Case Management Modernization (CMM) program, which helps the Administrative Office of the US Courts (AOUSC) build a modern, cloud-based system for all 204+ federal courts across the country.
The senior database administrator joins the CMM Data Modernization and Governance team, which delivers data governance, engineering, data platform, reporting, analytics and AI/ML capabilities that support operational decisions and the AOUSC's data goals.
The company is a global technology and professional services firm serving federal government, defense and intelligence agencies. It has 26,000 staff and operates in more than 50 countries, with work in AI, cloud, cyber and software development.
Responsibilities
Keep the production database environments behind the CMM program running well, covering shifts and on-call rotations so issues are fixed quickly and availability stays high.
Watch database performance, handle incidents and troubleshoot live problems, working with development and operations staff to bring services back fast.
Find the root cause of production defects and help make the system more stable over time.
Build and maintain SQL Server Management Studio objects such as stored procedures, jobs, views and tables.
Design scalable data models for Databricks lakehouse environments, including bronze, silver and gold layers, dimensional models, fact and dimension tables, and curated data products for analytics, reporting, business intelligence and machine learning.
Create and deploy ETL packages through a CI/CD pipeline, and work with core configuration management tools for version control.
Use Atlassian tools for software development management.
Send system and application logs into Splunk, then build dashboards, alerts and reports from them.
Set operating standards and best practices covering performance, security, scalability and maintainability.
Define, control and coordinate data elements and standards, and shape data relationships, system integration and physical structure.
Help create and roll out database management policies that keep quality control and data administration efficient.
Turn business needs from Product Owners and users into technical requirements, and meet agency leaders and stakeholders, including other consultants and program staff, to discuss new data analysis methods.
Document complex workflow designs for the project team and stakeholders.
Work through complex problems that require weighing many factors, and help shape new business strategies and methods within Agile practice.
Collect, analyze and interpret large data sets to guide business decisions, using advanced statistics, data mining and predictive modeling.
Combine data from many sources, spot patterns, and build visualizations that track key performance indicators and other metrics tied to program outcomes.
Review teammates' code and check data validity, accuracy and integrity.
Work in an Agile environment with daily scrums, biweekly sprint planning and quarterly Program Increment planning.
Requirements
Required: a bachelor's degree in computer science, computer programming, computer engineering or a closely related computer-based field, plus 5+ years of experience maintaining server databases and analyzing them (or a similar role).
Preferred: a bachelor's degree in a comparable computer-based field, plus 7 + years of experience maintaining server databases and analyzing them (or a similar role).
A bachelor's degree may be substituted with 4+ years of additional experience.
Experience supporting production database systems, including shift and on-call duties.
Solid hands-on work with AWS database services such as Amazon Aurora PostgreSQL and other AWS-managed data services.
Experience with Databricks and some exposure to the AWS cloud platform.
Experience installing, configuring and ongoing administration of database environments.
Understanding of standard data warehouse concepts.
Skilled in data modeling, data mapping, data flow diagrams and data marts.
Prior experience designing and building cloud-based database solutions on various platforms.
Experience migrating data from legacy on-premises databases to multi-cloud or hybrid cloud platforms.
Ability to take ownership, work independently, set priorities and get work done.
Strong analytical, technical and problem-solving skills.
Strong organization and time management, with the ability to rank tasks and meet schedules.
Clear communication with people at all levels, and comfort writing ideas, implementation plans and status reports.
Preferred but not required: one or more of Databricks Certified Data Professional, AWS Certified Database - Specialty, or AWS Certified Solutions Architect Associate and/or Professional.
US person status is required: a green card holder, US permanent resident alien, refugee, asylee or US citizen. US citizenship itself is not required.
Conditions
Remote, from any location.
Scheduled at 40 hours per week, with shift-based coverage and on-call support.
Travel required: less than 10%.
Public trust clearance required: BI Full 6C (T4).
The likely salary range is $116,450 to $157,550. This is not a guarantee. Pay is set by experience, geographic location and possibly contract terms, and may fall outside this range.
Identity verification uses biometrics and AI. Virtual interviews require you to be on camera, the company may take your picture to verify identity, and by proceeding you consent to collection and use of biometric data for verification and security.
Equal opportunity employer, including individuals with disabilities and protected veterans.
Benefits
Medical plan options, some with Health Savings Accounts, plus dental and vision plans for US-based employees.
401(k) plan where you can contribute pre-tax and post-tax dollars up to IRS annual limits, with a company match.
Full flex work weeks where possible.
Paid time off including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave.
Typically 15 days of paid leave per calendar year for vacation, personal business and illness, plus 10 paid holidays per year, prorated from the hire date.
Paid Family Leave of up to 160 hours in a rolling 12 month period for eligible employees.
Short and long-term disability, life, accidental death and dismemberment, personal accident, critical illness, and business travel and accident insurance, provided or available.
An AI-powered career tool that identifies career steps and learning opportunities, and an internal mobility team to help you reach your goals.
A military-friendly workplace.
Where you’d work
Fully remote
You can work from
United States
About the company
G
General Dynamics Information Technology
Also hiring in United States, Arlington, United States, Philadelphia, United States and 6 more places