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.
Overview:
We are seeking a Senior Software Engineer with expertise in Oracle technologies to design, develop, and manage robust database-driven applications. This role involves working with Oracle databases, tools, and development platforms to deliver scalable, secure, and high-performance solutions. The ideal candidate will have extensive experience in Oracle development, strong problem-solving skills, and a proven ability to lead complex projects.
Key Responsibilities:
• Application Development:
o Design, develop, and maintain applications leveraging Oracle databases, PL/SQL, and related technologies.
o Build and optimize database objects, such as stored procedures, triggers, views, and functions.
o Develop and implement database schemas, ensuring data integrity and performance optimization.
• System Design & Integration:
o Collaborate with application architects and business analysts to design and integrate Oracle-based solutions with other systems.
o Implement ETL processes to manage data migration, transformation, and loading.
o Ensure seamless integration between Oracle databases and front-end or middleware applications.
• Database Management:
o Optimize database performance by monitoring and tuning queries, indexing, and partitioning.
o Manage database security, ensuring compliance with organizational and regulatory requirements.
o Participate in database backup, recovery, and disaster recovery planning.
• Collaboration & Leadership:
o Work with cross-functional teams, including software engineers, system administrators, and QA teams, to deliver high-quality solutions.
o Mentor junior developers and review their code to ensure best practices and consistency.
o Lead technical discussions and contribute to strategic decision-making for database-related projects.
• Testing & Documentation:
o Develop and execute unit tests, integration tests, and performance tests for Oracle-based applications.
o Maintain comprehensive documentation for database designs, system workflows, and technical specifications.
Required Skills and Qualifications:
• Technical Expertise:
o Proficiency in Oracle SQL and PL/SQL programming.
o Strong understanding of database design principles, normalization, and performance optimization.
o Experience with Oracle tools, such as SQL*Plus, Toad, Oracle SQL Developer, or similar.
o Familiarity with Oracle Application Express (APEX) or other Oracle development platforms.
o Knowledge of database performance monitoring and tuning tools.
• System Knowledge:
o Understanding of data modeling tools like ERwin or Oracle Designer.
o Experience with Oracle Real Application Clusters (RAC) and Oracle Data Guard.
o Knowledge of middleware technologies and APIs for database interaction.
• Development Practices:
o Hands-on experience with Agile development methodologies.
o Familiarity with version control systems (Git, SVN) and CI/CD pipelines.
o Strong grasp of software development lifecycle (SDLC) and DevOps practices.
• Education and Experience:
o Bachelor’s or Master’s degree in Computer Science, Software Engineering, or a related field.
o 5+ years of professional experience in Oracle database development and management.
o Proven track record of delivering scalable, high-performance Oracle-based applications.
• Soft Skills:
o Excellent problem-solving and analytical skills.
o Strong written and verbal communication skills.
o Ability to work independently and lead technical teams.
Preferred Qualifications:
• Experience with Oracle E-Business Suite (EBS) or Oracle Cloud applications.
• Knowledge of other database platforms like MySQL, PostgreSQL, or MS SQL Server.
• Familiarity with data warehousing and business intelligence tools.
• Certification in Oracle technologies, such as Oracle Certified Professional (OCP) or Oracle Certified Master (OCM).
• Exposure to Big Data platforms and integration with Oracle databases.
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!
