BASIC SERVICES OFFERED:
– Perform Oracle database administration tasks including configuration management, backup/recovery, performance optimization, and space management
– Administer ORACLE data warehouse
– Design and develop data warehouse solutions, data views, summaries
– Create and execute ETL scripts
– Make recommendations to improve processes
– Provide development and design assistance to development and other application support teams
– Perform Root Cause analysis
– Perform deep impact analysis of problems, projects or technical solutions
ADVANCED SERVICES OFFERED:
– Optimize SQL statements and PL/SQL procedures
– Make recommendations for process improvements
– Develop and implement PLSQL processes
– Work with the development/support teams to optimize SQL statements and PLSQL procedures
– Monitor and analyze ORACLE database performance and make changes to optimize performance
– Assist with migration and/or load of application data into the database environment
– Work collaboratively with other teams including project managers, developers, and architects to ensure project success