R SURINANI

Phone: 412-***-****

Email: ad2ejv@r.postjobfree.com

Professional Summary

Certified Oracle Professional with 15+ years of working experience in Oracle Application E-Business Suite Versions R12/11i and Oracle Database versions 9i/10G/11g/12c/18c and 19c with excellent technical, project & task management skills. Proven ability to plan, co-ordinate and implement complex implementation and support projects.

Good knowledge of Oracle Apps DBA activities, Core Database activities, Real Application Clusters Database administration, OBIEE Application Administration.

Good knowledge on Oracle Database Install, configure, administer, upgrade, physical standby, OEM, RMAN, Oracle ASM, Exadata administration and migration.

Extensive working knowledge in Performance tuning of Oracle Databases, SQL tuning, PL/SQL tuning, Instance tuning.

Installed and Configured Oracle 10g,11g,12c and 19c RAC, distribution of workload across nodes, fixed many performance issues of RAC by using the AWR and analyzing the wait events.

Exposure to Oracle 12c and 19c multi-tenant architecture and support 12c and 19c databases.

Good knowledge on administering Standby Database using Data Guard for large financial applications.

Experience in working with ASM for RAC and non-RAC setups.

Experience with design and implementation of database backup and recovery procedures using RMAN and Grid control. Working with storage administrators for Storage level snapshot backups e.t.c.

Troubleshooting Oracle Data warehouse performance issues arising due to daily ETL loads and ensuring the ETL jobs completes with in SLA.

Worked extensively on Oracle Application performance tuning of Concurrent managers, concurrent requests, scheduling of concurrent jobs through Tidal tool, JVM tuning.

Working knowledge in Patching including Oracle HRMS module patches for global legislation, Country specific localization patches, Cloning, Upgrades & Fresh installation of Oracle Applications 11i & R12 environments.

Involved in Installation/Configuration/Maintenance of Oracle Applications Tech-stack.

Setup/configure/Support/maintenance of multi-node 11i, R12/12.2 Environments.

Involved in Installation/Implementation/Configuration/Upgrades/Support of 11i, R12/12.2 instances.

In-depth Knowledge of Oracle Apps Administration 11i, R12/12.2 like setup users/managing user responsibilities, registering custom applications e.t.c.

Experience in working with SSL certificate and software level load balancer on EBS server.

Good knowledge with integrating Oracle Single Sign-on(SSO) and Oracle Internet Directory(OID) on Oracle EBS R12 release.

Involved in Oracle Apps Upgrades to all major versions from 11i to R12, R12.1.1 to R12.1.3 and 12.1.3 to 12.2.

Code migrations of Forms/Reports/Java/ADF objects across SDLC and finally to Production environments through PPM tool.

Involved in Platform migration of Oracle Applications 11i, R12/12.2 using Transportable Tablespaces.

Ownership of the quarterly maintenance security patching, providing SOX Audit reports and being responsible for managing technical quality deliverable/resource/schedule/risks throughout the project, working extensively under onsite-offshore model.

Configure and managing of Oracle database on oracle Exadata servers.

24X7 Production Oracle Application and Database Maintenance, Support and Administration.

Experience in writing backend procedures, functions, packages, and triggers using PL/SQL.

Strong understanding of operating system (OS) like AIX,H.P Unix, Oracle Linux and storage technologies like,NAS, SAN,Data domain to effectively work with Unix and Storage system administrators.

Good knowledge of UNIX shell-scripting for automation of tasks and implementation of Custom monitoring alerts.

Proficient in administering/installing/configuring of Monitoring tools such as OEM 10g,11g,12c grid console for monitoring hosts, databases and Oracle applications through AMP plugins and Oracle OBIEE environments through OBIEE plugins.

Education

1. Msc. computer science, London, U.K.

2. Bachelor of Computer Applications, Hyderabad, INDIA.

Technical Summary

ERP: Oracle E-business Suite (11.5.9, 11.5.10, R12 and 12.2) administration.

FMW: Oracle WebLogic server 11i and 12c, Oracle OBIEE 11g middle ware.

Work Areas: Installation, Upgrades, Cloning, Patching, Backup & Recovery, Performance tuning.

Database: Oracle RDBMS 9i/10g/11g /12c and 19c.

Languages: SQL, PL/SQL, UNIX, Shell Scripting.

Monitoring Tools: OEM 10g, 11g, 12c, Solar winds, RUEI.

Tools and Utilities: TOAD, SQL Developer, Putty, Vnc, Winscp

Operating Platforms: Oracle Linux 5.5, 6.2, H.P UNIX, IBM AIX, Sun Solaris, RHEL, Oracle Linux.

Professional Experience

US Steel Corporation

May 2012 – Till Date

Role: Oracle DBA/Exadata Engineer

Description: United States Steel Corporation, more commonly known as U.S. Steel, is world's 38th-largest steel producer and the second-largest in the US, trailing only Nucor Corporation. As part of this project, we support Linux, IBM AIX, Windows servers running close to 300+ databases of versions ranging from 10g to 19C and EBusiness suite applications 12.2 versions.

Installed, configured, maintenance and upgrade of Oracle databases from 11g to 19c on RHEL, IBM AIX and Exadata.

Support Databases include both single and multi-node RAC databases running from 11g to 19c versions on Linux/IBM AIX. EBS apps 12.2 system with many Third-party applications integrated like OTM, OBIEE, SOA, KBACE and VERTEX.

Database upgrades and release upgrades of RAC and Non-RAC databases from 10g to 11g, 11g to 12c, 12c to 18c and 18c to 19c.

Perform regular database maintenance tasks, including backups, restores, and database refreshes, space management.

Collaborate with development and infrastructure teams to troubleshoot and resolve database-related issues.

support Oracle OBIEE 11g application, including ETL daily loads.

Production Support of ERP 12.2.7 environment Database 3 - Node RAC,12 Node Application Tier with load balancer in DMZ configuration.

Installed/Configured/Administered OEM monitoring tool 11g, Upgraded OEM grid 11g to OEM 12c enterprise grid console, Installed AMP and OBIEE plugins and discovered EBS11i/R12/OBIEE targets.

Involved in the Oracle Applications upgrade of r12.1.2 to R12.2.7.

Worked on critical Oracle Datawarehouse ETL jobs and reduced the load time and ensured SQL Baseline plan stability.

Managing, troubleshooting, and resolving oracle database, RAC and applications issues.

Great experience in converting a E-Business Suite Database to RAC.

Great experience in Cloning RAC to RAC, RAC to NON-RAC INSTANCE.

Involved in EBS archive project for reducing the data footprint of oracle EBS 12.1.2.

Involved in Installing/Configuring/Managing of OBIEE11g 2 node cluster for Business Intelligence solution.

Cloning of ERP and non-ERP database using RMAN restore.

Attending weekly CAB - Change Advisory board meetings and ensuring the production changes to go smoothly.

Environment: Oracle Applications 12.2.7, R12, Oracle Database 10g,11g,12c,19c, Oracle RAC 11g,12c,19c, ASM, OEM 12c, OBIEE 11g, Linux servers, IBM AIX Unix Machines. Oracle Manufacturing, Oracle Financials, Order Management, I Payment, Oracle Inventory, Integration of EBS12.2 through Oracle.

Tempurpedic

Feb 2010 to May 2012

Role: Oracle Apps DBA

Description: Tempur-Pedic International, is a manufacturer and distributor of mattresses and pillows made from viscoelastic foam. Tempur was originally based on NASA's research to develop a material that would cushion aircraft seats and improve survivability in the event of an accident.

Been part of Oracle EBS upgrade from R12.1.1 to R12.1.3.

Implemented range partitioning for few custom application tables and automated the partitions creation for the object on a weekly basis to improve the application performance.

Worked on ASCP planning work bench performance issue by working with Functional and Development team and created custom partitioned index to fix the issue.

Applied many patches to unix server and worked with Oracle support to fix the Analytical engine performance issues.

Fixed critical Demantra planning forecasting performance by executing DBMS_REDEFINITION for SALES_DATA table and reduced the storage size.

Production Support of EBS 12.1.3 environment on 2 Node RAC cluster with 2 Node Application tier on IBM AIX platform.

Installed/Configured/Stabilized OEM 11g grid console and discovered all Ricoh Database servers and configured the monitoring alerts.

Configured multiple Jservs, forms, report, and concurrent managers for PCP.

Involved in patching, refresh and upgrading the system to the latest RUP levels.

Resolved concurrent request issues including printer and output post processing issues.

Worked with Oracle Support to resolve issues pertaining Database and EBS issues.

Worked on Oracle datapump utilities and imp/exp tool to migrate schemas/tablespace between different environments.

Involved in day-to-day Oracle Applications DBA activities like patching, cloning etc.

Resolved locks and performance issues on RAC nodes.

Timely fashion adding additional space to database on ASM.

Applied patches on RAC Instances.

Stabilizing the oracle 10g RAC cluster by working with oracle vendor on frequent node reboots issue.

Support for code deployments, long running reports by working with development team to and fixing critical reports performance issues using SQL baseline, profiling, OEM tuning pack, and AWR.

Environment: Oracle Applications 12.1.3, Oracle Database 9i,10g,11g, Oracle RAC 10g, Linux servers, IBM AIX Unix Machines.

Marsh & McLennan

Jan 2010 - May 2010

Role: Oracle Applications DBA

Description: Marsh McLennan is a global professional services firm headquartered in New York City with businesses in insurance brokerage, risk management, reinsurance services, talent management, investment advisory, and management consulting.

Been part of Oracle Database upgrade from 9.2.0.4 to 10gR2.

Applied CUP patchset 2 to 11.5.10 environment and upgrade to 12.1.2 version.

Installed SQLT tool to analyze slow running SQL queries due to database upgrade. Created outlines for few critical sql to have plan stability.

Configured SSL mode for Oracle HTTP server in EBS 11i environment.

Upgraded databases from 9i to 10gR2 after the production upgrade.

Production support of EBS 12.1.2 with Single Node Database and 2 Node application tier.

Configured Parallel Concurrent Processing (PCP) and Shared APPL_TOP.

Converted forms server from servlet to socket mode to improve the performance.

Created Oracle application users, assigned responsibility, Created custom's menus and responsibility for Oracle Apps.

Installed and upgraded Oracle (10g, 11g) software in different environments, created and maintained Oracle development and test databases.

Created users, assigned roles, and privilege management. Maintained user accounts and privileges to maintain application security.

Worked with the application team and the business team in determining the requirements and solved all kinds of database and data issues.

Migrated data using RMAN transportable tablespace.

Created and maintained materialized views for replication.

Developed the shell scripts to load the data coming from the vendor into the databases.

Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for performance tuning.

Ensured security of the database by creating profiles for each user and monitored the user sessions.

Interacted with development team in fine-tuning the SQL and PL/SQL code.

Analyzed tables and indexes of Oracle database periodically for better performance.

Migrated the code as well as the data from one environment to another depending on the application team's request.

Environment: Oracle Applications 11.5.10,12.1.2, Oracle Database 9i,10g, Oracle RAC 10g, Sun Solaris, IBM AIX, RHEL servers.

MSP Hitect(M)Sdn Bhd (Malaysia)

Sep 2006 to Nov 2009

Role: Oracle Applications DBA

Description: The project maintains all the Oracle Applications Database instances of the client BATM which is a leading Tobacco company.

Upgraded Oracle Database from 9.2.0.4 to 10g running on IBM AIX machine.

Performed the Oracle Applications upgrade from 11.5.9 to 11.5.10.

Applied HRMS patches to 11i environment.

Performed tablespace level re-org to reduce the fragmentation, storage footprint and increase the performance.

Monitored and managed the Storage Usage by resizing Tablespaces for better Disk I/O.

Scheduled DB activities using crontab on Linux servers.

Compiled apps schema and validating invalid objects using utlrp script and adadmin utility.

Co-ordinate with oracle metal ink to issues on database and oracle application.

Fixed oracle Apps User related issues.

Applied apps patch using adpatch utility for various EBS modules.

Documented RCA for various issues and deployed on solutions among various environments.

Installed Oracle RDBMS server software and version upgrades on Oracle EBS server.

Fixed forms related issues of Oracle EBS.

Performed refresh and cloning of EBS instances for test, development servers.

Scheduled and minimized the down time of the production system by resolving issues on a test system.

Created request group, data group on EBS servers.

Created concurrent managers, programs, and request sets for specific requirement.

Automated manual day-to-day activities using shell scripts.

Managed the Concurrent Managers and its operations on EBS like starting, stopping the concurrent managers, re-schedule the requests, tuning of concurrent managers and monitoring of the concurrent manager operations.

Created development database manually and using DBCA as per requirement.

Environment: Oracle Applications 11.5.10, Oracle Database 9i, 10g, Oracle RAC 10g, H.P Unix, IBM AIX Unix Servers. Oracle HRMS, Oracle Financials are the main modules implemented.

D’CRUZ Consultancy UK

May 2003 to June 2006

Oracle DBA

24x 7 Production database administrations support all Production of Oracle Applications 11i and monitoring to ensure a proactive problem recognition and resolution of multi-terabyte database issues.

Involved in Database Upgrade from 8.1.7 to 9.2.0.6 and from 9.2.0.3 to 9.2.0.6.

Involved in Oracle Applications Upgrade from 11.5.8 to 11.5.9.

Configured and Installed Oracle Application 11i using Rapid Install. Monitored the Applications and Database using OEM.

Setting up of printers In the Apps.

Maintenance of concurrent processing requests and concurrent managers.

Tuned concurrent managers using Oracle Enterprise Manager (OEM).

Using AD Utilities like ADADMIN, ADIAMGR, ADPATCH, and ADCTRL.

Created Shell script for daily refreshing an instance from Oracle Apps 11i Production instance.

Creating the database, tables, Tablespaces, data objects, setting privileges, indexes, user logins, and passwords.

Reorganization of the Database using export import.

Installing RHEL and Solaris for Oracle 8i testing and development purpose.

Developing Hot, cold and logical backup scripts to automate the backup procedures.

Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.

Daily activities include monitoring batch application for performance and space requirements and tuning the system to optimize space and performance.

Query optimization and tuning using tools like TOAD and SQL Loader.

Provide technical assistance to developers in all matters concerning performance, application related issues.

Debugged Oracle Reports and Oracle Forms programs.

Created new Oracle Reports and Oracle Forms programs based on user specifications.

Assists in design tasks such as debugging, specifications development and system integration testing.

Provides technical assistance and user support functions.

Monitoring all alerts configured from Enterprise Manager Console.

Environment: Oracle Database 8i, 9i, Oracle Applications 11.5.8,11.5.9, IBM AIX, RHEL Servers, Net Apps Storage.

Contact this candidate