Oracle PL SQL Developer (RARR Job 5509)

• Develop and maintain PLSQL procedures functions packages and triggers
• Design and optimize complex SQL queries for data extraction and reporting
• Perform data modelling schema design and database tuning
• Collaborate with application developers to integrate backend logic with frontend applications
• Conduct unit testing and support system integration and user acceptance testing
• Monitor and troubleshoot database performance issues
• Maintain documentation for database structures and processes
• Participate in code reviews and ensure adherence to best practices

Required Skills Tools

• Strong expertise in Oracle SQL and PLSQL and Shell scripting
• Experience with tools like SQL Developer TOAD and PLSQL Developer
• Familiarity with database performance tuning and optimization techniques
• Knowledge of version control systems e.g. Git Bitbucket
• Exposure to Unix Linux environments and shell scripting
• Experience with data migration ETL processes and data quality checks