Source description
About the role
As a DB Automation Specialist, your role will involve automating end-to-end database provisioning across on-premise infrastructure (90%) and cloud IaaS environments. You should have deep knowledge of Terraform, Ansible, CI/CD, and hands-on expertise with PostgreSQL, Oracle, MySQL, MongoDB, and integration components such as backups and monitoring. Your focus will be on building scalable, repeatable, and automated DB provisioning workflows. Key Responsibilities: - Design and develop automated workflows for provisioning databases using Terraform and Ansible. - Implement on-prem DB provisioning including storage, networking, virtualization, and OS-level dependencies. - Automate DB deployments in cloud IaaS (AWS/Azure/GCP) including VM creation, network configuration, and bootstrap scripts. - Build and maintain CI/CD pipelines (Jenkins/GitLab) for DB provisioning and infrastructure automation. - Create and maintain Helm charts / Operators (optional) for database automation. - Automate installation, configuration, initialization, patching, and upgrades for multiple DB engines. - Integrate provisioning workflows with backup tools, monitoring agents, exporters, logging agents, etc. - Troubleshoot provisioning failures and optimize automation for speed, reliability, and idempotency. - Collaborate with DBAs, Infrastructure, DevOps, and Cloud teams to define standardized provisioning patterns. - Maintain documentation, architecture diagrams, and best practices for DB automation processes. Required Skills: - Automation & IaC: Strong experience with Terraform (modules, workspaces, state management), expert in Ansible (playbooks, roles, inventories, orchestration). - Database Expertise: Experience automating provisioning/configuration for at least two of PostgreSQL, Oracle, MySQL/MariaDB, MongoDB. - Platform Skills: Strong experience with on-prem infrastructure (storage, networking, virtualization, OS provisioning) and Cloud IaaS (AWS/Azure/GCP). - Integration Experience: Knowledge of backup tools, monitoring tools. Good to Have: - Kubernetes / Helm / Operators for DB workloads. - Experience in SRE / DevOps environments. - Knowledge of REST APIs and automation frameworks. As a DB Automation Specialist, you should possess strong problem-solving and troubleshooting skills and have the ability to work cross-functionally with Infra, DBA, and Cloud teams. Excellent documentation and communication skills will be essential for this role. As a DB Automation Specialist, your role will involve automating end-to-end database provisioning across on-premise infrastructure (90%) and cloud IaaS environments. You should have deep knowledge of Terraform, Ansible, CI/CD, and hands-on expertise with PostgreSQL, Oracle, MySQL, MongoDB, and integration components such as backups and monitoring. Your focus will be on building scalable, repeatable, and automated DB provisioning workflows. Key Responsibilities: - Design and develop automated workflows for provisioning databases using Terraform and Ansible. - Implement on-prem DB provisioning including storage, networking, virtualization, and OS-level dependencies. - Automate DB deployments in cloud IaaS (AWS/Azure/GCP) including VM creation, network configuration, and bootstrap scripts. - Build and maintain CI/CD pipelines (Jenkins/GitLab) for DB provisioning and infrastructure automation. - Create and maintain Helm charts / Operators (optional) for database automation. - Automate installation, configuration, initialization, patching, and upgrades for multiple DB engines. - Integrate provisioning workflows with backup tools, monitoring agents, exporters, logging agents, etc. - Troubleshoot provisioning failures and optimize automation for speed, reliability, and idempotency. - Collaborate with DBAs, Infrastructure, DevOps, and Cloud teams to define standardized provisioning patterns. - Maintain documentation, architecture diagrams, and best practices for DB automation processes. Required Skills: - Automation & IaC: Strong experience with Terraform (modules, workspaces, state management), expert in Ansible (playbooks, roles, inventories, orchestration). - Database Expertise: Experience automating provisioning/configuration for at least two of PostgreSQL, Oracle, MySQL/MariaDB, MongoDB. - Platform Skills: Strong experience with on-prem infrastructure (storage, networking, virtualization, OS provisioning) and Cloud IaaS (AWS/Azure/GCP). - Integration Experience: Knowledge of backup tools, monitoring tools. Good to Have: - Kubernetes / Helm / Operators for DB workloads. - Experience in SRE / DevOps environments. - Knowledge of REST APIs and automation frameworks. As a DB Automation Specialist, you should possess strong problem-solving and troubleshooting skills and have the ability to work cross-functionally with Infra, DBA, and Cloud teams. Excellent documentation and communication skills will be essential for this role.
More at Saransh