Sample Banner
Sample Resume > Sample Resume References > Sample List of References

Sample List of References 

 

 

 

Client

Sodexho Financial Services Inc., Buffalo, NY, USA

Position

Oracle DBA

Duration

Sep 06 – Feb 08

Project Description: Sodexho Financial Services Inc. is the North America's leading provider of food and management services and one of the largest food companies in the world. The project involved in design, development, and management of large complex databases that are located on multiple servers in a diverse hardware environment across geographically separate data centers. Responsible for the structural integrity of large-scale database management systems and for the development and implementation of preventative maintenance routines to ensure end-user availability and performance of database files.

Responsibilities:

  • Designed, reviewed, implemented, tested and released databases.
  • Created users, granted roles and privilege management.
  • Performed maintenance of user accounts and privileges to maintain application security.
  • Planned, Configured and Setup Replications.
  • Created Standby Database for Disaster Recovery using Dataguard.
  • Performed Testing of Switch Over and Failover process functioning.
  • Monitored the archive log shipping to the standby system.
  • Used Flashback technology for recovering drop tables and other user errors.
  • Performed day to day backup operations using RMAN and monitored & run Hot/ Cold Backup scripts, Incremental backup scripts etc.
  • Migrated databases from Sun Solaris platform to Windows using RMAN.
  • Transferred data using Transportable Tablespaces, Data Pump and RMAN.
  • Performed online/ offline backups and recoveries of various oracle databases using Export/ Import and DataPump Utility.
  • Done Database Cloning from production to test database to identify the problems, recovery purposes.
  • Involved in Performance/ Application/ Memory Tuning and analyzing tables and indexes.
  • Tuned SQL statements using Explain Plan, HINTS, TOAD, OEM and appropriate indexing.
  • Gathered Database statistics using the DBMS_STATS and extracted AWR reports and using advance advisory oracle tools.
  • Ensured security of the database by creating profiles for each user and monitored the user sessions.
  • Developed UNIX Shell and Perl Scripts to monitor and automate jobs.