Job Objective

Your role as a Senior Database Administrator is to be responsible for planning, implementing, and maintaining efficient and reliable database platforms to support Monty Holding's business applications. You will work on performance tuning and ensuring the optimal functioning of the database systems.

You will also provide Database and engineering support for all of Holding’s business services. Additionally, you will guide customers in the use of best practices and the application of database solutions.

Main Tasks

• Design, implement, and maintain complex database systems and ensure they meet organizational needs and performance requirements.
• Monitor and optimize database performance, identify, and resolve bottlenecks and issues to ensure high availability and reliability.
• Implement and enforce data security policies, access controls, and encryption to protect sensitive data.
• Ensure compliance with relevant data protection regulations and industry best practices.
• Develop and maintain backup and recovery strategies to safeguard data against loss or corruption.
• Perform regular backups and test recovery procedures to ensure data integrity.
• Conduct performance tuning and optimization to improve efficiency and database responsiveness.
• Monitor database growth and plan for scaling resources as needed to accommodate increasing data volumes.
• Provide recommendations for hardware and infrastructure upgrades.
• Develop scripts and automation tools to streamline database tasks and improve operational efficiency.
• Create and maintain disaster recovery plans to ensure minimal downtime and data loss in the event of a system failure.
• Respond to and resolve database-related incidents and issues and provide on-call support as necessary.
• Maintain comprehensive documentation of database systems, configurations, and procedures.
• Mentor and provide guidance to junior database administrators.
• Keep up-to-date with the latest database technologies and share knowledge within the team.

Qualifications

• 5+ years of experience as DB Developer using PostgreSQL, SQL Server, Mongo DB.
• Professional proficiency in Arabic and English required.
• Strong knowledge of database management systems (e.g., Oracle, SQL Server, MySQL, PostgreSQL)
• Experience in DB Design / Architecture for applications built on micro-services architecture.
• Experience with using Apache Airflow to schedule alerts and reports based on data from various sources and databases.
• Ability to write complex DB functions to implement the business logic for the application using PostgreSQL DB.
• Understanding of IT architectures including High Availability and Disaster Recovery.
• Experience working with and troubleshooting PostgreSQL 11 and 10 databases.
• Working knowledge of PostgreSQL in Linux environment.
• Understanding of PostgreSQL internals.
• Experience with databases deployments in cloud.
• Familiar with container technologies such as Docker, Kubernetes, OpenShift.
• Exceptional interpersonal skills, written and verbal communication.
• Enthusiastic team player with a strong drive to create positive and dynamic work environment.