Database Analyst / Administrator

Kmrg, Llc

United States

Remote

USD 140,000 - 175,000

Full time

5 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

KMRG, LLC is hiring a remote Database Analyst / Administrator to support cloud-based database operations and data modernization for AOUSC. You will administer production databases, support AWS and Databricks environments, and work with stakeholders to ensure reliable, secure data services.

The role requires 7+ years of database experience, a CS/Engineering degree, familiarity with AWS databases, and on-call availability. Remote work is within the United States with no travel.

Qualifications

  • 7+ years of database maintenance, analysis, or related experience.
  • Bachelor’s degree in computer science, engineering, or related field.
  • Experience supporting production databases, including shift-based and on-call support.
  • Proficiency with AWS database technologies (e.g., Amazon Aurora PostgreSQL).
  • Experience with Databricks and cloud-based database solutions.
  • Knowledge of data warehousing, dimensional modeling, data mapping, data flow diagrams, and data marts.
  • Strong analytical, technical, and problem‑solving skills.
  • Ability to document technical plans, operational status, and complex solutions for diverse stakeholders.

Responsibilities

  • Install, configure, administer, and maintain production database environments.
  • Monitor performance, troubleshoot incidents, and restore services with teams.
  • Design dimensional data models, star/snowflake schemas, and data marts.
  • Administer AWS databases including Aurora PostgreSQL; support Databricks environments.
  • Develop stored procedures, jobs, views, and tables using SSMS.
  • Migrate legacy on-prem databases to cloud/hybrid platforms.
  • Build and deploy ETL packages via CI/CD pipelines and version control.
  • Define database policies for data integrity, security, and administration.
  • Analyze data from multiple sources to identify trends and KPI visualizations.
  • Collaborate with product owners to translate business needs into technical requirements.
  • Participate in Agile planning, standups, and code reviews.
  • Index logs in Splunk and create dashboards, alerts, and reports.

Skills

7+ years experience
Database maintenance
AWS PostgreSQL
Databricks
Data warehousing
Cloud architecture
On-call support
Agile

Education

Bachelor’s degree in Computer Science / Engineering or related field

Tools

SSMS
Splunk
Jira

Job description

Title: Database Analyst / 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 Database Analyst / 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.

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Database Analyst / Administrator
Database Analyst / Administrator

Kmrg • United States

Remote
USD 140,000 - 175,000
Database Analyst / Administrator
Database Analyst / Administrator

Kmrg, Llc • Washington

Remote
USD 140,000 - 175,000
Cloud Database Administrator
Cloud Database Administrator

Kmrg, Llc • Washington

Remote
USD 140,000 - 175,000
Cloud Database Administrator
Cloud Database Administrator

Kmrg, Llc • United States

Remote
USD 140,000 - 175,000
Databricks AWS Database Administrator
Databricks AWS Database Administrator

Kmrg, Llc • Washington

Remote
USD 140,000 - 175,000
Databricks AWS Database Administrator
Databricks AWS Database Administrator

Kmrg, Llc • United States

Remote
USD 140,000 - 175,000
AWS Databricks Database Engineer
AWS Databricks Database Engineer

Kmrg, Llc • United States

Remote
USD 140,000 - 175,000
AWS Databricks Database Engineer
AWS Databricks Database Engineer

Kmrg, Llc • Washington

Remote
USD 140,000 - 175,000
Senior Database Analyst/Administrator
Senior Database Analyst/Administrator

General Dynamics Information Technology • Virginia

On-site
USD 110,000 - 150,000
Remote Cloud Database Engineer & Administrator
Remote Cloud Database Engineer & Administrator

Kmrg, Llc • United States

Remote
USD 140,000 - 175,000