Database development, maintenance, production support-Query and application performance and tuning, ad-hoc requests etc. Successfully implemented Data Warehouse built all components for a flip schema mechanism by creating synonyms and granting the right privileges. -Schema creation, user ID management, roles and privileges, oracle parameter setup, oracle directories, synonyms, server monitoring, -Performed production support identified issues and resolutions. -Used Er/Win to design structures and Meta data in the logical model and generated physical model. -Created partitions using Er/Win in the logical model, generated script to be run in the physical model. -Developed complex stored procedures to load data from external feed to staging and ODS layers. -Unix data pump loads to export and import data and Meta data, writing procedures and -functions, testing queries for data quality. -Performed unit, regression and performance testing.
