Senior Engineer - Database Administrator

Job Description

• 9+ years hands-on experience of managing PostgreSQL/MySQL databases
• Experience Working on Cloud Environment (AWS, AZURE)
• Experience in designing and setting up databases on AWS (RDS) and other cloud native environments
• Experience in migrating database workloads from on-premise to cloud environments with minimal down time
• Experience in preparing provisioning templates to deploy databases on on-premise as well as on cloud environments
• Experience in deployment and maintenance of PostgreSQL/MySQL Databases
• Experience in PostgreSQL/MySQL database backup, restore and Ponint in Time Recovery (PITR)
• Experience in Performance tuning of PostgreSQL/MySQL databases
• Experience in configuration, integration and setting up disaster recovery sites as per best practicies
• Experience in configuring High Availability (HA) and Disaster recovery (DR) using active-active and master-slave on PostgreSQL and MySQL
• Experience in configuring Transparent Database Encryption (TDE) on postgreSQL as well as MySQL databases
• Experience in designing and managing PostgreSQL/MySQL database schemas
• Experience in deploying complex schema changes as per application/business/project requirements
• Experience in implementing and maintaing Role Based Access Control (RBAC)
• Experience in applying PostgreSQL/MySQL patches and keeping up the environment secure, compliant and healthy
• Experience in identifying any vulnerabilites in the environment and ability to fix these with high quality standards
• Experience in interacting with project managers and business leaders to understand Full project life cycle
• Experience in setting up Enterprise Manager, PGAdmin and other enterprise tools to monitor databases performance
• Experience in configuring desired critical alerts to detect any anamoliles early before it become an incident
• Experience in automating routine tasks to be handed over to other teams for self service
• Strong proficiency in MySQL database management
• Decent experience with recent versions of MySQL
• Understanding of MySQLs underlying storage engines, such as InnoDB and MyISAM
• Experience with replication configuration in MySQL
• Knowledge of de-facto standards and best practices in MySQL
• Proficient in writing and optimizing SQL statements
• Knowledge of MySQL features, such as its event scheduler
• Ability to plan resource requirements from high level specifications
• Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases
• Experience setting up and using PostgreSQL/MySQL replication
• Strong written and verbal communication skills
• Highly motivated, able to work both in a team and solo
• Must be able to meet deadlines and work well under pressure
• Basic Unix/Linux admin experience
• Familiarity with other SQL/NoSQL databases such as Oracle, MongoDB, etc.
• Document database architecture and ensuring the security and integrity of the databases.
• Assist in developing, implementing, and maintaining policies and procedures.
• Oracle database experience is a plus
• Any programming skills including Java, Perl, Unix scripting
• Strong Spoken and written English skills

Keyskills :

About Company

FAB, the UAE’s largest bank and one of the world’s largest financial institutions offers a an extensive range of tailor-made solutions, and products and services, to provide a customised banking experience. Through its strategic offerings, it looks to meet the banking needs of customers across the world via its market-leading Corporate and Investment Banking and Personal Banking franchises.
Headquartered in Abu Dhabi, in Khalifa Business Park, the bank’s international network spans over 19 countries, across the world, providing the global relationships, expertise and financial strength to support local, regional and international businesses seeking to do business at home and abroad. In line with its commitment to put customers first, to Grow Stronger, FAB will continually invest in people and technology to create the most customer-friendly banking experience and will support the growth ambitions of its stakeholders across the global network in which the bank operates.