Senior Engineer- Database Administrator -UAE Nationals Only !

8 نوفمبر، 2022

0 1 2 دقائق

Job Description

Job Description
Generic Accountability

Senior Engineer as part of the Infrastructure & Operations aligned to a particular service
Ideally through experience you will enhance your skills across multiple specializations.

Specific Accountability

MySQL and PostgreSQL Database Support-On Prem and Cloud Servers.
Strong Experience on MySQL and PostgreSQL Server version 8 and 13, respectively.
Performance and Problem management on database
Troubleshooting & Identifying OS, Database Issues
Vendor/OEM coordination
DR activities
Major incident/Sev1 Call handling
RCA Preparation
Adhere to Change Management Process.
Mentoring Junior Engineers.
Industry Best Practices (Service Improvement Plan) Implementation
Documenting Risks/SPOF in databases.
Active Participation & Involvement in Project Technical Discussions
Cloud Experience in MS-Azure & AWS (Amazon Web Services)
Additional work experience on Oracle or MongoDB would be added advantage.

Qualifications

9+ years hands-on experience of managing Oracle, 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 Oracle, PostgreSQL/MySQL Databases
Experience in PostgreSQL/MySQL database backup, restore and Point 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 practices
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 maintaining Role Based Access Control (RBAC)
Experience in applying PostgreSQL/MySQL patches and keeping up the environment secure, compliant and healthy
Experience in identifying any vulnerabilities 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 anomalies 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 MySQL's 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