Oracle Database Administrator Resume
4.00/5 (Submit Your Rating)
PROFILE:
- 11 years of experience in IT industry with 10 years thorough experience in SAP consulting.
- Hands on experience in handling wide spread support with Change Management,
- Incident Management. Hands on experience towards Sap one cloud architecture projects, designing, planning and execution of system build.
- Performed multiple SAP Version/EHP upgrades, Unicode conversion, Oracle Database upgrades, Data center migrations, Hardware migration and Performance tuning.
- Good Knowledge and understanding with different Operating systems for SAP systems build with RAID Levels.
- Strong focus and planning towards proactive measures for SAP systems for monitoring alerts, defining and updating SLAS and coordinating with other teams for various checks towards SAP systems health checks.
- Good Knowledge towards ITIL V3 process.
- Good Knowledge and hands - on experience to handle SAP Hana Administration
- Knowledge and understanding towards GPFS in Hana database and to identify infrastructure issues.
- Good understanding towards Hana Services and Administration and operational procedures
- Hands on Drill down to Database errors and Diagnosis of problems and resolution
- Hands on Splitting tables which are crossed more than 2 Billion records or consuming more space on disk
- Hands on experience in handling Data Replications for SLT between SAP and HANA systems
- Hands on tuning HANA parameters with reference to sap notes and recommendations on recurring issues
- Currently involved in ERP Oracle to HANA project which in planning phase
- Hands on Force compressing tables in HANA
EXPERIENCE:
Confidential
Oracle Database AdministratorResponsibilities:
- Continues Improvement on SAP Systems Optimization techniques to resolve performance bottle necks and to Stabilize systems.
- Works closely with other teams ERP, SCM, PI, BW Logistics teams to resolve recurring issues.
- Handling of Day to Day HANA operational issues in productive support environments for EPR and BW systems
- Knowledge and understanding towards GPFS in Hana database and to identify infrastructure issues.
- Hands on Drill down to performance, database errors and Diagnosis of problems and resolution
- Hands on Splitting tables which are crossed more than 2 Billion records or consuming more space on disk
- Hands on experience in handling Data Replications for SLT between SAP and HANA systems
- Hands on tuning HANA parameters with reference to sap notes and recommendations on recurring issues
- Currently involved in ERP Oracle to HANA project which in planning phase
- Hands on Force compressing tables in HANA
- Hands on working with replication scenarios and performed annual disaster recovery exercise
Confidential
Oracle Database AdministratorResponsibilities:
- Responsible for widespread support, change management, planning and execution of technical changes in critical landscape which involves ECC with 50 Application Servers and 60TB Database, SCM Live Cache, PO, SLD, and Solution Manager with Oracle Database along with IBM 3rd party tools MB, MQ integrated with sap systems.
- Hands on experience for handling P1, P2 tickets within SLA and responding back with updates till closure of issue.
- Hands on experience for analyzing top growing tables and revealing the indexes quality and rebuilding for poor quality indexes
- Good knowledge towards work load analysis, background jobs and identifying bottle necks.
- Hands on experience for distributing Work load to Logon groups and using Round Robin techniques.
- Hands on experience for distributing RFC loads and setting RFC parameters for high interface loads for different business requirements.
- Responsible for identifying bottlenecks, tuning of Database instance and Memory parameters at application layer.
- Hands on experience towards JAVA architecture, tuning Application Threads, Thread Management, VM parameters, Load distribution between server nodes and monitoring PO systems under high interface loads.
- Good experience towards PO bidirectional SLD with Solution Manager.
- Hands on Monitoring and fixing issues in PO RWB, Adapter engine, Component monitoring, Communication channel Monitoring, Message Monitoring and monitoring NWA
- Hands on experience for handling SCM Systems under high interface load with Live Cache Database.
- Good knowledge and experience towards Live cache tuning
- Responsible for scheduling Technical performance optimization checks, reviewing EWAS and regular service checks of SAP systems.
Confidential
Oracle Database AdministratorResponsibilities:
- Responsible for offshore team deliverables and point of contact to customer
- Handling a team of 8 resources for 24x5 model
- Responsible for reviewing the current infrastructure and coordinating with onsite customer for continuous improvement
- Reviewing INCIDENTS and providing solutions for the offshore team coordinating with onsite mentors
- Responsible for the delivery of Monitoring and handling Incidents Globally of 60 systems and components includes ERP, BW, EP, PI, MDM, BO, BODS, SABRIX, FEDEX and Web console systems integrated to SAP landscape
- Responsible to coordinate with Global database team and Global Unix team for proactive measures and continuous improvement
- Hands on working with remedy tool for INCIDENTS and CHANGE MANAGEMENT process
- Responsible for Solution manager 7.1 landscape for installation and configurations of EWA and Solution monitoring
Confidential
Oracle Database AdministratorResponsibilities:
- Scope of project is Database tuning / Applying Oracle Software bundle patches / EHP Technical upgrades.
- Planned and performed Oracle patch upgrade from 10.2.0.2.0 to 10.20.5.0
- Performed Database tuning and O/S tuning with setting large pages formula for O/S level in for BI, EP and ERP.
- Performed ERP 6.0 EHP5 technical upgrade from ECC 6.0 SR2 for Sandbox, Dev, Qly & Prd involving components for Central applications and Human capital management
- Planned and performed Technical upgrade from BI 7.0 to BI 7.0 EHP2 on Sandbox, Dev, Qly & Prd systems
- Planned and performed EP 7.0 to EP 7.0 EHP2 on Sandbox, Dev, Qly & Prd systems considering ESS/MSS packages.
- Vedanta Aluminum Limited ( Confidential Solutions)March 2012 - May 2012
- Scope of project is Database tuning / Applying Oracle Software bundle patches / EHP Technical upgrades.
- Responsible for planning and execution of Database patching and EHP5 upgrade in a business critical environment for 6 SAP systems Sandbox, Dev, Qly & Prd and synchronizing DR1 and DR2
- Performed Kernel upgrade and Database tuning for complete landscape.
- Planned and performed oracle patching from 10.2.0.2.0 to 10.2.0.5.0 and updated Oracle bundle
- Planned and performed ERP 6.0 EHP5 upgrade with minimized downtime on PRD system
- Coordinating with functional team/Security remediation and mentors for post EHP5 upgrade approach and testing
Confidential
Oracle Database AdministratorResponsibilities:
- Planning for migration of SAP system to new hardware on HP IA64 processor architecture with ECC 6.0 and Oracle database 10.2 release
- Performed DEV and QLY systems migration
- Performed PRD system migration with Service guard for SAP on HP UX 11.31
- Tested failover/fallback strategies for PRD system using SG for SAP
- Responsible for Database tuning and post migration activities and monitoring
- Godavari Polymers ( Confidential Solutions) June 2011 - December 2011
- Scope of project is Implementation and post implementation support
- Involved in hardware sizing and 3 systems landscape design
- Responsible for End to End implementation with Microsoft cluster on PRD environment for DB2 High Availability
- Installed IDES EHP4 with DB2 9.7 fp3, Performed post installation activities
- Installed and configured Solution manager 7.0 EHP1 with post load activities on DB2 9.7
- Installed ERP 6.0 and performed EHP4 SR1 upgrade on DB2 9.7 fp3
- Responsible for all ongoing activities includes Client administration, STMS, Backups/Restores, Workload analysis, Application/DB tuning
- Responsible for Microsoft cluster and installing/upgrade ERP 6.0 software with proper failover/failback strategies
Confidential
Oracle Database AdministratorResponsibilities:
- Scope of project is Implementation and post implementation support for Enterprise portal NW7.0 EHP1
- Planning and execution of Enterprise portal 7.0 EHP1 implementation for 3 system landscape
- Performed installation and post installation of NW 7.0 EHP1
- Configured technical systems and updated SLD, Kernel upgrade, created JCO RFC connection to backend system
- Deployed ESS, MSS business packages and SAPJ2EE core components to full stack
- Configured single sign, maintained JCO connections for model data and meat data for required business packages and ADS configuration
- International Fragrance and Flavors ( Confidential ) November 2010 - February 2011
- Scope of project is to perform Technical upgrade of CRM systems from 6.0 to 7.0
- Planning the technical upgrade strategy involving the timelines.
- Managed 4 team members of mid-level and junior level resources
- Coordinating with on-site SAP Basis team, mentor colleagues, enhance established processes
- Handled SAP CRM systems upgrade Sandbox, Dev, Qly & Prd from CRM 6.0 to CRM 7.0
- Handled post upgrade activities
Confidential
Oracle Database AdministratorResponsibilities:
- Planned & performed SAP systems migration from Gurgoan data center to Mumbai data center using R3load export/import & Backup restores.
- Planned & performed migration of ECC 6.0 DEV & PRD server from Gurgoan to Mumbai on clustered environment
- Planned & performed migration of BI 7.0 DEV & PRD server from Gurgoan to Mumbai
- Planned & performed migration of PI 7.0 DEV & PRD server from Gurgoan to Mumbai
- 24x7 environment & major challenge is to minimize downtime during migration
- Responsible for Kernel upgrade, Database tuning & Application tuning
- The timeline for the whole activity was very short and still accomplished the tasks within the deadline by migrating several systems in parallel on different servers and maintaining the accuracy
Confidential
Oracle Database AdministratorResponsibilities:
- Scope of Project MSSQL DB upgrades \ Migration to new hardware \ SAP Version upgrade from 4.7 EE to ERP 6.0 EHP4
- Planning of SAP systems migration from 32 to 64 bit architecture for entire landscape
- Database upgrade from MSSQL 2000 sp4 to MSSQL 2005 sp3 during migration
- SAP Version upgrade from 4.7ee Ext Set 1 to EPR 6.0 EHP4 for central applications
- 24x7 environment & major challenge is to minimize downtime during migration
- Hands on experience in Database & application with effective response times for 500 users
- Responsible for Application patches, Kernel upgrade & daily monitoring
Confidential
Oracle Database AdministratorResponsibilities:
- Planning of SAP systems migration from 32 to 64 bit architecture
- Planned & performed Oracle DB upgrade from 9i to 10.2.0.4.0 with minimum downtime in 24x7 environment
- Setting up of DRSERVER using oracle dataguard
- 24x7 environment & major challenge is to minimize downtime during migration
- Configured windows cluster & created cluster groups
- Planned & perfomed migration of SAP system from 32 to 64 bit in clustered environment
- Tuned Database & application with effective response times for 500 users and responsible for patches
Confidential
Oracle Database AdministratorResponsibilities:
- Planning the upgrade & Unicode strategy involving the timelines of multiple SAP systems
- Handled Upgrade & Unicode conversion of SANBOX from 4.6c to ECC6.0 SR2 of 1 TB
- Handled Upgrade & Unicode conversion of Development from 4.6c to ECC6.0 SR2 of 500gb
- Handled Upgrade & Unicode conversion of Quality from 4.6c to ECC6.0 SR2 of 1TB
- Handled Upgrade & Unicode conversion of Production from 4.6c to ECC6.0 SR2 of 1TB
Confidential
Oracle Database AdministratorResponsibilities:
- Planning the Installations & configurations involving the timelines of multiple SAP systems for ERP, BI and EP
- Installed & Configured SAP systems ECC, EHP4 for DEV, QAS & PRD with Suse Linux 10 SP2, Oracle 10.2
- Installed & configured EP 7.0 systems for DEV, QAS & PRD with Suse Linux 10 SP2, Oracle 10.2
- Installed & configured BI 7.0 systems for DEV, QAS & PRD with Suse Linux 10 SP2, Oracle 10.2
- Responsible for tuning JAVA stack & deploying patches, application patches
- Responsible for Basic/Initial and System Setup Configuration in Solution manager 7.0
- International flavors & fragrances ( Confidential ) September 2008 - April 2009
- Scope of Project is SAP Version upgrade from ECC 5.0 to ERP 6.0 EHP4 & EP 6.0 to EP 7.0 systems
- Planning the technical upgrade strategy involving the timelines.
- Coordinating with on-site SAP Basis team, mentor colleagues, enhance established processes
- Handled Sap HR systems upgrade Dev, Qly & Prd from ECC 5.0 to ECC 6.0 EHP4 SR1
- Handled Sap PLM systems upgrade Dev, Qly & Prd from ECC 5.0 to ECC 6.0 EHP4 SR1
- Handled Portal upgrade on JAVA stack Dev, Qly & Prd systems from EP 6.0 to EP 7.0 EHPI
- Performed lot of performance tuning tasks on SAP, Oracle DB & AIX
SAP Basis Support
Confidential
Responsibilities:
- Scope to plan & migrate SAP systems from 32 to 64 bit which also includes hardware migration.
- Handled ECC 6.0 systems Migration Dev, Qly & Prd from 32 to 64 bit.
- Handled SAP BI 7.0 systems Migration Dev & PRD from 32 bit to 64 bit.
- Workload Analysis and Performance Tuning of R/3 and BI Landscapes which includes R/3 memory tuning, DB shared memory tuning, Disk I/O load balancing
- Performed hardware migration of SAP Production system
- Identified exact Memory, I/O bottlenecks in AIX environment
- Hands on experience in tuning AIX with Oracle DB
- Patched, tuned, and troubleshot J2EE Engine 6.20/ 6.40 for XI environment
- Planned & Performed system refresh activities from Production to Quality
- Hands on working with clustered environment on HP-UX systems.
- Hands on experience in tuning HP-UX with Oracle for effective run time
- Being responsible for system monitoring and troubleshooting
- Planned & Performed systems refresh activities from Production to Quality time to time
- Completed In-house Training for SAP Basis Administration and SAP Workload Analysis and Tuning
- Responsible for tuning BI systems
- Performed kernel upgrades across the landscape R/3 & BI systems.
- Planned transaction log maintenance across the landscape
- Planned & Performed systems refresh activities from Production to Quality time to time and responsible for support
- Responsible for tuning DB2/UDB, AIX and continuous support
- Identified major bottle necks & tuned DB2 database
- Planned & Performed systems refresh activities from Production to Quality time to time
- Hands on experience in performing client export & import activities
- Being responsible for system monitoring and troubleshooting
- Performed DB2 patches & kernel upgrades
- Responsible for Hardware Sizing & 3 system landscape design.
- Planned and executed end to End implementation
- Installed & Configured SAP systems throughout the landscape for ECC 6.0 with Oracle 10.2.0.2.0
- Performed an Add-on of AFS 6.0
- Responsible for the application patches, kernel upgrade, and DB patches
- Configures SAP transport management systems & handled mass transports, Workload Analysis and Performance Tuning of database
- Responsible for Daily monitoring and Database backup’s
- Responsible for the application patches, kernel upgrade, and DB patches Workload Analysis and Performance Tuning of R/3 and BI Landscapes which includes R/3 memory tuning, DB shared memory tuning, Disk I/O load balancing