For more than 40 years, Accelya has been the industry's partner for change, simplifying airline financial and commercial processes and empowering the air transport community to take better control of the future. Whether partnering with IATA on industry-wide initiatives or enabling digital transformation to simplify airline processes, Accelya drives the airline industry forward and proudly puts control back in the hands of airlines so they can move further, faster.
Responsibilities
- Database Development: Create, modify, and optimize database objects (tables, views, indexes, sequences, etc.) using PL/SQL.
- Query Optimization: Write complex queries to retrieve and manipulate data efficiently.
- Performance Tuning: Analyze and improve database performance by optimizing queries, indexing, and database objects.
- Data Integrity: Ensure data integrity and accuracy through validation and error handling.
- Code Documentation: Document PL/SQL code, packages, procedures, functions, and triggers.
- Troubleshooting: Investigate and resolve issues related to data retrieval, processing, and storage.
- Collaboration: Work closely with business analysts, data modelers, and other teams to gather requirements and implement solutions.
- Tools and Technologies: Utilize tools like SQL Navigator and TOAD for efficient development and debugging.
- Unix Knowledge: Familiarity with Unix-based systems, especially when working with Oracle databases.
- PRO*C (Added Advantage): Knowledge of PROC, an embedded SQL precompiler for Oracle, is a valuable skill. PROC allows developers to embed SQL statements directly into C/C++ code, enhancing performance and flexibility.
- Certifications (e.g., Oracle PL/SQL Developer Certified Associate) are a plus
- Conduct code reviews and provide constructive feedback to peers to ensure code quality and adherence to coding standards.
- Identify and troubleshoot software defects, and implement effective solutions in a timely manner.
- Work closely with QA engineers to develop and execute comprehensive test plans to ensure software quality.
- Continuously learn and stay updated on emerging technologies, tools, and industry trends to enhance technical skills and contribute innovative ideas.
- Communicate effectively with team members and stakeholders to provide status updates, discuss technical solutions, and solicit feedback.
- Contribute to the improvement of development processes and methodologies to optimize efficiency and productivity.
- Adhere to project timelines and deliver high-quality software solutions on schedule.
What does the future of the air transport industry look like to you Whether you're an industry veteran or someone with experience from other industries, we want to make your ambitions a reality!
