ECS | Enterprise Change Specialists
Location
Secunderabad | India
Job description
Senior Database Developer is responsible for developing and supporting PLSQL database codes for FZ PSS system.
Should be having 8+ years PL/SQL experience on OLTP systems.
Required Knowledge, Skills, And Abilities - Strong development skill in Oracle Database 11g, 19c, preferably in airline domain.
- Building packages/procedures/functions/triggers.
- In depth understanding and working experience in SQL and PL/SQL
- Knowledge on Oracle Advances Queue.
- Daily support tasks. Resolve tickets.
- Query performance tuning.
- Data Architecture skills.
- Data modeling skills.
- Ability to understand the requirement and work independently.
- Experience in External Data Loader.
- Understanding of database objects like table, view, trigger, etc.
- Understanding of ETL process.
Major areas of responsibility include:
- Develop the SQL and PL/SQL codes to automate the manual reporting works.
- Optimize the existing codes for better Performance.
- Integrate data between Oracle Database and SQL Server Database.
- Use PL/SQL for ETL works.
- Use as much as possible features available in procedures.
Technology / Tools
- Oracle Database 11g, 19c
- SQL, PL/SQL
- TOAD , SQL Developer
Job tags
Salary
