We provide IT Staff Augmentation Services!

Oracle Dba Consultant Resume

5.00/5 (Submit Your Rating)

Exton, PA

SUMMARY:

Experienced consultant providing technical support expertise on SAP and ERP Applications and have extensive experience in designing, developing and supporting integrated IT solutions.

  • Worked on a wide range of technical aspects of installation, configuration, infrastructure development, support and customization of all layers of the SAP n-tier architecture
  • Experience in setting up of SAP landscapes, Central user Administration, and transport management
  • Worked proactively to identify and troubleshoot technical issues involving the SAP systems.
  • Worked extensively on performance monitoring and tuning on SAP Applications and Oracle databases
  • Worked on solution manager and configured maintenance optimizer, service desk with change request management configuration
  • Involved in opening service connections integrated with service desk to handle SAP support message, Sap router ACLS, secure access management and applying correction notes and fixes
  • Worked with functional teams to develop role based security profiles, monitor security and authorization violations. Created Batch jobs report variants, identifying controls, generating access review reports and security reports for user access
  • Worked on ALE configuration, IDOC/EDI, RFC support services for SAP/R3, NW04S, BW, XI and EP
  • Expertise in Enterprise Portal administration, configuring ESS/MSS, SNC/SSO, monitoring and troubleshooting portal system by using J2EE admin tools
  • Familiar with RunSAP methodology and ASAP implementation, technical project plan development, infrastructure assessments, test management, and post-implementation knowledge transfer
  • Proficient in Installation and configuration of MDM server, console, Import manager, data manager, Import and syndicate server, and knowledgeable in integrating MDM with other SAP components
  • Supported Basis/NetWeaver administration, performance monitoring, tuning, transport management, security administration, version upgrades, Unicode and OS/DB migrations
TECHNICAL SKILLS:

OS

UNIX Solaris 2.6-10, HP-UX11, VX/VE, DEC UNIX, AIX5.3, RHEL4x/ Advanced Server 2.x, SUSE9, Windows NT/2003/XP/Vista, VERITAS vxfs/VM/netbackup 3.x, Sun E class servers, HP9000, IBM RS/6000, DEC Alpha, Data General - Aviion servers, Control Data - CYBER 830/930 NOS/VE, and Intel based servers

RDBMS

Oracle RDBMS 11g/10g/9i/8.x/7.x, DB2, MySQL and MS Server 2005

ERP Apps

SAP MII rel12, Shop floor DB integration, NW04s(ECC6, SolMan4, SRM, CRM, BI, XI/PI), SAP R/3, ECC 5/6.0, SCM, ITS 620/640, SAP APO 3.0A/4.0, SAP Workplace 2.10/ 2.11, SAP Knowledge Warehouse 5.0/5.1/6.0, SAP Enterprise Portals 5.0/6.0, Oracle Applications 10.6/10.7, peoplesoft6/7, PeopleTools

Installation & configuration

SAP ERP/BI/CRM/SCM servers- R/3 3.1H, 4.0B, 4.5B, 4.6C, 4.6D, 4.7 IDES, SAPGUI, SAPHELP, ITS620/640, Business data warehouse (BW) 2.0B /2.1C, SAP CRM 3.0A/4.0, EP6.0, XI, TREX, SCM, SAP Knowledge Warehouse 5.1, Solution Manager 30/3.1/3.2/4.0

Networking

TCP/IP, DHCP, NFS, NIS, DNS, WINS, IIS, SAN, LDAP, SSH/SNC/SSO

Tools

MSCS, WMS, Vertex/SABRIX/MQ, SAP CCMS, PFCG, SAPDBA, BRTOOLS620/640, Migration Monitor, CATT, BMC Patrol, RAC, Data Guard, OEM, RMAN, Quest Central, Foglight, TOAD, Erwin and SQR, SQLDeveloper/Navigator, SQL*Plus, pro*c, Java, C, C++, Pascal, COBOL, Fortran etc.

WORK EXPERIENCE:

Senior Basis/Oracle DBA Consultant, Confidential,Exton, PA 08/11 to 4/12

  • Supporting and resolving the SAP MII, Solman7 and shop floor database migration to 11g2
  • Resolved oracle database upgrade from 10g to 11g and related issues with oracle 11g2 and patches

Senior Basis Consultant,Confidential,Dubuque, IA 05/10 to 04/11

  • Worked on Blue Harmony project for supporting SAP Application Upgrade and Unicode migration of SAP R/3 landscape to ECC6 - technical upgrade preparation, sizing and support upgrade phases
  • Performed SAP daily monitoring and maintenance – opening support connections, applied critical sap notes, support package application, kernel and executable upgrades,
  • Performed oracle database upgrade include oracle 11g2 release installation and apply patches

SAP Basis Consultant, Confidential,Houston, TX 11/08 - 03/09

  • Upgraded oracle 9i to 10g in MSCS cluster Fail-safe environment for Unicode conversion
  • Participated in non-Unicode conversion 4.6C to ECC6.0 Unicode

SAP Basis Consultant,Confidential,Hauppauge, NY 04/08 - 09/08

  • Participated in project plan preparation and run prepared upgrade plans for SAP R/3 4.6C to ECC6.0 include setup a new SLD on sandbox with data from production and integration testing and sizing
  • Resolved solution manager configuration issues, maintenance optimizer/support packs issues
  • Upgraded SAP R/3 system from 4.6C to ECC6.0 and covert from MDMP languages to Unicode

SAP Basis Administrator, Confidential, Wilmington DE 11/07 - 03/08

  • Worked on WMS technical upgrade preparation, sizing, integration and upgrade phases
  • As a technical team member, participated in designing the landscape, transport strategy planning, and maintenance of the upgrade path on ECC6.0 implementation project

SAP Basis/Database Consultant, Confidential, Houston, TX 05/07 - 09/07

  • Working on production support and upgrade project for SAP environment from 4.6C to NW04s
  • Participated in configuration of SolMan4 with ECC6.0 server to aid testing, setting up of test-clients, populate master & customization data for manual and regression testing

SAP Basis Consultant, Confidential, East Hanover, NJ 10/06 - 04/07

  • Participated in new landscape design and upgraded SAP R/3 4.6C to ECC6.0 include setup a new sandbox and integration testing with third party tools
  • Upgraded Vertex Sale Tax (VSUT) database 2.1 to 3.1 in oracle 10g and configured SAP Applications.
  • Worked on Kernel upgrades, Tuned R3/database buffers and shared memory parameters
  • Involved in the upgrade of oracle 8i to 9i and 9i to 10g for non-Unicode to Unicode conversion

Contractor, Confidential,Wilmington, DE 03/05 - 08/06

  • Involved in Basel II project batch jobs development, scheduling and tuning for large data set loads
  • Supported tuning, troubleshooting and problem diagnosis to improve the overall application response
  • Documented the tasks according to regulation and standards, worked closely with authorizations
  • Performed kernel upgrades, system copies, and configured security profile generator
  • Resolved large dataset loads and production issues related to BW and Oracle 10g Database

Database Administrator, Confidential,Wilmington, DE 05/04 - 09/05

  • Worked on DELTA project and upgraded OS/database to 9i and integrating with PeopleSoft and other third party packages
  • Setup Oracle 9i for Unicode and porting data from mainframe data sets and third party tools
  • Created XML data sets to ease production integration and created data extracts for future migration
  • Helped DW/BI architect in meta-data creation, data modeling, data mining and Dimensional Modeling
  • Participated and Proficient with performance tuning to handle ETL of large table/index partitioning
  • Resolved technical issues during process of decommissioning legacy systems master data management, data migration, data cleansing and BW porting to low cost storage

Oracle Database Administrator, Confidential, Bedford, MA 10/02 - 04/04

  • Performed the Phase3 database recovery, security support, installation, configuration, and day-to-day activities of the entire STN landscape
  • Supported database upgrades, performance tuning, troubleshooting to improve the overall application response
  • Upgraded Oracle database 8.0.6/8.1.7 to 9i and DR solutions

Technical Consultant, Confidential, Morristown, NJ 09/01 - 06/02

  • Worked on proof-of-concept projects and performed research on new technologies
  • Participated in SLD architectural design, sizing, installation, configuration of learning system
  • Configured Transport Domain Controller and Transports import setup
  • Worked on administration of the database including backups, Performance & tuning
  • Configured the Application servers for system Monitoring, Kernel upgrades

Technical Consultant, Confidential, New Castle, DE 07/99 - 08/01

  • As system administrator and worked with developers on performance tuning and optimizing, crash dumps analysis on the Information security infrastructure servers farm.
  • Assisted lead architect at the architectural review and approval process and integrated third party security and application products, configured, setup and maintenance support
  • Participated in COB/DR planning, design, development and testing, and resolved the recovery issues
  • Analyzed Performance issues and implemented system tuning fixes to overcome system bottlenecks

Oracle Apps DBA, Confidential,Chicago, IL 12/98- 05/99

  • Upgraded Oracle APPS and integrated third party payroll application
  • Worked on documentation and conversion of custom Reports to report 2.5 and registered in Application object Library and attached them to the report group
  • Developed shell scripts to automate the job schedule for backups, concurrent managers and listeners

Technical Consultant, Confidential, Journal Square, NJ 08/98 - 11/98

  • Developed shell scripts to generate reports for the management of auditing and accounting of NFCS
  • Worked on backup, recovery procedures and automated jobs, and resolved log errors reported from third party applications

Manager MIS, Confidential,Visakhapatnam 05/95 - 07/98

  • Worked as Manager MIS and implemented Floating Staff Claims Settlement system, Payroll Wage revision, and many other applications include MMS, SMS, based on Oracle applications
  • Streamlined Data center Operations, backup, recovery procedures and automated jobs, and resolved errors reported from third party applications

EDUCATION:MBA

CERTIFICATIONS:

SUN certified Unix system administrator, SUN certified Network administrator, Oracle 9i Database administrator Certified Associate Oracle 9i Database administrator, Certified Professional SAP Certified Technology Consultant, SAP NetWeaver ‘04 – OS/DB migration for SAP Systems, SAP Certified Application Associate HANA 1.0

We'd love your feedback!