RAMANDEEP

Mobile: +91-902*******/ *********

Email:ac7ucm@r.postjobfree.com

PROFILE SUMMARY

I am currently working as an Oracle DBA having 6 years of experience in Information Technology. I have sound knowledge in Oracle database like oracle 9i, 10g, 11g and 12c and experience with Building RAC, Data Guard, ASM and RMAN I have good exposure schema management, database monitoring, Export & Import Utilities (data pump), data guard,sqlplus, backup and recovery, documentation and planning etc.

CAREER OBJECTIVE:

I am looking ahead to work in a professional, growth oriented organization, where in one can make significant contribution to the success of the organization. Seeking a position that involves creativity, challenges and that provides me, an opportunity to constantly strive to explore, innovate & excel in attaining organizational and my individual goals. A consistently dependable team player, I can thrive in a high-pressure environment, enjoy the challenges of meeting deadlines and lead a team successfully.

EDUCATION BACKGROUND:

Course / Degree

Institute / Board

Year of Passing

Grade

B.Tech (Electronics & Communication)

Guru Nanak Dev University Amritsar

2012

1st

H.S.C

PSEB

2007

1st

S.S.C

PSEB

2005

1st

Areas of Expertise

Total Experience : 5 Years

Expertise : Oracle 11g Database Administration

: Experience with Building Data Guard, STANDALONE and RMAN, ASM, RAC

Employer : Capgemini

Title : Oracle DBA

Dates of Employment : Dec 2016 to till date

Client :Metlife (US)

Project Name : Metlife Production DBA Support

ORACLE - DBA SKILLS

Database Installation / Configuration • Patching

Database Migration / Up gradation • Backup and Recovery

Data Guard • EXP /IMP

RMAN

SQL*PLUS

Worked on upgrading of oracle databases from 10g to 11g and 11g to 12c.

Installation, configuration and management of Oracle 11g database on Linux / Windows.

Implemented OEM 12c Repository database, OEM 12c Agent

Performed Performance Tuning of Database using different tools like Oracle Enterprise Manager, Explain Plan, Tkprof reports, Awr reports.

Oracle Architecture Components, Oracle Instance Management, and Creation of Database and Management

Parameter Files management, Control File management, recreate control file on requirement of database, Redo Log Files management, Tablespace creation and management.

Datafile management as adding new datafile, resizing the datafileautoextend on/off etc.

Knowledge in oracle networking concepts Listener, Backup and Recovery Strategy.

AWR reports and various analysis for monitoring purpose.

Task scheduling in Linux cron-tab and Maestro scheduling.

Standby Database Configuration through RMAN.

Implement and administer Dataguard in 11gR2.

Standby database and Data Guard configuration switchover, switchback, gap resolution/troubleshooting.

Expertise in installing different versions of Oracle on UNIX platforms.

Tablespace and table creation and management of Space and Undo Segments.

Creating users, roles, profiles, assigning roles and profiles to users.

Implementation knowledge on Recovery Manager Utility (RMAN) for easier and well-managed recovery procedures.

Developing, testing continuously monitoring and updating the Backup and Recovery strategy. This strategy includes all three types of backups like Logical, Cold and Hot Backups.

Reorganization of tables, Fragmented tablespaces and database using export and import.

Gathering the database statistics to improve performance.

Taking logical and physical backups periodically.

Experience on DATAGUARD and Create and maintaining Physical & Standby database.

Performing day to day activities according to SLA’s

Administered the cluster databases using CRSCTL and SRVCTL utilities.

Administered ASM instance by using SQLPLUS and ASMCMD command line.

Ensure space management on servers and user management at the database and OS Level.

Monitoring and optimizing the performance of the Database.

Checking Alert log, trace files, listener log and other database job logs.

Resolving user’s day-to-day issues.

Reorganizing the Database at regular intervals to remove row migrations, fragmentation in Database using export and import utilities.

Proactive visit for database checkup like free space management.

Professional Profile

PROJECTS HANDLED

Client / Company : Metlife

[Capgemini India private Limited]

Oracle database : 10.2.0.4, 11.1.0.7, 11.2.0.3 & 12c

Operating system : IBM AIX, Windows, Sun Solaris, Linux 4/5

Role : Associate consultant

Duration : 20/12/2016 to till date (Current employer)

Brief description of the project:

MetLife’s Oracle production database environment has around 100 production servers and

Around 200 non prod servers supporting applications like PeopleSoft, data warehouse etc.

.

Responsible for:

Implementation and administering database documentation, guidelines, policies and procedures.

Implementation of replication using SHAREPLES / STREAMS.

Perform Testing, trouble shooting and provide root cause analysis of problems.

Test disaster recovery solutions (switch over/ switch back/ fail over / fail back) to avoid issues and check standby site.

Setup Oracle 11g/12c grid control monitoring & configuration.

Gather and automate the database level statistics to get the better performance.

Performance tuning using SQL Trace, TKPROF, Execution Plan, AWR and ADDM reports.

Upgrade databases from 11.2.0.3 to 11.2.0.4 and 12c and apply Jan 2017 patch set

Employer : Tata Consultancy Services Limited

Title : Oracle DBA

Dates of Employment : Sep. 2012 to Dec. 2016

Client : Reserve Bank of India

Project Name : SFMS and NEFT production Support

Responsibilities

Handling production outages

Installation of Oracle 9i/10g/11g on Linux and Windows platforms

Up-gradation and migration of database.

Installation, Configuration and Administration of Oracle 11g RAC and Oracle 10g RAC.

Refresh/Cloning of Database and applications for development and testing purpose

Database and schema migration, Tablepsace creation

Refresh non production database from production database using RMAN, Hot backup or Cold backup.

Database and Application tuning, Analyzing AWR Report, Query Tuning using explain plan.

Monitoring alerts ( Availability alerts, Tablespace Alerts, Hung Query or Lock related alerts,

jobs related alert, backup or refresh failure alerts) etc.

Coordination with system Administration team, monitoring team etc

Documenting the new process

Solving users queries

Handling database changes

Scheduling and maintaining jobs using crontab (Analyze, backup, alert, purge, exp/imp etc)

Solving problem for SFMS and NEFT Applications on daily basis.

Administration Staging/Uat/Dev/Prod databases.

Working on 24 X 7 supports.

Strength:

Ambitious and hardworking in nature.

Quickly adapting to the new environment and ability to learn.

Fulfilling the specified task within the proper duration.

Quick understanding, punctual and sincere at work.

Interacting with team members to ensure smooth progress of project work.

Personal Detail

Languages Known: English, Hindi, Punjabi (Speak, Read, Write)

Married Status: Married

Date of Birth: 16/03/1990

Permanent Address: V.P.O. Thana, The. Anandpur Sahib, Dist. Ropar(Punjab) 1400117

Current Address: Flat No. 105-B Plot No. 161, MGM Residency, Ulwe Node

Navi Mumbai 410206

DECLARATION

I solemnly affirm and declare that the above given information is true and correct to the best of my knowledge and nothing has been concealed by me.

Ramandeep

Contact this candidate