Relanto
Responsibilities
Should have around 10+ years of experience in DBA Activities
Provision MySQL instances: standalone, replication, cluster, HA configurations
Should have good exposure in cloud technologies
OCI, MySQL Heatwave, AWS RDS etc Ensure performance, security, and availability of databases Should be able to handle backup and recovery procedures Perform general technical trouble shooting and give consultation to development/operations team Maintain integrity of Databases across multiple instances as per agreed policies Production & Preproduction deployment and troubleshooting support Prepare documentations and specifications Handle critical database procedures such as upgrade, recovery, migration, performance tuning etc. Profile server resource usage, optimize and tweak as necessary Should be able to write shell/python scripts Monitor DB infrastructure and able to do the performance tuning (server level, query etc) wherever required Should have general understanding and working experience on NDB Cluster, Innodb Cluster etc Collaborate with other team members and stakeholders
Required Skills Strong proficiency in MySQL, Elasticsearch database management Decent experience with recent versions of MySQL (5.5, 5.6, 5.7, 8.0, 9) on prem and cloud Good hands on experience of OCI, MySQL Heatwave, AWS etc Understanding of MySQL's underlying storage engines Experience with Innodb Cluster, HA, Replication configuration in MySQL Experience with DB monitoring tools MySQL Enterprise, Datadog, Prometheus etc Knowledge of de-facto standards and best practices in MySQL Should be good in Unix or Python shell scripting Proficient in optimizing SQL statements Knowledge of MySQL features Familiarity with another SQL/NoSQL database such as Elasticsearch, MongoDB, Oracle, PostgreSQL etc Familiarity with configuration management tools like chef, ansible etc Knowledge of limitations in MySQL and their workarounds in contrast to another popular relational database Good communication skills Proficient understanding of code versioning tools Git, Perforce etc
OCI, MySQL Heatwave, AWS RDS etc Ensure performance, security, and availability of databases Should be able to handle backup and recovery procedures Perform general technical trouble shooting and give consultation to development/operations team Maintain integrity of Databases across multiple instances as per agreed policies Production & Preproduction deployment and troubleshooting support Prepare documentations and specifications Handle critical database procedures such as upgrade, recovery, migration, performance tuning etc. Profile server resource usage, optimize and tweak as necessary Should be able to write shell/python scripts Monitor DB infrastructure and able to do the performance tuning (server level, query etc) wherever required Should have general understanding and working experience on NDB Cluster, Innodb Cluster etc Collaborate with other team members and stakeholders
Required Skills Strong proficiency in MySQL, Elasticsearch database management Decent experience with recent versions of MySQL (5.5, 5.6, 5.7, 8.0, 9) on prem and cloud Good hands on experience of OCI, MySQL Heatwave, AWS etc Understanding of MySQL's underlying storage engines Experience with Innodb Cluster, HA, Replication configuration in MySQL Experience with DB monitoring tools MySQL Enterprise, Datadog, Prometheus etc Knowledge of de-facto standards and best practices in MySQL Should be good in Unix or Python shell scripting Proficient in optimizing SQL statements Knowledge of MySQL features Familiarity with another SQL/NoSQL database such as Elasticsearch, MongoDB, Oracle, PostgreSQL etc Familiarity with configuration management tools like chef, ansible etc Knowledge of limitations in MySQL and their workarounds in contrast to another popular relational database Good communication skills Proficient understanding of code versioning tools Git, Perforce etc