Oracle Software Engineer
Resume:
SHOAIB SYED
********@*****.***
Summary:
Over all Six years of experience as Oracle DBA / APPS DBA.
Oracle Application DBA and sysadmin activities and worked extensively in cloning,
patching.
Extensive experience in Installation, Migrations, Upgrades, maintenance and day-to-day
Administration capacities of Oracle Applications 11i and R12 instances.
Extensively worked on oracle 9i/10g/11g and planned and carried out Database.
Migration/Upgrade/Installation.
Expertise in Operating system Installation, configuration and managing OS groups and
Users and experience in UNIX sysadmin Activities.
Effective and efficient UNIX and scripting experience.
Cloning of the Applications using Rapid Clone and Ad clone.
Workflow mailer setup and configuration.
Possess exceptional analytical & problem solving skills, excellent communication and
interpersonal skills, worked independently as well as in team environments.
Technical Skills:
I) Oracle EBS Applications DBA
Installation/Configuration/Integration of Oracle 11i/R12 Applications / Databases / Appl
Servers on Oracle 10g/11g RAC / Multi-nodes / OS Hardware Clusters.
Cloning, Patch Management, Application Tuning and Management/Monitoring.
Providing advance level technical support, problem analysis/trouble shooting,
monitoring.
Manage / co-ordinate Oracle Application / Technical Service Requests (SR) to resolution.
II) Oracle Database Administration
Planning and implementing Oracle software installations, Database creations, upgrade
and migration.
Database Upgrade 10g/11g.
Database cloning and patching
Installed and managed 9i/10g and 11g database server
Involved in Capacity Planning, Space Management, Auditing, Roles and Privileges
control.
Experience with remote database administration. Exposure to Oracle Tools and
Techniques.
Employment History:
APPS DBA Needa Software Solution Pvt. Ltd., Hyderabad. (March 2009 till date).
APPS DBA NexEvolve Logic Solutions Pvt. Ltd., Hyderabad. (Feb 2008 to Feb 2009).
Software Engineer Zahra Technologies, Dubai, UAE. (April 2005 to Jan 2008).
Software Skills:
Oracle EBS Apps 11.5.10/2, R12 (12.0.4/6), (12.1.1 and 12.1.2)
Database : Oracle /9i/10g/11g Server.
Application Server : Oracle 9i, 10g AS, 10g Discoverer
Operating System : Sun Solaris, HP-Unix, Linux, Windows.
Case Tools : Sqlplus, TKPROF, SQL Loader, OEM, TOAD.etc….
INDUSTRY EXPERIENCE:
1) CXTEC (April 2010 – Present).
Cxtec: Cxtec Founded in 1978, CXtec is a value-added reseller that offers new and pre-owned
networking, voice and cabling technologies worldwide. CXtec now has its World Headquarters in
North Syracuse, New York, and its 70,000-square-foot (6,500 m2) Technology Certification and
Distribution Center in Syracuse, New York.
Environment: Linux, Oracle 9i, 11g, 11.5.9, R12, Discoverer, OEM, RMAN.
R12 (12.1.2) Multi Node with Oracle 11g on Red-Hat Linux 5.2 with DELL Server H/W.
Installation/Configuration and Integrating Oracle 10g Discoverer with Oracle R12 EBS.
Responsibilities:
Database upgrade from Oracle 9i to 11g.
Setting up and managing of Data Guard for 11g Production servers.
Setup and monitoring through EM 11g Grid Control.
Cloning applications using rapid clone and adclone.
Cloning databases using RMAN backups.
Monitoring 24/7 and managing PRODUCTION server, Production Support and Test
Application user creation / responsibilities assignment.
Managed and installed application patches. Working with Functional and Developer
team in issues resolution through metalink TAR and internal trouble Tickets.
2) ATMI Inc (March 2009 Present).
ATMI Inc: ATMI is a global leader in enabling process materials and process technology for
semiconductor, display and life science industries. At ATMI, process ingenuity unleashes new
process possibilities for customers. Since 1986, ATMI has developed capabilities including rapid
process development, high performance materials, ultra-clean materials utilization/packaging
solutions and global supply chain management.
Environment: Linux, Solaris, Oracle 9i, 10g, RAC, 11.5.10.2, PCP, ASCP and Data guard.
11i (11.5.10.2) Multi Node with Oracle 10g RAC for HAA on Red-Hat Linux 5.2 with DELL
Server H/W. Installation /Configuration and Integrating of ASCP with EBS.
Responsibilities:
Database upgrade from Oracle 9i to 10g.
Database platform migration.
Setting up and monitoring the Data Guard for 10g Production servers.
Managing PRODUCTION server, Production Support and Test.
Copy/Clone of Oracle application environment using Rapid clone and adclone.
Cloned Oracle database from RAC to RAC and RAC to Non RAC.
Cloning Oracle Applications 11i instances with RAC to RAC and Multi node to
Multinode as well as Non RAC and single node
Applying one-off fixes to Database Oracle Homes (both RAC and non-RAC) using
Opatch utility
Patch application to the production and non-production environment like Dev, SIT, UAT,
and QA.
Proactive monitoring of Database and Oracle Applications using Nagios tool.
Register custom applications, menus, forms, and programs through code migration
procedure using FNDLOAD.
Defined and configure Oracle Application printers. over 600 printers on a
PASTA Configuration.
Managed and installed application patches, working with Functional and Developer
team in issues resolution through metalink TAR and internal trouble Tickets
Extensive use of remedy BLT Tool for monitoring and troubleshooting of high and low
priority calls during the 24/7 Support.
Experience with Code Migration tool / Build deployment tool, to ensure Integrity and
Control, Between Development and Production Environments.
3) RASGAS (Aug 2008 – Feb 2009).
Rasgas: Rasgas is one of the premier integrated liquefied natural gas (LNG) enterprises in the
world. Rasgas has developed world class facilities for the extraction, storage, processing and
export of LNG and entered into long-term agreements to supply customers around the globe.
Environment: Linux, Oracle 9i, 10g, Application Server 9iAS, RAC, OEM
Responsibilities:
Install and maintain Oracle Applications in complex environments such as Single-node
and multi-node installations.
Applying latest releases of the patches from Oracle to the instance to resolve few
application issues.
Cloning the instances from production to Test, Development instance to test & simulate
few technical challenges, coordinate with testing and development teams.
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.
User Management and gathering statistics on Database Objects.
Monitored Hot and Cold backups.
Monitored the growth of table spaces to see the fragmentation and available space for
growth. Check for log and trace files.
4) Zahra Technologies (April 2005 to Feb 2008).
Zahra Technology LLC: Zahra is a well established Security and Communication company
with operations in the Dubai, Abu Dhabi & Northern Emirates. Zahra Security Systems
and Electricals which has the focus of its operations in Security System Solutions and Visual
Communication Systems.
Environment: Oracle Applications 11.5.10 / 11.5.10.2, 9i and 10g Databases, RHEL4 and
Windows2003.
Responsibilities:
Installed and implemented Oracle 11.5.10 on Solaris Server.
Testing the product under test database and do the required changes based on the user
feedback.
Interaction with Oracle Developers, to assist them in troubleshooting their problems
related to Oracle Applications and Oracle Databases.
Designed backup & recovery strategies for all Oracle Applications Instances Recovery
strategies include simulation of crash scenarios on a test system
Troubleshooting the Application, Concurrent managers, etc.
Cloning the 11.5.10 Applications and Database Production system in regular intervals
using Rapid Clone.
Co-ordinate TAR support for resolution of Instance Issues.
Responsible for analyzing the need for applying the patches to the Applications database
This also includes monitoring the users, concurrent managers, setting profile options,
identifying and resolving user issues.
Plan and schedule Application Instance Weekly Backups.
Plan and schedule regular Database backup and perform restoration drills.
Academic Qualification:
BE (Electronics and Communication Engineering) Passed in 2003 from Visvesvaraya
Technological University, (V.T.U) Karnataka. India.
Contact this candidate