Senior Oracle Application DBA
DRAGON OIL
Total years of experience :19 years, 4 Months
TECHNOLOGY
- Installation/Upgrade/Implementation/Support of Oracle Apps 11i/R12
- Oracle Applications Performance Tuning.
- Oracle database upgrades
- DR setups for DB and Oracle Applications.
- DMZ setup for customers.
- SSL configuration.
- RAC configuration.
- Applying Critical Patch Updates
- Cloning Oracle Applications using RMAN/ASM/Cold backups.
- Oracle Applications Database Health Check.
- Oracle Applications Backup & Recovery.
- Oracle Applications High Availability.
- Oracle Applications Diagnostics / Troubleshooting.
- Supporting on- going projects for client (Migration of hardware, up gradation etc.)
- Designing Backup Strategy. Use of RMAN, Conventional Backups
- RMAN setup
- Formulating backup policies, security policies, patch protocols, clone protocols.
- Configuring Oracle Apps 11i/R12 with RAC & PCP.
- Creating SOP for all the work for documentation purpose.
- Oracle Knowledge Base (Oracle Database9i, 10g, 11g/Oracle Apps 11i/R12)
- Single Node and Multi Node Installation - 11i/R12.
- Oracle Applications Architecture - File System and Database Entities.
- Maintenance of Single Node and Multi Node Instances.
- AD Utilities.
- Upgrades of various Oracle Applications versions to 11.5.10, 11.5.10.1 and 11.5.10.2.
- Upgrades of various Oracle Applications 11i releases to R12.
- Data Install and HR Global patch
- Applying patches - Oracle Applications and Database patches
- Cloning Oracle Applications
- Oracle Apps Platform Migration
- Single Node to Multi Node Cloning - Splitting servers across nodes
- Oracle Apps SYSADMIN functions.
- Installing Oracle Database 9i, 10g
- Creating Database
- Upgrading Databases
- Applying Patches
- Export/Import of DB
- Data pump Import/Export of DB
- Hot and Cold Backups
- Script development
- RMAN
- RAC
- ASM
- DR Setup
- BEA, TIBCO, Model- N and Hyperion, SSO, OID, Business Objects (BO), REIM, SIM
PROJECT MANAGEMENT
- Vendor Management Engagements on SOP’s, SOW’s, PUGH matrix etc.,
- Project Leadership for the entire GE global research database associates projects
- Managed 15 members of DBA team includes Sr. DBA’s with 6000 customers at site
- Provided 24 x 5 DBA support model to work with 300 consultants from various functions
- Incident Handling Methodology
- SLA based approach model
- Ticket trend analyse methodology
- Work out Six-Sigma Green Belt methodology
- Worked on Remote vendor program engagements
- Global team engagements in Decision making, Understanding the project scope in / out to allocate the right resource and ensure with the timelines
- Handling 11g / 12c Oracle Database Administration and R12 Oracle Apps DBA
- Working with key users of HRMS / FINANCE / SOURCING to handle day-to-day issues.
- Maintained Oracle database and Retek Database like REIM, SIM
- Handling data ware house database for Business Objects (BO)
- Sizing the servers for the upgrade projects
- Handling UC4 job scheduler
- Implement 11g OEM
- Installation of BEA
- Implementing the client agents of 11g
- Implemented TIBCO 5.9 version on Solaris platform
- Supported TIBCO 5.9 version on Solaris platform
- Consolidation of 150 database servers to 20 database servers
- Analysing and finding the database servers for the consolidation
- Migrate and upgrade the databases into 11g databases on Linux platforms
- Setting up the backup strategy on all the databases.
- Migration of Sql Server database to Oracle database
- Database upgrades from oracle8 to Oracle 11g
- Implementing Symantec backup strategy to Oracle database
- Upgrade R11.5.9 to R11.5.10.2 & R12 Oracle Applications -- BOU (Bank of Uganda) Uganda, Africa
- Database upgrades 8i to 11g
- System Administration
- Environment preparations
- Upgrade Oracle Application to R11.5.10.2, R12
- Patching and Troubleshooting
- Database Backup Activity
- Upgrade R11.0.3 to R11.5.10.2 Oracle Applications -- NATO, Belgium
- Database upgrades 8i to 11g
- System Administration
- Environment preparations
- Upgrade Oracle Application to R11.5.10
- Patching and Troubleshooting
- Implementing RMAN backup strategy for the client
- Upgrade R11.0.3 to R11.5.10.2 Oracle Applications -- Pacific National, Australia
- Database upgrades 8i to 10g
- System Administration
- Environment preparations
- Upgrade Oracle Application to R11.5.10
- Patching and Troubleshooting
- Database Backup Activity.
- Single node to multi node conversion
COMPANY Freelance Trainer
Location Bangalore, India
Client Oracle, IBM, IIHT, NIIT
Role Oracle Database Administration Trainer
Duration Jun 2004 - Feb 2006
- Oracle 9i Database training
- Oracle 10g Database training
- Oracle 9i RAC Database training
- Oracle 10g Database training
- Undergone 10G / 11G New Features Training from Oracle Corp.,
- Undergone Oracle APPS DBA 11i & R12 training from Oracle Corp.,
- Undergone Six-Sigma GB Certification Training from GE Corporate
- Undergone GE Presentation Program Skill training from GE Corporate
- Undergone GE Team Building workshop from GE Corporate. Etc.
Bachelor of Engineering in Electronics & Communication, Computer Science, PGP Engineering college from Periyar university. Additional Course: courses: OCP (Oracle Certified Professional) Six-Sigma (Green Belt) Certified