****************@*****.*** Cell: 443-***-****
Mountain View, CA, 94043.
Karishma Bhagwani
-------------------------------------------------------------------------------------------------------------------------------------------
Objective: Seeking a challenging position as an Oracle DBA.
Education:
Bachelor of Engineering Technology (B.Tech)
in Computer Science (August 2002 – May 2006)
Sant Samarth Engineering College, JNTU (India)
Professional Experience: Total 5.5 years of experience in Oracle Database Administration.
Relevant Skills:
Database : Oracle 9i, 10g and 11g
Operating System : IBM AIX, HP UNIX, Sun Solaris, and Windows
Tools : Oracle Enterprise Manager, SQL Developer, TOAD.
Certification: 9i Oracle Certified Professional (OCP)
1. Organization : HSBC Software India Pvt. Ltd, Hyderabad, India
Duration : Dec 2009 to Sep 2011
Role : Senior Database Administrator
Clients Supported : Global Banking and Markets (GBM)
Scope of Work
Provide 24x7 Production Support.
Design and setup OLTP and OLAP Database environment as per client’s requirement which includes development, test and production databases, backup and recovery strategies, capacity planning.
Performance tuning of SQL queries and databases.
Refreshing Test and Development environment as per client’s need.
Troubleshooting Oracle Errors and Bugs.
Applying Patches, database upgrades and migrations as per client requirement.
Providing on call support and working on High Priority (sev 1 and sev 2) incidents
2. Organization : Computer Sciences Corporation India Pvt. Ltd, Hyderabad, India
Duration : Jan 2006 to Dec 2009
Role : Database Administrator
Clients Supported : Royal Mail Group (RMG), British Bombardier Transport (BBT), Gallaher, Nissan, Goodrich, Belron, Diageo, National Grid (NG)
Scope of Work
Planning and configuring Physical backups through netbackup (tape and disk) and RMAN.
Perform Data purging and reorganization of OLAP databases.
Cloning of databases using RMAN
Troubleshooting oracle errors in standalone and RAC environments
Performance tuning of sql queries.
Database Upgrades.
Providing on call support and working on High Priority (sev 1 and sev 2) incidents.
Documenting the tasks executing at Operational level.
Maintaining the quality documents as per ITIL Version 3.0 and to bring awareness among the team members about the process and Procedures for Incident, Problem and Change Management.
Automated the process of extracting data for Capacity Planning.
DBA Skills
Database environment designing as per Application requirement
Database Upgrades
Performance Tuning
Dataguard
RMAN backups and restoration
RAC
Database Cloning.
Database Reorganization
Database creation (manual and using DBCA).
Installation, Patching and Upgrading Oracle Software.
Troubleshooting of oracle bugs.
Capacity Planning of Large database environments