Oracle Project

Shankar P Email: **********@*****.***

Mobile: +91-897*******.

PERSONAL SUMMARY

An experienced IT professional with oracle database administrative skills. Having the ability to handle L2&L3 tasks as the senior analyst in projects and supporting technical implementation working on multiple products.

Currently working in a demanding production support environment managing large volumes of business critical data. A committed team player, self-motivate d with the ability to communicate at all levels.

Key Responsibilities handled:-

Having around 4+ years of IT experience which includes the Oracle Database Administrator,RAC and Application DBA.

Expertise in installing, maintaining and administering Oracle Applications 11i ( 11.5.10, R12) instances.

Having good knowledge on 12c.

Having experience on Oracle Golden Gate configuration and its solving the gap issues.

Support and maintenance of Oracle Applications 11i and R12.1.3 Prod instances on Oracle Linux platform.

Troubleshoot Applications and Database issues.

Support and maintenance of 11g databases on Oracle Linux platform.

Patch analysis and application of patches.

Installing of Oracle Software in UNIX and Linux environment and maintaining databases.

Having experience on performance monitoring and tuning.

Experience in RMAN (10g,11g) Configuration and managing backup for all Prod and Non-prod database's through RMAN utility.

Experience in cloning (Refreshing) the databases through RMAN utility and manually.

Performed backups and tested crash recoveries using conventional Hot & Cold backups and RMAN.

Upgraded Oracle DB version from 10g to 11g version in both Production and Non-Production Environment.

Having experience on Data guard configuration and solving the gap related issues.

Having experience on ASM configuration and creating ASM instances and administrating of ASM disk groups in core environment.

Migrating Databases from NON-ASM to ASM and ASM- NON ASM.

Planning and implementing the oracle quarterly patch set release for both Production and Non-Production databases.

Taking the Export and import of tables and schemas.

Having experience in creating database links creation and Materialized views.

Management of schemas, objects & Partitioning the tables & indexes.

Creating and monitoring of the tablespaces according to their growth, assigning tablespaces for users.

Creating users with restricted access with required privileges.

Assigning quotas, roles, privileges and profiles to users.

Regular monitoring of Alert log file on day-to-day basis and to find out the root cause of the issues.

Having experience on RAC (Real Application Clusters).

AREAS OF EXPERTISE

Operating System : RHEL, OEL, HP UNIX.

Databases : Oracle 10g & 11g.

Languages : SQL.

Tools & Utilities : EXPDP, IMPDP, RMAN, DBCA.

Academic:-

B.Sc from BMR degree College affricated to OSMANIA University, Hyderabad in 2010.

Employer:-

Have been working as L2 DBA for L&T,Chennai from Sep 2017 to till now.

Have worked for Trigent softwares Pvt Ltd Chennai from june 2016 to december.

worked as L2 Oracle DBA for ARTECH INFO SYSTEMS PVT LTD,Bangalore from Jun-2015 to jan 2016.

Worked as Oracle Database Administrator for Genpact,Bangalore from Aug-2012 to Mar-2015.

Worked as Oracle Database Administrator for Qualcomm India Pvt Ltd, Hyderabad from Aug-2011 to Jul-2012.

Project:- (CURRENT)

Client : IMS(Information management system)

Project : Finance Project.

Role : Oracle Database Administrator.

Environment : Oracle 10g, 11g,12c RedhatLinux, OEL,Solaris,Windows.

Duration : Sept-2017 to till now.

Contribution:-

Installation and Configuration of Oracle 10g & 11g databases on Linux, Unix Environment.

Support and maintenance of Oracle Applications 11i and R12.1.3 Prod instances on Oracle Linux platform.

Troubleshoot Applications and Database issues.

Support and maintenance of 11g databases on Oracle Linux platform.

Troubleshoot workflow notification mailer issues.

Maintenance of Oracle Applications using AD utilities.

Sys Admin activities like Creating Users, Assigning Responsibilities, Changing Profile Options, Request Groups, Registering Forms, reports etc

Patch analysis and application of patches.

Patched and upgraded databases from 10g to 11g.

Performance monitoring and tuning whenever required.

Experience on Application DBA.

Refresh the Application & databases depends on project requirement.

Oracle Golden Gate Configuration and resoves gap issues.

Create the Database links depence upon the requirements.

Create the Materialized views based on the users requirement.

Having experience in RMAN configuration for all Production databases.

Monitored the growth of Table spaces and pro-actively adding a data file to the tablespaces.

Created users, granted privileges and created user profiles.

Taking exports and imports of schemas/tables.

Project:-

Client : Transaction Network Services (TNS)

Project : Billing Project.

Role : Oracle Database Administrator.

Environment : Oracle 10g, 11g RedhatLinux, OEL.

Duration : june-2016 to till now.

Description:-

Project has been developed to deal with all Transaction network services operations and external customer's services. The integrated Customer system is designed to handle the TNS user's issues and other problems that are coming into the database. Supporting all TNS databases and troubleshooting all day-to-day issues.

Contribution:-

Installation and Configuration of Oracle 10g & 11g databases on Linux, Unix Environment.

Support and maintenance of Oracle Applications 11i and R12.1.3 Prod instances on Oracle Linux platform.

Troubleshoot Applications and Database issues.

Support and maintenance of 11g databases on Oracle Linux platform.

Troubleshoot workflow notification mailer issues.

Maintenance of Oracle Applications using AD utilities.

Sys Admin activities like Creating Users, Assigning Responsibilities, Changing Profile Options, Request Groups, Registering Forms, reports etc

Patch analysis and application of patches.

Patched and upgraded databases from 10g to 11g.

Performance monitoring and tuning whenever required.

Experience on Application DBA.

Refresh the Application & databases depends on project requirement.

Oracle Golden Gate Configuration and resoves gap issues.

Create the Database links depence upon the requirements.

Create the Materialized views based on the users requirement.

Having experience in RMAN configuration for all Production databases.

Monitored the growth of Table spaces and pro-actively adding a data file to the tablespaces.

Created users, granted privileges and created user profiles.

Taking exports and imports of schemas/tables.

Monitoring of alert log file for solving the day to day issues.

Solving the User connectivity issues.

Project:-

Client : Kaiser Permanente (KP)

Project : Health Project.

Role : Oracle Database Administrator.

Environment : Oracle 10g, 11g RedhatLinux, OEL.

Duration : june-2015 to jan-2016.

Description:-

Project has been developed to deal with all Kaiser Permanente operations and external customer's services. The integrated Customer system is designed to handle the KP user's issues and other problems that are coming into the database. Supporting all KP databases and troubleshooting all day-to-day issues.

Contribution:-

Installation and Configuration of Oracle 10g & 11g databases on Linux, Unix Environment.

Patched and upgraded databases from 10g to 11g.

Having experience in RMAN configuration for all Production databases.

Monitored the growth of Table spaces and pro-actively adding a data file to the tablespaces.

Created users, granted privileges and created user profiles.

Taking exports and imports of schemas/tables.

Monitoring of alert log file for solving the day to day issues.

Solving the User connectivity issues.

Project:-

Client : Cox Communications Inc.

Project : Cox Communications.

Role : Oracle Database Administrator.

Environment : Oracle 10g, 11g RedhatLinux, OEL.

Duration : Sep-2012 to Mar-2015.

Description:-

Project has been developed to deal with all Cox business operations and external customer's services. The integrated Customer system is designed to handle the Cox business user's issues and other problems that are coming into the database. Supporting all Cox customer databases and troubleshooting all day-to-day issues.

Contribution:-

Installation and Configuration of Oracle 10g & 11g databases on Linux, Unix Environment.

Patched and upgraded databases from 10g to 11g.

Having experience in RMAN configuration for all Production databases.

Worked on Data guard gap related issues.

Monitored the growth of Table spaces and pro-actively adding a data file to the tablespaces.

Created users, granted privileges and created user profiles.

Taking exports and imports of database/schemas/tables.

Monitoring of alert log file for solving the day to day issues.

Solving the User connectivity issues.

Project:-

Client : Bajaj Finance

Project : Bajaj Finance.

Role : Oracle Database Administrator.

Environment : Oracle 10g, 11g RedhatLinux, OEL.

Duration : Aug-2011 to Jul-2012.

Contribution:-

Installation and Configuration of Oracle 10g & 11g databases on Linux, Unix Environment.

Having basic knowledge of RMAN backup and recoveries.

Monitored the growth of Table spaces and pro-actively adding a data file to the tablespaces.

Created users, granted privileges and created user profiles.

Taking exports and imports of schemas/tables.

Monitoring of alert log file for solving the day to day issues.

Solving the User connectivity issues.

Contact this candidate