AWS Databricks Database Engineer

After School Matters, Inc.
United States
2 days ago
Apply on kmrgllc.applytojob.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
7 years minimum
Compensation
$140,000 - $175,000
Working hours
Shift work

Tech stack

Adobe Analytics Agile Methodology Amazon Web Services Data Analysis Cloud Database Code Review Computer Programming Databases Computer Engineering System Configuration Data as a Services Data Architecture
+26 more
Data Integration Data Integrity Extract Transform Load (ETL) Data Mapping Data Mart Data Transformation Data Mining Data Warehousing Database Analysis Programming Tools Dimensional Modeling PostgreSQL Operational Databases Scrum Methodology SQL Stored Procedures Multi-Cloud Database Performance HybridCloud Build Management Information Technology Atlassian Tools Data Analytics SQL Server Management Studio (SSMS) Splunk Software Version Control Databricks

Job description

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 AWS Databricks Database Engineer 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!, 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

Requirements

  • 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, Are you 18 years of age or older?* LinkedIn Profile URL: Are you a US citizen? This role requires citizenship since it supports the federal government.* Are you willing to undergo a background check in accordance with federal laws/regulations?* This position is subject to federal drug-free workplace requirements. Are you able to comply with federal regulations regarding prohibited substances regardless of state law?* Do you have seven (7) or more years of experience in database maintenance, database analysis, or a related field?* Do you have a bachelor’s degree in Computer Science, Computer Programming, Computer Engineering, or a related field, or equivalent relevant experience?* Do you have experience supporting production databases, including shift-based and on-call support?* Are you proficient in AWS database technologies, including Amazon Aurora PostgreSQL and other AWS-managed data services* Do you have experience working with Databricks?* Do you have experience installing, configuring, and administering database environments?* Do you have knowledge of data warehousing, dimensional modeling, data mapping, data flow diagrams, and data marts?* Do you have experience both architecting and implementing cloud-based database solutions?* Do you have experience migrating on-premises data to multi-cloud or hybrid-cloud environments?* Do you have experience documenting technical plans, operational status, and complex solutions for diverse stakeholders?* Are you able to provide on-call support and/or follow a flexible work schedule as needed?*

Benefits & conditions

Invitation for Job Applicants to Self-Identify as a U.S. Veteran

  • A β€œdisabled veteran” is one of the following:
  • a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or
  • a person who was discharged or released from active duty because of a service-connected disability.
  • A β€œrecently separated veteran” means any veteran during the three-year period beginning on the date of such veteran’s discharge or release from active duty in the U.S. military, ground, naval, or air service.
  • An β€œactive duty wartime or campaign badge veteran” means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
  • An β€œArmed forces service medal veteran” means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on kmrgllc.applytojob.com
Prepare application

Good distractions

Loading talks and stories from around this role…