ROLES AND RESPONSIBILITIES : Primarily the architecture, engineering, deployment, and support of MySQL database environment.
Support Database Platform Engineering in the architecture, development, and deployment of MySQL Database on AWS / Ali Cloud in high SLA environments.
This includes, but is not limited to, advance to expert engineering and implementation of the following : Manage, support and maintain database technology and infrastructure, adhering to the architectural guidelines and policies.
Database administration for off the shelf and internally developed applications, ensure continuous 24x7 operation and availability in support of mission-critical business applications and participating in on-call rotation.
Install, configure, monitor, upgrade and maintain MySQL databases in production and non-production environments.Support local / across the DC failover with a High Availability Disaster Recovery environment with MySQL native / cloud Replication.
Participate in Database Maintenance and DR activities.Write / maintain OS level scripts for DB automation and application maintenance.
Provide technical expertise and hands-on support in the consolidation and migration of databases to new hardware and platforms.
The physical implementation of databases, storage structures, high-availability solutions, replication, and disaster recovery solutions.
Proactive and reactive performance analysis, monitoring, troubleshooting and resolution of escalated Level 2 and Level3 issues.
Regular database capacity planning related to database growth and system utilization, trend analysis, predictive future database resource requirements, and the structured organized reporting of the same.
Work closely with another Infrastructure engineering, product development, business operations, and technical operations to ensure delivery of database services within the SLA’s and performance targets.
Adapt business requirements, model data, and develop database specifications, table and element attributes.Participate in the evaluation, selection, and implementation of DBA tools to improve the effectiveness of tasks such as performance monitoring and tuning, recovery, and database change management processing.
Ability to work well as a team and as an individual with minimal supervision.SKILLS, QUALIFICATIONS, AND COMPETENCIES2-5 years of DBA experience, managing MySQL databases, Versions 5.
6 and onwardsInnoDB Cluster Experience is a plusStrong understanding of MySQL database fundamentalsStrong understanding of MySQL Native Replication fundamentalsStrong understanding of MySQL database security managementWith UNIX platform skills and understanding of the network, storage, tiered application environments, and security.
Knowledge of operating systems, Shell scripting, Perl / Python scripting is a plusKnowledge of google big table or distributed database is a plusGood interpersonal skills along with with effective communication (both written and verbal) skills.
Demonstrated ability to solve complex systems and database environment issues.Demonstrate the ability to work in a complex organization to determine business and customer needs, providing the best solution to meet those needs.
Work experience in a Financial Institute will be preferred.