Advisor - MySQL Database SME

enGen Global; Hyderabad; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

enGen Global in Hyderabad is seeking a Senior-Level Database Administrator to ensure reliable operation, maintenance, and performance of SQL Server environments. The role emphasizes cloud concepts (Google Cloud SQL) and growth across PostgreSQL and MySQL on Linux, with scripting and IaC automation to boost efficiency.

You will collaborate with application teams and vendors, handle on-call rotations, and document processes while keeping security and HA/DR in focus.

Qualifications

• 10 to 12 years of experience in Sql Server Database Administration.
• Experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) is a plus.
• Knowledge of SolarWinds DPA for performance tuning, monitoring, and SQL is a plus.
• Mandatory skill: Advanced PowerShell automation experience supporting SQL Server monitoring, backup/restore validation, DBA task automation, reporting, and configuration management.
• CloudSQL PostgreSQL Support.
• PostgreSQL on managed cloud platforms (GCP).
• Understand cloud backup models, HA, read replicas, and monitoring.
• Automate routine DB A tasks using scripting (Shell / Python / PowerShell).
• Troubleshoot and resolve database and application issues.
• Exposure to monitoring tools (Cloud Monitor, Prometheus, pgAdmin).
• Implement security, roles, and access controls.
• Collaborate on cloud database best practices.
• MySQL Administration of MySQL 8.4.X
• Backup, replication, performance tuning, and security basics.
• Familiar or some experience with the following is a plus
• CloudSql on Google Cloud Platform
• Postgres or AlloyDB databases familiarity with Infrastructure as Code (IaC) principles, Terraform
• Linux OS
• AI tools such as Copilot and Sidekick
• SQL Server/ GCP Certifications are a plus
• Oracle Enterprise Manager for MySQL
• Commvault / Snapcenter experience
• Ansible Automation
• Other duties as assigned or requested.

Responsibilities

• Database Operations Performance: Manage day-to-day operation, maintenance, and performance tuning of on-prem SQL Server instances and databases.
• Monitor, capacity plan, and optimize queries.
• Installation Configuration: Install, configure, and patch SQL Server environments, including managing SQL Server Agent jobs.
• Backup Recovery: maintain backup and recovery strategies to ensure data integrity and availability.
• HA/DR: Monitor and maintain existing HA/DR solutions (Always On) and assist with implementation.
• Security Management: Administer SQL Server security, managing logins, users, roles, permissions.
• Troubleshooting Support: Diagnose and resolve database-related issues with application teams and vendors.
• Documentation: Maintain clear documentation for database systems and processes.
• Proficiency in scripting languages like T-SQL, Shell Scripting, Ansible.
• Provide applications support for staff and outside division related to DBMS tech and platforms.
• Root cause analysis to identify and resolve availability issues.
• Vendor coordination to facilitate problem resolution.
• Participate in 24/7 on-call rotation.
• Establish and maintain technical standards and procedures.
• Ensure compliance with corporate standards and audits.

Skills

SQL Server administration

PowerShell automation

Cloud database concepts

PostgreSQL on Linux

MySQL administration

Shell scripting

Python scripting

Terraform (IaC)

Ansible automation

Linux & Windows

Education

Bachelor's Degree in Engineering

Tools

SSIS

SSRS

SolarWinds DPA

Cloud Monitor

Prometheus

pgAdmin

Terraform

Ansible

Copilot

Job description

Job Summary

We are seeking a skilled and proactive Senior-Level Database Administrator to join our strong, dedicated, and experienced team. The ideal candidate will primarily focus on the reliable operation, maintece, and performance of our SQL Server environments. A foundational understanding of cloud database concepts, particularly Google Cloud SQL, is important, coupled with a strong willingness to learn and grow across diverse database platforms, including Postgres and MySQL on Linux. They should possess strong communication skills and a keen understanding of automating database tasks and managing infrastructure as code to enhance efficiency. This role offers an excellent opportunity for professional growth within an experienced team, contributing to the support and evolution of critical database systems that underpin both our provider and payer side operations. Candidates should be capable of working independently on routine database administration tasks, troubleshooting issues, and collaborating effectively with application teams and vendors on customer projects with limited guidance.

Responsibilities

• Database Operations Performance: Manage the day-to-day operation, maintece, and performance tuning of on-prem SQL Server instances and databases.
• This includes monitoring, capacity planning, and optimizing queries.
• Installation Configuration: Install, configure, and patch SQL Server environments, including managing SQL Server Agent jobs.
• Backup Recovery: maintain backup and recovery strategies to ensure data integrity and availability.
• High Availability Disaster Recovery (HA/DR): Monitor and maintain existing HA/DR solutions (e.g., Always On Availability Groups) and assist with their implementation.
• Security Management: Administer SQL Server security, managing logins, users, roles, permissions, and ensuring compliance with security policies.
• Troubleshooting Support: Diagnose and resolve database-related issues, providing support to application teams, vendors, and participating in incident resolution.
• Documentation: Maintain clear and comprehensive documentation for database systems and processes.
• Proficiency in creating scripting languages like T-SQL, Shell Scripting, Ansible.
• Provide applications support for staff, as well as, outside division to answer questions and resolve problems related to the DBMS technology and computing platform such as Linux, and Windows.
• Conduct root cause analysis to identify and resolve problems impacting application and/or database availability and service levels.
• Contact vendor support when necessary to facilitate application development and client problem resolution with optimum speed and efficiency.
• Participate in on-call rotation 24/7.
• Participate in establishing and maintaining technical standards, departmental procedures, and other technical documentation as required.
• Assure compliance to required Corporate standards, procedures, guidelines and processes, including audits.

Required Skills

• 10 to 12 years of experience in Sql Server Database Administration
• Experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) is a plus.
• Knowledge of SolarWinds DPA for performance tuning, monitoring, and SQL is a plus
• Mandatory skill: Advanced PowerShell automation experience supporting SQL Server monitoring, backup/restore validation, DBA task automation, reporting, and configuration management.
• CloudSQL PostgreSQL Support
• PostgreSQL on managed cloud platforms (GCP)
• Understand cloud backup models, HA, read replicas, and monitoring.
• Automate routine DB A tasks using scripting (Shell / Python / PowerShell).
• Troubleshoot and resolve database and application issues.
• Exposure to monitoring tools (Cloud Monitor, Prometheus, pgAdmin).
• Implement security, roles, and access controls.
• Collaborate on cloud database best practices
• MySQL Administration of MySQL 8.4.X
• Backup, replication, performance tuning, and security basics
• Familiar or some experience with the following is a plus
• CloudSql on Google Cloud Platform
• Postgres or AlloyDB databases familiarity with Infrastructure as Code (IaC) principles, Terraform
• Linux OS
• AI tools such as Copilot and Sidekick
• SQL Server/ GCP Certifications are a plus
• Oracle Enterprise Manager for MySQL
• Commvault / Snapcenter experience
• Ansible Automation
• Other duties as assigned or requested.

Qualifications

• Bachelors Degree in Engineering or equivalent

Shift Details

• Ready to work in 3PM - 12AM IST shift.
• Should be flexible in providing weekend support on demand (Change Implementation Situations)
• Ready to take up On-Call when required.