SUMMARY:

• My deep knowledge of SAP ADMINISTRATION, HANA DB, DB2 LUW, Oracle, MSSQL, Snapshot Backup/Restore, Tivoli Flash Copy Manager (ACS), UNIX, Shell scripting, Network Administration has been key in development of critical databases and online applications. My leadership roles combined with my experience on server, middle and client tier led to successful implementation of ambitious projects with strict deadlines.

TECHNICAL SKILLS:

SAP BASIS ADMINISTRTAION (6 years): Single/Dual stack running on AIX/DB2, Linux/Oracle (ABAP & JAVA) & Linux/HANA

DBA (14 years): UDB/DB2 7.2, 8.1,9.1,9.5,9.7(DPF),Oracle 7.3.4, 8.0.5, 8.1.5, 8.1.6, 8.1.7, 8i, 9i (Replicated, Distributed, Cluster, Batch/On - line), MS SQL7.0, and MS SQL2000, MS SQL2005 Worked with DBA Artisan, BMC, Server Manager, DBA Studio, Oracle Enterprise Manager(OEM), StatsPack, Export/Import, SQL* loader, SQL Worksheet, SQL Query Analyzer, RMAN, Database Designer, MS Query, Data modeling, Data Warehousing, Data Replication and Data Migration Techniques.

Storage (8 years): Worked with Tivoli Storage Manager, Tivoli Storage Flash Copy Manager ( also known as Advance Copy Services(ACS)), Traditional & Snapshot Backups/Restore using TSM, NetApp, & Data Domain

Networking Skills (20 years): TCP/IP, SMS, SMTP, Firewall OpenSSH and TCP Wrapper on Solaris (7 and 8)

Operating Systems (20 years): Windows - NT & 2000 Server (8 years)AIX (4.x, 5L, 7.1) HACMP (12 years)Sun Solaris (10 years) NT/95/98/2000/XP workstation (20 years)Linux (RedHat & Suse)

PROFESSIONAL EXPERIENCE:

Confidential, Saint Paul, MN

Responsibilities:

• Worked as a Technical Lead to implement SAP BW on SAP HANA
• Worked as part of project team to implement SAP ECC, SAP SCM on SAP HANA
• Upgraded SAP HANA to SPS10 ( from SPS08)
• Supported SAP HANA Databases running SAP ECC, SAP SCM & SAP BW
• Worked as a member of Database Team supporting multiple DBMS
• Worked as a Focal point for any issues related to SAP landscape
• Implemented BRTOOLs to support SAP databases using SAP interface
• Used SAP T-code like DB02,DB13,SE16 & DBACOCKPIT to administer SAP databases
• Worked as an expert in the team for SAP, DB2, Real Application Cluster, Oracle Data Guard, Data Domain, Unix(AIX & Linux)
• Wrote Shell script to automate the process of SAP system refresh using Database Backup/restore method
• Documented the whole process of SAP system copy using traditional Backup/Restore method
• Implemented Best practices for databases recommended by SAP
• Worked with SAP support to resolve complicated issues
• Worked as a technical lead to implement snapshot backup for SAP application(NetApp)
• Worked as a technical lead to implement Delphix Proof Of Value (POV)
• Delphix is a third party SAP system copy product
• Supported multi-node Cluster Databases using Oracle’s Real Application Cluster(RAC)
• Implemented latest Database Patch recommended by SAP
• Helped team member in supporting Siebel application running on DB2
• Worked as project team member to refresh SAP stage system with production data( SAP System Copy)
• Setup RMAN & Data Domain configuration to Refresh databases across sites
• Designed, Implemented & successfully tested Disaster Recovery instances using Oracle Dataguard for mission critical applications (SAP & non-SAP)

Confidential, Saint Paul, MN

Responsibilities:

• Worked as a member of SAP Basis Team
• Worked as focal point to troubleshoot any Database related issues with SAP
• Used SAP T-code like DB02,DB13,SE16 & DBACOCKPIT to administer SAP databases
• Used DB13 to schedule Database maintenance Jobs
• Worked as technical lead to upgrade SAP databases from Version 8.2 to 9.7
• Supported SAP systems running on DB2(single & multiple partitions using DPF)
• Implemented DB2 row compression for SAP databases (DB2 Ver. 9.7)
• Implemented Disaster Recovery for DB2 databases using HADR for mission critical application
• Wrote Shell scripts to automate the process of Database reorg
• Worked with IBM & SAP support to troubleshoot database & application issues
• Performed system copies using Database Backup/Restore method
• Performed system copies using TSM’s Flash Copy method
• Documented the process of SAP system copy using TSM’s Flash Copy & traditional DB Backup/restore method
• Implemented Snapshot Database Backup through ACS for DB2 databases
• Automated Snapshot Backup using third party Scheduling Software (UC4)
• Wrote shell(Korn) script to automate the snapshot backup through UC4
• Implemented SAP Support Pack using SAP tools
• Implemented SAP Enhancement Pack using SAP tools
• Implemented SAP notes to resolve known issues
• Helped Business users with resolving any technical issues with SAP
• Provided 24X7 support to mission critical SAP application

Confidential, Plymouth, MN

Responsibilities:

• Worked as a member of DB2 DBA Engineering team
• Worked primarily on DB2 database using DPF for large DBs
• Supported multiple databases running on DB2 V8 ( FixPack 9a) and V9(Fixpack 4a)
• Wrote and implemented a Shell script to create a Single Partition/Multipartition database using AUTOSTORAGE/NON AUTOSTORAGE based on option provided (using getopts)
• Wrote and implemented a Shell script to create a SMS/DMS tablespace for Single Partition/Multipartition databases using AUTOSTORAGE/NON AUTOSTORAGE based on option provided (using getopts)
• Worked as Data Base Architecture for Data Warehouse Application
• Helped DB2 DBA operation team in resolving complex technical issues
• Implemented Grid Scale to provide High Availability for mission critical application
• Provided 24X7 On- Call support for mission critical application
• Worked a technical lead for Rapid Recovery Project( Disaster Recovery)

Confidential, Minneapolis, MN

Responsibilities:

• Supported multi partition DB2 Databases running on SUN and AIX
• Provided 24 X 7 on call support to critical applications
• Supported DB2 Databases ( size in TBs) for Data Warehousing application using DPF
• Install and setup DB maintenance/monitoring scripts on new servers
• Provided after hours/ weekend support to application developers for the new releases
• Worked as technical lead for new projects from DB2 Data warehouse team
• Configure 30 node multipartition database to use ssh instead of rsh
• Started On Call Support one month after joining the team

Confidential, Minneapolis, MN

Responsibilities:

• Helped DBA team in Migrating SQL server Databases to Twin Cities Datacenter
• Supported application running on DB2 UDB databases(Using DPF)
• Worked with IBM( and application team) in resolving complex issues with DB2
• Helped application team in understanding the execution plan for complex SQL( for Oracle & DB2)

Confidential, Plymouth, MN

Environment: AIX 5.2 ML 7, AIX 5.3 ML 4, HACMP, DB2 V7.2, DB2 V8.1 ESE (Fixpack 8 and Fixpack 9a), DB2 V9 (with DPF), Quest (Central and Dashboard), DB2 Connect V8.

Responsibilities:

• Worked as a member of DB2 DBA support team
• Provided day to day support for any database issue
• Worked as lead DBA on various projects
• Worked as a Primary DBA for the biggest database(about 1TB) supported by team
• Provided guidance to the application architect for the design of the database
• Provided documentation to resolve basic issues for first level support
• Provided after hours support during new implementation
• Provided on call support on rotation for business critical applications
• Migrated Version 7 instances to version 8
• Build Reorg, Runstat, and redirect restore scripts for database maintenance
• Used tools like Quest and Control Center for administration of databases
• Worked with IBM to resolve complex problems.
• Applied hot fixes and fixpack to production systems with minimum downtime
• Worked as a focal point for any TSM(Tivoli Storage Manager) and AIX related issue.

Confidential, Saint Paul, MN

Environment: AIX 5.2, HACMP, DB2 V8.1 ESE(64bit), DB2 Control Center, Datastage, Mainframe (TOPS and TSO), Test Director.

Responsibilities:

• Working on Client's site to develop a database (expected to grow in terabytes) for marketing group
• Used datastage as ETL tool to load data from legacy systems to the database (UDB ver. 8.1)
• Developed System Requirement Document (SRD) based on the input provided by Business Line and data architect
• Got Business Lines to provide sign off (Approval) to the final version of System Requirement Document
• Used approved SRD to develop ETL jobs
• Worked on mainframe application like TOPS and TSO to create test data for Integration and unit testing
• Worked as focal point for any database and AIX issues

Confidential

System Analyst/Database Administrator

Responsibilities:

• Worked as production DBA in UDB(7.2 and 8.1), Oracle (8i and 9i), and MS SQL server 2000 Enterprise Version in Windows 20003/2000/4.0, Sun Solaris, and AIX environment
• Install and setup database(UDB version 8.1) for Master Card fraud detection application
• Worked as part of team for the upgrade of UDB from 7.x to 8.1
• Made sure that all the RDBMS (UDB, Oracle and Microsoft SQL Server) are up to date on the maintenance level running in production environment
• Provided 24/7 on call support for critical databases
• Supported production databases as big as 3TB in size(Data Warehouse Applications databases)
• Designated as a to go person for any Oracle, Unix(AIX and Solaris) and Microsoft SQL server issues
• Worked with IBM, Oracle and Microsoft Technical Support Specialist to troubleshoot complex issues with their products
• Involved in evaluation and recommendation of DBA tools like TOAD, DBAArtisan and Oracle Enterprise Manager(OEM)
• Defined, Interpreted and enforced technical & administrative policies, standards and procedures
• Automated jobs to optimize production and QA databases by rebuilding indexes and analyzing tables
• Install, setup and supported replication between two geographically separated Microsoft SQL Servers(Ver. 2000)
• Install and setup Log Shipping between two geographically separated UDB(Ver. 7.x and 8.1), Oracle(Ver. 8.x and 9i) and Microsoft SQL Servers(Ver. 2000)
• Worked with application support staff to troubleshoot performance problem with Call Center Application(CTI) running on Microsoft SQL Server 2000
• Worked as a mentor for junior team member
• Worked as acting manager in the absence of section manager
• Install, setup and supported Oracle 9.2.x on AIX 5.2 with Real Application Cluster Option
• Worked as part of team for the upgrade of Siebel CRM application on Oracle 9.2
• Install, setup and supported Microsoft SQL Server 2000 on Windows 2003 cluster server
• Migrated Siebel CRM database( about I TB in size) from Oracle 8.1.7 to Oracle 9.2 with Real Application Cluster option
• Worked as Project coordinator for critical projects like Corporate Credit, Corporate Funds Transfer(Minimum transaction of about US$50,000)
• Defined and setup Service Level Agreement(SLA) for new applications/projects
• Provided support documentation to First Level Support for new applications/projects
• Organized the contents of database through tablespaces and loaded large volumes of data into Oracle 8.1.7 database using SQL Loader
• Monitored and tuned performance & resource management of Database by using tools like BMC Patrol, OEM
• Wrote AIX server hardening script ( Korn Shell) based on guidelines provided by Information Security department
• Created views, tables, packages and procedures for development
• Responsible for Code promotions/modifications as per requirements
• Worked with Java developers and helped them in development with tables, index, sequences, triggers, and synonym and data migrations.
• Suggested developers ways to improve their code for maximum performance
• Restored database after a crash from backup with minimum downtime
• Administered IPlanet, IIS, Apache servers.
• Used StatsPack to create reports for performance tuning and capacity planning
• Supported multiple applications like Online Banking, Fund Transfer Facility(FTF) and Corporate Credit Systems running against Oracle production DB
• Performed administrative task for Development, test and production databases
• Install and setup AIX 5L on machines in development environment
• Made sure that all the OS (AIX, Solaris, and Windows) are upto date on the maintenance level running in development environment

Confidential, Minneapolis, MN

System Administrator

Responsibilities:

• Managed a Production environment with the following:
• Four Email servers running Confidential proprietary Messaging "Rialto" products (300 Users):
• Two of them running Solaris 2.6 (E250)
• One of them running HP-UX 10.10 (HP9000)
• One of them running NT4.0 (Compaq Proliant)
• Responsible for all aspects of system management
• Installation and configuration of new systems, upgrades and backup
• Performance analysis and tuning
• Low Level Kernel Tuning
• Capacity planning
• Security policy creation and enforcement
• Wrote Korn Shell script to standardized and log the process of software distribution in the production environment
• Developed, modified and supported a number of applications for managing the environment. Such as:
• Directory synchronization program in PERL
• An Email notification program to notify the administrator for any network problem, Shell(ksh)
• Shell(ksh) script to remove the unwanted files from the systems