Role description

Job Description

Design develop and maintain complex Oracle PLSQL programs Oracle Analytics including packages procedures and functions to meet business requirements Optimize database solutions ensuring data integrity availability and high performance Perform data analysis and validation to support accurate reporting and analytics Collaborate with crossfunctional teams such as 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