Analyst - Open-Source Database Administrator

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 Company'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

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