ARCHITECT - SQL

Happiest Minds Technologies; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Happiest Minds Technologies is seeking a Database Automation Engineer to automate DBA operations across Oracle, MSSQL, and PostgreSQL environments. The role emphasizes building automation playbooks with Ansible or Puppet, automating provisioning and health checks, and integrating with IAM and monitoring tools.

The successful candidate will have 8+ years of experience, strong scripting skills, and a focus on reducing MTTR through self-service and event-driven remediation workflows.

Qualifications

• 8+ years of experience in database automation or related field.
• Automate DBA operations across Oracle, MSSQL, and PostgreSQL environments.
• Build automation playbooks using Ansible, Puppet, or similar tools.
• Automate user provisioning, access management, and role assignments.
• Automate database health checks, maintenance, job monitoring, remediation, refreshes, cloning, and backup/recovery validation.
• Integrate automation with IAM, monitoring, and observability tools.
• Develop ServiceNow workflows for automated fulfilment.
• Identify process improvements to reduce manual effort and MTTR.

Responsibilities

• Automate DBA operational activities using PowerShell and/or Python.
• Build automation playbooks using Ansible, Puppet, or similar tools.
• Analyse DBA tickets and automate repetitive activities.
• Automate user provisioning, access management, and role assignments.
• Automate database health checks, maintenance, job monitoring, remediation, refreshes, cloning, and backup/recovery validation.
• Integrate automation with IAM, monitoring, and observability tools.
• Develop ServiceNow workflows for automated fulfilment.
• Identify process improvements to reduce MTTR.

Skills

PowerShell and/or Python automation

Oracle & MSSQL DBA

DBA operations and automation

ServiceNow workflow automation

Workflow and process automation

Tools

Ansible

Puppet

Job description

Database Engineer(Automation)

Experience:

8+ years

Role Summary:

Seeking an experienced Database Automation Engineer to automate DBA operations across Oracle, MSSQL, and PostgreSQL environments, improving efficiency, reducing ticket volumes, and enhancing MTTR.

Key Responsibilities:

• Automate DBA operational activities using PowerShell and/or Python.
• Build automation playbooks using Ansible, Puppet, or similar tools.
• Analyse DBA tickets and automate repetitive activities.
• Automate user provisioning, access management, and role assignments.
• Automate database health checks, maintenance, job monitoring, remediation, refreshes, cloning, and backup/recovery validation.
• Integrate automation with IAM, monitoring, and observability tools.
• Implement self-service and event-driven auto-remediation workflows.
• Develop ServiceNow or ticketing tool workflows for service requests and automated fulfilment.
• Identify process improvements to reduce manual effort and MTTR.

Primary Skills:

• PowerShell and/or Python automation
• Oracle & MSSQL DBA
• Ansible, Puppet, or equivalent orchestration tools
• DBA operations and automation
• ServiceNow or comparable ticketing tool workflow automation
• Workflow and process automation

Secondary Skills:

• IAM and access-management integration
• Monitoring and observability tools
• REST APIs, Git, and CI/CD
• Linux and Windows administration
• ITIL processes and technical documentation