Database Analyst / Administrator

New
K
KMRG, LLCDatabase operations
Remote work from within the United StatesFull-TimeSenior
Salary140,000 - 175,000 USD per year
Apply NowOpens the employer's application page

Job Details

Experience
Seven (7) or more years of database maintenance, database analysis, or related experience
Required Skills
AWSSQLETLCI/CDDatabricks

Requirements

  • Have seven or more years of database maintenance, database analysis, or related experience.
  • Hold a bachelor’s degree in Computer Science, Computer Programming, Computer Engineering, or a related field; equivalent experience may be considered.
  • Have experience supporting production databases, including shift-based and on-call support.
  • Be proficient with AWS database technologies, such as Amazon Aurora PostgreSQL and other AWS-managed data services.
  • Have experience working with Databricks.
  • Have experience installing, configuring, and administering database environments.
  • Know data warehousing, dimensional modeling, data mapping, data flow diagrams, and data marts.
  • Have experience architecting and implementing cloud-based database solutions and migrating on-premises data to multi-cloud or hybrid-cloud environments.
  • Be able to provide on-call support and/or follow a flexible work schedule as needed.
  • Preferred: AWS Certified Data Engineer – Associate, AWS Certified Solutions Architect – Associate/Professional, or an equivalent cloud/database certification.
  • Preferred: Experience developing and managing database reports, dashboards, and visualizations.
  • Preferred: Knowledge of court operations and law enforcement business data.

Responsibilities

  • Install, configure, administer, and maintain 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.
  • Analyze data from multiple sources and develop KPI visualizations; index logs in Splunk and create dashboards, alerts, and reports.
  • Translate business needs into technical requirements, document workflows, and participate in Agile planning, scrums, and peer code reviews.
View Full Description & ApplyYou'll be redirected to the employer's site
140,000 - 175,000 USD per year
Apply Now