Database Automation Engineer – DBaaS Specialist

The Role:

We are seeking a highly skilled Database Automation Engineer to design, implement, and manage automated Database-as-a-Service (DBaaS) solutions across a diverse set of platforms—including PostgreSQL, Oracle, Microsoft SQL Server, Amazon Redshift, Amazon RDS, Google CloudSQL, and MongoDB. This role is central to enabling scalable, secure, and self-service database provisioning across hybrid environments, using Ansible and CI/CD pipelines as core automation drivers.

Core Responsibilities:

• Automation Architecture & Engineering
  • Design and implement scalable automation frameworks for DBaaS lifecycle management using Ansible.
  • Build modular, reusable Ansible playbooks tailored to multi-database, multi-cloud infrastructures.
  • Deliver single-click database provisioning and retirement with strict adherence to internal SLAs.
• DevOps & CI/CD Integration
  • Integrate database automation into enterprise-grade CI/CD pipelines (e.g., Jenkins, GitLab CI, Azure DevOps).
  • Embed version-controlled infrastructure changes and collaborate with development teams on delivery alignment.
• Operations, Monitoring & Resilience
  • Develop self-healing mechanisms for database clusters—automating patching, scaling, backups, and recovery.
  • Implement standardized observability, logging, and alerting for all database services to ensure uptime and security.
  • Enforce compliance with DR, encryption, and access controls in line with enterprise governance.
• Collaboration & Enablement
  • Partner with application, platform, and security teams to identify automation opportunities and support rapid onboarding.
  • Produce clean, consumable documentation for automation workflows, SOPs, and knowledge bases.

Requirements:

• Proven experience automating and managing databases across Postgres, Oracle, MSSQL, Redshift, CloudSQL, RDS, and MongoDB.
• Strong proficiency in Ansible and scripting (Bash, Python, or PowerShell).
• Familiarity with infrastructure delivery via Jenkins, GitLab CI, or Azure DevOps.
• Working knowledge of cloud-native DBaaS offerings (AWS/GCP/Azure) and traditional database operations.
• Expertise in backup/recovery, high availability, and security configuration.

Preferred Qualifications:

• Certifications such as AWS Certified Database – Specialty, Oracle OCP, or Microsoft Certified: Azure Database Administrator.
• Exposure to Infrastructure as Code (IaC) tools beyond Ansible, such as Terraform.
• Experience with performance tuning, capacity planning, and database observability (e.g., Prometheus, Grafana).

Originally posted on Himalayas