Vacancies at Kenya Airways

Brief Description

• The Database Administrator will be responsible for the planning, implementation, management, and support of all Kenya Airways Limited database platforms. This includes Oracle, Microsoft SQL Server, MySQL, PostgreSQL, MongoDB, and otheremerging database technologies. The role requires ensuring high availability, performance, scalability, and security of databases to support the operationaland strategic objectives of the airline.

Detailed Description        

• Administer, monitor, and optimize performance across all database environments to ensure efficient operations.
• Design and implement Business Continuity Plans (BCP) and High Availability (HA) solutions to ensure system resilience and zero downtime during maintenance or unexpected outages.
• Conduct capacity planning and anticipate future database storage needs in line with business growth.
• Respond promptly to user-reported issues and perform root cause analysis to prevent recurrence.
• Develop, test, and maintain robust backup and recovery strategies to safeguard data integrity.
• Implement strong database security controls to protect against unauthorized access, breaches, and data leaks.
• Prepare regular reports on database usage, performance metrics, and incident resolution.
• Collaborate with IT project managers, developers, and other stakeholders to ensure alignment of database requirements with business applications.
• Provide input on database design to support front-end and back-end development teams.
• Apply industry best practices in database administration, maintenance, and lifecycle management.
• Work closely with technology vendors and partners for solution support, upgrades, and issue resolution.
• Keep abreast of new trends and technologies in database systems and recommend improvements or adoption.

Job Requirements        

• Bachelor’s Degree in Computer Science, Information Technology, Software Engineering, or related field.
• Minimum of 5 years’ experience in infrastructure support or database administration, preferably within a complex enterprise environment.
• In-depth experience with both relational and NoSQL databases, including Oracle RAC, Data Guard, RMAN, SQL Server, MySQL, PostgreSQL, and MongoDB.
• Hands-on expertise in Linux/Unix administration as it relates to database hosting and management.
• Proven ability in database performance tuning, troubleshooting, migration, and Information Lifecycle Management (ILM).
• Oracle Certified Professional (OCP)
• Oracle Certified Expert (OCE)
• Microsoft SQL Server Certification
• Exadata Administration
• Linux/Unix Certification
• Hadoop Administration (an added advantage)
• Working knowledge of cloud-based database models and integration architectures.

Additional Details        

• Stronganalytical and problem-solving skills with keen attention to detail.
• Excellent communication and interpersonal skills to interact with cross-functional teams.
• Ability to work under pressure and manage multiple priorities simultaneously.
• Demonstrated leadership and collaboration in project or squad-based work environments.
• A proactive approach to identifying risks and proposing innovative solutions

go to method of application »

Brief Description        

• Flight Disruption and Revenue Enhancement is a section operating on 24/7 basis and isresponsible for ensuring proper, efficient and effective way of handling flightdisruptions (WW), schedule changes (CV), and facilitating accurate passenger re-accommodation both inbound and outbound. The role provides inventory support through flight creations, rescheduling and resultant re-protections. The roleis equally critical in controlling inventory abuse through correct rebooking of PNRs affected by irregular operations.
• The analyst supports continuous revenue generation on all KQ flights by pro-actively capturing revenue opportunities, SSRs confirmations, ensuring revenue integrity and minimizing inventory spoilage (flying an empty seat) and achieving overall company revenue and passenger targets.

Detailed Description        

Operational

• To represent the Strategy and Innovation Department by providing input for decision making during flight disruptions.
• Work closely with OCC Duty Managers and inventory teams during disruptions to deploy the right equipment on the right route to maximize revenue and reduce operating costs using all available data.
• Re-protect Passengers in ER window in case of Aircraft changes to ensure seamless customer service.
• Update Ad-hoc flight changes in Altea Inventory systems.
• Actively provide rerouting alternatives for passengers during flight disruptions in close co-ordination with contact center, sales offices, Operation Control Center and Airline partners to maintain customer satisfaction and give world class service.
• Continuously reconcile and synchronize planned versus filed flight schedule/equipment to ensure optimal revenue gains per flight and ensure customer satisfaction.
• Update and communicate to all stakeholders’ options provided for passenger’s misconnecting and all other disrupted passengers.
• Provide the best available options that return the operations to normal as soon as possible ensuring minimum disruptions whilst protecting revenue potential.

Network Redesign andEfficiency

• Work closely with Network Planning and Inventory during Schedule Publications and Schedule Changes to ensure flight reflection in Altea Inventory, impacted guest’s Re-accommodation and Alternative Flight Solution offered, handling SET for urgent CV within 24hrs and seasonal CV within 72hrs.
• Daily checks on Turn schedule to reconcile Scheduled Equipment in Altea published by Network Planning versus Planned Equipment in Aims by Operations Control.

RevenueEnhancement

• Ensure that the most cost-effective re-route options are chosen when disruption occurs using Sky team partners, JV partners, re-protection agreements and Interline SPA partners.
• Maximum retention on KQ services followed by selective usage of SPA and Hotel accommodation.
• Minimize costs by proactively liaising with RM Interline on negotiating with other carriers to take our passengers at lower negotiated rates during disruptions.
• Support Inventory team to Perform timely flight steering to avail the right seat to the right customer at the right price in the right time.
• Support revenue integrity during nightshifts, weekends, and public holidays with suspending/unsuspending tickets/CRS abuse.
• Proactively provide solutions to reduce revenue leakage and revenue opportunity loss in the areas under control of Revenue Management.
• Follow-up on correct usage of Marriage Segment Control /Minimum Connecting Time.
• Processing of Special Service Requests to ensure quality customer satisfaction (INFT, WCOB, STCR, WHCS, SPML, Plusgrade, Blocked and unblocked seats).
• Assist the network on force booking as per initial classes due disruption, duty tickets, special cases i.e., MEDA and INADs, special market offers/ promotions, ancillary services, and others through managers’ authority.

Reportingand Analysis

• Prepare and analyze the Schedule change SET report, flight disruption report and circulate the same to all relevant stakeholders.
•  Prepare daily Loads Signal (LOSIG) report on flights booking, loads performance (low or over sale) to facilitate DMO/MOC minimize Ad hoc disruptions.
•  Prepare daily reports on reconciled versus planned flight schedule/ equipment for future use in decision-making.

Job Requirements        

• A professional degree with strong emphasis in a business-related field e.g., Statistics, Economics, business administration, Mathematics or Commerce.
• Minimum 3 years airline experience pricing and revenue management, commercial, ground services or operations.
• Knowledge of fares, ticketing, reservation, and passenger handling systems an added advantage.
• Customer focused and good Public Relations.
• Ability to work under pressure.
• Ability to work on shift as the office is manned on a 24/7 hr. basis.