Oracle 10g/11g, Oracle Applications 11i and R12, SQL Server, RMAN, OEM, Exp/Imp, Data Pump, Adadmin, Adctrl, Fndcpass, Autoconfig, Putty, Srvctl, Crsctl
Oracle Applications Database Administrator
From January 2012
Duration: Jan 2012 to till date
Sical Logistics Ltd. is India's leading integrated logistics solutions provider, providing end-to-end logistics solutions. Sical was acquired by Coffee Day group, one of India's fastest growing business conglomerates with interests ranging from coffee plantations and agri-businesses, commodity exports, stake holdings in leading IT and embedded technology companies, real estate and hospitality.
➢ Managed instances to be up and running in production environment
➢ Starting and Stopping all Apps services and troubleshooting if needed
➢ Cloning of Database and Applications from Production to Dev/ Testing
➢ Administered and maintained Oracle Applications using Ad utilities - adadmin, apatch, auto config, adrelink and adctrl etc.
➢ Responsible for Sysadmin activities such as adding forms, menus, functions and managing concurrent programs and requests, user registration and assignment of responsibilities to users
➢ Setting profiles and creating concurrent managers with different workshifts
➢ Applying patches for database and applications including one-off, mini packs, SPU and PSU patches
➢ Troubleshooting on Patching issues handling using Ad utilities, Post Clone issues, Apache troubleshooting, Concurrent manager issues and Login issues
➢ Performed patch analysis for patches involving lot of pre-requisites
➢ Monitoring cpu utilization, memory utilization, disk i/o
➢ Creation and sizing tablespaces and setting tablespace attributes
➢ Managing database backups and purging unwanted out and log files
➢ Gathering stats frequently and monitoring fragmentation of tables and tablespaces for better performance
resolving space management
From May 2010
➢ Having 3.4 Years of experience as Oracle Applications, Database and RAC Administration in IT industry.
➢ Efficient knowledge in installing Oracle E-Business Suite 11i and R12 on single node and multi node and has involved in configuration, maintenance, cloning, Patching of oracle apps in RAC environment
➢ Good experience in resolving space management and User management issues related to oracle applications. I have carried out various activities like maintaining instances, taking appropriate backups for security and consistency, performing schema refreshes, performing backups using cold/hot/RMAN methods and recovery techniques.
➢ Working as an Oracle Applications DBA for Monsoon InfoTech, HYDERABAD from May 2010 to till date
Oracle Apps DBA
Winsome Textile Industries LTD
May 2010 - December 2011
Winsome Textile Industries LTD is a fully imported plant with precision winder from SSM, dyeing vessels from Cubotex, hydro extractor from Galvanin & R/F dryer from Stalam. Develop any shade in Melange / package dyed / fiber dyed yarns here.
➢ Helping users while initial setup of application launch and resolved db Connectivity issues, Resolving yellow bar issue for users.
➢ Refreshing of various Databases from the production.
➢ Perform day-to-day database administration and ensure integrity, security, and availability of the database.
➢ Performed Cold & Hot Backups.
➢ Monitoring alert log and trace files, Managed archive logs, DB-links & Performed Media recovery.
➢ Monitoring table space size, resizing table space, relocating data files for better disk I/O.
➢ Resolved issues related to networking (listener & tnsnames).
➢ Proactive monitoring on system performance with the help of BMC alarms, alert monitoring and taking necessary action in case of any database locks etc.
Qualifications & Certifications
Skillpages has been acquired by Bark.com!
Bark.com is pioneering the way people find local services. Skillpages is the world’s premier directory of service providers.Find out more