Tiempo Completo
Skills and experience needed:
5+ years of experience: MySQL
2+ years of experience: Data analysis
Language(s) required: Spanish - Fully fluent, English - Conversational.
Additional requirements (other than skills)
Minimum 8 years of experience in different flavors of MySQL, such as Percona-MySQL, MySQL community, and enterprise editions.
Should have experience with MySQL active-active cluster setup, database upgrade and migration, database scripting.
Should have experience in administrating MySQL on the Linux platform.
Experience on MySQL version upgrade, preferably from version 5.6 to 5.7, in a production environment with a zero or very minimum application downtime.
Experience on design & architecting the MySQL environment using any framework like Galera cluster or Percona XtraDB or InnoDB cluster.
Experience in building the databases monitoring using tools like Nagios, Grafana, ELK, appD, etc.
Experience in database performance tuning which includes both SQL tuning and hardware configuration and capacity planning.
Good to have (not mandatory):
Experience working with PCI (payment card industry data security) standards.
ITIL environment experience.
Data analytics and business intelligence.
Good to know database objects like SQL scripts, procedures, functions, and other database objects.
Experience and knowledge of any NoSQL and big data technologies.
Responsibilities:
Install, deploy and manage MySQL on physical, virtual, AWS EC2 instances and Docker containers.
Build MySQL cluster with high availability, active-active cluster setup in a large scale, and multi-datacenter environment having minimum RPO and RTO on a DR scenario.
Design and implement the backup strategy and BCP process across the MySQL environments.
Maintain the uniform backup strategy by using the tools like Percona XtraDB or custom scripts and which can automate the process with the right monitoring and alerting mechanism.
Design & architect the MySQL environment using any framework like Galera cluster or Percona XtraDB or InnoDB cluster.
Define the database monitoring, monitoring thresholds, alerts, validate the notifications and maintain the documents for future references.
Setup high availability with master-master/ master-slave replication depends on the application needs.
Database performance tuning based on the application requirement and maintain a stable environment.
Analyze the existing SQL queries on behalf of the performance improvement program.
Work with the engineering team to understand the database requirement and guide them to the best practice and optimize the queries to get better performance.
Database version upgrades and maintain both OS and MySQL patches up to date in compliance with infosec rules.
Work with application stakeholders to understand the production requirement and propose effective database solutions.
Review and understand the ongoing business reports and create new ad hoc reports based on the requirement.
Adhere to the incident and change process, prepare the document and perform the peer review for all the planned production tasks.
Develop and maintain the database release process, support the release team to automate the database release process.
Additional details
Opportunity managed by Zonamericas
Avanzado
5-10 años
