SHIVA. A
Mobile: 088******** Email:
acea2n@r.postjobfree.com
TECHNICAL SUMMARY:
o Oracle Apps DBA professional with 4.2 Years of experience as
maintenance and supporting Oracle Application instances and Oracle
Databases in different UNIX&LINUX platforms
o Experience in installations of Oracle Applications and Oracle Database
o Experience in up gradation of Oracle Database
o Hands on Experience in Platform migration.
o Administrating E-Business Suite 11i
o Monitoring and Troubleshooting of Apache, Forms, Conc. Manager,
Servers, and Database related issues
o Experience on administering and maintaining various AD utilities
o Experience on Application patching and database patching on production
and Non-production Instances
o Cloning of different production and non-production Application
Instances and databases using RMAN, Cold, Hot
o Sysadmin tasks like creating user, assigning responsibilities,
registering forms, creating responsibilities and menus
o Experience on administering concurrent managers
o Experience in monitoring and handling Table spaces
o Experience on various backup and recovery strategies like RMAN, Cold,
Hot
o Experience on R12
o Experience on RAC
o Self-motivated team player, highly motivated and professional team
player with an interest in working in a team environment and ability
to learn things quickly
o 24/7 support on both production and development databases
PROFFESSIONAL SUMMARY:
o Working with Century Link India (QWEST SOFTWARE SOLUTIONS) as an
associate ORACLE Apps DBA Consultant from Aug-2012 to till date.
o Worked with Southern water Pvt Ltd (UK) as an associate consultant
from Dec 2011 to Aug-2012.
o Worked with Barcode India Limited as an associate consultant from
April 2010 to DEC 2011.
EDUCATION :
o B-Tech from JNTU (2007).
TECHNICAL SKILLS:
Operating Systems : Enterprise Linux 4.0, 4.8, 5.0
Databases : Oracle 9i, 10g, 11g
Oracle e-business suite : 11i and R12
Utilities : RMAN, Export/Import, Data pump, TKPROOF
PROJECT 1:
Oracle E-Business Suite 11i & R12 support
Client : Century link India Limited (QWEST)
Designation : Sr. Software Engineer (Associate ORACLE Apps DBA
Consultant)
Environment : 11.5.10.2, 12.1.1, 12.1.3
Duration : Aug 2012 to till date
Client Description:
CenturyLink is the third largest telecommunications company in the United
States and is recognized as a leader in the network services market by
technology industry analyst firms. The company is a global leader in cloud
infrastructure and hosted IT solutions for enterprise customers.
CenturyLink provides data, voice and managed services in local, national
and select international markets through its high-quality advanced fiber-
optic network and multiple data centers for businesses and consumers. The
company also offers advanced entertainment services under the CenturyLink
Prism TV and DIRECTV brands. Headquartered in Monroe, La., CenturyLink is
an S&P 500 company and is included among the Fortune 500 list of America's
largest corporations.
Responsibilities:
o Responsible for the support and maintenance of the Oracle applications
Production and Non-Production Instances on Linux platform
o Troubleshooting Oracle Applications components like Forms, Apache and
Concurrent Managers
o Responsible for database health-check's and trouble shooting if
necessary
o Experience in database upgrade from 10.2.0.3 to 10.2.0.5 & 10.2.0.3 to
11.2.0.3
o Experience in Platform Migration with TTS Utility
o Adding an off cycle products using adsplice and registering them with
the Oracle Applications E-Business Suite
o Analyzed and applied applications patches and database patches in both
Production and Non-Production Instances
o Compiling invalid objects if any manually and also using adadmin after
patching
o Cloning of Oracle applications Instances from production to non-
production instances using rapid clone and database using RMAN and
cold cloning procedure
o Changing the apps passwords after cloning using FNDCPASS
o Maintaining and monitoring backups regularly
o Creating application user accounts and adding responsibilities
o Creating database users and giving database security by assigning
roles
o Adding a data files for a tablespace when tablespace reaches threshold
value
o Regularly monitoring Database Alert log
o Interacting with the customer to understand their requirements and
their Technical queries
o Technical Oracle S R Management &Coordination with Development Teams
PROJECT 2:
Oracle E-Business Suite R12 support
Client : Southern Water Private Limited (UK)
Designation : Associate Consultant
Environment : 11.5.10, 11.5.8
Duration : Dec 2011 to Aug 2012
Client Description:
Southern Water supplies fresh, quality drinking water to almost one million
households and treats and recycles wastewater from nearly two million
households across Sussex, Kent, Hampshire. They are owned by Greensands
Investments Limited, a consortium made up of pension and infrastructure
funds.
Responsibilities:
o Responsible for the support and maintenance of the Oracle applications
Production and Non-Production Instances on Linux platform
o Performed the Cloning of oracle applications instances from prod to
test and dev using rapid clone utility.
o Patching of oracle applications using AD Patch.
o Monitoring the Concurrent Manager & its operations like starting,
stopping the concurrent managers & troubleshooting problems, viewing
the log/out files for resolved the issues of concurrent requests.
o Maintaining and supporting Standby Database using Data Guard
o Supporting SSO related issue
o Migrating the data from Production to Development using FNDLOAD.
o Deploying Workflow data using WFLOAD.
o Managing passwords of apps and Product passwords using FNDCPASS.
o Monitoring the Application System with Oracle Applications Manager
(OAM).
o Supporting development teams, general troubleshooting & Support in
administration of production & test instances.
o Performed Tracing of various User sessions, Forms sessions and
Concurrent programs.
o Interacting with Oracle support for technical assistance.
o Monitoring table spaces for space usage and adding required space
whenever it reaches threshold and also monitoring alert log file for
errors.
o Creation of application user accounts and assigning the
responsibilities.
PROJECT 3:
Oracle E-Business Suite 11i support
Client : BarCode India Limited
Designation : Apps DBA Consultant
Environment : 11.5.10.2, 10.2.0.4
Duration : April 2010 to DEC 2011
Client Description:
BCIL has been in the field of offering solutions in Enterprise Mobility and
Automated Identification and Data Capture (AIDC) and has experience in
Enterprise Mobility, Bar Coding, Wireless and RFID technology. We have rich
experience in technology consulting, domain knowledge of key market
verticals, deep understanding of supply chain across verticals and system
integration. BCIL has emerged as leading player in the field of Enterprise
Mobility Solutions and has maintained its leadership position in the
market.
Responsibilities:
o Responsible for the support and maintenance of the Oracle applications
Production and Non-Production Instances on Linux platform
o Troubleshooting Oracle Applications components like Forms, Apache and
Concurrent Managers
o Involved in database upgrade from 9.2.0.6 to 10.2.0.4
o Adding an off cycle products using adsplice and registering them with
the Oracle Applications E-Business Suite
o Analyzed and applied applications patches and database patches in both
Production and Non-Production Instances
o Compiling invalid objects if any manually and also using adadmin after
patch
o Cloning of Oracle applications Instances from production to non-
production instances using rapid clone and database using RMAN and
cold cloning procedure
o Changing the apps passwords after cloning using FNDCPASS
o Maintaining and monitoring backups regularly
o Creating application user accounts and adding responsibilities
o Creating database users and giving database security by assigning
roles
o Adding a data file for a tablespace when tablespace reaches threshold
value
o Regularly monitoring Database Alert log
o Interacting with the customer to understand their requirements and
their Technical queries
o Technical Oracle S R Management &Coordination with Development Teams.