Oracle Database Professional with extensive experience exceeding 11 years in Oracle Applications R12 and database management. Expertise in Oracle architecture, patching, and performance tuning, with a focus on enterprise-wide database optimization. Proven track record in high availability setups, including RAC and ASM, and adept at troubleshooting and monitoring database performance. Effective leader with strong integrity and ability to facilitate change within teams.
Hi, I’m
ROY PRAVIEN ANTHONY RAJAMANICKAM
Oracle Apps DBA (Database Administrator)
Hoover,Alabama
Summary
Overview
11
years of professional experience
2
Languages
Work History
Cognizant Technology Solutions
Associate – Manager (Tech Lead) Support
01.2018 - 08.2023
Job overview
- Client Title: PepsiCo
- Role: EBS DBA
- Environment: Oracle 11i/R12 Apps & 11g/12C/19C on Diff OS Platform
- Description: World's leading food & beverage company with over $63 billion net revenue and global portfolio of diverse and beloved brands
- Team Size: 12
- Monitoring job failure and coordinating with operations.
- Developing and implementing procedures, supervising daily operations, identifying training needs, generating reports, providing support to team members, and assessing their performance.
- Coordinating with various teams like Unix team, network team and other application teams for handling application/database related issues.
- Motivating team to meet technical project deadlines.
- Working on multiple instances like development, testing, UAT, database & application backup/recovery and production including RAC, stand by Instances, Oracle application database, Oracle EBS/database cloning, patching and troubleshooting and CPU/PSU patching.
- Using Sysadmin (Oracle Apps) programs for creating users/responsibilities/profile options.
- Refreshing development/Test database from production using RMAN hot backup
- Collaborating with Team Lead / Project Managers regularly to maintain the health of the project and working on the activities plan and with the Technical/Functional Team for patching related activities.
- Using service-now for ticketing tool like incidents, PM, Service requests, Change Tasks and Request Tasks.
- Completed Internal certification on Dev ops white belt program.
- Application: Oracle Applications 11i (R12.1.x, 11.5.10.2)
- Database: Oracle 9i/10g/11g
HCL Technologies
CONSULTANT
10.2015 - 11.2017
Job overview
- Client Title: PepsiCo
- Role: EBS DBA
- Environment: Oracle 11i/R12 Apps & 11g/12C on Diff OS Platform
- Description: World's leading food & beverage company with over $63 billion net revenue and global portfolio of diverse and beloved brands
- Team Size: 13
- Facilitating multiple instances like development, testing, UAT, database & application backup/recovery and production including RAC, stand by Instances, Oracle application database, Oracle EBS/database cloning, patching and troubleshooting and CPU/PSU patching
- Utilizing Sysadmin (Oracle Apps) programs for creating users/responsibilities/profile options
- Liaising with Team Lead / Project Managers regularly to maintain the health of the project and working on the activities plan and with the Technical/Functional Team for patching related activities
- Leading refreshment of development/test database from production using RMAN hot backup and using export/import for scheme level refresh
- Maintaining preparation & analyzation of weekly/monthly database status reports
- Managing ticketing tool like incidents, PM, service requests, change / request task through HP-SM application
Sonoco Steady State
Oracle Apps DBA
10.2015 - 09.2016
Job overview
- Role: Oracle Apps DBA
- Environment: Red Hat Linux
- Team Size: 6
- Directed configuration & maintenance of Concurrent Manager & its operations like starting, stopping & troubleshooting the issues on Concurrent Managers
- Led Oracle application upgrade from 11i to R12 releases and did cloning/refreshing of Oracle application in single tier model.
- Used JDK/JRE upgrade in R12 application and installed new languages for R12 as per project requirement.
- Assisted Oracle SR for technical and functional issues.
- Managed database patching using Opatch Utility at database level, ensured Crontab scheduling and monitored alert log /trace files.
- Utilized Axciom application for ticketing tool like incidents, SRQ and requests.
- Employs 16,500+ people with operations in 35 countries—doing business in 85 countries. The packaging solutions provider has invested in growing the consumer side of its business by moving into packaging platforms such as rigid paperboard and flexible and rigid plastics. Implementing an ERP system has helped Sonoco integrate its operations in 35 countries.
Petrofac Information Systems Pvt. Ltd.
Associate Consultant
07.2012 - 02.2015
Job overview
- Led cloning of applications system and database in test/dev/prod in multi-Tier environments - IBM AIX 6.1
- Acted as the part of DBA team member during Go Live (4000 users added in Live ERP System)
- Managed application of Patches (Adpatch & Opatch) in multimode environment, Schema objects (tables, indexes, sequences, and views) and maintenance of R12 (12.1.2) & 11g database (11.1.0.7)
- Maintained scheduling of backups using tar/RMAN and development of shell script for Tablespace & operating systems error
- Executed cloning of Oracle applications from multi node to single, single node to single node and multi node to multi node
- It is a leading international provider of facilities solutions to oil & gas production and processing industry, with diverse customer portfolio including integrated, independent and national oil & gas companies with more than 20000 employees. Petrofac operates out of six strategically located operational centers in UK, Aberdeen, Sharjah, Chennai, Mumbai and Abu Dhabi and a further 21 offices worldwide.
Education
Mookambigai College of EngineeringPudukkottai, Tamil Nadu
B.E. from E.C.E
01.2011
University Overview
Anna University
Skills
Motivational skills in collaboration
Timeline
Associate – Manager (Tech Lead) Support
Cognizant Technology Solutions
01.2018 - 08.2023
CONSULTANT
HCL Technologies
10.2015 - 11.2017
Oracle Apps DBA
Sonoco Steady State
10.2015 - 09.2016
Associate Consultant
Petrofac Information Systems Pvt. Ltd.
07.2012 - 02.2015
Mookambigai College of Engineering
B.E. from E.C.E