Chetan Yadav
K-** ,Diamond District ,
Kodihalli, old airport road,
Bangalore. Mobile#: 080********
**************@*****.***
http://chetanyadavds.blogspot.com/
Career Summary
Highly skilled Oracle Database Administrator in Oracle with 2.9 years of experience within Healthcare sector and finance and HRMS. Proficient in DB administration, relational database management system, SQL and PL/SQL. Backed up with strong knowledge database creation and database maintenance activities of Oracle Database on different Operating System platforms such as Unix/Windows. Ingenious problem finder and troubleshooter, lucratively point out the errors in early stages to avoid time/cost expenditures. Excellent leader with success in coordinating efforts within the internal external terms to reach and surpass expectations.
Motivating and enthusiastic Oracle 9i Database Administrator Certified Associate through an excellent approach to achieve triumph in all projects. Capable of delivering success in a complex projects with scope for learning and challenge.
Career Objective Core Competencies
Talented and dedicated individual seeking productive role as a Database Administrator in Banking Industry, effective in attaining high technology solutions with quality and implement the expertise and experience gained in this field to develop complex project with efficiency and excellence. DB Administration
Client relationship management
SQL & PL/SQL
MS ACCESS
PS tools and application
High-quality methodical skills.
Team Management
Result-oriented
Communication Skills
Analytical skills
Key Highlights
Demonstrated exceptional working skills and independently handled the work for 4 months.
Configured the Oracle installation on Unix platform independently.
Successfully topped the Oracle Certification Exam.
Professional Experience
Quality Control
Oracle On Demand
(SOAIS client ) November- 2010-December 2010
Client Name Oracle On demand
Project Title / Name Various
Project Duration 1 months
Project Location Bangalore
Team Size 12
Role QA
Software / Tools / Technology Used Ebiz and peoplesoft and oracle
Project Description
Quality Control team checks for errors committed by human or machines. There are always chances of errors in human work. This team will check each and every steps completed by an analyst and also the performance of the machine. After thorough analysis if any error found then team needs to take appropriate action to correct it. This team works with Oracle dba, Ebiz and Peopelsoft activity.
Change Management
Oracle On Demand
(SOAIS client )
jan 2010– till Date
Client Name Oracle On demand
Project Title / Name Various
Project Location Bangalore
Team Size 14
Key Responsibilities
Creating new user’s and changing passwords.
Taking Backup of database by using RMAN for database.
Export and import with help of Data pump
Generating AWR report.
Professional Experience
Oracle DBA/Peoplesoft DBA
SOAIT Solutions May 2010- Till Date
Key Responsibilities
Generate leads by analyzing the project code and ensuring set targets are achieved.
Installation people, configuration and administration of oracle database on UNIX/Windows environment.
Analyzing and identifying the performance issue by generating AWR report and examining the report to find the key bottleneck issue.
Coordinating with the team and resolve key bottleneck issues.
Daily Monitoring application server and web server.
Resolving issue of application server and web server.
Projects Completed
Client Name ShoppersStop
Project Title / Name ShopperApp
Project Duration 5 months+
Project Location Bangalore
Team Size 5
Role Peoplesoft DBA
Software / Tools / Technology Used Unix and windowsNT , Oracle10g.,people soft tools and people soft application
Project Description
This is ERP solutions for maintenance of finance and Human resource management system .It provide all kind data which is related to Finance and HRMS .And give monitoring of application server and web server.
Responsibilities
• Daily Monitoring application server and web server Installed and configured database
• Resolving issue of application server and web server.
• Generating AWR report.
Professional Experience
Oracle DBA
MIIT Software Solution Feb 2008 – may2010
Key Responsibilities
Generate leads by analyzing the project code and ensuring set targets are achieved.
Maintaining database management and taking back-up by using RMAN for large database and import & export for schema back-up.
Involved in DBA activities allied with creating schemas, managing users, assigning roles & privileges, and space management.
Creating new scripts to automate the procedures for generate statistics on database management.
Installation, configuration and administration of oracle database on UNIX/Windows environment.
Analyzing and identifying the performance issue by generating TKPROF & AWR report and examining the report to find the key bottleneck issue.
Responsible for finding the estimate storage requirement, creation of tablespaces and other database primary objects.
Involved in development of standby database.
Analyzing, understand and resolving various oracle errors.
Coordinating with the team and resolve key bottleneck issues.
Cloning of data base
Export and import with help of Data pump
Renaming of database and instance name
Projects Completed
Client Name Confidential
Project Title / Name Hospacksaver
Project Duration 2 years
Project Location Bangalore
Team Size 4
Role JR. ORACLE DBA
Software / Tools / Technology Used Unix and windows, VB .NET , Oracle9i, Unix
Project Description
This is a package which is basically developed for patient management, pathology reporting, attendance/payroll and accounting. It consists of 5 modules that are General, diagnosis, employee, inventory, patient management.
HMS product includes built in tools like Information Export Panel that allows exporting all reports from program to printer with print preview, MS Excel, MS Word. All reports can be displayed in grid as well as in list view (sort-able) format. The program makes use of crystal reports for efficient generation of reports.
Responsibilities
• Installed and managed various ORACLE 9i /10g
• Installed and configured database
• Taking Backup of database by using RMAN for database .and import/export for schema backup
• Creation of users and roles
Education
Bachelor of Engineering
Rajiv Gandhi Proudyogiki Vishwavidyalaya 2007
Technical Skills
Category Software / Tool / Technology Proficiency
Operating Systems Windows XP, 2000 & WIN NT, UNIX Proficient
Programming Languages C, C++, PL/ SQL Proficient
Database Concepts ORACLE 9i, 10g, MS ACCESS Proficient
ERP People Soft Proficient
Certifications / Courses
Oracle Certified Associate (OCA) in 9i Database Administrator
Bhopal (M.P.) 2010
NCC (Network Centered Computing )
NIIT Vidisha (M.P.) 2003
DOA (Diploma in Office Automation )
CDAC , Vidisha (M.P,) 1999
Extra Curricular Activities
Played Cricket Matches at Intra School Level, Intra College Level.
State level player of Taekwondo
Worked as Coordinator in organizing Two Literary Events at University Level
Participation in various Sports Competition in School and won many prizes.
Secured many prizes in Drama competition.
Personal Details
Date Of Birth 01st Sep1984
Marital Status Single
Languages Known English ,Hindi
Nationality Indian
Passport Details J1426139
Personal Interests Blogging , internet surfing ,skating , listening music