Bhim Mangla

Sugar Land, Texas, USA

857-***-**** mailto:ac247i@r.postjobfree.com ac247i@r.postjobfree.com

Summary of Qualifications:

Experience as a Sr. Oracle DBA, Sr. Oracle consultant, Tech Lead and Management level.

Installed Oracle 12c Database, RAC 12c, Oracle 12c OEM, Oracle 13c, created new user, tablespace, datafiles, Backup with Data Pump, HOT BACKUP, RMAN BACKUP, Oracle Golden Gate.

Highly skilled Oracle DBA – Oracle Installation 9i/10gR2/11g/11gR2, OEM, ASM, Data Guard, Oracle RAC 10gR2, Administration & Managed Oracle RAC 11gR2.

Expert in Hot and Cold Backup used utility Import/Export, Data Pump and Recovery Manager (RMAN), Increment backup & Recovery, SQL Loader, External Table.

Experienced in Performance Tuning: TKPROF, AUTOTRACE, EXPLAIN Plan, ADDM/AWR, TKPROF, Table Fragmentation, Row Chain issue, Hit Ratio, unused indexes.

Experience in Oracle upgrades, Oracle patch & CPU patch, Data migration in Terabyte (4 TB), troubleshooting, Oracle architecture designed on new server, space management.

Installed Golden Gate and working on it.

Experienced in planning and implementation of Backup and Recovery strategy, designed physical and logical, In-depth knowledge of setting up RMAN backups and maintaining catalog schema.

Migrating experience of Oracle 8i, 9i, 10g.2 to 11gR2.

Created new and managed database existing DBs, space management issues and user management.

Worked on TOAD, SQL Developer, VLDB, Table Partition and troubleshooting.

Expert in UNIX (Sco HP UNIX, AIX, Linux and Sun Solaris), shell script, CRONJOBS Script, Linux & Solaris installation.

Worked on Outlook express, Lotus Notes, Tivoli and BMC Remedy (IBM).

Strong technical and analytical skills, interpersonal and communication abilities.

Consistently maintain a positive attitude, work well under pressure, a team player and quick learner.

Worked as a team member to provide 24x7 on-call production database support.

Education:

1.(M.Sc. Mathematics (Master Degree) Agra University, India.

2.Post M.Sc. Diploma in Computer Science and Application Kurukshetra University, 1.6 years.

3.Oracle 9i and Ecommerce Development from University of Toronto [6 months full time]

4.Have completed PMP training (35 PDUs) from TCS.

5.ITIL Basic Foundation Certification.

Technical Summary:

Databases: Oracle 8i/9i/10g/11g/11gR2/12c/13c, RAC/ Data Guard, ASM and Managed SQL server Database.

Tools: EXP/IMP, Data pump, RMAN, OEM, GRID, SQL*Loader, TOAD, SQL Developer, Oracle Architecture, OEM, Oracle agent, Database security, Audit table and database level, and VM ware.

Platform: Sun Solaris,OLE / Redhat 6/7, Sco open server and Windows.

(Page 1/3)

Professional experience:

Tata Consultancy Services Role: Oracle DBA Jan 2012 and Continued

Installed Oracle 12c, RAC, standalone server with ASM 12c and OEM 13c.

Created PDB/CDB new databases, schemas refresh- Data Pump.

Brought all DBs from no archive mode to archive mode.

Reduced Disk groups from 23 to 5 [ in RAC] and 4 [Standalone servers].

Configured (nfs) on Red hat Linux server.

Configured DBACA on Linux [DISPAY].

Schemas objects drops as per application requirement.

Resolved - RMAN backup back up failing issues, ASM configuration issues etc.

Handling databases issues, RAM decreased from 32 GB to 8 GB, Listeners Issues etc.

Converted CDBs databases to non-CDBs Oracle 12c.

Discuss current issues with client for best performance according to application team.

Frequently involve in meeting with client and teammates.

Taking Initiative to share problems with team member and advice to teammate for the correct solution.

Reduced dramatically Admin alert issues, adding datafiles & related issues; creating new Tablespace, users, patch etc.

Modifying and writing new shell scripts, crontab, High usages of CPUs, indexes & long queries.

Developed a process-

Checking Automatics status of Data Guard synchronization, deleting old archive logs on standby server, sending alert email to team as a proactive alert.

Synchronized Data Guard to removing GAP or rebuild from scratch.

Installed Golden Gate and replicated schemas and tables.

Improved RMAN configured policy and brought up to Data Guard standard & shared knowledge with team.

Improved Disaster Recovery process using RMAN catalog and successfully tested on clients side.

Rewarded by client --- Disaster Recovery.

Involving only Emergency & High priority tickets,

Production support 24x7, Data Capacity planning and using Quest Toad, Remote Desktop & Putty.

Environment: Oracle 11g/12g/13c/ Golden Gate /RAC/ ASM/Data Guard environment, SunOS (24x7)

Clients:

Farmers Insurance Woodlands Hills, CA Jan, 2017 to present.

Charleston County Charleston, SC July, 2015 to Dec, 2016

Johnson Control Inc. Milwaukee, WI April, 2014 to Jun, 2015

Price Water House Coopers Tampa, FL Jan, 2012 to March,2014

iNek Technology Sr. Consultant Dec, 2007- Jan 2011

Oracle installed 10gR2 / 11gR2 RAC, ASM and Data Guard on new servers

Installed Oracle Clusterware, RAC administration and OCR backup.

Configured RMAN, Import & Export and DATAPUMP.

Designed Architecture physical and logical.

Data migrated (used Import & Export and Data pump utility) from Oracle 8i, 9i to 11gR2

Created new users, roles and maintained database security.

Created shell scripts and CRONTAB automating backups.

User security & database security, USERS Management, DDL & DML statements.

Managing TABLESPACE, adding datafiles, Redo log, UNDO & Control file management.

Tuned SQL queries using TKPROF, Analyzer (Monitor USAGE), AUTOTRACE and EXPLAIN Plan.

Troubleshoot and changed CHAR to byte as per application requirement.

Managed TABLESPACE, datafiles, and Redo log, Recovered user table with FLASHBACK.

Generated and analyzed STATSPACK / AWR / ADDM reports and monitored statistics for performance tuning of the database,

(Page 2/3)

Provided 2nd/3rd level support, including on-call support through rotational basis.

Diagnosed and remedy Oracle database problems, following company incident management process.

Complete support and handling of various internal Trouble-ticket work requests.

Provided support of Oracle partitioning, maintenance, and monitoring of Oracle databases.

Provided schema management for objects such tables, views, indexes etc, and meet internal database standards.

Installed and administer Oracle OEM Control.

Provided support Oracle databases through TOAD and Oracle Enterprise Manager (OEM).

Configured/trouble-shoot Oracle connectivity/communication software.

Day to day activities, Follow up with clients and resolving database issues.

Environment: Oracle 9i/10g/11g RAC/ ASM/ Data Guard environment, SunOS (24x7)

Clients: CIBC Bank, Athabasca University, Deloitte, Zibra technology

IBM Global Services, Canada Oracle DBA Jun 2006 - Dec 2007

Backup, recovery and configuration of RMAN catalog.

System tuning & SQL tuning with EXPLAIN, AUTOTRACE, TKPROF, Analyzer Monitor Usage and CBO.

USED STATSPACK and ADDM/AWR.

Planned the size of Database and used Oracle Enterprise Management (OEM)

Used SQL Loader, External Table and Data Pump

Responsible for the physical, logical database design, data conversion, Data modeling and data analysis

Managed TABLESPACE, Redo log, UNDO & Control file management.

Database Management: Physical and Finance Database eliminated duplicate records.

Created UNIX shell script, new user, Indexes and maintained security.

Maintained duplicate record writing script in SQL, Tables, indexes and procedures.

Performed Regular checkup of production and test databases and performance of Oracle application system.

Provided support 24x7

Environment: Oracle 9i, AIX and 10gR2 and Linux (Red Hat),

Daily Liquor Store, Canada Role: Oracle DBA Jan 2003 and Jun 2006

Oracle Database Management and Inventory Management.

Installed Oracle 9i and 10g on UNIX platform.

Created new users, schema, roles, Index and maintained old indexes.

Data manipulation and change the price of items through SQL.

Developed new procedures, Function, Package, Database triggers and maintained SQL scripts.

Maintained backup through (hot & cold backup) and shell script.

Configured STATSPACK on Oracle 9i.

Backup (import and export), Recovery and load data from flat file through SQL*Loader.

Developed new reports; old rates and new rates, stock & sales status, dead inventory and

Developed new script for data query using SQL; daily, weekly, monthly and yearly sales report.

References:

Available upon request.

(Page 3/3)

Contact this candidate