PREM KUMAR SINGH

M.no :- 098********

Email :- adjjdq@r.postjobfree.com

OBJECTIVE:

To sharpen my skills through continuous learning being on a challenging job and to work towards achieving the objective of the oraganization.

EMPLOYEEMENT ABBREVATION:

Presently I am working in HCL TECHNOLOGIES as a Technical Specialist.

I have experienced in Giplanner Technologies Pvt. Ltd as a Sr. Software Engineer.

I have experienced in ANR Software Pvt. Ltd as a Oracle DBA.

CAREER EXPERIENCE SUMMARY:

Oracle certified Professional with 8+ years of experience as a Sr. DBA. I am responsible for the Following:

•Worked on various environments involving in major clients on all OS in mission critical OLTP (up to 30TB) and OLAP (up to 80TB) Environments.

•Experienced in RAC (Real Application Culster) Installation, configuration and Administration on oracle 11gR2.

•Maintained and Supported 12 node RAC cluster with invoicing databases.

•Good Experienced in Oracle Installation, Database configuration and Administration, troubleshooting of various Oracle Products/versions on different platforms including Redhat Linux/Unix, Sun-Solaris

•Extensive DBA experience in maintenance, development, Export/Import and Backup/Recovery.

•Experienced in designing and configuring high-availability systems using DATAGUARD with physical standby

•Experienced in supporting Oracle 12c/11g/10g Data Guard and Physical standby databases, Snapshot maintenance and creation

•Experienced in DB upgrades, patches and data migration.

•Data guard rebuild.

•Check and resolved the archive gap issue.

•Apex Installation

•Decommissioning and troubleshoot of databases.

•Experienced in performance tuning.

•Experienced in RMAN Backup and Recovery, planning strategy & implementation, cloning database, standby database.

•Experienced in replication with Golden Gate.

•Performed key role in preparing external database Audits and fulfilling the gaps for POSITIVE Audit result in making databases ready, guiding both offshore and onsite teams.

•Regular interaction with customer/Vender managers, development teams and system administrators in coordinating projects.

•Provide 24 * 7 Production Database Support and maintenance.

•Guided a jonier DBAs on projects and gained rich leadership and motivational skills.

•Handled planned/ Un-planned outages of production servers.

•Documenting all the issues and resolutions in a Fail N Fix document for the future reference of the same issue.

•Support OS Patching in RAC/Data guard and GG environment.

•Check Vulnerability and Fixed the issues.

•Manage all aspects of the OGG design, implement and support in development, UAT and production environments. Identify and resolve OGG problems occurring in all database environments including performance related issues (i.e. database & SQL tuning).

•Setting up High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2 RAC environments (Troubleshooting typical OGG technical problems such as unique key violation / long transaction abend by using GGSCI / Log dump / discard file analysis etc.

•Performance Tuning OGG in extremely high data volume environments. Installing and configuring OGG heterogeneous environments (from MySQL/MariaDB).

TECHINICAL PROFICIENCY:

Database Administration

Oracle 10g, 11gR2 and 12c with RAC, Golden Gate, Dataguard

Operating Systems

Unix, Linux and Windows

Tools / Utilities

OEM, RMAN, Data Pump, Export/Import

Other technologies

RAC, Dataguard,ASM, Golden Gate

PROFESSIONAL EXPERIENCE:

1)Current Experience

HCL Technologies

Client

Novartis Global Services

Environment

Unix, Linux, AIX

Databases

Oracle 11gR2 and 12c with RAC, Golden Gate and DataGuard

Duration

From 23rd Aug 2019– Present

Role

Technical Specialist

Total No of databases 1600

Total No of databases developement: 500

Total No of databases in production: 900

Total No of databases UAT: 200

Team size : 40 members(DBA)

JOB & ROLE RESPONSIBILITIES:

Ensuring Database backup & recovery process.

Supporting OS Patching.

Database Decommission phase wise.

Node Add and Delete task.

Applying PSU on Dataguard, Grid and Standalone database.

Add the services in RAC Database.

Implementation of Data Guards on 10g/11g and create standby database, upgrades, data migration.

Rebuild Standby database.

Supporting 24*7 producation database.

RAC configuration and install on producation database.

Managing users,maintaining systems security, controlling and monitoring database access and managing audit logs.

Managing session load, disk space, archive location, monitoring object creation, extent monitoring.

User & privilege management and managing audit logs

Taking and deciding the suitable kind of backup (RMAN, Export, Cold & Hot Backup).

Query tuning, system performance analysis and tuning

RMAN Backup and recovery.

Install Apex 18.2 version

Previous Experience

1)ANR Software Pvt Ltd

CLIENT & SYSTEMS:

Client

McDonald’s,Taco Bell, Pizza Hut,(USA)

Environment

Sun-Solaris, Linux, AIX

Databases

Oracle 11gR2 RAC and Golden Gate

Duration

From 26th Dec 2011 – 30th Mar 2017

Role

Oracle DBA

Total No of databases 350

Total No of databases developement: 150

Total No of databases in production: 100

Total No of databases UAT: 50

Team size : 10 members(DBA)

JOB & ROLE RESPONSIBILITIES:

Ensuring Database backup & recovery process.

Implementation of Data Guards on 10g/11g and create standby database, upgrades, data migration.

Supporting 24*7 producation database.

RAC configuration and install on producation database.

Managing users,maintaining systems security, controlling and monitoring database access and managing audit logs.

Managing session load, disk space, archive location, monitoring object creation, extent monitoring.

User & privilege management and managing audit logs

Taking and deciding the suitable kind of backup (RMAN, Export, Cold & Hot Backup).

Query tuning, system performance analysis and tuning

RMAN Backup and recovery

2)Giplanner Technologies Pvt Ltd

CLIENT & SYSTEMS:

Client

Sabre travel technology Pvt Ltd

Environment

Unix, Linux, AIX

Databases

Oracle 11gR2 and 12c with RAC, Golden Gate and Dataguard

Duration

From 06th Apr 2017 – 23th Mar 2018 date

Role

Sr. DBA

Total No of databases 500

Total No of databases developement: 250

Total No of databases in production: 150

Total No of databases UAT: 100

Team size : 35 members(DBA)

JOB & ROLE RESPONSIBILITIES:

Ensuring Database backup & recovery process.

Supporting OS Patching.

Database Decommission phase wise.

Node Add and Delete task.

Applying PSU on Grid and Standalone database.

Add the services in RAC Database.

Implementation of Data Guards on 10g/11g and create standby database, upgrades, data migration.

Supporting 24*7 producation database.

RAC configuration and install on producation database.

Managing users,maintaining systems security, controlling and monitoring database access and managing audit logs.

Managing session load, disk space, archive location, monitoring object creation, extent monitoring.

User & privilege management and managing audit logs

Taking and deciding the suitable kind of backup (RMAN, Export, Cold & Hot Backup).

Query tuning, system performance analysis and tuning

RMAN Backup and recovery

Manage all aspects of the OGG design, implement and support in development, UAT and production environments. Identify and resolve OGG problems occurring in all database environments including performance related issues (i.e. database & SQL tuning).

Setting up High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2 RAC environments (Front-end: Linux and AIX, Back-end: Oracle).

Troubleshooting typical OGG technical problems such as unique key violation / long transaction abend by using GGSCI / Log dump / discard file analysis etc.

Performance Tuning OGG in extremely high data volume environments. Installing and configuring OGG heterogeneous environments (from MySQL).

CERTIFICATION:

OCP (Oracle certificated Professional) in oracle 10g.

RHCT 5.1

EDUCATIONAL QUALIFICATIONS:

MCA(Master Of Computer Application) from IGNOU (Delhi)

BCA from IGNOU (Delhi)

10th from Sarvodaya Vidhayalay Saran (BR)

12th from SDS College Chapra (BR)

PERSONAL DETAILS:

NAME : Prem kumar Singh

F’ NAME : Sri Sureshwar Singh

D.O.B : 05-Feb-1988

Sex : Male

Nationality : Indian

Status : Married

Permanent address : H. No.-15, Gali No-4, New T Block, Uttam Nagar, New Delhi-59

Declaration:

I consider myself familiar with people . I am also confident of my ability to work in a team.

I hereby declare that the information furnished above is true to the best of my knowledge.

Date (Prem kumar Singh)

Contact this candidate