AWS Database Administrator, Databricks

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

📋 Description

• Install, configure, manage, and uphold mission-critical production database environments.

• Monitor database performance, troubleshoot issues, and restore services in collaboration with development and operations teams.

• Conduct root-cause analysis and enhance database reliability, performance, security, and scalability.

• Manage AWS-hosted databases, including Amazon Aurora PostgreSQL, and assist with Databricks environments.

• Create stored procedures, jobs, views, tables, and other database objects utilizing SQL Server Management Studio (SSMS).

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

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

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

• Develop and enforce database policies and standards to ensure data integrity, quality, security, and administration.

• Analyze data from various sources using statistical analysis, data mining, and predictive modeling to uncover trends, guide decisions, and create KPI visualizations.

• Collaborate with product owners and users to convert business needs into technical specifications and document workflows.

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

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

⛳️ Requirements

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

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

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

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

• Experience with Databricks.

• Skilled in installing, configuring, and administering database environments.

• Knowledgeable in data warehousing, dimensional modeling, data mapping, data flow diagrams, and data marts.

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

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

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

• Capable of working independently, prioritizing tasks, and meeting deadlines.

• Excellent organizational, written, and verbal communication skills.

• Ability to document technical plans, operational status, and complex solutions for a variety of stakeholders.

• Must be able to provide on-call support and/or adhere to a flexible work schedule as required.

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

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

• Familiarity with court operations and law enforcement business data.

• U.S. citizenship is mandatory as the role supports the federal government.

• Must be willing to undergo a federal background check.

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

🏝️ Benefits

• Flexible schedule; shift-based and on-call coverage as necessary.

• Option for remote work within the United States.

• No travel required.