AWS Databricks Database Engineer

This is a fully remote position, open to applicants in United States.

📋 Description

• Install, configure, manage, and sustain critical production database environments.

• Monitor database performance, troubleshoot issues, restore services, and conduct root-cause analyses.

• Enhance database reliability, performance, security, and scalability.

• Administer AWS-managed databases, such as Amazon Aurora PostgreSQL, and support Databricks environments.

• Develop stored procedures, jobs, views, tables, and other database objects utilizing SQL Server Management Studio.

• Design dimensional data models, including star and snowflake schemas, fact and dimension tables, and data marts.

• Facilitate the migration of legacy on-premises databases to cloud and hybrid platforms.

• Construct and deploy ETL packages via CI/CD pipelines and version-control workflows.

• Formulate and enforce database policies and standards for data integrity, quality, security, and administration.

• Analyze data through statistical analysis, data mining, and predictive modeling to identify trends and develop KPI visualizations.

• Convert business requirements into technical specifications and document workflows with product owners and users.

• Engage in Agile planning, daily scrums, peer code reviews, and technical collaboration.

• Utilize Atlassian development tools and index logs in Splunk; create dashboards, alerts, and reports.

⛳️ Requirements

• A minimum of seven (7) years of experience in database maintenance, database analysis, or a related field.

• Bachelor’s degree in Computer Science, Computer Programming, Computer Engineering, or a related discipline; equivalent experience may also be considered.

• Proven experience in supporting production databases, including shift-based and on-call support.

• Proficiency in AWS database technologies, including Amazon Aurora PostgreSQL and other AWS-managed data services.

• Experience with Databricks.

• Background in installing, configuring, and managing database environments.

• Understanding of data warehousing, dimensional modeling, data mapping, data flow diagrams, and data marts.

• Experience in architecting and implementing cloud-based database solutions.

• Familiarity with migrating on-premises data to multi-cloud or hybrid-cloud environments.

• Strong analytical, technical, and problem-solving capabilities.

• Ability to work independently, prioritize tasks, and meet deadlines.

• Excellent organizational, written, and verbal communication skills.

• Capacity to document technical plans, operational status, and complex solutions for varied stakeholders.

• Must be available for on-call support and/or adaptable to a flexible work schedule as required.

• AWS Certified Data Engineer – Associate, AWS Certified Solutions Architect – Associate/Professional, or equivalent cloud/database certification is preferred.

• Experience in developing and managing database reports, dashboards, and visualizations is preferred.

• Knowledge of court operations and law enforcement business data is preferred.

• U.S. citizenship is required for this federal government-support position.

• Must be willing to undergo a federal background check.

• Compliance with federal drug-free workplace regulations is mandatory.

🏝️ Benefits

• Flexible schedule.

• Opportunity for remote work within the United States.

• No travel required.