Managing principal DBA
Apps Associates India Private limited
Total des années d'expérience :20 years, 11 Mois
• Responsible for E-Business Suite administration for all assigned clients installations, including:
EBS Installations on single and Multi-Tier architecture.
Configurations
Troubleshooting
Patching
Backups and recoveries
Upgrades covering Apps and Technology stack, including several database upgrades
Security CPU patching
Deploy proactive monitoring processes
Cloning
• Expertise in installation and setup for EBS 12.2.8 with database on Oracle RAC One Node
• Migrated on-premises 12.2.7 ERP application to OCI cloud DBAAS 12c
• Performed EBS upgrade from 12.1.3 to 12.2.11 along with database upgrade from 11.2.0.4 to 19c
• Expertise in EBS administration on versions from 11.5.7 to R12.
• Performed additional NLS language installation for EBS.
• Provided support for EBS Multi-Tier architecture including Load Balancing via Big IP, and Oracle IStore implemented on Oracle Applications 11.5.10.2.
• Build and scale Center of Excellence groups in Database Administration, Application Administration functionalities.
• Enabling TLS in Oracle E-Business Suite Release 12.2
• Oracle E-Business Suite Integrated SOA Gateway (ISG) Release 12.2, SOAP-based web services are deployed on Oracle SOA Suite running on Oracle WebLogic Server.
• Expertise in installation and setup for EBS 12.2.8 on AWS ec2 instances.
• Migrated on-premises 12.2.7 ERP application to OCI cloud DBAAS 12c
• Expertise in EBS administration on versions from 11.5.7 to R12.
• Performed additional NLS language installation for EBS.
• Provided support for EBS Multi-Tier architecture including Load Balancing via Big IP, and Oracle IStore implemented on Oracle Applications 11.5.10.2.
o Managing SSO set up Integration of EBS 12.1.3 with OAM on 11gr2 RAC environment
o performed Oracle database Upgrade from 10.2.0.4 to 11.2.0.4
o Complete management of all technical matters related to the Oracle Applications databases including Production Maintenance, Administration, Clone, Upgrade, Migration and New Implementations of R12/11i environments on Oracle RAC 11gR2 database on Exadata Database server X3-2 Eighth Rack servers
o Mentored the DBA team with the required training and practice.
o DMZ (SSL) setup using reverse proxy.
o Involved in the execution of administrative execution of sql’s on SQL SERVER as per client requests
• Managing 11i (11.5.10.2) instances and Migration and Management of 11i (11.5.0.2) instance on to VM ware configuration.
• Implemented new Oracle database appliance Exadata on Linux os
• Troubleshooting day to day production dba activities like high CPU usage, high temp, excess redo, locking. Cloning’s, reorg activities etc.
• I am a SME (subject matter expert) for an assigned instances making sure I take care of all its activities.
• Managed 2 teams with one team in the startup stage of a projected Strength of a 26-member Technical team outsourcing team.
• Troubleshooting day to day production dba activities like high CPU usage, high temp, excess redo, locking.
• Attending escalation calls and troubleshooting issues and preparing RCA
• Performing monthly performance calls detailing the whole monthly activity on the instance.
• Worked for prestigious US clients like applied materials Inc, US, Cisco India managing ERP production instances
• Maintenance Apps activities includes Cloning Apps instances using rapid clone, patching, Adadmin activities.
• Cross platform migration using transportable tablespaces.
• Managing 11.0.3 instance and a multiple databases ranging size from 300 to 600 GB.
• Maintenance Apps activities includes Cloning Apps instances, patching, Adadmin activities
• Maintaining database activities like upgrades, re-org, database links, grants, exports, imports, creation of users, database links etc.
• Database Migration for convert characterset of database.
As a Cluster Manager Operations, responsible for
• the complete offshore operations to include delivery and resource management of around 30-odd people in total, one of it for a Hosted Practice in 24 *7 fashion
• Responsible for Offshore Operational & Resource Management, worth-while experience in:
• Initiate Hiring, Mentoring, provide Trainings, Focal & Bonus and boom for the Career Growth of the Engineers.
• Streamlining Operational SLAs/Processes/Work Schedules towards High Availability & Disaster Recovery Setup & Management
• Alignment of Operations to ITIL Standards and adaption of SAS-70 compliance. Improved Change Management Norms
• Timely assessment of Operational Tasks to ensure Efficiency and provide seamless Operational Delivery within the scope of the SLAs
• Managed 2 teams with one team in the startup stage of a projected Strength of a 26-member Technical team, with around 16 members On-Board and rapid hiring, based out of Hyderabad, Bangalore & Noida and the second being 12-member Technical team again located out of Hyderabad, Bangalore & Noida
• Revised the Standard offerings through Operational Readiness Programs as a buy-in for Future Customers.
• Successfully handled Implementations for Customers and dealt with the clients across the geography like in Asia Pacific Region, EMEA (Europe), South America, Australia and United States.
• Involved in set up of clustered team for Tier-1 Customers to:
• Strengthen Customer affinity at Engineer level
• Reduce Time & Effort towards resolution and Increase Accountability
• Prioritize and Balance Work Load
• Provided support, which includes database patching, upgrades, analysis etc.
• Administered Oracle Server included installations, Database Design, Schema Designs, Implementation, Security Management, Performance Maintenance and Tuning.
Le lien a été supprimé pour non-respect des conditions d'utilisation. Veuillez contacter l’équipe d'assistance pour plus d'informations.