Databricks AWS Database Administrator

WashingtonRemoteFull-time$140k–$175k

AI Summary

Administers production AWS and Databricks database environments for the US federal courts, handling performance, incidents, data modeling, ETL and on-call support. Supports data modernization and migration to cloud platforms.

About this role

Title: Databricks AWS Database Administrator
Location: Remote, United States
Schedule: Flexible; shift-based and on-call coverage as needed
Pay: $140,000 – $175,000 annually, commensurate with experience

ROLE
KMRG, LLC (KMRG) is a federal services company that hires talented professionals to support Government agencies and the communities they serve. We are hiring a remote Databricks AWS Database Administrator to support cloud-based database operations and data modernization initiatives for the Administrative Office of the US Courts (AOUSC).

In this role, you will administer production databases, support AWS and Databricks environments, troubleshoot issues, and strengthen data integration, modeling, and analytics capabilities. You will work with technical teams and stakeholders to maintain reliable, secure, and efficient data services.
Applications will be reviewed as they are received. Apply today!

RESPONSIBILITIES
Database Operations & Production Support

Install, configure, administer, and maintain mission-critical production database environments
Monitor database performance, troubleshoot incidents, and restore services with development and operations teams
Perform root-cause analysis and improve database reliability, performance, security, and scalability

Cloud Database & Data Architecture

Administer AWS-managed databases, including Amazon Aurora PostgreSQL, and support Databricks environments
Develop stored procedures, jobs, views, tables, and other database objects using SQL Server Management Studio (SSMS)
Design dimensional data models, including star and snowflake schemas, fact and dimension tables, and data marts
Support migration of legacy on-premises databases to cloud and hybrid platforms

Data Integration, Analytics & Collaboration

Build and deploy ETL packages through CI/CD pipelines and version-control workflows
Develop and implement database policies and standards for data integrity, quality, security, and administration, including data accuracy validation
Analyze data from multiple sources using statistical analysis, data mining, and predictive modeling to identify trends, inform decisions, and develop KPI visualizations
Work with product owners and users to translate business needs into technical requirements and document workflows
Participate in Agile planning, daily scrums, peer code reviews, and technical collaboration
Use Atlassian development tools; index system and application logs in Splunk and create dashboards, alerts, and reports

REQUIRED BACKGROUND

Seven (7) or more years of database maintenance, database analysis, or related experience
Bachelor’s degree in Computer Science, Computer Programming, Computer Engineering, or related field; equivalent experience may be considered
Experience supporting production databases, including shift-based and on-call support
Proficiency with AWS database technologies (e.g. Amazon Aurora PostgreSQL and other AWS-managed data services)
Experience working with Databricks
Experience installing, configuring, and administering database environments
Knowledge of data warehousing, dimensional modeling, data mapping, data flow diagrams, and data marts
Experience architecting and implementing cloud-based database solutions
Experience migrating on-premises data to multi-cloud or hybrid-cloud environments
Strong analytical, technical, and problem-solving skills
Ability to work independently, prioritize tasks, and meet deadlines
Strong organizational, written, and verbal communication skills
Ability to document technical plans, operational status, and complex solutions for diverse stakeholders
Must be able to provide on-call support and/or follow a flexible work schedule as needed

PREFERRED BACKGROUND

AWS Certified Data Engineer – Associate, AWS Certified Solutions Architect – Associate/Professional, or an equivalent cloud/database certification
Experience developing and managing database reports, dashboards, and visualizations
Knowledge of court operations and law enforcement business data

LOCATION & TRAVEL

Remote work from within the United States
No travel required

******************
KMRG, LLC is an Equal Opportunity/Affirmative Action (EEO/AA) employer. All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, sex, gender identity, sexual orientation, ancestry, national origin, age, marital or civil partnership status, mental disability, physical disability, medical condition, pregnancy, maternity status, political affiliation, military or veteran status, genetic information, traits historically associated with race, or any other basis prohibited by federal, state, and/or local law.

Skills

AgileAmazon Aurora PostgreSQLAtlassianAWSAWS Certified Data EngineerAWS Certified Solutions ArchitectCI/CDDatabricksData WarehousingDimensional ModelingETLSnowflake SchemaSplunkSQLSQL Server Management StudioStar Schema