An accomplished Database Administrator with ** years experience in database administration and 6 years in SAP BASIS administration installation, systems analysis and design, coding, help testers create testing scripts and help supporting database solutions to improve functionality. Exhibits excellent analytical and inter-personal skills to interact with end users and other team members. Proficient in an assortment of technologies and proven ability to implement technologies that decrease costs, increase performance and positively affect the bottom line.

Technical Skill

Oracle 7-12c

SQL Server

HP-UX

Linux & Windows

Shell Scripting

SAP AP R/3 4.7

ECC6.0

EP7.0

Solution Manager 7.0

Peoplesoft

Various Java Applications in SAP and Redhat

SAP MDM

Enterprise Manager

PL/SQL

TOAD

Professional Experience

Ferguson Enterprises Inc. Newport News, Virginia

Application Administrator/SAP BASIS Adminstration December 2016- August 2018

Maintain, troubleshoot and worked with IBM Datastage environments, SOLR servers, Red Hat Datagrid, BPM and JON in various environments. Work with Oncall on a rotation basis and Maintenance weekend, F5 for the server Load balancing, installing and managing certificates, DBA’s bringing the average service time from 450ms to 70ms, and with Developers on issues with production issues. Deploy services in different environments and troubleshoot issues with the current production and nonproduction environments. Maintaining SAP XI and SAP ECC system.

Ferguson Enterprises Inc. Newport News, Virginia

Oracle Database Administrator/Peoplesoft Administrator June 2012 -November 2016

Prepared database performance adjustments, database security, and designing tables for service/application. Implemented improvements by working with system DBAs, and use trending analysis partnered with the development team working on identifying tuning opportunities to manage performance. Design database systems and make recommendations to improve the performance and efficiency of existing systems. Knowledge in installing and administering PeopleSoft Server elements like PeopleSoft Application Servers, Process Scheduler Servers, Tuxedo, Web logic Servers, PIA (PeopleSoft Internet Architecture), Application Messaging, Integration Broker, SQL server, application and technical issues, configuring Workstations, Application Server, Process Scheduler, Tuxedo, Web Servers, PIA, Report Repository, Report Nodes for PeopleSoft applications. Apply updates, fixes, and tools patches and upgrading tools to higher versions.

Ferguson Enterprises Inc. Newport News, Virginia

SAP Basis Administrator/Database Administrator August 2006 – May 2012

Primary basis administrator for ECC system and other modules like XI/PI, Solution Manager, SPM and BI application. Worked on various aspects of Security in ECC and PI modules. Used BRTOOLS extensively and supported various database aspects of projects, including monitoring and resizing Tablespace and managing backups. Staged environment in different modules and refreshed various systems from production to QA. Facilitated ECC system upgrades from Enhancement Pack 2 to 4 and fixed mixed issues using applicable SAP correction notes. Analyzed different logs and table locks and troubleshot connection to various API resources. Set up OSS connection as a fix and EWA Job on Solution manager, updated compliance weekly. Applied support packages and kernel update and performed client copy and client and related settings. Handled printer setup and troubleshooting. Installed Netweaver system and Sabrix application to move systematically from Netweaver to JBOSS. Monitored Java-based application using Wili Interscope.

Ferguson Enterprises Inc. Newport News, Virginia

Oracle Database Administrator March 2000 – July 2006

Responsible for Datawarehouse database and actively involved in Development of the datawarehouse with the size of 5 TB.

Primary database administrator for the High Jump Database and was actively involved in the implementation and go-live of the project.

Creating and supporting various databases and codes necessary for various projects.

Helped in creating supporting RMAN script.

Worked and developed code using PL/SQL and maintaining the datawarehouse.

Working with the ETL team to develop SQL Loader scripts and Automating the loading of the ETL jobs.

Responsible for the backup and restore of the databases.

Upgraded the database to various version and applying security patches.

Tuned various process which was taking a long time and got it works much faster.

Performance tuning with various other application like Peoplesoft, Datastage etc.

Projects

System Integration & Application Migration

Derived maximum benefit from information technology based on the current state of the art client/server technology blended with business operation & procedures suitable for the organization. Used Application System Integration for implementation of Enterprise Resource Planning systems.

Re-engineered and simplified processes (for example - Bill Receivable with Excise Invoice of Dispatch System, Bill Payable with Purchase Order & Material Receipt, etc.).

Generated delivery orders at corporate office were transferred to three other dispatching locations & excise invoices generated at three dispatching locations were also transferred to the corporate office and also booked into corporate F/A system using Oracle job scheduling & procedures.

Developed the Integration of Office Automation (i.e. MS-Office) Package with user data in client or in Oracle Server.

Generated application from various applications in different platforms (i.e. FoxPro, Clipper and Debase) and integrate into the final payroll which was in Oracle.

The data for the same used to be loaded into Oracle via SQL Loader.

Inquiry Processing & Order Acceptance.

Captured and projected Customer Inquiry and Market Demand and Intelligence.

Assist in the control and processing of the customer's Order Acceptance requirements to ensure prompt service to the customer.

Excise system to distribute finished goods to customer satisfying various statutory requirements.

Generate various MIS reports, enabling management to make strategic decisions. Also provide on-line capability to enter order details with product specification, delivery schedule, commercial terms, confirmation and subsequent release for production planning.

Integrate system with production reporting, capacity planning, delivery order processing & dispatch.

Financial Accounts: Satisfy organizational needs of this multi-profit center system and to migrate it from obsolescence (IBM-1401 & AUTOCODER). The data validation & timely reporting are the main components. The smooth migration & parallel run was done with the help IBM-1401 simulator available in RSTS/E. This system consists of about 200 programs & various modules (like Sales, Purchase, General Accounts, Costing, Banking, and Finance).

Online Accounts Receivable & Payable

Payroll

Delivery Order Processing & Multi-Point Distribution

Material Management System

Material Accounting

Created and maintained snapshots between two geographically different locations (Mumbai and Tarapur) via satellite. Connected two databases using a database link on two servers located in the same premises. Created and tested a sample online replication option for the Dispatch System, which was a machine critical application. Used the @job function to program update of a few rows in a table at various locations.

Contact this candidate