Oracle Project
Resume:
VENU KIRAN KUMAR VISHNUMAHANTI
****.***@*****.***
Summary:
Around 5+ years of experience as Oracle Applications DBA
Over two years experience as faculty in CMC Limited.
Worked in 24x7 production environment and provided on-call and day-to-day support
Enhanced computer skills with functional expertise in related fields.
Superior organizational skills and problem solving skills.
Quick decision-making and time management.
Ability to adapt fastly to any new environment.
Oracle APPS DBA Skill Set:
Installation of Oracle 9i, 10g, 11g software on various clients/ servers platforms, working with multiple oracle homes, creating Databases using various methods (manual, dbca) creating and managing multiple databases with single oracle home. Shared server configuration & enabling archiving & administer databases.
Installation, upgrade, patching Oracle RDBMS software.
ERP installation of 11i and R12 versions.
EBS upgrade from 11.5.10.2 to R12.
Workflow configuration and troubleshooting.
Configuring and troubleshooting printers at OS level and Oracle Applications.
Upgrading of Databases from 10g to 11g.
Cloning – Production to Test instance, migration and logical backups (export, import-table, user level, tablespace, database).
Working with RMAN to take the backups and restore the databases
Support and maintaining RAC databases.
Configuring physical standby databases (DR)
Setup and maintain documentation and standards
Perform general technical trouble shooting and give consultation to development teams.
Monitoring the alert logs and other log files, generating sql trace files, fixing the oracle inventory issues, working with oracle support (TAR, SR), installing and configuring RDA (Remote diagnostic Agent), researching the issues and identifying the fixes using Oracle METALINK.
Extensively working on Oracle Applications Ad Utilities
Maintained mission critical production application support (24x7x365) in 11i making highest availability exceeding all service level agreements solving critical issues very quickly in multiple application environments including test & development from small to large application environment.
Configuring Test, Training and Development Instances and cloning the entire Oracle Application Instance from Production to testing environments on a regular basis, across multiple tiers.
Incorporating Custom Programs, registration of new Users, defining new Custom Application Top.
Security Management involving Audit Trails, changing passwords for Oracle Application Users, Running Concurrent Programs and Monitoring Application Users.
Analyzing and applying patches in test instances and performs rigorous Testing and subsequently moved to the development Instance and same to PRODUCTION environment.
Technical Profile:
Software Oracle 9i, 10g, 11g
ERP Oracle Applications Rel. 11i, R12
Languages C, C++, PL/SQL and shell scripting
Operating Systems Windows-95/98/2000/XP, Linux, Unix, Sun OS, IBM-AIX
Work Experience:
2012 Jun. – till date
Working as an Oracle applications database administrator in Mubadala Development Company under contract hire from Sundus Management Consultancy.
2010 Oct. – 2012 Jun.
Worked as an Information Specialist (Oracle Apps DBA) at Net Solution Fz LLC, Dubai, UAE
Outsourced to Injazat Data Systems as an Oracle Applications DBA.
2009 Nov. – 2010 Sep.
Worked as an Oracle Apps DBA, Permanent employee in NalSoft (P) Ltd.
2007 Mar. – 2009 Nov.
Worked as an Associate Consultant, Permanent employee in Sierra Atlantic Software Services (P) Ltd.
2007 Jan. – 2007 Feb.
Worked as an Associate Consultant trainee in Sierra Atlantic Software Services (P) Ltd.
2006 Jun. – 2007 Jan.
Management Trainee, ORAFACT Inc., As a Management Trainee, completed intensive fulltime training program in 9i, 10g Oracle DBA, 11i Oracle Applications DBA.
2004 Jan. – 2006 May.
Worked as a faculty at CMC-ATC, Dilsuknagar, Hyderabad.
o Taking Demo from the newly joined Faculty and test their abilities.
o Resolving issues faced by Students in lab.
o Troubleshooting issues related to Oracle Database.
o Conducted seminars, Case study, Group discussions and Project works to enhance the innate talents of the students.
o Handled the Corporate Trainees.
o Dealt the languages C, C++, UNIX, ORACLE (SQL & PL/SQL) and JAVA.
Academic details:
B.Sc Computers completed in 2001.
Education:
B.Sc. (Computers) from Acharya Nagarjuna University 1998 – 2001.
Diploma in Software Technologies from CMC Ltd 2001 – 2002.
PGDCA 2000 – 2001.
Certification & Training:
Trained in Oracle 11i eBusiness Suite
Oracle 9i Certified DBA Professional (OCA).
Oracle R12 Applications: Install, Patching and Maintenance certification.
Oracle 11g Administration-1
Projects Summary:
Project
Company Production Support
Mubadala Development Company (Sundus Management Services)
Client Mubadala Development Company – Abu Dhabi(UAE)
Role Oracle Apps DBA Consultant
Duration Jun 2012 to till date
Environment Sun Solaris, Linux x86_64, Oracle Applications R12.1.3
Database – 2 node RAC, Applications – 4 node
Description:
Production Support.
Performing regular refresh of TEST and DEV instances from PROD.
Monitoring and maintaining the production instance.
Supporting and maintaining RAC database.
Cloning RAC databases to single database using RMAN.
Giving support to functional & technical team for both TEST & PROD instance.
Project
Company Production Support
Injazat Data Systems (Net Solutions)
Client Mubadala Development Company – Abu Dhabi(UAE)
Role Oracle Apps DBA Consultant
Duration Feb 2011 to Jun 2012
Environment Sun Solaris, Linux x86_64, Oracle Applications R12.1.3
Database – 2 node RAC, Applications – 4 node
Description:
Upgraded Oracle EBS from 11.5.10.2 to R12.1.3
Production Support.
Configured Standby System for Oracle applications.
Performing regular refresh of TEST and DEV instances from PROD.
Monitoring and maintaining the production instance.
Supporting and maintaining RAC database.
Cloning RAC databases to single database using RMAN.
Giving support to functional & technical team for both TEST & PROD instance.
Project
Company Production Support
Injazat Data Systems (Net Solutions)
Client Musanada – Abu Dhabi(UAE)
Role Oracle Apps DBA Consultant
Duration Nov 2010 to Jan 2011
Environment Sun Solaris and Oracle Applications 11.5.10.2
Description:
Production Support.
Performing regular refresh of TEST and DEV instances from PROD.
Monitoring and maintaining the production instance.
Giving support to functional & technical team on both TEST & PROD.
Project R12.1.3 – Implementation
Client National Rehabilitation Center(NRC) – Abu Dhabi(UAE)
Role Oracle Apps DBA Consultant
Duration July 2010 to Aug 2010
Environment Linux and Oracle Applications 12.1.3
Description:
Installed new R12.1.1 Vision instance.
Installed new R12.1.1 CRP and PROD instances and enabled Arabic language.
Upgraded R12.1.1 instance to R12.1.3 by applying the Release update pack.
Project Production Support
Client Masdar – Abu Dhabi(UAE)
Role Oracle Apps DBA Consultant
Duration June 2010 – July 2010
Environment Sun Solaris and Oracle Applications 12.1.1
Database – 2 node RAC
Applications – 4 node
Description:
Monitoring and maintaining the production instance.
Performing regular refresh of TEST and DEV instances from PROD.
Configuring and troubleshooting printers in Oracle applications.
Giving support to functional & technical team for both TEST & PROD instances.
Project R12.1.1 Implementation
Client Waha Capital – Abu Dhabi(UAE)
Role Oracle Apps DBA Consultant
Team Size 6
Duration Nov 2009 to Apr 2010
Environment Linux 5.3 and Oracle Applications 12i
Single node installation
Description:
R12.1.1 implementation and Post-Production Support.
Configuring Workflow notification mailer.
Configuring Printers at OS level and Oracle Applications.
Performing regular refresh of TEST and DEV instances from PROD.
Prepared automatic backup scripts for both standalone and EBiz Databases.
Prepared automated script to perform Oracle applications clone from PROD to other instances.
DBA alerts are configured to monitor the instance.
Giving support to functional & technical team on both TEST & PROD.
Patching, Monitoring and maintaining the production instance.
Prepared and scheduled scripts for automatic cold and hot backups.
Prepared script for automated clone.
Project R12.1.1 Implementation
Client National Factory for Glass Bottles – Riyadh(Saudi)
Role Oracle Apps DBA Consultant
Team Size 6
Duration Sep 2009 to Nov 2009
Environment Linux 5.3 and Oracle Applications 12i
Description:
Installed Oracle Applications R12.1.1 on Linux 5.3. It’s a Single node installation with 11g database and enabled Arabic language.
Project R12.0.6 Implementation
Client Birla Copper Plant, Aditya Birla Group - Dahej(India)
Role Oracle Apps DBA Consultant
Team Size 6
Duration Jun 2009 to Aug 2009
Environment IBM AIX 5.3 and Oracle Applications 12i
Description:
Installed Oracle Applications R12.0.4 on IBM AIX 5.3 server. It’s a Single node installation with 10g database. Upgraded Oracle Applications version from 12.0.4 to 12.0.6 and Database version from 10.2.0.2 to 10.2.0.4.
Project Apps Support - Maintenance and support of Oracle Applications/Databases
Clients Sierra Atlantic Software solutions
(Amli, AOC resins, Bigband Networks, COSI, Dynea, FormFactor, Genus, Heliovolt, Molecular Devices, Telex Communications, Singapore Food Industries (SFI))
Map Byte, Knowles, iControl
Role Oracle Apps Consultant
Team Size 8
Duration Mar 2007 to Jun 2009
Environment Windows, Linux, Sun OS, HP-UX, Oracle 9i/10g and Oracle Applications 11i/12i
Description:
Regular monitoring and checking the refresh status of standby databases.
Resolving the Lock contentions on production databases.
Refreshing of Database and Applications in regular intervals.
Applying patches using adpatch and opatch utilities.
Configuring Workflow notification mailer.
Delivering core DBA administrative tasks.
Working with RMAN to take the backups and restore the databases.
Support and maintaining RAC databases.
Monthly object growth report.
Addressing day-to-day issues.
Providing oracle access to the users.
Promoting change requests or code moves to production.
Monitoring and maintaining the database activities/issues.
Complete care of Application System Administrator activities.
Uploading and downloading entities using FNDLOAD and WFLOAD.
Incorporating Custom Programs, registration of new User, defining new Custom Application Top and Request Sets.
Raising, updating and monitoring different SR’s and involving in OWC session to analyze and resolve the issue quickly.
Monitoring auto generated mails and taking necessary actions if required.
Monitoring the mount point size limits and taking necessary actions if required.
Responsibilities
365x24x7 support to all the customers in the Shared APPS Support team.
Used to take up the P1 issues issued through a hot line number.
Involved in the upgradation of Oracle applications from 11.5.9 to 11.5.10.2 and 9.x databases to 10g.
Supported the customers with 10g Application Server environments, like OID, portal, Discoverer plus and viewer.
Performing patch analysis of patches recommended by Functional teams.
Applying patches in test instances and performs rigorous Testing and subsequently moved to the development Instance and same to PRODUCTION environment.
Used to attend the weekly and monthly status calls with the customer’s officials.
Cloning and Configuring Test, Development and UAT Instances from Production on a regular basis.
Personal Profile:
Full Name : Vishnumahanti Venu Kiran Kumar
Date of Birth : 30-July-1982
Email-Id : ****.***@*****.***
Present Location : Abu Dhabi (UAE)
Present Company : Mubadala Development Company (Sundus Consulting).
Primary Role : Oracle Applications DBA
Mobile No. : 971-*********
Contact this candidate