Vimal Ramasamy Email and Phone Number

Worked as SME for Oracle ERP middleware and databases with added responsibility as Service Delivery Manager role. Lead the team of 15 members to support and maintain the Oracle and SQL server database for large manufacturing customer.• Installation of 11gR1 OIM and integration with Oracle ERP 12.1.3• Troubleshooting the production DR switchover and switchback related issues and resolution for Oracle ERP and OIM• Review of AWR report and reduce the workload of EBS system by reducing the application reads from 11 billion to 1 billion per day• Regularly interacted with clients regarding satisfaction, expectations, and potential projects. Ensured work was correctly scoped and staffed to address client needs and for timely completion of projects.• Implemented process oriented work streams for service delivery• Managed and monitored results of team to ensure the minimum and expected SLA's are met• Successfully lead and delivered the DR switchover and switchback cycle and plan in production• Delivered the SOP’s for regular DBA support task hence reducing the dependency on staff augmentation model• Successful delivery of Directed Services projects like EBS R12 node addition, Load balancing BI and EBS jobs to database, Stat for BI, Reduce the non-actionable monitoring alerts, decommission of 11i environment etc.

Providing technical services for production, Non-Prod Oracle ERP & web Logic environments. Architecture design for 11i to R12 upgrade projects. Leading the team of 5 members for 11i to R12 upgrade projects and delivered the upgraded environment on time and in budget. Lead the offshore team for cross platform migration from UNIX to Linux to reduce the operating cost for the customer.• Lead the offshore team, design and migrate the 20+ oracle application databases from HP UX to Linux using cross platform migration.• Migration of around 200 oracle application databases from Sun Solaris to Linux using cross platform migration.• Installation of RAC and configure the ASM as part of Cross platform migration• Design and implement to manage the Oracle ERP load to the oracle RAC database by segregating the batch and online jobs.• Create the physical standby database using Data guard broker• Cloning of non-prod environment from standby database• Stabilization and hybrid support after platform migration and R12 upgrade. • Well versed in administration & adop patching activities in 12.2 oracle application database• As part load testing after platform migration added and removed the node from RAC• Design the architecture for oracle application 11i (11.5.10.2) to R12 (12.1.3, 12.2.4) upgrade project• Fine tune and reduce the oracle application upgrade downtime using adpatch options like distributed AD, skipping patch autoconfig and invalid compilations etc. • Configuration of SSL in Oracle application environment• Web logic installation, upgrade, cloning and administration• Oracle performance tuning using SQL tuning report, AWR report, ASH report and SQL monitor report• Automated the trace files purge using ADRCI utility for the entire database in oracle grid infrastructure• Partially automated cloning procedure in R12 environment

Worked as a Technical Analyst in a Global team of 25 Oracle DBAs, providing support to approximately 200 oracle application instance (sizing from 25 GB to 12 TB) across the APAC (Asia Pacific), EMEA (Europe and Middle East), and NA (North America) regions in a 24*7 support model. Achieved the award “Night of the Town” for successful implementation of non-ASM to ASM migration.• Migration of 12TB database from NFS FS to ASM FS by following the Oracle standby setup to reduce the downtime window• Successfully moved the year-on archival data from production to archival database using transportable tablespace option• Upgraded the Oracle Application from 11.5.9 to 11.5.10.2 and 11.5.10.2 to R12• Advanced database objects compression in 11G environment• Installation of 10GR1 and 11GR2 RAC instance and troubleshooting the RAC installation and support issues• Migrating single node to RAC database using manual procedure• Administration of Oracle Application server like SOA, BPEL, BAM• Converted the node specific APPL_TOP into shared APPL_TOP configuration• Configuration of Parallel concurrent processing (PCP) and Hardware-level load balancing of web service in Oracle ERP• Implementation of data guard in core database 9i, 10g, 11GR2 environment and successfully tested the switchover and failover operations• Carried out database upgrade from 9i to 11g and 10G to 11G

Administrated multiple Oracle database and application. Involved in various Oracle ERP installation and upgrade activity.• Oracle application and database cloning• Patching in oracle application database environment using adpatch and opatch utility. • Implemented RMAN backup to disk and tape. script and schedule the RMAN backup• Alert management using 10g OEM GRID• Upgrade of Oracle Application from 11.5.9 to 11.5.10.2 and DB from 9.2.0.6 to 10.2.0.1• Managing the Concurrent Managers and its operations like defining workshifts of the concurrent managers, re-schedule the requests, purging the concurrent requests historical data, tuning of concurrent managers and monitoring of the concurrent manager operations• Monitoring the production instance for various alert like long running concurrent request, error messages in alert log and tablespace alert• Creation of daily shift report for various mount point space availability, Invalid objects counts, available free space and used space in the database etc.• Created shell script for SAR (server activity report). SAR informations loaded in to the database using SQL loader.• Installation and administration of core database 9i and 10g• Created and managed the Database objects and schemas• Application user creation, responsibilities assignment and registering the concurrent program to the respective application