Technical Consultant

Performance Technical Consultant

Location:

Remote Duration of the contract: 60 days to start with if required will extend

Role Overview:

We are seeking an experienced Performance Optimization Consultant to analyze and improve the performance of our airline ticketing, scheduling, and check-in system. The application was originally developed in TPF Mainframe Assembler, translated into C language, enhanced with additional C code, integrated with PostgreSQL database, and deployed on Azure Virtual Machines. The system is currently experiencing performance bottlenecks, and we need an expert to identify root causes and recommend minor changes for optimization.

Key Responsibilities:

• Conduct a comprehensive performance assessment of the application stack (C code, PostgreSQL DB, Azure infrastructure).
• Analyze CPU, memory, and I/O utilization on Azure VMs and identify bottlenecks.
• Review translated C code for inefficiencies and suggest optimizations.
• Evaluate database queries, indexing, and schema design for performance improvements.
• Assess network latency and application architecture for potential optimizations.
• Provide actionable recommendations for minor code changes, configuration tuning, and infrastructure adjustments.
• Document findings and present a performance improvement plan.

Required

Skills & Experience:

• Strong expertise in C programming and performance tuning.
• Experience with legacy system migration (Assembler →
  
  C) and associated challenges.
• Deep knowledge of PostgreSQL optimization (query tuning, indexing, connection pooling).
• Hands-on experience with Azure Virtual Machines and related performance monitoring tools.
• Familiarity with airline reservation systems or similar high-transaction environments is a plus.
• Proficiency in profiling tools (e.g., gprof, perf) and database performance analyzers.
• Ability to provide quick, practical solutions without major architectural changes.

Preferred Qualifications:

• Prior experience with TPF systems or mainframe-based applications.
• Knowledge of Azure scaling strategies and cost-performance trade-offs.
• Strong analytical and problem-solving skills.
• Knowledge of Airline Industry is a plus.

Engagement Deliverables:

• Detailed performance analysis report.
• List of recommended optimizations (code, DB, infrastructure).
• Optional:
  Assist in implementing suggested changes