Applications DBA
Resume:
Venkat Puli
Oracle **i Applications DBA Consultant
***********@*****.***
Professional Summary:
• An Oracle certified professional (Oracle 10g, 9i Database Admin) who is team-oriented, flexible and result-driven that has already managed a fairly-sized group for implementing complex I.T. systems
• Over 8 years hands-on experience in Oracle 11i Applications Database Administration
• Specific expertise in Upgrades, migrations, applying patches by using ad utilities, Cloning/refreshes and Troubleshooting, End user support of applications powered by Oracle systems
• Experience in RAC implemented system and 10g DB upgrades and tech stack upgrades
• Experience in a variety of industries: government, manufacturing, distribution, telecommunications, supply-chain and finance (banking and insurance)
• Extensive knowledge and expertise in using various Oracle technologies to effectively implement an end-to-end solution to an organization’s strategic goals and objectives including: Oracle 11i E-Business Suite, Oracle Discoverer, Oracle Application Server (9iAS, 10g) and Oracle PL/SQL and SQL and Oracle RDBMS (Oracle8i, 9i, 10g), Oracle Developer (Oracle Forms and Reports Developer)
• Experience in database installation, configuration, development, security implementation, back-up and recovery (Oracle import / export utility, SQL* Loader) and performance tuning by using SQL Trace / TKPROF / Explain Plan.
• Experience in supporting medium (GB size range) to very large databases (TB size range) in a 24x7 support environment (on-call, night-shift)
• Performed Applications DBA activities on different platforms like Red Hat Linux, HP-UX, Sun Solaris 2.7,2.8 and 5.10 and Windows (NT, 2000,2003 and XP)
• Supported machine critical applications/databases in financial & manufacturing sectors
• Good knowledge in all departmental functional activities of manufacturing sector
• Hands on experience on writing SQL queries, PL/SQL procedures, Functions, Triggers in Oracle server and database testing
• Strong interpersonal skills, ability to interact with people at all levels good communication and presentation skills
ORACLE CERTIFICATIONS:
1. Oracle 10g Database Administrator Certified Professional
2. Oracle 9i Database Administrator Certified Professional
3. Oracle 11i Install Patch and maintain Applications
4. ITIL certified for Service Industry
TECHNICAL SKILLS:
Operating Systems: Red Hat Linux, HP-UX ,Sun Solaris 2.7, 2.8 and 10,
Windows (NT, 2000,2003 and XP) and MS-DOS
Databases: ORACLE8.x, 8i, 9i,10g and Forms/Reports (D2k),
MS Access (97,2000)
Scripting Languages: Java Script 2.0 and VB Script
Reporting Tools: Crystal Reports 8.0, Data Reports
Web Technologies: HTML, DHTML
GUI Technologies: Visual Basic 6.0
Office Tools: MS Powerpoint, MS Word, MS Excel and
Adobe Photoshop 6.0, PageMaker 6.5
SKILLS SUMMARY:
Patching, Cloning and Autoconfig
Database Design/Implementation
Technical Analysis
Performance Tuning by using Explain Plan and Tkprof utility
Resolved user problems, recovered database on demand
Good knowledge in departmental functional activities.
SKILLS/TOOLS:
Oracle Application Manager (OAM), Oracle Enterprise Manager (OEM)
ORACLE 8i, 9i implementation, admin, tuning
PL/SQL, SQL * Loader, Export, Import and SQL*Plus, TOAD, KINTANA, ASM
UNIX installation, configuration
Windows 2003 Server, build, install, configure
HTML, JavaScript
Access, ODBC, NT
WORK EXPERIENCE:
Client: Sun Microsystems Inc., Mar’2008 to Till date
Role : Sr. Oracle Applications DBA Location : Broomfield, CO Team : Sun IBIS
Project Description:
All the Environments are in 11.5.10.2 and a 10.2.0.4 implementation and this environment has a 4 node RAC with a 4 node PCP configuration. This contains 10 middle tiers for internal users and another 10 for external users, standby setup for all the instances with Solaries operating system release 5.10
Responsibilities :-
• Maintenance of installed Oracle Applications and supporting multiple production,development and test instances of varied complexity including multiple tier, PCP and RAC environments
• Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and Memory tuning. Checking Alert Logs, Archive Logs, Trace files and to work proactively on alerts for the file system and cpu issues.
• Space management, adding datafiles/resizing datafiles
• Analyzing tables and schemas
• Code promotions
• System administration activities such as creating executable, programs, request sets and attaching program to request group.
• Interacting with Functional Consultant to tune the sql queries in Custom Applications to improve the performance
• Application of apps and database patches.
• Upgrading oracle applications from 11.5.10.2 to R12
• Participate in critical issue meetings, co-ordinate development efforts across all modules in e-business suite
• Configuration changes which includes changes of files for various components of Oracle Applications for example database (init.ora) Apache(httpd.conf,jserv.properties,jserv.conf) and forms(appsweb.cfg)
• Cloning of Oracle Applications
• Database backup and recovery using RMAN.Written RMAN scripts to perform automatic full and incremental backup. Tuned backup for performance by parallelizing channel allocation. Performed complete and incomplete recovery using RMAN.
• Troubleshoot problems with web server, web listener, forms server concurrent managers, workflow and database.
• Orcle Data guard and DR has been implemented in this environment
• Handling SSO and OID issues
• Handling Discoverer issues
• Performing of all cutover tasks needed for go-live of production instance.
• Generating tkprof Report with Explain plan for analysis
Client: Oracle Corporation April’2006 to Feb’2008
Role: Oracle Applications DBA Location : Hyderabad, India Team : OOD
A member of Oracle OnDemand Operations, who supports more than 500 customers, where customer logs TAR/SR, regarding their problem, we need to work out and give the proper solution to the customer, I performed jobs under Change Management, Release Management and upgrade teams.
Responsibilities :-
• 11i DBA support : Responsible for patching of Oracle Applications instance and its maintenance
• Applying Apps, RDBMS patches and tech-stack patches and used lot of techniques to reduce the patching downtime
• Managed system configuration using Autoconfig
• Upgrading oracle applications
• Performing pre-patch analysis and pre-config analysis
• Apps system administration
• Managing application user accounts and responsibilities and database user accounts
• Experience of handling cluster and critical customers
• Attending calls with customer and took feed back of the system performance
• Attended Criticcal CPU patching, Mass patching and DST patching
• Datafixes and cemli code promotions
• Bouncing the instance as per customer requirement
• Monitoring the instance
• Worked as a shift lead in pre patch analysis and patching team
• Organizing team meeting and co-ordinate with other team leads
Project: Hartex Groups, Nov'2001 to Mar’2006
Role : Oracle DBA and Applications DBA Location : Hyderabad, India
Hartex Groups (http://www.hartex.in )
Hartex Groups having multiple business, Software development, Textiles, Export/Imports, Construcation works and manufacturing of rubber etc., All Unit of Hartex groups are certified on standard of ISO 9001:2000. Mainly we are concentrated on manufacturing of Cycle tyres and tubes. All Units commenced commercial production in a record time and its product carrying HARTEX Brand got established in the international market for superior quality and reliability. The production has since increased substantially and in 2003-04 has reached 12 million Bicycle Tyres and 8 Million Bicycle Molded Tubes. Hartex has also commenced production of Nylon Tyres and Butyl Tubes in various sizes and patterns, since 1995. Currently the Capacity for Nylon Tyres is 5 Million and for Butyl Tubes is 3 Million per annum. Hartex has largest manufacturing Cycle Tyres & Tubes industry in south India, turnover of 160 cores and Hartex groups turnover of 280 crores.
Single Oracle Application Database with two-node configuration running on v11.5.9 accessed by many users of the Company. All financial & Manufacturing modules such as GL, AR, AP, PO, INV,BOM & WIP etc., have been integrated into one single instance powered by Oracle 9.2.0.5
Responsibilities :-
• Install and maintain Oracle Applications in complex environments such as Single-node and multi-node installations.
• Upgrade of Applications from 11.5.9 to 11.5.10 on test servers successfully.
• Applying latest releases of the patches from Oracle to the instance to resolve few applications issues.
• Cloning the instances from production to test, development instance to test & simulate few technical challenges, coordinate with testing and development teams.
• Assist in managing databases from maximum performance under high load.
• Participate in a team to maintain & support for multiple oracle databases and applications in high availability (24 X 7) heterogeneous environment
• Work closely with teams including Applications development, database development, Oracle Support, and business community.
• Assist in developing, documenting, implementing and sustaining standard operation procedures.
• TAR reviews with oracle support personnel.
• Expertise in Database Backup strategies and scenarios
• Knowledge of automated stand by database implementation.
• Used SQL Loader, Export/Import and Database Links.
• Involved in time-to-time troubleshooting Oracle Databases.
• Solved problems like load balancing of temporary tablespace growing unlimited.
EDUCATION :
Master of Science in Computer Applications from Allahabad University, India
Contact this candidate