[pic]
PANKAJ YADAV
E-Mail:
abi625@r.postjobfree.com, abi625@r.postjobfree.com
Mobile: +91-931*******
To pursue a challenging and rewarding career in IT industry, seeking an
excellent
Opportunity as Oracle DBA in an IT Organization where I could utilize my
skills and knowledge for the growth of company
3.6 years of total experience
Professional Certification: OCA (Oracle certified Associate) Oracle 10g
Key Skill: Oracle DBA (Database Administrator)
Current Organization:
Organization UTI Infrastructure Technology And Services Ltd.
Duration March 2012 to Till date
Designation Oracle DBA
Client:
Client name Employee's Provident Fund Organization Faridabad
( Ministry of labour & employment, Government
of India)
Responsibility Oracle database Management
Database Version Oracle 10g, & Linux (RHEL 5)
Activities Database management, Monitoring of Database,
Tablespace Management, Space management, User
Management, Backup & Recovery.
Roles and Responsibilities:
. Managing table space, data files, archive log files, control files
. Managing redo logs, checking alert log.
. Management of Database Creation and Maintenance
. Establish and Maintain Sound Backup Policies and procedures including
HOT and COLD backup.
. DB Backup using RMAN
. Planning and Performing Daily, Weekly and monthly Cold and Hot
Backups.
. Day to day administrator activities (user creation, granting quotas on
appropriate table space, assigning proper roles and privileges).
Previous Organization:
Organization Broadline Computer Systems.
Duration Feb 2010 to Feb 2012
Designation Junior Oracle DBA
Client:
Client name Department of Public Health and Family Welfare,
Government of Madhya Pradesh
Responsibility Oracle database Management
Database Version Oracle 10g, Windows Server 2003 & Linux (RHEL 4)
Activities Database management, Monitoring of Database,
Tablespace Management, Space management, User
Management, Backup & Recovery, Client
interaction.
Organization Crazy Cyber tech Pvt. Ltd.
Duration May 2009 to Jan 2010
Designation SEO Engineer
TECHINAL SKILLS:-
RDBMS Oracle 9i, 10g
TOOLS & TILITIES Export/Import, RMAN, TKPROF, SQL*Plus, Statspack,
( FOR ORACLE ) AWR,DBCA, Putty,scp,winscp etc.
OPERATING SYSTEM Linux (RHEL.4v2),Unix (5.9), Windows server 20003
Windows 2008
INERNET UTILITIES FTP, HTTP,WINSCP
ORACLE DBA SKILLSETS:-
. Knowledge of Oracle Architecture Components, Oracle Instance
Management, and Creation of Database and Management
. Knowledge of Parameter Files management, managing redo logs,
checking alert log.
. Knowledge of 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 datafile
autoextend on/off etc.
. Installation of Oracle10g on REDHAT LINUX (RHEL) platform, and
creation of database on same platform.
. Knowledge about the Logical & Physical Backup Strategy.
. Establish and Maintain Sound Backup Policies and procedures
including HOT and COLD backup
. DB Backup using RMAN
. Planning and Performing Daily, Weekly and monthly Cold and Hot
Backups.
. Tools and Technology like Import/Export, TKPROF.
. Security management and User Management, creation of profiles,
roles, assignment of privileges.
. DB Refresh using online backups.
. Perform Database Duplication and Refreshes using Hot backup, RMAN
and export/import utility.
. Knowledge about the catalog database.
. Knowledge about the generation & Analysis of AWR Report.
. Knowledge about the Automatic Database Diagnostic Monitor (ADDM) &
Report generation of ADDM.
. Knowledge about the Flashback technology, Recycle bin & space
utilization.
. Knowledge about the SQL to communicate with database server to
access manipulates and controls the data.
. Knowledge, installation, and management of Linux operating system.
. Good exposure on Oracle Data guard, standby database.
SOFTWARE SKILL:-
Operating System : Windows Serve 2003/ XP, Linux AS 4.0 (Red
Hat)
Languages : SQL, Oracle
Database : Oracle9i, Oracle10g
Web Technologies : HTML/DHTML
GUI : Dreamweaver
Tools : PL/SQL Developer, SQL Developer, Putty
ACADEMIC CREDENTIALS:-
. Professional Certification: OCA (Oracle certified Associate) Oracle
10g
. Master of Computer Application (MCA) from UNSIET V.B.S. Purvanchal
University, Jaunpur in 2009.
. Bachelor of Computer Application (B.C.A) from School of Management
Sciences (SMS) Varanasi (V.B.S. Purvanchal University, Jaunpur) in
2006.
. Higher Secondary Exam from U.P. Board, Allahabad in 2003.
. Senior Secondary Exam from U.P. Board, Allahabad in 2001.
PERSONAL DOSSIER:-
Personal Identification
Pankaj Yadav
Date of Birth
2nd Aug 1987
abi625@r.postjobfree.com
Contact No.
Permanent Address:
Vill-Chandpur Post-
Muradganj, Jaunpur,
(U.P.) 222002.
Passport No.
K0561826
Pankaj Yadav