You and the process

With a person
Anna, in-house recruiter
9 years hiring engineers
30 minutes with a real recruiter
They read your CV with you, on a call, and say where the offers are being lost.
Didn’t find what you were looking for? Tell us what to build
General Dynamics Information Technology

Senior Database Administrator - Production Support

  • Remote
  • 6+ years

Salary

$116,450 - 157,550/ year

AI summary

For members

The whole posting in a few lines. Sign up to read it here and on every role you open.

Sign Up to Read

Description

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

General Dynamics Information Technology

Also hiring in United States, Arlington, United States, Philadelphia, United States and 6 more places

75 of their 568 open roles are remote

Your chances

Worth a look before you spend an evening tailoring a CV for it.

  • 21 checks run
  • 1 red flag

Still hiring?

14 checks

1 red flag

How crowded?

7 checks

No red flags

Fits Me

How well does this role fit you?

Answer a few questions or drop your CV, and every role gets a fit score with the reasons, this one first.

  • Your field
  • Level
  • Stack
  • Work model
  • Salary floor
  • Must-haves
Details11 facts · Role, Location, Compensation, Employment
Tech stack
  • SQL
  • PostgreSQL
  • AWS
  • CI/CD
  • Databricks
Seniority
Senior
Type
Full-time
Specialty
Data Engineering
Region
United States
Pay period
Annual
Show 5 more factsShow less

Role

Category
Data & Analytics
Specialty
Data Engineering
Seniority
Senior
Experience
7+ years
Tech stack
  • SQL
  • PostgreSQL
  • AWS
  • CI/CD
  • Databricks

Location

Work model
Remote
Region
United States
Remote from
  • United States

Compensation

Salary
$116,450 - 157,550 / year
Pay period
Annual

Employment

Type
Full-time

Something wrong with this vacancy?

Similar vacancies

Share this vacancy

What's wrong with it?

The employer never sees who reported.

Reason