Senior Oracle Database Administrator (Oracle E-Business Suite - Apps DBA)
The Petroleum Institute
Total years of experience :18 years, 8 Months
Professional Summary
Senior Oracle apps database administrator with 13+ years of achievement in implementing large-scale, complex and transformative ICT initiatives. Successfully implemented some of largest transformation ICT programs, which included Oracle ERP, Database cluster, disaster recovery, Oracle Hyperion planning applications, and database security.
Having solid experience in installing, maintaining, cloning, upgrading and managing Oracle E-Business Suite applications and databases under Unix/Linux platforms.
Having solid experience in administration of middleware WebLogic servers.
Having good experience of implementing and managing Oracle Access Manager for Oracle EBS to achieve Single Sign On.
Strong experience configuring multi-node Oracle applications in DMZ environment.
Solid experience with AD utilities, RMAN, OEM cloud control, and RAC.
Extensive knowledge in Oracle Essbase multi-dimensional database and Hyperion Planning and Budgeting applications and experience in Oracle Business Intelligence - OBIEE and OBIA.
Worked closely with Linux system administration. Having good experience of administrating MS SQL Server databases, My SQL in the cluster environment.
Experience Summary:
•Over 8 years of relevant experience in the Database and Application Technologies ( Oracle 8i/9i/10g/11g, Oracle E-Business Suite R12, MS SQL Server 2005/2008) under various platforms (Red Hat Enterprise Linux 5.2, Windows 2003/2008 Server, Solaris).
• Good exposure in implementing of backup & recovery strategies, database cloning & refreshing, database patching, application cloning, application patching, monitoring and performance tuning.
* Upgraded Oracle EBS 12.0.6 to 12.1.2 and Database 10.2 to 11.1
• Strong experience in supporting critical applications of Oracle EBS, and databases under Red Hat Enterprise Linux 5.
• Functional support experience in Oracle Procurement, Self Service, HRMS and Finance modules.
• Experience in UNIX/Linux shell scripting to automate database and application activities.
• Experience of database analysis, design, development and implementation of variety of complex business systems.
• Experience in Documentation, Entity Relationship Design and Database Development including Stored Procedures, Database Triggers.
• 3+ years of experience as Oracle Application DBA in the Education domain with Abu Dhabi Education council.
• 2 years of DBA experience with the overseas projects (Oracle 10g/MS SQL Server 2000) in the Islamic Banking/ Retail/Oil Field Service domains - Kuwait, Oman, UAE (Assyst International Pvt. Ltd. Cochin, India).
• 2 years as Production/Development DBA support (Oracle 8i/9i, MS SQL Server 2000) in the Banking sector (ITCS Pvt. Ltd., Kerala, India).
z
Project Description (MHD LLC, Muscat, Oman) - Role: Oracle DBA
• Implemented Physical Standby Dataguard successfully with Oracle 10g R2.
• Implemented and tested the new backup strategy with Oracle 10g RMAN utility.
• Performed Database Tuning (Architectural and SQL)
• Performed Database rebuild.
• Installing the Oracle Critical Patch on the required oracle servers.
• Troubleshooting of Oracle Database.
• Checking the Disk Space of the file systems.
• Checking the Alert Log Files.
• Upgrading from Oracle 9i to Oracle 10g.
• Checking the Performance of the database.
• Refreshing the Database with Database Cloning.
• Writing Scripts to automate Database Administrative tasks.
• • Understanding of Oracle RAC and ASM.
• Knowledge of VERITAS backup.
Project Description (Path Solutions, Kuwait) : - Role: Oracle DBA
As a DBA I was involved in:
• Involved in Database design and development.
• Database and Application Performance Tuning.
• Provides database security.
• Provides database and application support to the clients Kuwait Finance House (KFH), Boubyan Bank, Kuwait.
• Developed APIs to integrate the Islamic Investment module with the Core Banking system for Boubyan Bank, Kuwait.
Project Description (Thomson Prometric) : - Role: Oracle DBA
My responsibilities Involves:
• Remote Database Administration
• Configuring Physical Standby Database with Oracle 10g Data Guard.
• Monitoring the database, which runs on Solaris Platform.
• Tuning Database and Application.
• Rebuilding Database objects to recover fragmented space.
• Installing the Oracle Critical Patch on the required oracle servers.
• Troubleshooting of Oracle Database.
• Checking the Disk Space of the file systems.
• Checking the Alert Log Files.
• Upgrading from Oracle 8i to Oracle 9i.
• Checking the Performance of the database.
• Refreshing the Database.
• Operating Systems: Windows 2003, Linux, Solaris2.8
• Generating Update scripts.
ITCS is an IT enabled and service providing company in the Banking sector. It provides service to more than 200 Banking establishments through out the Kerala, India. The service offerings include Application software for Banks, Implementation/Installation service, Data Management services, 24X7 monitoring and support includes backup and restore, performance tuning, space allocation monitoring, database recovery and disaster recovery planning.
Responsibilities:
I was responsible for
• Provides lead to a Database team to handle 180 clients in the Banking domain.
• Installing Oracle Software and Other Utilities.
• Designing databases.
• Clone the database.
• Database Upgradation.
• Tuning the Databases and Applications.
• Configuring Oracle Database.
• Monitoring the Database Usage.
• Developing Backup & Recovery strategies.
• Performing Cold & Hot Backups.
• Database Import/Export utilities.
• Writing Business Rules with Stored Procedures & Triggers.
• Writing Scripts to automate Database Administrative tasks.
• Database Normalization.
• Performing Application Tuning & Database Tuning.
• Performing Space Management.
• Writing & Debugging SQL Queries.
• Writing Packages.
-Master of Computer Applications (M.C.A) from Mohamed Sathak Engineering College, Madurai Kamaraj University, Tamil Nadu, India. 78% of marks in the aggregate (Sep, 2001).