Leading system maintenance engineer of the electronic identification department in Diya

Responsibilities:

• Analyzing and optimizing database performance
• Identifying and fixing performance bottlenecks
• Using indexes, table partitioning and caching to improve performance< /li>
• Setting roles and access rights for users
• Setting MySQL configuration (my.cnf) to optimize server performance

Requirements:

• Higher education
• Minimum 3-5 years of experience working with MySQL
• Experience in designing, implementing and maintaining MySQL databases
• In-depth knowledge of SQL
• Experience optimizing queries, indexes, and database performance
• Knowledge of creating, backing up, and restoring databases
• Experience with MySQL Replication and clustering
• Understanding of performance monitoring and tuning tools such as MySQL, Enterprise Monitor, Percona Monitoring and Management (PMM), etc.
• Understanding database security principles
• Configuring role and access rights for users
• li>
• Experience in data security and encryption
• Diagnostic and troubleshooting skills with databases
• Experience with logging and troubleshooting tools
• Knowledge of scripting languages ​​(e.g. Python, Bash) to automate tasks
• Experience with other DBMS such as PostgreSQL, Oracle or MS-SQL Server and experience with UNIX/Linux OS will be a plus
• Knowledge of cloud technologies such as AWS RDS, Google Cloud SQL will be an advantage.