Databricks AWS Database Administrator

Kmrg, Llc; United States; Remote; USD 140,000 - 175,000; Full time

Job summary

KMRG, LLC is seeking a remote Databricks AWS Database Administrator to support cloud-based database operations and data modernization initiatives for AOUSC. 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, with shift-based and on-call coverage as needed.

Qualifications

• 7+ years in database maintenance or analysis.
• Bachelor’s degree or equivalent experience.
• Experience supporting production databases with on-call coverage.
• Proficiency with AWS database technologies (Aurora PostgreSQL, etc.).
• Experience with Databricks and cloud-based database solutions.
• Strong analytical, communication, and documentation skills.

Responsibilities

• Install, configure, and maintain production databases.
• Monitor performance, troubleshoot incidents, and collaborate with teams.
• Improve reliability, security, and scalability of data systems.
• Administer AWS databases and Databricks environments.
• Develop SQL objects and data models; support data migrations to cloud/hybrid platforms.
• Build ETL packages and CI/CD workflows; implement data policies and validation.
• Analyze data to identify trends and create KPI visualizations.
• Document technical plans and workflows for stakeholders.
• Participate in Agile planning and peer code reviews.
• Index logs in Splunk and create dashboards/reports.

Skills

AWS

Databricks

SQL

SSMS

Data warehousing

Dimensional modeling

ETL

CI/CD

Splunk

On-call support

Education

Bachelor's degree in Computer Science or related field

Tools

SSMS

Aurora PostgreSQL

Databricks

AWS data services

Splunk

Job description

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.

RESPONSIBILITIES

• 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
• 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
• 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

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.