Nir Yu logo

Database Automation Engineer – DBaaS Specialist

Nir Yu
Full-time
Remote
Mexico
Automation

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).