TS Controller - Postgres SQL DBA

About Your Job

• You will organize all Database Systems Administration activities for QR systems on a regular basis to ensure they are up to date.
• You will be responsible for supporting line management in the IT Strategy development, its implementation and compatibility with operational and business objectives and also assist in the budgetary preparation.

Responsibilities

• Leads and controls the implementation, installation, maintenance and support of all relevant technology ensuring quality service is provided to Qatar Airways and its subsidiary organizations to achieve business uptime.
• Control all Backup/Recovery of IT systems are in place as per current IT standards and processes including the processing of Batch Jobs for all systems round the clock
• Oversees the trouble shooting of IT Systems, Networks, Databases and User end devices are carried out on a 24 X 7 basis as per procedures laid down to ensure quick resolution for IT faults or incidents reported
• Organises and supervises the coordination and communication with Vendors and Information Systems Providers for systems support in order to handle system upgrades, fixes and enhancements whenever required.
• Organizes and provides technical support for any system failures in the TS Infrastructure and other implemented products ensuring quick resolution to reduce down time to the business units
• Oversees that Process and Procedures are followed as per ITIL standards for IT Services and Support across all platforms
• Organizes control of all User Profile Management and Access Control on Servers, applications, Databases systems to ensure security of the IT systems and their access as per existing policies and standards to safeguard the company data from the possible IT threats.
• Oversees and carries out regular checks to ensure that all IT Operational jobs are performed on a periodic basis (i.e. Daly, Weekly or monthly) for IT systems hosted at Qatar Airways Data Centre(s) and performs all required Data Centre operations tasks and responsibilities.
• Oversees all coordination with Vendors/suppliers for the follow up on IT supplies of hardware, software and end user computer accessories and ensures proper delivery of IT equipment as per orders submitted Organises and is responsible for control over IT Stores and regular updates of IT assets in the IT Asset Management system to ensure all IT assets are properly reordered, issued, updated and disposed of as per end of life cycle.
• Oversees all system documentation for IT procedures, standards and policies and its updates are carried out on a regular basis and these are stored in a central repository.
• Perform other duties and responsibilities as requested by Management.

About You

• Candidate must hold a Bachelor's degree or Diploma with minimum 5+ years of experience in end-to-end full life cycle of Upgrading PostgreSQL Database
• Knowledge on DB installation, Upgrade, replication setup and provide performance, scalability, and High availability solution in a Linux operating system and cloud platform.
• Expertise in High availability solutions like repmgr, patroni, streaming replication.
• Expertise in cloud PostgreSQL flavors like Azure flexi postgres, Alloydb, cloud SQL.
• Expertise in various backup solutions, pgdump,pg_base_backup,pgBackrest and Recovery solution
• Should be flexible for 24x7 based L2/L3 Technical & functional support
• Added knowledge in migration of ...