Cloud Database Administrator

KMRG, LLC•Washington, DC

2d•$140,000 - $175,000•Remote

About The Position

KMRG, LLC is hiring a remote Cloud Database Administrator to support cloud-based database operations and data modernization initiatives for the Administrative Office of the US Courts (AOUSC). The role administers production databases, supports AWS and Databricks environments, troubleshoots operational issues, and strengthens data integration, modeling, and analytics capabilities. The administrator collaborates with technical teams and stakeholders to maintain reliable, secure, and efficient data services.

Requirements

Seven or more years of database maintenance, database analysis, or related experience.
Bachelor’s degree in Computer Science, Computer Programming, Computer Engineering, or a related field; equivalent experience may be considered.
Experience supporting production databases, including shift-based and on-call support.
Proficiency with AWS database technologies, such as 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.
Ability to provide on-call support and/or follow a flexible work schedule as needed.

Nice To Haves

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.

Responsibilities

Install, configure, administer, and maintain mission-critical production database environments.
Monitor database performance, troubleshoot incidents, and restore services in coordination 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.
Provide shift-based and on-call production database support as needed.