Mysql DBA

Role: MySQL and Oracle/SQL Database Administrator

Key Responsibilities:

• Independently perform all aspects of relational database management for MySQL and Oracle/MS SQL, including but not limited to - installation, configuration, patching, migration, PLM/upgrade, and operational support - in on-premises and public cloud environments.

• Automate repeatable database tasks using shell scripting, Chef and/or Ansible to drive efficiency, enhance quality and reduce human errors.

• Design and implement effective backup and recovery strategy for databases to ensure timely restoration, as needed.

• Establish and maintain database security policies, manage user access, and monitor databases to ensure data is protected from unauthorized access, ransomware. or breeches.

• Design and implement strategies to ensure high availability and database resiliency in the event of a disaster.

• Proactively analyze database systems for performance tuning, remove bottlenecks, and make recommendations to reduce database response times and enhance efficiency.

• Collaborate with peer DBAs, application development groups, system administrators, and other IT professionals to support database-related projects and address operational issues.

• Refresh lower environments as needed by other teams to facilitate testing and development.

• Develop infrastructure, infrastructure tools, and documentation during project phases.

• Provide on-call operational support for Production databases and answer severity calls for problem resolution.

Required Skills:

• At least 5 years of experience with all aspects of MySQL database management on UNIX, including but not limited to - installation, configuration, patching, migration, PLM/upgrade, and operational support.

• 5+ years of on-call experience in supporting multiple mission critical MySQL production databases.

• 3+ years of experience in developing shell scripts and Chef recipes to automate database installs and maintenance activities on UNIX platform.

• 3+ years of experience in supporting Oracle databases on UNIX, or MS SQL databases on Windows.

Preferred Skills:

• Experience in migrating MySQL databases from on-premises to Public Cloud, preferably Microsoft Azure.

• Experience in developing PowerShell scripts for MS SQL databases on Windows platform or supporting Oracle databases in multi-tenant architecture on Exadata platform.

• Working knowledge of Ansible.

Certifications: Relevant certifications in SQL, data analysis, or Python are a plus.