• Experience in Oracle SQL and PL/SQL.
• Advanced PLSQL Programming, Collections and Bulk processing, Analytical functions
• SQL query tuning and PL/SQL Performance optimization
• Good data analysis skills.
• Should be able to understand business requirements and do solution design.
• Senior PL/SQL Developer (Database)
• Senior Database Developer is responsible for developing and supporting PLSQL database codes for Revenue Accounting system.
• Should be having experience in advanced PLSQL programming.
• Required Knowledge, Skills, and Abilities
• Strong development skill in Oracle Database 11g, preferably in airline domain.
• Data Architecture & modelling skills.
• Understanding of database objects like table, view etc.
• Building packages/procedures/functions/triggers.
• Advanced PLSQL Programming, Collections and Bulk processing, Analytical functions
• SQL query tuning and PL/SQL Performance optimization
• Daily support tasks. Resolve tickets.
• Ability to understand the business requirements, provide solution design and work independently.
• Major Areas of Responsibility
• Develop the SQL and PL/SQL codes to automate the manual reporting works.
• Optimize the existing codes for better Performance.
• Integrate data between different databases
• Do data analysis on and identify discrepancies and provide RCA for data issues.
• Technology / Tools
• Oracle Database 19c
• SQL, PL/SQL
• TOAD , SQL Developer