Prashant Singh

Summary

Objective

Apply Database Administration/ Maintenance skills to contribute for the success of a leading edge Organization and to obtain DBA position in a progressive company.

Summary

Oracle professional with around 3 and half years of IT industry experience having sound Oracle database administration (Oracle DBA) experience and managing, developing, and implementing software solutions in Materials Management, Production planning, Manufacturing, Human Resources, Sales, Payroll, and Finance module with strong technical skills in Oracle tools having sound functional knowledge and good understanding of business processes and logic .

3 And Halfyears of Oracle Data Base Administration with Bachelors Degree in Computer technology.

A total experience of more than 3 years on different Oracle tools & technologies and out of which having more than 3 years of experience as Oracle DBA in High Availability architecture to support Production databases for Database administration, installation, maintenance, performance tuning, backup and recovery.

Worked on various Projects and played DBA role on production environment.

Worked with team of developers from different companies to resolve/support ongoing issues.

Achieved Oracle Certification Professional 8i and 9i DBA (OCP 9I) and having significant knowledge in Oracle Technologies.

Experience in manage high availability of Production Database servers .

Work History

Work History
Sep 2008 - Present

Oracle DBA

Business Oriented Systems And Solutions

Oracle DBA

Therole evolved into database backup and recovery Both cold backup and hot backup, Performance tuning and monitoring the database. Decommissioning process for oracle databases. Database Monthly recovery testing process. Doing import and export using datapump.Also doing archive space monitering.Doing logical backup and restoration. Recovering database from cold backup. Refreshing the database. Refreshing the production schema with other production schema. Checking CPU intensive sql.Handling day to day problems arise in database. Handling KINTANA,ITSM RFA's.

Apr 2008 - Aug 2008

Software Engg

Birlasoft India Limited, Noida

Worked on the IT Operations of Birlasoft as a full time (24*7) Oracle DBA .

As an Oracle Database Administrator I was Managing and Maintaining multiple large databases of Production,Test and Development Databases in High Availabilityarchitecture and on different operating system flavor (Linux, Unix).

Responsibilities

1.Creating and maintaining Database objects (Tables, Indexes, Views, DB Link)

2.Creating and maintaining Database storage structure including Tablespace, Datafile and ASM instance.

3.Performing User administration and database security such as Creating and dropping User (schema), Granting and revoking privileges and roles.

4.Daily Database Health check

5.Performing online and offline backup (RMAN, Export/Import, Cold or Hot Backup)

6.Performing Quarterly CPU patchingon production and test Databases

7.Database cloning (cold or logical-Export/Import) from production or test databases.

8.New Database Installation.

9.Space management on servers and Database for the availability of free space.

10.Using Diagnostic tool Explanation Plan and Tkprof

11.HP OPEN VIEW Monitering

12. Handling billing and pointing activity.

Sep 2005 - Mar 2008

Oracle DBA

V.S. Computers , Nagpur , India

As a Oracle DBA I was Managing & Maintaining Database servers for Nagpur location.

Responsibilities

  1. Logical Backup of Production and Restoration on Oracle Database.
  2. Copy Archived Logs to standby Database and Roll Forward.
  3. Check & Verify Logs for the Success of Backup & Restoration and for alerts & errors.
  4. Copy and Maintain Dump files and Archived Logs .
  5. Check Space utilization & free space on all the Database servers & Tablespaces.
  6. Cold backup of Production Database and Deletion of last 15 days Archive Files.
  7. Add Datafiles to the Tablespaces.
  8. Coordination with application vendors and business to implement new functionality & resolve application bugs.
  9. Recovering Data Base .
  10. Statistics Gathering.
  11. Snapshot Refresh.

Education

Education
May 1999 - Present

B.E

P.C.E.A