KEY RESPONSIBILITIES
1. Database Design & Development
Design, develop, and maintain robust database solutions using Oracle and advanced PL/SQL, including stored procedures, functions, packages, and triggers.
Build and optimise complex SQL queries to support high-volume data processing and analytical requirements.
Develop and manage data models and schema designs that are scalable, maintainable, and aligned with enterprise data standards.
Apply bulk data processing techniques using advanced PL/SQL methodologies to ensure efficient handling of large datasets.
Perform continuous performance tuning of SQL queries and data flows to meet operational SLAs and system performance benchmarks.
2. Data Warehousing & Integration
Architect and implement data integration and data warehouse solutions that consolidate disparate data sources in...