Description: We are looking a senior software engineer who have previously worked on improving application/database performances. Someone who can play with MySQL/Aurora to tune to get best performance output. He can optimise/rewrite SQL queries and establish best practices for writing them, as well as establish migration/seeding process and maintain it. Candidate should have hands-on experience in developing PHP/JavaScript web applications and having good working experience in ERP projects. Candidate should have more than 8 years of experience in web application development with database performance improvement experience. Responsibilities: - Provision MySQL instances, both in clustered and non-clustered configurations - Line up all database schemata across all different deployments (Schema merge) - Ensure performance, security, and availability of databases. - Prepare documentations and specifications. - Handle common database procedures, such as upgrade, backup, recovery, migration, etc. - Profile server resource usage, optimize and tweak as necessary. - Collaborate with other team members and stakeholders. - Support Development team in query/structure optimization - Maintain developed code and aim for improvements - Monitor developed features for possible failure cases - Debug/troubleshoot for any errors and provide resolutions - Working closely with architect team for planning/designing systems and components Requirements: - Minimum 8-year experience in SQL developer/Software Engineer position - Very good knowledge of MySQL/Aurora - Very good knowledge of AWS RDS setup of MySQL and Aurora - Experience in MySQL 8.0/ Aurora - Experience with replication configuration in MySQL/ Aurora - Knowledge of de-facto standards and best practices in MySQL - Proficient in writing and optimizing SQL statements. - Knowledge of MySQL features, like how to create MySQL Schedules/Events - Ability to plan resource requirements from high level specifications. - Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases - Proficient understanding of code versioning tools (GIT) - Experience in NDB cluster/big data - Database performance monitoring and suggest optimal solutions. - Should know how to write stored procedures (Add/Update/Delete) for application models. - Should know how to create table partitions so lookup time will be lower. - Troubleshooting database errors - Working experience with PHP/JavaScript for over 8 years - Working experience with Codeigniter 3/Laravel/Slim frameworks for over 5 years - Linux (Ubuntu/RedHat) experience and knowledge - Familiarity with other SQL/NoSQL databases such as SQLite, PostgreSQL, MongoDB, etc - Good to have o MySQL/SQL professional certificates o SOAP/REST Web Services o PHPUNIT 9 o GIT/Bit Bucket o Redis with JSON o Apache Kafka o Web Sockets o Browser Service Workers and Local Storage implementation o AWS SDK o Ubuntu 18.04 and Shell Scripting o JIRA o SOA, Microservices and Event Driven Architecture Experience o BI, DI Application Experience o Python Programming Language o NodeJS 12+ o Elastic Search 7+ (ELK Stack) o Containers (Dockers) o Kubernetes Job Type: Full-time Ability to commute/relocate:

• Dubai: Reliably commute or planning to relocate before starting work (Required)

Application Question(s):

• How many ERP application development experience do you have?
• Do you have MySQL/SQL professional certificates?

Experience:

• MySQL 8: 8 years (Required)
• PHP 7: 5 years (Required)
• Linux: 8 years (Required)
• AWS: 5 years (Required)

Application Deadline: 21/04/2023