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.