Cloud Database Administrator

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

📋 Description

• Install, configure, administer, and maintain critical production database environments.

• Monitor database performance, troubleshoot incidents, and collaborate with development and operations teams to restore services.

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

• Manage AWS-managed databases, including Amazon Aurora PostgreSQL, and provide support for Databricks environments.

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

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

• Assist in migrating legacy on-premises databases to cloud and hybrid platforms.

• Build and deploy ETL packages through CI/CD pipelines and version-control workflows.

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

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

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

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

• Utilize Atlassian development tools; index system and application logs in Splunk, and 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 be accepted.

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

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

• Experience working with Databricks.

• Proven experience in installing, configuring, and administering 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.

• Experience in migrating on-premises data to multi-cloud or hybrid-cloud environments.

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

• Ability to work autonomously, prioritize tasks, and meet deadlines effectively.

• Excellent organizational, written, and verbal communication skills.

• Capability to document technical plans, operational status, and complex solutions for a diverse range of stakeholders.

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

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

• Preferred experience in developing and managing database reports, dashboards, and visualizations.

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

• U.S. citizenship is required as the position supports the federal government.

• Willingness to undergo a federal background check is necessary.

• Must comply with federal drug-free workplace regulations.

🏝️ Benefits

• Flexible, shift-based work schedule.

• On-call coverage as needed.

• Remote work available from within the United States.

• No travel required.