Manager Oracle

ANKUR TYAGI

Mobile: +91-995-***-****, +91-999-***-****

E-mail: abgngq@r.postjobfree.com

Objective

To seek a challenging and demanding position in an esteemed organization as Oracle

Applications Database Administrator

Soft Skills:

• Good written and verbal communication skills, can effectively communicate with both

technical and non-technical audiences

• Comprehensive problem solving abilities; thinks out of the box, always willing to explore

new ideas & approaches for issue resolution.

• Has a keen eye for details, always detailed oriented in work and problem solving.

• Always eager to learn new technologies, likes to explore in latest & emerging trend

• Team player, ability to work cohesively & respectfully with team mates

Certification & Trainings:

• Red Hat Linux official training in Red Hat Certified System Administrator (RHCSA) from SQL

Star International, Delhi

• Oracle University’s official training in Oracle Certified Professional - Database

Administrator from SQL Star International, Delhi

• Passed Oracle Database SQL Expert exam securing 90% marks

• Passed Oracle Database Administration l leading to Oracle Certified Associate securing

95% marks

• Passed Oracle Database Administration ll leading to OCP securing 93% marks

Technical Skills:

• Languages: SQL, PL/SQL, C, C++

• Database Technologies: Oracle 10g,11g Oracle database, 11i & R12 Applications

• Database Tools: Oracle Enterprise Manager, Server Manager, SQL* DBA Enterprise Manager

Applications, Instance Monitor, TOAD

• Software: SQL* PLUS, PL/SQL, SQL* LOADER, EXPORT/IMPORT, SQL*FORMS

• Operating Systems & Platforms: Microsoft Windows 2003, 2008 32bit, Red Hat Enterprise

Linux 5.x, 6.x, on 32 and 64 bit x86 architecture, AIX, HP-Unix

• Networking & Storage: TCP/IP, DHCP, DNS, FTP, Telnet, Logical Volume Manger (LVM),

RAID Configuration, NFS, NAS & SAN Concepts

• Virtualization: Linux Xen Hypervisor, VMware, Oracle Virtualbox 4.x

Page 1 of 3

Education Qualification:

• Passed B Tech – Electronics & Communication in year 2011 securing 58% marks from

Hindustan Institute of Technology, Greater Noida, affiliated to U.P. Technical University

• Passed XII in year 2006 securing 67% marks from Kulachi Hansraj Model School, Delhi

• Passed X in year 2004 securing 76% marks from Kulachi Hansraj Model School, Delhi

Work Experience :

Worked at Bodhtree Consulting Ltd, Hyderabad from Februray 2012 to till date.

Role: Associate Apps DBA

Project 1

Client Name:- Logitech

Environment 11.5.10.2,10.2/10,2 AIX/Linux/HP-Unix

Team Size 20

Ro l e Oracle Applications DBA

Duration November 2011 to till date

• Troubleshooting High CPU and memory utilization consumption issues.

• Rebuilding indexes and tables using shrink and move command.

• Archiving and purging unwanted out and log files by using find command.

• Monitoring standby database, checking archive transfer, recovery mode, switching archive logs manually

and performing manual recovery for standby databases.

• Maintaining passwords for Apllication users, and Apps user.

• Trouble shooting OraInventory issues. Creation of users and responsibilities.

• Work Flow Mailer configuration and troubleshooting.

• Miscellaneous tasks such as printer related issues, scheduler tasks, etc

• Monitoring Concurrent Managers, concurrent requests related and long running requests.

• Code Migration to PROD, DEV, QA through PPM.

• Troubleshooting on

- Apache Trouble shooting

- Concurrent managers

- Login issues

• For monitoring of critical errors in alert log on time base. Performed routine checks of space utilization.

• Extended Tablespces by resizing/adding data files when needed.

• Taking the backup of the database regularly through RMAN, Cold and Hot Backup procedures.

• Performing daily Application and database health checks.

• Interacting with Oracle Support for Service requests through Metalink.

Page 2 of 3

Project Undertaken During B. Tech:

MICROCONTROLLER BASED SPEEDOMETER & ODOMETER

Description: It describes how to build a digital speedometer-cum-odometer for your Motorbike. The

circuit uses a microcontroller, an LCD display and some other commonly available electronic

components. It is a better alternative to the mechanical speedometer and even a Beginner with

minimal skill level can assemble it.

Industrial Training During B. Tech:

G L O BA L SYSTEM FOR MOBILE COMMUNICATIONS (GSM) ARCHITECTURE at Reliance

Communication

Description: During the training period, I got to learn various things about the Mobile Station, the

Base station sub-system, Networking and Switching sub system. During that process, I also learn about

the structure, working & the various applications of ‘GSM Cellular Structure

Extra-Curricular Activities:

• Actively participated in Debate and Presentation.

• Volunteer in events organized in annual college festival.

• Avid follower of Cricket,

Tennis.

Personal Information:

Date of Birth : 24th August, 1988

Gender : Male

Address : C-11 Reids Line, Opp. Miranda House College, Delhi University, Delhi –110007

Father ’s Name : Late Sh. Om Dutt Tyagi

Father's Profession : Technical Office in Center for Professional Development in Higher

Education

(CPDHE), Delhi University

Declaration:

I, AnkurTyagi S/o Late Sh. Om Dutt Tyagi, hereby declare that all the above mentioned details are true

to the best of my knowledge and belief.

Ankur Tyagi

Dated: Tuesday, February 26, 2012

Page 3 of 3

Contact this candidate