Analyst – Open-Source Database Administrator – Transguard Group , Dubai, UAE

Job Description
Transguard Group was established in 2001 and has diversified significantly, we lead in the fields of Cash Services, Security Services, Manpower Services, Facilities Management & Aviation. Transguard Group is the UAE’s most trusted business support and outsourcing provider and has a large, dynamic and culturally diverse workforce with 50,000 employees! We are currently recruiting for a Analyst – Open-Source Database Administrator for our trusted client in Aviation industry to be based out of their headquarters in Dubai.

Job Purpose-
Migrate Dubai Airport’s databases to the latest open-source PostgreSQL and MySQL
Company’s critical operational application databases run on proprietary databases like Oracle and SQL Server, the candidate will be the single point of contact to evaluate, plan and implement migrations in target to reduce the total cost of ownership and reduce the footprint of proprietary databases
Project IDs:
BT PMO-nnnn: Database Migration to Open Source
Migration of on-premise Company’s databases to the latest release of PostgreSQL & MySQL with High Availability, Security, and Disaster Recovery architectured within the systems
BT PMO-0335: Database Encryption
A feature included with the Enterprise databases that Company is licensed to use. It will encrypt the database at rest i.e. when it is on storage or backup devices. No Application change is required.
Data protection will be enabled so in case data is taken from Production to other environments an encryption-decryption Certificate will be required.
BT PMO-0336: Performance Enhancements
Improve Company’s Applications database performance. Already started talking to Company’s service owners and vendors to implement architecture, design & query changes to enhance performance and utilize features like Auto Tuning & archive data compression
Business as Usual
There are daily maintenance and BAU in addition to requests from the business for release to application supports like performance troubleshooting or system upgrades

Job Accountabilities
Oracle & SQL Server migrations to PostgreSQL & MySQL and improvement in stability and performance
All migrations should follow the CAB process going with all available PreProd and Production
Database Encryption is a Security requirement to enable transparent database encryption without any changes to the dependent Applications and ensure all the systems working as before enabling the feature
Business as Usual and Application Team support
Monitoring & Shell Scripting

Skills
Education
Degree level qualification in Computer Science B.Sc or Computer Engineering
Professional Qualifications/Regulatory Requirements
Professional Certification preferred
PostgreSQL Professional Certification
EDB Professional Certification
OCP: Oracle Certified Professional MySQL
RHCE: RedHat Certified Engineer or RHCSA
Tools and Systems Experience:
PowerShell & Python scripting
Database Clustering, Replication i.e. CitusData
RedHat Linux
ASM Storage
Database NetBackup
Backup & Recovery
Enterprise Monitoring

Click here to Apply Online

Enter your email address to receive latest Gulf Jobs Updates: