Senior PL-SQL Developer

Job Description:

• Design, develop, and optimize PL/SQL queries and scripts for Oracle databases.
• Optimize PL/SQL code to improve performance and reduce resource consumption.
• Manage and maintain large datasets and work with Partitioning in Oracle.
• Perform data backup and recovery using Data Pump, IMP, and EXP.
• Familiarity with Backup & Recovery methods and collaborate with the DBA team to execute these processes.
• Develop and support Oracle APEX as needed.
• Work with OBIEE to create analytical reports and management dashboards.
• Use Shell Scripting in a Linux environment to automate database processes.
• Collaborate with development teams and other technical departments to improve system performance.

Requirements:

• Proficiency in PL/SQL and writing optimized code.
• Familiarity with Backup and Recovery methods.
• Proficiency in Data Pump, IMP, and EXP.
• Familiarity with Oracle APEX.
• Familiarity with Linux and Shell scripting.
• Experience working with partitions and large datasets in Oracle.
• Familiarity with OBIEE.