Oracle Database Administrator.

Posted on: 2013-04-28

Professional skills:

* Clear concept about the oracle (9i,10g & 11g) database architecture.
* Capable of installing Oracle 9i/10g/11g in Hp-ux, Linux and Windows platform.
* Stack pack/AWR/ADDM report analyzing & sql tuning.
* Working with utilities like dbms, exportdump, importdump.
* Knowledge of Oracle Failsafe in Windows platform.
* Creation of Oracle Data Guard in Linux/HP-Ux and windows platform.
* Generate & analyze session trace with the help of tkprof utility.
* Knowledge of user management & auditing.
* Knowledge of database cloning.
* Knowledge of Oracle RAC 11g on Windows 2008 and Linux platform.
* Working with UNIX shell scripts.
* Working exposure in Hp-Ux platform,Linux & Windows Platform.
* Clear concept of oracle database migration from one server to another server.
* Clear concept of implementation of database server in windows and HP-UX.
* Clear concept of oracle RMAN backup.
* Clear concept about the database structure of Finacle application (7.9,7.11,7.19) .
* Having knowledge of installation of Oracle Fail Safe.
* Having knowledge on creation of windows 2003 server cluster.
* Basic idea of Finacle (7.9,7.11,7.19) architecture.

Technical Skills:

Operating Systems : Win XP, Win 2003 & 2008, Linux, HP UNIX 11i V2 & V3.
Languages : C, C++, UNIX Shell Scripting, HTML.
RDBMS : Oracle 9i, 10g & 11g.
Database Admin : Oracle 9i, 10g, 11g DBA.

Detailed Profile

WORKING EXPERIENCE: 4.10+ Years

Organization: Hewlett Packard India Sales Ltd
Outsourcing: Embee Software Pvt. Ltd.
Designation: Oracle DBA (Database Administrator), UCO Bank CBS Project .
From, July 2008 to Present.
Database Size: 5.5 TB.

Live Activity Done in Production Environment.

* Completed the full implementation of oracle database servers in HP-UX and windows platform for three tire architecture data Centre.
* 5 TB Production server database migrations from EVA storage to HP XP-P9500 storage.
* Oracle Fail-safe Migration along with database migration to new servers.
* New server implementations for full setup of “International UCO Bank”. Server Platform HP-UX V3 and Windows 2008 R2 server.
* New DR setup implementations for full setup of “International UCO Bank”. Server Platform HP-UX V3 and Windows 2008 R2 server.
* Reorganization of 2.9 tb Database .
* Moving datafile for reducing space in mount point. Database configured with Oracle DG.
* Successfully performed DC-DR Drill switchover – switchback of production database.
* Re-correcting one of the corrupt data file in the database.
* Partition of 300 gb table along with 250 gb Index.
* Recovering of Datafiles deleted from root user in production database.
* Successfully recovered the standby database, for deletion of archive before it applied to standby database, with the help of RMAN.
* Oracle database migration from 10gR2 to 11gR2.

Responsibilities:

* Regular health checkup of 24 instances of UCO Banks Production server databases.
* Checking the performance related issue of database.
* Creating various types of report for database.
* Maintaining the Oracle database License for each instances.
* Checking the statspack report and thereafter to analyze the report for troubleshooting the performance related issue.
* Finding the High cpu/memory utilization sql queries, and to find the cost of the queries through explain plan, and then to tune the queries is possible.
* Oracle Software Installation. Database Creation. Database Cloning.
* Tablespace create for different user.
* Datafile add & resize according to requirement. Undo space management.
* Creating crontab and checking crontab.
* Checking trace file through Tkprof utility.
* Compiling invalid objects.
* Creating report server.
* Maintaining the database configured with Oracle Data Guard in Hp-Ux environment.
* Maintaining the database configured with Oracle Data Guard in Windows environment
* Maintaining the Database configured with Oracle Failsafe in windows.
* Gathering statistics through dbms utility and analyzing tables and indexes.
* Client Configuration. Responsible for handling users online.
* Managing database User, Privileges & Roles.
* Monitoring Multiple Databases using alert log file, trace file and also AWR (stats pack).
* Performance Tuning (Database Tuning, SQL Tuning) using stats pack, explain plan.
* Troubleshoot problems related to Oracle Database.
* Maintenance of Index by analyzing and rebuilding.
* Standby database configuration and maintenance.
* Preparing and maintaining the Shell script for performing day to day activity.
* Preparing the sql script for running some analyze and creating the report.
* Checking partition table health, add datafile to it.

ACADEMIC QUALIFICATIONS:

Examination University Department Year of Passing
B.Com (Hons.) Kalyani Commerce 2004
A.I.S.S.C.E C.B.S.E. Commerce 2001
A.I.S.C.E. C.B.S.E. 1999

Professional Qualification: DOEACC A Level (PGDCA)

Certification: Oracle certified associate (oracle 9i DBA)
Oracle certified associate (oracle 11g DBA)

AREAS OF STRENGTH

* Hard Working and dedication
* Desire and ability to learn new things quickly
* ‘Don’t quit’ attitude
* Adaptable to any environment

PERSONAL PROFILE:

Name Tapas Kumar Karmakar
Father’s Name Prabhat Kumar Karmakar
Date of Birth 25-may-1983
Gender Male
Marital Status Single
Nationality Indian
Hobby * Net Surfing
* Listening to music
* Helping helpless person
* Blog Writing: My youtube blog http://www.youtube.com/user/tapaskarmakar2000
Languages known * English
* Bengali
* Hindi

DECLARATION:

I hereby declare that above mentioned particulars are true to the best of my knowledge and belief.

PLACE: Kolkata Yours sincerely,
DATE: Tapas Kumar Karmakar.