Job Description :
Job Title: Oracle Production Support
Job Location: Minneapolis, MN
Duration: 6 months
Experience: 6 Years
Work on Incident management
Work on Problem management
Work on Change management
Promoting/creating db objects , Tacking backup (Schema, table)
Monitoring DB/environment for any issues
Creating BI publisher report /OEM jobs for monitoring Creating sql profile/baseline for tuning application sqls
collating stats on table/schema
User Management: creating user ids and password management, access management
perform analysis on oracle memory components for optimal sizing
Working on oracle internal errors.
Working on application blocking/deadlocks
Working on tuning efforts of all application queries consuming high resources
performing reorg, datafile shrink ,table/index shrink in order to reclaim wasted space
Following with IBM oracle team for some oracle system related issues
Working on Incidents from application team
Working on problem tickets
RCA on production issues (Problem Management)
Database Capacity planning for procurement requests
Managing Back-up and Restore