Softility - Database Automation Engineer - DBaaS

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 platformsincluding 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 :

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

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

3. Operations, Monitoring & Resilience :

- Develop self-healing mechanisms for database clustersautomating 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.

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

Required Skills & Experience :

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