Sr. Apps Dba Resume
SUMMARY
- Has over Twenty years of I.T. experience out of which 15 years in Database installation, administration, design and development in the Oracle (7.0, 7.3, 8.0, 8i, 9i,11g,12c versions) on UNIX and Win NT Platforms, primarily in the Business Applications area. Has around 15 years of experience in administration of Oracle Apps 11i, R12.
- Expertise on various software and hardware platforms including Windows 95, HP UNIX, Sun OS 5.7 (Solaris 7), 5.8 & 5.9.
- Has in - depth knowledge of Oracle Applications 11i, Oracle 7.3.3, 8.0, 8i & 9i with Developer / 2000, Erwin 3.5.2, Advanced Replication, Partitioning and Oracle Certified Database Administrator for Oracle 7.3, 8.0, 8i & 9i. Has very good command over performance tuning of databases and applications.
TECHNICAL SKILLS
ERP: Oracle 10.7, 11i (11.5.8), 11.5.9,R12.1.3
RDBMS: Oracle 7.0, 7.3, 8.0.5, 8i, 9i,11i,12c, SQL Server 2000,SQL Server 2005
O.S.: Sun OS 5.7, 5.8,9,10,11, Win NT 4.0, HP UNIX 10.2, Windows 95,2000,10
Languages: C, SQL, PL/SQL, Pro*C, VC++
Hardware: Super Cluster, Exadata,Ultra 10, Sun E250, Sun E10K, PCs, UNIX WorkStations.
App. Server: Oracle Application Server 4.0.7, Oracle Web server 2.1, Apache 1.3.19, Weblogic Server 5.1,10.3.0.6, 12cGUI: Oracle Developer/2000 (Oracle Forms 5.0, Oracle Forms 6.0/6I, Oracle reports 3.0), Visual Basic 4.0
Tools: Erwin 3.5.2, Oracle Diagnostic pack, Oracle Tuning pack, Toad (Quest Software), PL/SQL Developer 5.1, Kintana, Quest Central
PROFESSIONAL EXPERIENCE
Confidential
Sr. Apps DBA
Environment: Oracle Apps 12.1.3, Oracle 11.2.0.4 RAC, OBIA 7.9.6.4, Solaris 10, RMAN, OBIEE 11.1.1.9, OAM 11.1.2.x, WebLogic 10.3.0.6, Informatica 4.x, 9.x
Responsibilities:
- Configure the LBR Setup with Shared APPL-TOP of Multi- Apps Node
- Configure the external Web Tier for iSupplier with reverse proxy
- Integrate EBS with Oracle Access Manager for SSO
- Migration of EBS DB from Solaris to Linux.
- Periodic application of Security Patches to the stack.
- Configure Concurrent Manager to run in PCP.
- Setup maintenance jobs for workflow cleanups, gather statistics etc.
- Install and Configure OBIEE 11.1.1.9.
- Applying patches, cloning of instances, JWS turning, Forms Code Signing etc
- Setup of Printers, Punch out, Users and responsibilities.
- Performance tuning and troubleshooting Concurrent programs.
- On-call support 24 x 7.
- Configuring the OEM to monitor the instances and set the base line metrics.
- Support for Release migration, Year End & Monthly closing.
- Troubleshooting the workflow and workflow mailer process and resolving it.Configured to use cloud email account. Segregate workflow mailers for PO separate from default.
- Setup / Configure SAS MI install and support daily activities.
Confidential
Sr. Apps DBA and SAS BI Support
Environment: Oracle Apps 11.5.9, Oracle 9.2.0.6, RAC, Forms 6i, Reports 6i, Kintana, Discoverer 4.x, Solaris 9, RMAN, Veritas Netbackup 4.5
Responsibilities:
- Migrated to the OATM Tablespace Model.
- Configure Concurrent Manager to run in PCP.
- Setup maintenance jobs for workflow cleanups, gather statistics etc.
- Install and Configure Discoverer.
- Upgrade the discoverer from 4.1.46 to 4.1.48
- Applying patches, cloning of instances (RAC to RAC and RAC to non-RAC cloning)
- Setup of Printers, Users and responsibilities.
- Performance tuning and troubleshooting Concurrent programs.
- Providing support for day to activities.
- Written the RMAN backups scripts and scheduled to perform backups.
- Resolving the blocking locks and identifying the bottlenecks queries.
- Support for the batch concurrent process.
- On-call support 24 x 7.
- Configuring the OEM to monitor the instances and set the base line metrics.
- Support for Release migration, Year End & Monthly closing.
- Troubleshooting the workflow and workflow mailer process and resolving it.
- Setup / Configure SAS BI install and support daily activities.
Confidential, Atlanta
Apps DBA
Environment: Oracle Apps 11.5.9, Oracle 9.2.0.4, RAC, Forms 6i, Reports 6i, Kintana, Discoverer 4.x, Solaris 9, RMAN, Veritas Netbackup 4.5
Responsibilities:
- Installation and setup of Oracle Apps
- Configuration and setup of Oracle Discoverer
- Applying patches, cloning of instances.
- Written the shell script to perform hot backups, startup / shutdown instances
- Performance tuning and troubleshooting
- Providing support for day to activities
Confidential, Tampa, Florida
Apps DBA
Environment: Oracle Apps 11.5.9, Oracle 9.2.0.5, Forms 6i, Reports 6i, Discoverer 4.x, Discoverer 10g, Siteminder, Oracle Portal 3.0, Solaris 9, 170 Markview, Kintana
Responsibilities:
- Applying patches through Kintana
- Cloning of Instance between Production, Test and Development
- Setup / Cloning of Imaging Servers (170 Markview Systems)
- Support the functional team on the technical issues
- Setup / Cloning of Constellar Hub Repository
- Resolving and closing the tickets
- Tuning of Concurrent programs