SUMMARY

• Highly experienced, well - educated, senior SAP Certified Consultant, demonstrating 15+ years of experience in Information Technology.
• Creative, highly energized professional with outstanding communication skills and visionary problem-solving ability.
• Meticulous organizer, who handles multiple tasks simultaneously, pays careful attention to details and follows through to completion to meet deadlines.
• Team player who willingly accepts new challenges and increased level of responsibility.
• Ability to prioritize and meet deadlines in demanding fast-paced environments.
• Strong communication, organizational and problem-solving skills.

PROFESSIONAL EXPERIENCE

Confidential

SAP HANA Consultant/Architect

Responsibilities:

• Administrating/Architecting solution and support large number of SAP HANA databases for SAP Hybris application.
• Successful migration of customer Oracle databases to SAP HANA using SDI.
• Build and deploy SAP HANA environments on Linux virtual machines.
• Setup and deployed SAP HANA Cockpit to monitor and administer large number over 2000 of SAP HANA databases.
• Created and setup database health check scripts for monitoring and sending alert for any issue.
• Build self healing solutions for recurring issues such as filesystem space, Out of Memory, blocking locks situations and others.
• Analysis and trouble shooting of performance issues and prepare RCA.
• Build automation process to generate daily, weekly, and monthly HANA database performance statistical reports to maintain high availability.
• Analyze load during different promotional events and allocate/deallocate resources accordingly.
• Build standard operations processes for L1, L2 teams to perform day to day operations.

Confidential

SAP DBA

Responsibilities:

• Managed and supported Oracle databases for SAP systems.
• Upgraded Oracle databases from Oracle 11g to Oracle 12c for SAP ERP Systems.
• Setup database infrastructure. Install database server software and related products and build databases. Setup/build and configure Dataguard (Standby databases) for disaster Recovery.
• Monitor and tune database performance issues. Troubleshoot database performance issues using UNIX/Linux tools such as top, nmon, vmstat, iostat and Oracle Enterprise Management tools such as AWR, ADDM, and ASH to determine the root cause of the issue.
• Document performance and space related charts for capacity planning.
• Performed and managed database backup/restore using Oracle RMAN / BRBACKUP/ BRRESTORE. Development UNIX/Linux shell scripts to perform database backups on daily, weekly, and monthly basis.
• Performed database re-org on SAP Oracle database to release 1.5TB diskspace.
• Managed space and segments using BRTOOLS. Perform table/tablepace re-org.
• Participate in SAP system copies / refreshes by performing Oracle database cloning (using Oracle RMAN) or restore database backup.
• Manage SQL Server databases. Perform backup/recovery of SQL server databases
• Worked on SQL Server upgrade project to upgrade SQL Server 2000, SQL Server 2005, and SQL Server 2008 database to SQL Server 2012.

Confidential

SAP DBA

Responsibilities:

• Successfully migrated Customer SAP systems from Oracle database to SAP HANA using DMO/SUM.
• Successfully migrated customer SAP systems from Solaris to Linux platform.
• Successfully migrated customer SAP systems from Oracle Non-RAC databases to Oracle RAC on Linux.
• Perform SAP administration tasks such as installing and upgrading SAP, applying support packs, applying kernel upgrades, installing third party software, interfacing with SAP and participating in problem resolution.
• Manage SAP HANA database using HANA studio. Manage filesystem space on Linux servers. Manage backups of HANA databases. Create user access and managing security in SAP HANA database
• Performed SAP system copies and SAP refreshes.
• Build Red Hat/ Suse Linux server to setup Oracle databases. Install Linux RPM, create oracle, grid user accounts, and groups, modify configuration files and setup Kernel parameters required for Oracle software installation.
• Build new database infra-structures. Install Grid Infrastructure / Clusterware (RAC), database server software and related products. Setup, configure standby databases using Oracle Dataguard, replication using Oracle Streams/Goldengate, ASM for data storage and RMAN for backup and recovery.
• Monitor and tune systems and database performance. Troubleshoot Oracle database performance issues using UNIX/Linux tools such as top, nmon, vmstat, iostat and Oracle Enterprise Management tools such as AWR, ADDM, and ASH to determine the root cause of the issue.

Confidential

ORACLE DBA

Responsibilities:

• Ensure high level of database availability and all related services such as Oracle RAC, ASM, Oracle streams and Data Guard.
• Setup new database infrastructure. Install Grid Infrastructure / Clusterware (RAC), database server software and related products. Setup, setup and configure Oracle Dataguard, replication using Oracle Streams, ASM for data storage and RMAN for backup and recovery.
• Apply Oracle patchset/PSU.
• Monitor and tune database performance issues. Troubleshoot database performance issues using UNIX/Linux tools such as top, nmon, vmstat, iostat and Oracle Grid Control and Oracle tools such as AWR, ADDM, and ASH to determine the root cause of the issue.
• Define database backup/restore procedures using RMAN and TSM. Manage database backups and perform recovery. Participate in DR exercise twice a year to validate recovery procedures.
• Prepare documentation and baselines. Analyze gap assessment and create road maps to overcome those gaps using Oracle best practices.
• Monitor and maintain database security. Co-ordinate with Security administrator in adding, maintaining, and removing users account, administering quotas, auditing, and checking for security issues. Maintain audit data in database or as operating system audit data.