PANKAJ YADAV

678-***-****

acp89d@r.postjobfree.com

SYNOPSIS

6+years of professional experience in the Oracle Database Administrator (Oracle 9i,10g,11g), RAC DBA, Database Installation, Upgrading, Migration, Patching, Performance Tuning, RAC Installation, all kind of Backups and Recoveries, Cloning, systems Analysis, design and development of complex OLTP, Data Warehouse, RDBMS for different domains like Retail, Finance, Healthcare and Telecom Domains.

About Expertise

Planned and implemented high availability solutions using Oracle 11g/10g RAC, Standby Database management.

Perform database software installation, configurations, patches, and upgrades Oracle 9i, 10g and 11g in various environments.

Implement Oracle Enterprise Manager Grid Control (OEM 10g/12c) for centralized monitoring and administration.

Experience in applying Opatch and Patchset to the databases.

Experience in database performance monitoring, analysis and tuning.

Provided 24x7 production support for Oracle 11g/10g/9i databases on various platforms

Proficient in all DBA responsibilities such as Installation, Configuration, Upgrades, Patches, Backup (Cold and Hot), Recovery, Cloning, Space management, Troubleshooting, Database Design, SR support, Unix Shell Scripting and Documentation

Experience in creating users, configuring grants, roles, privileges and managing tablespaces.

Expertise in Oracle Backup and Recovery for a VLDB.

Experience in Data Migration using RMAN and Oracle Data Pump, Export/Import

Design and Document backup and disaster recovery plans for critical databases using conventional HOT, COLD and RMAN backups

Managed very large size database of maximum size more than30TB

Implement, Maintaining and Troubleshooting High Availability Architecture(DR Planning and Solution)

Proficient on Physical Standby configuration and management 10g/11g.

Experience in RAC 10g/11gR2 configuration on Linux/Solaris/windows platform.

Manage Disaster recovery and full database RMAN recovery.

Proficient in physical standby database, Snapshot standby and active dataguard

Experience on conversion from Physical standby database to snapshot standby database.

Expertise in Replication and Extracting data and applying on production using GoldenGate.

Running backups HOT/COLD/full, Incremental backup from the GRID control

Knowledge on Oracle support process for technical requests using Metalink and other support features

Good experience of creating PL/SQL packages, Stored Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases

Experience in data integration and data movement and using oracle Sql*Loader, External table, Export Import utility.

Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.

Experience in database query tuning performance tuning using various techniques analytical functions, with clause, Indexes, Partitions, Clusters, explain plan, TKprof.

About Core Competence

Database Management - Implement/Configuration/Managing 9i/10G/11G Database (File System/OMF/RAW database) over Windows, Linux and Solaris, Provided 24x7 support of Production Databases, patches, Performance monitoring, index rebuilding, Strong ability to deal efficiently on disaster recovery and Incremental backing up of the systems, Manual database creation, Database Cloning - Production database for development and testing purpose.

Oracle 10gR2/11gR2 RAC – Implement and Managing Configuration 10gR2 RAC database on 4 nodes over Linux, Migrate/Move Non-RAC database to RAC, Addition and Removal Nodes from existing cluster.OCR and Voting disk management. 3 node RAC Implementation and configuration experience on 11gR2 with ASM.

Oracle 10gR2/11gR2 ASM – Implement and managing 10G/11g ASM Instance/Database over Linux and Solaris, Migration/Move 10G/11g Non-ASM database to ASM over Linux and Solaris, Experience on setting up ASM instance creation, ASM Disk group’s creation. Maintain ASM, ASM diskspace monitor, ASM disk header corruption check, ASM disk header backup and working with ASMCMD to maintain entire ASM disk group. Also entire database movement across the disk group

Oracle Database Up-gradation – Upgrade database From 10g release 2 (10.2.0.1.0), 9.2.0.1.0 and 9.2.0.8.0 to 10g release 2 (10.2.0.1.0)/11gR2 (11.2.0.1)

Oracle 10g/11g Standby (Dataguard)- Implement 10g/11g Standby Database, Implement Physical Standby on Normal File System for ASM Enable Primary Database, Implement physical Standby on ASM for ASM Enable Primary Database.

Oracle Database Backup/Recovery - Implementing Backup and recovery strategy (both method RMAN and User Managed), Designing and implementing the backup strategy (Hot/Cold), Restoring Database in case of crash/emergencies. Implementing RMAN full backup and incremental backup recovery.

Oracle 10g/11g Cloning - Cloning/Duplicate 10g Database on Same Host and Different Host, Clone/Duplicate a ASM Enable Database to ASM Enable target System, Clone/Duplicate Database from Non-ASM to ASM Enable Target System, Clone/Duplicate Database from ASM to Non-ASM Enable Target System

Employment

Paramount Construction Atlanta, GA (Feb 2015 - Till date)

Oracle Database Admin

Environments: Oracle 10g, 11g, RAC, Data Guard, ASM, RMAN, Linux 5,Windows Server 2008, Grid11g, SQL plus, Putty, Data migration, Oracle VM Server.

Responsibilities:

Support production, development, test databases at high availability.

Administration of Oracle Databases 11g/10g.

Administration of 2/3 Node RAC instances

Supported up to 20TB Databases, And we are supporting 300+ERP/Non-ERP Databases both Prod and Non-prod environments.

Applying patches related to performance and bugs on Test, Dev, Stage & Production instances

Experience in Installation, Configuration & re-configuration of Oracle for Large Database on Unix O.S, Solaris, Linux, HP, VMware and Windows etc.

Applications system administration tasks like creating, managing users and their responsibilities

Identifying and troubleshooting long running queries, locked sessions to improve overall performance

Configuration of Standby Databases for High Availability.

Database User Management, Privileges, Roles, Auditing, Profiling, Authentication Cloning Oracle Database and Applications using Rapidclone

Manage database on OEM 10g and OEM 12c and defined the monitoring customized templates.

Interaction with Oracle Support to raise Service Requests to resolve the issues Databases/Applications in stable condition.

Storage management, sizing the database objects, monitoring file systems, and tablespace growth Set up and maintain physical standby database for high availability.

Trouble shooting with RMAN backups (archive log and database).

Helping development team with writing Stored Procedures using PL/SQL

Wipro Technologies Pune.

Infocrossing (May 2014 – Feb 2015)

(Avaya, Motorola, CA-Shell, IRI)

Senior Database Administrator

Environments: Oracle 9i, 10g, 11g, RAC, Data Guard, ASM, RMAN, Linux 5,Solaris, Windows Server 2008,GRID, SQL plus, Mysql, PL/SQL,TOAD, Putty, Winscp, Data migration, Oracle VM Server.

I am responsible for Managing and Monitoring of Oracle Database 9i,10g,11g with design development, test and implement oracle Database and sql/plsql programs . I am primarily involved in following activities:

Support production, development, test databases at high availability.

Worked in 24x7 production environment and provided on-call and day-to-day support.

Install 10g/11g RAC and migrate 40+ database from Non RAC to RAC.

Planning and creating new databases under various environments.

Monitoring more than 300 Database using OEM Grid control.

Migrating databases across different operating system platforms using export import utility.

Applying oracle database patches using Opatch utility.

Performing restoration and recovery using RMAN (block level recoveries, Datafile recovery, Controlfile recovery, logfile recovery).

Monitor database performance, diagnose performance problems, and tune the database as necessary. Investigate, gather diagnostic data for, and report to Oracle Support Services any critical database errors

Cloning database using RMAN backup, to create auxiliary database.

Performing database level refresh and Schema level refresh.

Creating and scheduling of jobs, export/import script execution.

Recovering table data from previous cold backup and intermediate export/import.

Monitoring space allocation and utilization in database objects.

Rebuilding the indexes and gather statistics of tables to improve the performance.

Analyzing and identifying the reusable components to performance tune the application.

Perform rolling upgrade of Oracle and Grid Infrastructure on multi node RAC cluster with 11gR2 – Precisely from 11.2.0.3 to 11.2.0.4.

Install configure and troubleshoot Oracle and Grid Infrastructure on multi node RAC cluster with 11GR2 (11.2.0.4)

Configured 2 node RAC on oracle 10g and 3 node RAC on Oracle 11g R2.

Upgraded 11gr1 to 11gr2 and 11.2.0.2 to 11.2.0.3 on many Oracle Databases.

Applied 11.2.0.3.5-11.2.0.3.13 Patches on RAC & NON-RAC DBs.

Worked on grid configuration and ASM management for RAC physical file and backup.

Managing OCR and Voting disk backup and recovery

Configure and maintained data guard (physical standby database) for production databases.

Identifying and resolving archive log gap in data guard physical standby database.

Testing data guard switch over and fail over by simulating disaster recovery on test database.

Actively involved in DR activities quarterly like switch over from Primary to Standby and vice versa.

Migrated from Single Instance Database to 2 nodes on Real Application Cluster Database.

Database Manual Upgrade from 10g to 11g on Windows and UNIX environment.

Experience with IBM AIX, Linux, SUN Solaris UNIX operating systems

Support DBA utilities, reorgs, index builds and DBA tools Oracle Enterprise Manager

Database Tuning - Tuning Applications, Tuning Memory, and Tuning Disk Usage.

Strictly following ITIL process in incident management and change management.

Experienced in GoldenGate Install, Configuration, Maintenance, Trouble Shooting and Upgrade. Responsibilities handled include supporting Production System with focus on tuning performance parameters of GoldenGate software to enhance replication speed and eliminate downtime.

Replication and Extracting data and applying on production using GoldenGate.

Experience configure, create and maintain SQL Server database.

AWC Software Pvt. Ltd. Noida(April 2013 – April 2014)

Oracle DBA

Environments: Oracle 10g, 11g,R12, Data Guard, ASM, RMAN, Linux 4/5,OEM

I am whole sole responsible for Managing and Monitoring of Oracle Database 10g,11g with Oracle R12 Application. I am primarily involved in following activities:

Monitoring Database and Application Instances

Creating jobs and scheduling activities

Regular maintenance activities like index rebuilding, updating stats, index tuning, clearing transaction log, tape backup etc

Proactive monitoring Database performance, space and capacity

Production Support environment 24*7 support

Maintaining & managing, monitoring database

Managing privileges & rolls to ensure the application/database security

Implemented backup and recovery strategies

Oracle Database 11g and Application R12 Cloning

Patch Analysis and Patching Application and Database

Performance Monitoring. Collection and Analysis of Staspack, AWR reports, Performance Tuning of Database.

Planning for backup and recovery of database information

Cloning database using RMAN backup, to create auxiliary database.

Performing database level refresh and Schema level refresh.

Creating and scheduling of jobs, export/import script execution.

Ability in UNIX shell scripting, PL/SQL coding and Perl.

Administer and supervise database security, manage database user.

Experience supporting Oracle R12 E-Business Suite application

Cloning Oracle Database & Application oracle 11i / R12 through rapid cloning.

Manage Application R12 Cloning activity through rapid clone.

Experience in ORACLE 11g with RAC and MSSQL 2008 & 2012.

Proficient in physical standby database, Snapshot standby and active dataguard (ADG).

Expertise in Disaster Recovery activities with full database recovery.

NH Infomedia Ltd Delhi(March 2012 - April 2013)

UTI-ITSLEPFO DBA Support ( Govt. of India)

Oracle DBA

Environments: Oracle 10g, ASM, RMAN, Datapump, Linux 5, windows server 2008.

I was whole sole responsible for Managing and Monitoring of Oracle Database. I am primarily involved in following activities:

Administration of 8 PRO/STAGING/UAT/DEV Databases.

Extensive knowledge in claim management of employee provided & fund.

Extensive knowledge in data uploading and downloading of pf and claim management.

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

Creation & administration of all database objects, including tables, indexes, views, sequences, packages and procedures, Assigning table spaces.

Monitoring Alert’s for load on Production Database, RMAN Backup and database alertlog

Performing to Cloning of the Live Databases to Stag/QA using RMAN.

Schemas refresh using expdp / impdp and Traditional exp / imp.

Up-gradation of database from Oracle 10.2.0.4.0 to 11.2.0.3.0.

Oracle database upgraded from 10.2.0.3.0 to 10.2.0.4.0.

Cross platform Migration of database using RMAN.

Database Tuning, analyzing wait events, monitoring databases using OEM Grid.

Experience with Real Application Clusters (RAC) and Automatic Storage Management (ASM)

Experience in Real Application Clusters (RAC) Configuration in 3 node with ASM amd grid.

Broadline Computer Systems Chennai(May 2009 – Feb 2012)

SDMIS (State drug management information system) Govt. of MP

Electric Board DBA Support

Oracle DBA

I was whole sole responsible for Managing and Monitoring of Oracle Database and healthcare application SDMIS for Govt of MP. I am primarily involved in following activities:

Support production, development, test databases at high availability.

Worked for State drug management system for Govt. of MP with good experience of working in Medicare and Medicaid projects.

Extensive experience in gathering Business and Functional Requirements, developing Use Cases, conducting Gap Analysis and preparing Training manuals.

Extensive experience in admin level management of healthcare administration and application management.

Experience of full Software Development Life Cycle (SDLC) and Methodologies & Validations to ensure the Quality Assurance Control

Experience in business analysis, cross system integration analysis, data analysis, use case analysis, configuration and change management, process re-engineering, design, testing, problem-solving and project management.

Planning and creating new databases under various environments.

Migrating databases across different operating system platforms using export import utility.

Applying oracle database patches using Opatch utility.

Configuring the backup recommended by oracle using RMAN.

Performing restoration and recovery using RMAN (block level recoveries, datafile recovery, controlfile recovery, logfile recovery).

Cloning database using RMAN backup, to create auxiliary database.

Performing database level refresh and Schema level refresh.

Recovering table data from previous cold backup and intermediate export/import.

Rebuilding the indexes and gather statistics of tables to improve the performance.

Education& Certification

Graduate in Computer Application from VBS PURVANCHAL University Jaunpur.

Master in Computer Application from VBS PURVANCHAL University Jaunpur.

Certification

Oracle 10g DBA Certified

Technical skills:

Operating Systems: HP-UX 11.0, Solaris, AIX, RedHat Linux 4.2, 5.3, Oracle Enterprise Linux, Windows Server 2005/2008,Wndows 7, XP.

Oracle Databases: Oracle 9i / 10g / 11g /12c Oracle Database

Tools: Oracle Enterprise Manager OEM, SQL*Loader, Export/ Import, Expdp / Impdp, RMAN.

Languages: SQL, PL/SQL, Shell Scripting (KSH, Perl).

Other Tools: RDA, OEM, Oracle Export/Import, Toad, Sql*plus, Oracle Grid Control, Performance Reports AWR, ASH, ADDM, OS Tools (Top, SAR, VMSTAT, IOSTAT)

Contact this candidate