RAMU MIRIAMPALLI
Mobile: 551-***-****
Email: acy4ie@r.postjobfree.com
Tampa, FL
Proficiency Summary
Having 9 years of experience as an Oracle Apps DBA, Oracle DBA professional specialized in implementations and administration of Oracle Databases 9i/10g/11g/12c, Oracle Applications 11i/R12.1 R12.2, Web Logic 11g and Oracle Fusion Middleware.
Experienced in Oracle Apps DBA tasks like Installation, Configuration, Patching, Cloning, Sysadmin Concurrent manager, users and security and up gradation of Oracle E- Business Suite 11i/R12.
Worked on most of the Application modules like HR Payroll, Financial, GL, AR, AP, PO, IREC, OE, INV, OM, Manufacturing, Workflow etc.
Experienced in Patching using Adpatch, Adopatch.
Performed Cloned application database from singe node to multi node system using Rapid clone
Good Experienced on performance tuning of Concurrent programs, Concurrent Mangers.
Having good experience on Oracle Fusion Middleware configuration.
Expertise in performance tuning of large databases.
Taking care of the performance issues both at the database level and applications level.
Good experience on ETL tools such as, Informatics and BODS.
Experience on Extract data from different source system and create schemas using different transformations load into target system.
Implementation of High Availability solutions with Oracle 10g/11g/12c RAC, Physical and Logical Standby Databases (Data Guard).
Experience on User management like adding and deleting users and assign roles and privileges.
Experience on Create objects like Table spaces, Segments, User management, Networking and security.
Strong experience in Backup and Recovery strategies using RMAN, Export/Import, Data pump,
Good knowledge on OAM,ODI,OEM, flat forms
Maintaining other Oracle database products on Red Hat Linux, IBM-AIX, Windows environments.
RMAN Configuration, backup and Cloning.
Experience in DATAGUARD and DISASTER RECOVERY support..
Education details;
MCA in Computer Application from Jawaharlal Nehru Technological University, 2007.
BSc (Computer Science) in Computer Application from Acharya Nagarjuna University, 2004
Technical Skills:
ERP:
Oracle Applications 11i (11.5.10.2) & R12 (12.1.3,12.2.5),Web logic
Databases:
Oracle 9i,10g and 11g,12c, Oracle Exadata
GUI/Tools:
ETL tools :
OEM, OAM,ODI, TOAD, Quest Central, DB Artisan.
Informatics 11.1power center, SAP BODS 4.1,Data stage
Utilities:
SQL * Loader, Export and Import, RMAN, TKPROF, utilities,OEM12c,IBM Stat
Platforms:
Solaris 10.0, HP-UX, Oracle Enterprise Linux5.6.7
Experience:
Client 1 : Citi Group, Inc. Tampa, FL Aug 2016 to till date
Role : Technology Lead
Project : Database Upgrade & E-Business Suite support.
Responsibilities:
performed the upgrade tasks of Oracle EBS applications from version 12.1.3 to version 12.2.4.
Upgraded Oracle databases from version 11.2.0.3 to 12.1.0.2.
Applying Oracle EBS patches using online patching(ADOP).
Performed Cloned application database from singe node to multi node system using Raid Clone
Implemented disaster recovery solution for Oracle EBS applications and databases using Oracle Data guard. Proficient in database switchover and failover using Oracle Data guard.
Creation of metrics and monitoring mechanism for Oracle applications and databases using OEM 12c.
Administration and maintenance of Oracle WebLogic 11g instances.
Experience on Data Guard, RAC on DEV, TEST environment Instances.
Applying Oracle EBS patches on multi node for bug fixes and quarterly patches.
Performing Patch analysis and applying the patches and troubleshooting Patch issues.
Environment:
Oracle Applications EBS 11i, R12 Database 10g, 11g and 12c, OEM 12c, Data guard, RAC, Fusion middleware
11g, SOA, OID, Web Logic 11g,
Client 2 : Valeant Pharmaceutical Inc. New Jersey, Jan 2016 – Aug 2016
Role : Technology Lead DBA
Project : Production E-Business Suite support.
Responsibilities:
Periodic Cloning of Development, Quality and Testing from Production using Database hot backup.
Apply of Jan2016 patches on OEM Grid Database home (12.1.0.2), OMS Home (12.1.0.5.0) and Agent Home (12.1.0.5.0) and regular patches for issue of EBS Application and Database.
Monitor of Performance issues of Concurrent Requests, Managers, Application and Database and resolved
Good exposure and support experience on Fusion Middleware products OBIEE, SSO/OAM Oracle Access Manager, Oracle Identity Management (OIM), Oracle Internet Directory (OID), Web Logic, SOA Suite
EBS Security is maintained by following Single-Sign-On, Limit on Access and Authentication, Audit Trail.
Performing regular backups of Applications and Database (Cold and RMAN utility) and ensuring backups
Implementation of OEM 12c for database monitoring (Including Exadata Database systems).
Client : Reliance India Ltd, India
Role : Associate DBA Consultant
Project : Upgrade from 11.5.10.2 to R12.1.3& E-Business Suite support.
Responsibilities:
Performing clones from Production EBS to DEV, INT and UAT instances.
Analyzing and applying the patches, troubleshooting patch issues.
Upgrading Applications from 11.5.10.2 to 12.1.3 and database from 10.2.0.4 to 11.2.0.3
RMAN backup and Monitoring Implementation
Troubleshooting Issues related Applications and Database
Applying Oracle Applications patches Maintenance Pack, Interoperability patch, one off patch, Security patches etc.
Troubleshooting issues at various layers of Oracle Applications
Environment:
Oracle Applications EBS 11i, R12 Database10g, 11g and 12c, OEM 12c, Data guard, RAC,
Queenz Software Development Pvt Ltd, India Nov 2009 – Dec 2014
Client : Hyundai America (Offshore) Mar 2013 – Dec 2014
Role : Associate Consultant
Project : Production E-Business Suite support.
Responsibilities:
Scheduling jobs for daily backups and monitoring daily backup reports.
Performing Patch analysis and applying the patches and troubleshooting Patch issues.
Collecting monthly maintenance data, finding log errors and troubleshooting them
Experienced in Amazon EC2 setting up instances, virtual private cloud (VPCs), and security groups.
Experience developing secure, reliable, scalable, python applications on the AWS cloud.
DB upgrade from 11.1.0.7 to 11.2.0.3
Upgraded Discoverer from 10g to 11g
Configured Active Data Guard for all production databases.
Managing the mount points and cleaning log directories.
Created shell scripts for automation of application and database clone configurations.
Environment:
Oracle Applications EBS 11.5.10.2, 12.1.3, Oracle Database 11g, Discoverer 10g & 11g, Data guard,
Client : GE Capital, India April 2011 – Mar 2013
Role : Associate Consultant
Project : RAC Migration and production support.
Responsibilities:
Upgraded production and non-production instances from 8i (8.1.7.4) to 9i Release2 (9.2.0.6).
Worked in Day to day production support.
Upgraded applications from 11i (11.5.10.2) to R12 (12.1.3).
Upgraded Database base from 9i to 10g and then further to 11g.
Worked on Noetix Installation (6.0.1), Upgrade (5.8.4 to 5.8.7 and 6.0.1) and Implemented the Security with Noetix Admin.
Worked on Character set conversion in DB level and installed NLS languages in Applications.
Implemented the Audit Vault & Database Vault to tracking all DBA tasks.
Environment:
Oracle Applications EBS 11i, Database 9i and 10g, Linux 4, Hp-Unix, Oracle 10g
Client : Ericsson Limited, Sweden (offshore) Nov 2009 – April 2011
Role : Sr Apps DBA Consultant
Project : Database upgradation and support.
Responsibilities:
Upgraded database from 9i to 11g.
Working on AD utilities
Defining and Administering of Concurrent Managers and Work shifts.
Troubleshooting/Fixing the production and Development issues
Upgraded Oracle EBS from 11.5.10 to 11.5.10.2
Worked on upgrading JRE from 1.3 to 1.6
Working with Patch Wizard and estimating the time effort for various activities
Executing Code Migrations in PRODUCTION instance in maintenance windows and validating
Monitoring daily backup jobs and ensure them completed successfully.
Environment:
Oracle Applications EBS 11i, Database 9i and 10g, Linux 4, Hp-Unix,Oracle 10g
ACCS Pvt, India Sept 2007 to Nov 2009
Client : ANZ bank, Australia (offshore)
Role : Jr. DBA Consultant
Project : Maintenance and support.
Responsibilities:
Performed Backups & Recovery and Monitoring & Troubleshooting
Expertise in creating the required Tables paces.
Expertise in RMAN Backup & Recovery Techniques.
Managing physical and logical structure of database.
Cloning the production db. for testing, development and reporting purposes.
Expertise managing Redo logs and Data files like adding, renaming and resizing.
Expertise in managing Control files, redo logs and data files.
Created Table spaces like, Undo TS, Temp TS, user TS etc. …
Experience on logical backups using IMP/EXP utilities.
Monitoring daily backup jobs and ensure them completed successfully.
Monitoring daily alerts and troubleshooting issues.
Applying patches based on functional and technical team requirements.
Created shell scripts for monitoring services and RMAN Backup
Environment:
Oracle Applications EBS 11i, Database 9i and 10g, Linux 4,Hp-Unix,Oracle 10g