Sap Basis / Db2 Dba Resume
Sfo, CA
SUMMARY
- Highly motivated, creative and proficient technology professional with overall 28 years of Information Technology experience together with over 10 years of experience in SAP Basis administration
- Provide leadership and manage projects to drive overall work effort in the areas of SAP/DB2
- Experienced as a Test Lead for SAP and Non SAP applications involving Test strategy preparation, Estimation, Execution and coordination of onshore/offshore teams
- Experienced in Basis administration (ABAP, Java and Web Portal), troubleshooting and day - to-day support
- Extensive experience as a DB2 DBA and DB2 systems support for SAP and NON SAP database environments.
- Experienced in administering DPF environments.
- Experienced with HADR and TSA
- Implement measurements and actions that improve cost and continuous improvement in quality that will result in value to our customers
- Skilled in coordinating, negotiating and motivating outside vendors and off-shore resources in support of timeline and IT project deliverables
- SAP Performance Monitoring and analysis.
- Extensive experience in implementing security and compliance protocols in the areas of Database SAP ABAP application, Java, AIX (BOS) and File permissions
- Skilled in automation using UNIX shell scripts
- Skilled in evaluation, implementation and support of vendor software packages.
- Experienced in UNIX system administration.
- Possess good knowledge in Linux administration
- Excellent written and verbal communication skill
- Knowledge of EXCEL and Microsoft Project office
- Knowledgable in HANA application and Extended administration
- SAP systems Configuration, Administration, monitoring and performance tuning
- Provide collaboration services to SAP based development and support teams.
- Support project requirement needs and provide estimates for delivery team.
- Analyse, develop and maintain data architectures and process models within SAP.
- Perform Oracle/DB2 database backup and recovery administration
- Install, upgrade, Configure DB2 LUW and DB2 connectivity
- Experienced in system refresh, Support Pack upgrades and ECC6 Installation
- Install and Implement OSS NOTES, CINS and manual transports
- Assigning and dispatching jobs to team members and balancing the work load.
- Manage Critical outages and related Situations, i.e. From a system outage status until the system is brought back to a productive and steady state status
TECHNICAL SKILLS
SAP Applications: NetWeaver 7.4, ECC 7.4, BI 7.4, EP 7.4, SCM 7.4, PI, Solution Manger, GRC, LVM, Access control, Auto ID infrastructure, Object Event Repository, Cronacle V8,Global Batch traceability,Vertex,Global Trade services,IM,Access control,Object Event Repository, Global Batch Traceability, Master Data Governance, Concur Travel/expense, Global Trade Services
Boltons: Vendavo(price Management), Upside(Contract Management), Sabrix and Vertex tax ware
OperatingSystems: IBM AIX,Linux, HP-UNIX, zOS, SUN Solaris, LINUX, Windows 2000, and Windows 2003 server
Database: DB2 10.5 FP 5SAP2 and FP6 (LUW ) Oracle 11g/10g/9/8/7 and MaxDB
Tools: SAPinst, SAPup, SUM, SecureCRT, WinSCP, CuteFTP, XManager and Download Manager
Systems and Methodologies: MVS, OS/390, Linux, Windows NT/95/98/ 2000, Risc 6000, Data General, AS/400,SGI Graphics,SP/2 and Sun Workstation.
PROFESSIONAL EXPERIENCE
Consultant
Confidential, SFO, CA
Responsibilities:
- Report QA validation status on SAP and Non SAP and update information to upper management
- Creating time lines to task completion
- Facilitating meetings with build teams and technical contact/SME
- Sending reminder notices to work stream groups and technical contacts on QA status
- Communicating with Infrastructure team and application owners
- Reporting and updating validation data to all stake holders
Consultant: SAP BASIS / DB2 DBA
Confidential
Responsibilities:
- Responsible for daily administration on 5 SAP landscapes, supporting approximately 150 AIX and Linux system.
- Resolve Incident, Change and problem tickets.
- Install, Configure and upgrade DB2 environments
- Responsible for daily tasks arising out of maintenance and upkeep of the SAP/DB2 environment
- Integration of DB2 environments
- Perform Quarterly Maintenance tasks.
Consultant: SAP BASIS / DB2 DBA
Confidential, Indianapolis
Responsibilities:
- Responsible for resolving change and problem tickets for 8 landscapes containing approximately 130 systems
- Plan outages and send schedules to user community for their approvals to perform changes to the SAP systems
- Install and configure latest Kernel, RTA(GRC) and support pack upgrades on all landscapes
- Install and configure special fix pack 5SAP2 and FP 6 on all db2 instances
- Installed and imported language packs for SAP environment
- Migrated DB2 physical systems to a virtual environment(VMWare)
- Migrated DB2 environment that used VMAX storage to XTREME IO
- Implemented performance and optimization parameters
- Understand new database requirements from the Data Architect and implement the same with overall design
- Implemented Role-based Security
SAP Systems integration and Basis Administration
Confidential
Responsibilities:
- Responsible for Resolving problem tickets for various Customers for maintaining, monitoring and troubleshooting day to day problems in various system landscapes
- Performed Troubleshooting of system problems, update and lock entries, Spool Jobs, Background Jobs, RFC, ABAP Dumps, System log and Database issues.
- Maintained and fine-tuned SAP profiles parameters, OP Mode Switching, Scheduling and Work Process distribution.
- Configured and Maintained Transport Management System (STMS), carried out various transports - single and mass transports, resolved various transport issues in diverse system landscape.
- Knowledgeable in Administration and configuration of SAP change and Transport System (CTS).
- Performed a variety of System Copies, Implemented Add-on, Support Package, Stack, Solution Tools, Kernel Upgrades and JSPM updates.
- Participated and developed Disaster Recovery procedures for DR testing, specific to DB2 and SAP
- Performed Spool Administration: configuring printers and logical spool servers, implementing device type in system landscape and trouble-shooting and administration of spool request and TemSe problems.
- Created clients and performed Client Deletes, client copies both remote and local and client export/import as per business requirements.
- Troubleshooting SAP GUI issues and support users with front end issues.
- Installed, upgraded and maintained db2 environments on Linux and AIX(Unix)
- Performed DB2/Oracle administration: Table Space administration, parameter changes, log monitoring, Table Reorganization and Trouble shooting.
- Enabled client changes through client opening.
- Configured SAP solution manager Standalone Diagnostic Agent on monitored systems
- Initiated OSS connection to SAP according to customer's request and Created OSS message to SAP.
- Support experience in resolving tRFC/qRFC problems
- Involved in the Implementation of Enhancement Package5
- Hands on experience on the tools like Visual admin, Config tool, SDM, JSPM and Log Viewer
- Configured J2ee parameters and Added Java Server Process
- Worked with customers for Logon load balancing (SMLG), TRACE and Printer problems.
- Worked with customers for monthly maintenance, response times SLAs and day to day issues.
- Configured and implemented SAP router, Systems in Solution Manager, EWR and Responsible for downloading and approval in maintenance optimizer.
- Configured and maintained SCOT, worked with customers for their workflow issues
- Performed tax updates with ADP and other TAX sites.
- Interact with SAP application teams to analyze proposed changes to SAP technical configuration settings to optimize overall performance and Daily system administration.
- Involved in scheduling all SAP Remote Support services including Early watch and Go Live
- Provided training and assistance to team members and end-users on efficient use of the SAP system and system resources.
DB2 DBA
Confidential, NY
Responsibilities:
- Planned and implemented space management, data movement, permissions / security
- Monitored and tuned database performance, troubleshoot database related problems.
- Established procedures for backup, recovery and reorganization.
- Coded shell scripts to simplify DBA tasks.
- Maintained Databases, Table spaces, indexes, views, Stored Procedures, functions, triggers etc.:
- Scheduled Utilities, including Backup and Recovery, Reorgs and Runstats
- Performed Exports/Imports/Loads of data
- Provided mentoring, advice on project process, and DBMS technical support to a team of six DBA members
- Collaborated with developers and architects in planning and deployment of new projects
- Took defect preventive measures in keeping the commercial and internal customers satisfied with service with an outage (24 X 7 steady state support)
- Installed Configured and maintained DB2 environments and established connectivity to target systems
DB2 Systems Support/Db2 connectivity
Confidential, CT
Responsibilities:
- Supported internal and commercial customers of IBM in integrating the db2 environment with numerous Applications (SAP, IDS LDAP, Content Manager, WebSphere, UAWEB and Network Dispatchers)
- Installed, Configured and Maintained db2 environments on approximately 700 servers
- Extensive experience with installation, configuration, upgrades and maintenance of DB2 and IDS LDAP
- Configured numerous applications with db2 connect and db2 database environments
Systems Administration and Command Center support
Confidential, Allen, Texas
Responsibilities:
- Provided System administration support to all mid-range and mainframe systems that were used forCredit Reporting .
Systems Administrator
Confidential, Garland, Texas
Responsibilities:
- Maintained and supported Inventory system and coordinated dispatching of materials