We provide IT Staff Augmentation Services!

Senior Database Administrator - Sap Resume

SUMMARY:

An accomplished, IBM Certified Advanced Database Administrator and a Certified Administrator for Apache Hadoop with diverse technical background and proven success in designing and implementing database/non - database solutions to improve business efficiency and functionality.

TECHNICAL EXPOSURES

DBMS: DB2 LUW, MySQL, MSSQL, MongoDB, Oracle, Sybase, MS-Access, DBaseIII plus, DBaseIV, ADAPT, PL/SQL, SQL-plus, Oracle Forms, MySQL, Postgres SQL DBOperating Systems: Unix (AIX, SCO, Solaris), Linux, Windows, DOS

Web/App Servers: IPlanet, Apache, WebLogic, Websphere

Programming Languages: Perl, PHP, Unix Shell Scripts, Servlets, Java Beans (OO Design/ Development), JSP, Java GUI, C, Bullant, Clip, XML, Java Applets, CTL, Pascal and Cobol

Miscellaneous: Tomcat, Java Scripts, HTML, CSS, Director 5.0, Authorware 3.5, VP-Expert, Excelerator, Crystal Reports, Composer (developed by InfoComp), Capital, CVS, PVCS

PROFESSIONAL EXPERIENCE:

Confidential

Senior Database Administrator - SAP

Responsibilities:

  • Management of multi-terabyte SAP environment hosted in XIV storage, performance tuning, backups with TSM in VTL with NetApp Data Domain, capacity planning and recovery and 24/7 on-call support.
  • AIX performance tuning and monitoring
  • Successful Migration of over 26TB SAP Oracle to SAP DB2 with DB2 Adaptive Compression to mere 5.6 TB
  • MSSql monitoring and capacity planning, SSRS Reporting along with windows servers WMI/PHP with IIS dashboard creation to identify and resolve performance issues.
  • Enterprise SuSE Linux/CentOS linux administration and hosting
  • MySQL administration
  • Mongodb cluster setup for monitoring logs of SAP landscape and dashboard creation.

Confidential

Senior Database Administrator

Responsibilities:

  • Managing over 280 DB2 LUW environments hosted in IBM SAN used with products like PEGA Systems, Oracle Content Server (Enterprise Content Management-Stellent), Dialog, ESB (Enterprise Services Bus), TSM (backend DB2), Lotus Notes Connection, LDAP, Identity Management, Master Data Management and Multi node multi terabyte Linux Cluster with TSA for Enterprise Data Warehouse (BCU with DB2 DPF), Optim Performance Management on AIX 5,6 and 7.1, SUSE Linux.
  • Collaborated with Enterprise/Solutions Architects as a key technical person in architectural/solution designs of projects spanning from few million to over 60 million dollars.
  • Constructed database policies for upgrade & maintenance.
  • Proactively worked in performance tuning of production/non-production environments utilizing MDC, MQT, WLM, DB2 Event Monitor, REORGs, DB2 Compression and Table/Database Partitioning.
  • Managed upgrades, backups & recovery, and participated in Enterprise DR exercises.
  • Proactively worked in security and auditing of databases using DB2 role based security and db2audit. Have detailed understanding of DB2 LBAC.
  • Delivered capacity planning information through a self initiated module utilizing system snapshots like AIX NMON and DB2 Snapshots.
  • Contributed processes/tools to enhance productivity with systems like Remedy Change Calendar (PHP in WAMP connecting to Oracle DB), NADM (Perl DB2 LUW Crawler), DB2Eye (TCL/TK monitoring GUI with dashboard and SMS capability), NCAPP (Perl, Capacity planning module) and Power Search (A full text search based in Open Source & self written DB2 External C function library allowing searches in unstructured text over 50 million records much quicker than native DB2/DB2 Text Search).
  • Configured, developed and managed DBA WAMP server allowing monitoring and 24/7 on-call roster management.

Confidential

DBA Team Lead/Senior Database Administrator

Responsibilities:

  • Managed Oracle, SQL Server and Z/Os DBAs
  • Delivered real time GPS data collection and reporting
  • Managed DB2 LUW environments used with products like JD Edwards (Peoplesoft), DB2 Spatial Extender, IBM Enterprise Content Management.
  • Involved as a key technical person in architectural/solution designs of projects
  • Constructed database policies for upgrade & maintenance.
  • Proactively worked in performance tuning of production/non-production environments utilizing MDC, MQT, DB2 Event Monitor, REORGs, DB2 Compression and Table/Database Partitioning.
  • Established DB2 HADR between remote sites
  • Managed upgrades, backups & recovery, and participated in DR exercises.
  • Proactively worked in security and auditing
  • Involved in 24/7 on-call roster
  • Performed DB2 users/group management in AIX systems and assisted in auditing and maintenance of accounts

Confidential

DB2 Consultant

Responsibilities:

  • Responsible for diagnosing and solving DB2 implementation as well as operational issues at variety of client installations and platforms.
  • Lead a project to re-align/standardize Datasync’s work methodologies with its clients
  • Key resource to develop consulting tools to aid in gathering system information, producing reports and recommending solutions.

Confidential

DB2 DBA

Responsibilities:

  • Managed DB2 LUW environments used with products like Capital (Superannuation management interface developed by Syncsoft).
  • Implemented and managed DB2 data replication to Data Warehouse
  • Involved as a key technical person in architectural/solution designs of projects
  • Constructed database policies for upgrade & maintenance.
  • Proactively worked in performance tuning of production/non-production environments utilizing MDC, MQT, DB2 Event Monitor, REORGs, and Table/Database Partitioning.
  • Managed upgrades, backups & recovery, and participated in DR exercises.
  • Proactively worked in security and auditing and in debugging and training stored procedure development.
  • Initiated, developed and implemented change management tool for Syncsoft database/program change deployment to allow for error-free upgrades Language used Perl on AIX )
  • Initiated, developed and implemented scheduling package to allow scheduling dependent jobs against the database like automatic refreshes of non-production environments and specific member records migration with obfuscation of key details.

Confidential

Business Analyst/Programmer

Responsibilities:

  • Key resource in analyzing, designing and developing customizations to Capital (Superannuation management interface developed by Syncsoft) using proprietary language (CTL).
  • Key resource in developing complex SQL reports
  • Developed an interface in Tcl/Tk to allow on-demand member copy from production to non-production environments to resolve outstanding member enquiries.

Confidential

Business Analyst/Programmer

Responsibilities:

  • Analysing, designing, documenting and developing various in-house intranet systems and reporting facilities as well as internet secure web portal using Java Servlets, XML, Sybase Database, iPlanet Web Server on NT following full SDLC. System development tasks which included gathering user requirements, writing technical/non technical specification, developing systems and preparing test plans and usability testing in coordination with various levels of management and technical teams.
  • Data-Mining facility was built in order to allow clients to search huge databases for their investors’ investments and other personal details.
  • As the search queries resulted in large results, it required complex calculation and coding to make it web efficient and prevent locks within the database during the search process.
  • Component of the transaction engine was built to facilitate the periodic distribution of income received.
  • This component was built to perform efficiently (given the amount of data to be processed) and securely (as unauthorised access could have devastating effect on the organization and could cause huge data/investment loss). Stringent rollback mechanisms were put in place to cater for any such issues that may come up during or before a transaction process completes.

Technology used: Java Servlets, Sybase (Stored-Procedures), IPlanet

Confidential

Researcher/Developer/Assistant

Responsibilities:

  • Taught programming in Java, Unix/Linux, C, Pascal and Shell Scripts at the Confidential (Lab Sessions)
  • Developed Online Share Trading System. A system designed for the research on the impact of information overload in decision making in an online share trading activity.
  • Designed, documented and developed the system using JSP, Java Beans on Solaris with Tomcat and Apache with Oracle database backend.

Confidential

Support Engineer

Responsibilities:

  • Delivered major projects and customizations to clients with ADAPT installation
  • Key resource in programming and customizing ADAPT recruitment in CLIP (proprietary C)
  • Provided service with installation of SCO Unix and Windows NT operating systems and their administration
  • Implemented backups and recovery procedure for installed ADAPT systems

Hire Now