Databricks AWS Database Administrator

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.