Role description

Job Summary

Seeking a Specialist with 5 to 7 years of experience in Oracle PLSQL to design develop and optimize database solutions within the Oracle DBODIPLSQL skill cluster

Job Description

Develop maintain and optimize complex Oracle PLSQL programs including packages procedures and functions to meet business requirements Design and implement efficient database solutions ensuring data integrity availability and performance Perform data analysis and validation to support accurate reporting and analytics Collaborate with crossfunctional teams including data architects and business analysts to translate requirements into technical specifications Utilize dimensional data modeling techniques to enhance data warehousing and reporting capabilities Monitor and tune database performance using Oracle tools and best practices Document database designs processes and procedures to maintain a comprehensive knowledge base and support compliance Stay updated with the latest Oracle database technologies and industry best practices

Roles and Responsibilities

Lead the development and implementation of PLSQL packages procedures and functions ensuring adherence to coding standards Conduct code reviews and provide technical guidance and mentorship to junior team members Troubleshoot and resolve complex database issues including performance bottlenecks and query optimization Collaborate with data architects and business analysts to design and implement dimensional models supporting analytics Participate in database migration upgrades and patching activities to ensure system stability and security Ensure compliance with security policies and coding standards throughout the development lifecycle Coordinate with stakeholders to prioritize and manage database development tasks and deliverables effectively Mentor and train team members to enhance their Oracle PLSQL and data modeling skills