• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Constraints, Database Access, Roles & Privileges.• Hands on experience in oracle supplied utility DBMS package, V$ views, DBA views.• Monitored Overall system Performance and Database growth.• Implemented database refresh, database retirement, database creation activities for production, development databases.• Extensively used Export/Import, Data pump utilities for data transfer between databases.• Performed physical backups, tape backups, cloning, recoveries and restorations using RMAN.• Performance tuning of SQL statements. Implemented ongoing monitoring of databases & applications using AWR reports, ADDM reports and other Oracle advisors.• Alert handling of databases and successfully carried out outages on weekends.• Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting and backup and recoveries.• Configuration of Oracle Enterprise Manager 12c environment for around 500 Oracle databases. Worked closely with networking team to establish Connection to MOS through OEM12c cloud control. Taking into account the requirements of MillerCoors Oracle DBA team, have set up the notifications for Production databases when specific incidents, events or problems arise. Experience with change management process for IBM Tivoli software. Successfully installed and configured agents on Sun Solaris, AIX, and Microsoft Windows 2008 R2 and Microsoft Windows 2003 R2 systems. Prepared documentation for OEM12c that will be useful for future references.

Responsibilities:• Provided 24X7 support for all database related issues.The environment consists of PROD and NON-PROD databases ,sizing from 1GB to 6 TB.• Creating and managing user accounts and profiles, granting roles and space management.• Implemented Oracle database backup and recovery solutions using RMAN.• Worked on advanced RMAN techniques like active cloning.• Worked on DFix and Deployments.• Refreshed development and test databases from production using logical backups (export and import).• Analyzed SQL queries and reorganized database objects and rebuilding of Indexes for better performance, maintenance of Oracle Database.• Involved in installation and configuration of Oracle products such as Oracle Home, Oracle client, Oracle Enterprise Management agent.• Generated AWR reports, ADDM reports, explain plan for fine performance tuning.• Built and Managed Data Guard environment effectively.• Implemented activities like database retirement, schema retirement.• Creation and management of databases, schemas (such as database creation, database refresh, schema creation, schema refresh etc.)• Identification of tapes needed to bring online for recovery of databases.• Prioritized and resolved high volume of client and internal user requests.• Worked on the EM health reports which monitored Disk space utilization and took appropriate action to put utilization under the threshold.• Handled server outages on weekends.• Scheduled jobs in the database using DBMS_JOBS.• Involved in activities such as schema creation, schema refresh, schema migration.