Ph: +1-408-***-****

E-mail: ac3pez@r.postjobfree.com

PRADEEP HASSAN SURYA

WORK PROFILE

13+ years of experience as Oracle database/Apps Administrator.

Working in a Complex and Critical Environment with over 700 ERP/Non ERP instances in Cisco Systems Inc Project. Part of DBA operations team handling production life-cycle instances.

Involved in complete lifecycle of planning, design and development, Implementation and Support of different Oracle Applications and products.

Area of Expertise:

Oracle EBS 11.x/12.x

Oracle Database Administration 8.x/9.x/10.x/11.x/12.x

Oracle GoldenGate 11g/12c with Unidirectional replication setup.

Oracle Weblogic 10.x/11.x/12.x

Oracle Fusion Middleware 11.x/12.x

Oracle Application Server 11g (SSO, OID, LDAP, OAM)

Oracle Data guard 10g, 11g, 12c

Technical Knowledge

Applications/RDBMS : Oracle Applications 11i/R12 & Oracle RAC DB 9i, 10g, 11g,12c with Knowledge of Oracle Golden Gate.

Application Technology : Oracle iAS, Weblogic Server. Languages/OS : Shell Scripting, SQL, Linux, Solaris, Windows, VMs Tools : Remedy, Service Now,Oracle Enterprise Manager NoSQL : Good knowledge on MongoDB and Cassandra

EDUCATION PROFILE

B.E in Automobile Engineering

Malnad College of Engineering, Visveswaraiah Technological University, Hassan, Karnataka, India. 1) Oracle Apps DBA at Wipro

Client: Cisco Systems

Period: April-2010 till date

Description: Production and implementation support of Oracle R12, Apps 11i, Non ERP instances in Cisco Systems.

Roles & Responsibilities:

Primary DBA for Supply Chain and Order Management IT databases in Cisco Systems. (Over 30 prod instances)

Worked on R12.2.5 Oracle Applications upgrade from R12.1.3 .

Installed patches using ADOP utility,adpatch utility.

Troubleshooting concurrent manager issues, Long running Concurrent programs, Workflow mailer issues on various occasions.

Experienced in the use of RapidClone, Autoconfig and AD utilities and high availability techniques in Oracle EBS environments.

Deploying Application EAR on Weblogic environments.

Handling connection issues with Oracle Connection Manager(OCM servers) and LDAP servers for external and internal applications.

Integration of weblogic and IDM servers with Oracle applications R12.

Sound knowledge on webgate and access gate w.r.t Oracle applications R12.

Worked on multiple Oracle 12c RAC Database upgrades with latest PSU patches applied(In-place upgrades)

Providing Oncall/Production support for high priority databases. Provide technical assistance and guidance to team members.

Responsible for fixing all monitoring Oracle database alerts configured via Oracle Enterprise Manager

(OEM).

Responsible and currently working on Upgrading all Cisco 11G databases to Oracle 12.1.0.2 alongwith DR .

Applying of one-off patches,bug-fixes,PSU patches according to Cisco standards and also involves working with Oracle metalink SR’s for any ora- errors reported as part of Daily Monitoring.

Migrated few of the critical schemas from 11G database onto newly configured Oracle 12c Database using RMAN Partial backup and restoration technique.

Doing POC for Oracle 12c In-Memory feature.

Handling Physical DR Resiliency testing with Application team as part of Quarterly Testing.

Debug/fix production issues related to Concurrent requests/programs.

Monitoring and Housekeeping of Production, test and development Instances.

Troubleshooting problems with web server, web listener, forms server, and concurrent managers, and database.

Configure, maintain and perform Oracle database Backup activities (RMAN and traditional methods)

Maintain Oracle Data Guard and disaster recovery instances, Switchover/Failover Administration.

Performing on multiple occasions of Physical Standby lag or missing archives using RMAN incremental backup and restore from source to target.

Perform database recovery (table, schema, database recovery) in Production instances.

Reviewing of change requests (including configuration changes, patch management, proactive and preventive maintenance).

Automation of routine tasks with Unix shell scripts (recently working on developing Hadoop mapr patching automation) with few scenarios on the spot automation based on Client request specific to envs.

Involved in scaling up ERP R12 to 16 web servers and 4 CMs.

Apply Oracle DB and application patches.

Database and application cloning from Production Instances.

Oracle database In-place upgrade for 24Tb of database to Oracle 12c.

Fixing Block Corruption, Reorganizing Tables or Indexes.

Database schema creation, user profile setup.

Performance/SQL Tuning in Oracle Environment.

Handling Cassandra and Mongo databases(NoSql databases). 2) Oracle Global Services Delivery(GSD)

Company: Oracle India Pvt. Ltd.

Period: February 2008 to April 2010

Description: As part of GSD team worked on major Clients Canon USA, Canon Australia, Stryker Corporation as Production support dba.

Roles & Responsibilities:

Installation and configuration of Oracle Databases,Oracle Applications.

Patching and upgrade of Oracle databases,Oracle Applications.

Clone of Oracle applications including DMZ setup from Production to Non-prod envs.

Cloning of Oracle databases from Production to Non Production servers.

Database Upgradations from 9i to 10g.

Exposure of RAC Environment.

Develop Scripts to Automate Functions and Processes.

Checking connectivity issues.

Monitoring all services of the Oracle Databases and ensuring its proper functioning.

Basic Unix Shell scripting for daily monitoring checks.

Taking and Restoring Database backups.

Applying Bug fixes as per Oracle recommendations for the ora- errors as part of SR.

Applying CPU’s,PSU patches to Oracle databases.

3) Oracle Apps DBA at Wipro

Client: CardinalHealth

Period: November 2006 to February 2008

Description: Production Support of Pyxis servers with Oracle Application 11i databases. Roles & Responsibilities:

Providing 24X7 Support to Cardinal Databases (Pyxis servers mainly Oracle Application Database).

Configured Alerts on day to day tasks which will alert in case of any issues on email.

Cloning and Patching of Oracle database.

Daily Validation of Hot Backups as part of Daily Tasks.

Creation of Objects,Schemas on Production and Non Production databases.

Handling of ora- errors by raising an SR with oracle and applying Bug fixes as per Oracle udpates.

Applying of CPU patches to Oracle databases.

4) Oracle Apps DBA at Q-soft Systems and Solutions Client: Cummins India ltd,Pune

Period: May 2005 to November 2006

Description: Production Support of Oracle Application 11.0.3 databases. Roles & Responsibilities:

Providing Datacenter Support 24X7 by Monitoring Production Databases of sizes 25Gb, 50Gb, 30Gb and 250Gb.

Major role was to SQL Tune the custom SQL/PLSQL code by identifying the time consuming queries from the Production Database.

Upgraded Database from Oracle 9.2.0.6 to 9.2.0.7.

User management like Creation of Users,granting of Privileges,creation and assigning of Roles,Creation of Profiles.

Tablespace creation, addition of Datafiles, resizing of datafiles and space monitoring as part of Monthly,Quarterly growth.

Logical backup of users, tables and import of users, tables to TEST environment as per requirement.

Hot backup, cold backup of Servers.

Restoring and refreshing the TEST and DEVELOPMENT servers.

Assisting Developers in Tuning Procedure, Packages to Improve the perfomance of the Applications.

Migration of Procedures, Packages, creation of triggers.

Cloning of Production to Non Production servers.

Raising SR with Oracle for ora-600/7445 errors to understand the impact on databases and if any bugfixes to be applied on Production databases.

Recovered the tables data which was deleted accidentally using Logminer utility. Solution Environment: UNIX, Oracle Apps 11.0.3/11i/R12.1.3/R12.2.5, Oracle iAS 10g,Oracle FM11g, 11g IDM,Oracle DB 9i/10g/11g/12c

Tools: UNIX Shell Scripting, SQL.

Contact this candidate