Name: Mr. Jyoti Ranjan Mishra DATABASE ADMIN

Contact: +91-886*******

E-Mail: acxtsy@r.postjobfree.com

Objective:

Seeking a versatile, challenging and demanding career in oracle database admin with high level of competence and responsibility, by rendering professional skills and thereby adding value to the organizational growth and self.

PROFILE SUMMARY

Having around 3 Years of experience as Oracle DBA along with experience of Oracle core DBA support for application stuff like Applications 11i/R12.1.1/R12.1.3/R12.2.2 with RAC (maintenance) & Oracle Fusion Middleware (with multi node architecture), providing 24x7 support of both Production & Development on Various Platforms.

Experience in Planning, installation, configuration, management and troubleshooting of Oracle 10g, 11g and 12c databases on Linux and Windows OS.

Hands on experience in Cross Platform Migration of Oracle Database 11gr2 on RHEL Linux from 32 bit to 64bit PRODUCTION Environment.

Configured DB links to access data in Oracle from MS SQL server database.

Installed and manage Oracle Enterprise Manager 13c.

Administrating database user management, capable of creating shell script of daily basis user management requirements.

Provide database administration on production, testing and development database servers.

Moved data from one database to the other using Transportable tablespace

Apply quarterly CPU patches to different version of databases.

Experienced in using and troubleshooting data pump export/import on migration based requirements.

Performed physical and logical backup using RMAN with automation scripting and manual backups as well.

Performing database cloning and duplication using RMAN and manual process.

Good experience in SQL, PL/SQL and Shell Scripting

Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports

Highly motivated and extremely passionate about resolving problems with a positive attitude and excellent attention to details.

Ability to grasp new tools and technology quickly.

Excellent interpersonal communication and presentation skills.

ORGANISATIONAL EXPERIENCE

Oracle Certified Professional Database 12c Administrator (OCP)

Oracle Certified Expert 11g Release 2 SQL Tuning (OCE)

Oracle Certified Associate Database 11g Administrator (OCA)

Oracle Certified Professional Database 11g Administrator (OCP)

Oracle Certified Associate PL/SQL Developer (OCA)

Oracle Certified Professional Advanced PL/SQL Developer (OCP)

IT SKILLS

Database: Oracle 10g, 11g, 12c

Languages: SQL, PL/SQL, UNIX Shell Scripting

Operating Systems: Windows, Red Hat Linux, Oracle Enterprise Linux

Tools: RMAN, OEM, SQL*PLUS, SQL*Loader, External

Tables, TOAD, SQL Developer, PL/SQL Developer

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACKSQL,

ADDM, AWR, SQL TUNING/ACCESS ADVISOR

EDUCATION

B.Tech (INFORMATION TECHNOLOGY) from BPUT University, 70 %

EXPERIENCE and PROJECTS WORKS DETAILS

Working with Estuate Software Pvt. Ltd Since Mar 2014 to till date.

#1. Project: Platform Migration of Oracle Database 11g R2 from Linux 32 bit to 64 bit

Environment : RHEL 4 32 bit, RHEL 6 64 bit

Role : Oracle DBA

Team Size : 5

Responsibilities:

Analyzed current Oracle Database 11g R2 Instance for migration

Analyzed custom objects

Involved with Functional/technical team to estimate the migration impact

Took full backup of Database using RMAN and OS Level backup(Snapshot)

Completed all prerequisite like rpm installation, user creation etc.

Installed Oracle software on 64 bit machine

Created parameter file & control file on 64 bit machine

Transferred the data files from 32 bit to 64 bit Linux machine

Exported OLAP from 32 bit Database to 64 bit Database

Ran migration script in upgrade mode and start the Database

Compiled all Database Objects and Resolved the Post-Migration issue

Collected system and database level statistics

#2. Project: Upgrade Oracle Database from 10g to 11g R2 (11.2.0.4)

Environment : RHEL 4

Role : Oracle DBA

Team Size : 5

Responsibilities:

Analyzed current 10g Instance for upgrade

Patch Analysis for technical Upgrade

Involved with Functional/technical team to estimate the upgrade impact

Took full backup of Database using RMAN and OS Level backup(Snapshot)

Upgraded Database from 10g to 11gR2 (11.2.0.3)

Compiled all Database Objects

Resolved the Post-Upgradation issues

#3. Project: MCMS (MTO Control and Management System)

Environment : Windows 2012 R2

Role : Oracle DBA

Team Size : 9

Description: This application is kind of reporting tool and it is enhancement project. This release was kind of redesigning of the modules. This involved designing of the configuration screen and redeveloping all the modules should work based on the configuration.

Responsibilities:

Involved in installation and configuration of database 11g on test and development environment

Monitoring Tablespaces and Datafiles utilization

Involved in creating and managing users and objects

Involved in assigning roles and privileges to different users

Inspected log file, monitored table spaces and partitions

Involved in creating tables, indexes and views

Took backup of whole database as well as objects(Specific to development)

Checking Databases Backup and Restore validity periodically

Export and import of objects form test to development environment when required

Involved in creating procedures, function and triggers based on the requirement

#4. Project: Oracle UCM (Stellent):

Environment : UCM

Role : Oracle DBA

Team Size : 5

Description: Oracle Universal Content Management Server (UCM) which is an automated system for sharing, managing, and distributing business information using a web site as a common access point.

Responsibilities:

Daily server monitoring activity and performance monitoring through OEM12c.

Daily activities for all database administration with oracle database 11g like database installation and configuration,security,trouble shooting, Data migration, Performance tuning .

Scheduling daily hot backups and weekly cold backups.

PERSONAL DETAILS

Date of Birth : 30/06/1991

Address : Plot No-178,3rd Cross, 2nd Main, Vidyranyapura,

Bangalore, PIN-560097

Gender : Male

Languages Known : English, Hindi and Oriya

Marital status : Unmarried

Nationality : Indian

Contact this candidate