Oracle Database Administrator. Resume
LOG IN OR REGISTER TO CONTACT ME
This button will open the login/register page in a new tab. After logging in, come back to this page and refresh your browser.
Resume:
Professional skills:
* Clear concept about the oracle (i,g & g) database architecture.
* Capable of installing Oracle i/g/g 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 g on Windows 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 (.,.,.) .
* Having knowledge of installation of Oracle Fail Safe.
* Having knowledge on creation of windows server cluster.
* Basic idea of Finacle (.,.,.) architecture.
Technical Skills:
Operating Systems : Win XP, Win & , Linux, HP UNIX i V & V.
Languages : C, C++, UNIX Shell Scripting, HTML.
RDBMS : Oracle i, g & g.
Database Admin : Oracle i, g, g DBA.
Detailed Profile
WORKING EXPERIENCE: .+ Years
Organization: Hewlett Packard India Sales Ltd
Outsourcing: Embee Software Pvt. Ltd.
Designation: Oracle DBA (Database Administrator), UCO Bank CBS Project .
From, July to Present.
Database Size: . 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.
* TB Production server database migrations from EVA storage to HP XP-P 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 V and Windows R server.
* New DR setup implementations for full setup of “International UCO Bank”. Server Platform HP-UX V and Windows R server.
* Reorganization of . 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 gb table along with 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 gR to gR.
Responsibilities:
* Regular health checkup of 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
A.I.S.S.C.E C.B.S.E. Commerce
A.I.S.C.E. C.B.S.E.
Professional Qualification: DOEACC A Level (PGDCA)
Certification: Oracle certified associate (oracle i DBA)
Oracle certified associate (oracle g 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 -may-
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/tapaskarmakar
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.
.jpg)