ABHILASH N

703-***-********

ac7jkc@r.postjobfree.com

IBM DB2 UDB Administrator

Summary:

Around 7+ years of experience in Information Technology with extensive experience in DB2 UDB Database Administration. Provide world-class consulting, database administration, and support services to IBM Information Management clients and business partners implementing IBM DB2 database technologies on open systems platforms with DB2 for Linux, UNIX, and Windows (DB2 for LUW).

Good experience in EXPORT, IMPORT and LOAD utilities, moving data between servers. Well acquainted with backup and recovery of database, online database backup, archived log files and offline database backup and experience in DB2 utilities, handling production and development issues, creation of database objects, backup and recovery.

Installed, set up and configured SAP Basis on Oracle and DB2 UDB platform respectively. Setup and configured the SAP Central Instance and other application servers within the Landscape. Installed, set up and configured SAP Solution Manager for SAP R3 4.6C on Oracle and DB2 UDB platform to monitor the entire enterprise.

Design the overall solution architecture by integrating SAP Basis, PEAK and Optivision for the various plants/mills throughout the enterprise.

Worked on SQL Replication and Q Replication. Experienced in Replication products Infosphere, CDC, SQL and Q Replication. Well versed in all aspects of Relational Database Design and Administration like logical and physical database design, creation, maintenance, backup, recovery strategies, performance monitoring and tuning, problem identification and resolution, security and disaster recovery planning in both OLTP and OLAP/DSS (Data Warehouse Environments).

Experience in db2 specific tools such as db2pd, db2dart, db2support, db2top, db2inspect, db2advis, db2explain, db2diag.

Scheduling regular backups / Image Copies to disks, TSM and HP Data Protector tool. Proficient in creating database objects such as tables, table spaces, indexes, views, and aliases and altering tables and adding check constraints and referential integrity.

Expertise in DB2 UDB Administration involving Performance Tuning, backup, Flashcopy and recovery, space management, disaster recovery and maintenance, HADR, TSA. Competent in monitoring databases using snapshot monitor and event monitor.

Client server communications configuration experience using TCP/IP, NetBIOS, SNA (APPC), IPX/SPX, and clustering over system area networks with TCP/IP and Virtual Interface Architecture (VIA) protocols.

Database utility experience including reorg, runstats, rebind, export, import, load, auto-load, backup, restore and recover database utilities and good knowledge in administering Windows Server Failover Clustering (WSFC).

Database backup and recovery experience with online full and incremental backups, online and offline transaction log archiving, restore and roll-forward (including redirected restore), and recover database utilities.

High availability (HA) and disaster recovery (DR) experience with DB2 HADR, offline transaction log shipping, split mirror images, data replication, and Microsoft Clustering Services (MSCS) using SCSI and SAN subsystems.

Database and SQL statement access plan optimization experience with DB2’s Explain, Visual Explain, and Design Advisor tools.

Data replication experience using DB2 Data Replication (DPropR) from DB2 mainframe and DB2 to DB2 client/server databases including Replicas (update anywhere) subscriptions.

Stored procedure (SP), user defined function (UDF), and user defined table function experience with DB2 SQL/PL.

Database analysis, design, and reverse-engineering experience using Power Designer Data Architect, Embarcadero ER/Studio, and ERwin.

Extensive experience automating database maintenance and monitoring with shell scripts including automating system event logging, e-mail alert notification, and reporting using the DB2 utilities and Command Line Processor (CLP) with the Windows Shell, Windows Scripting Host (WSH), and Open Object REXX.

Database migration experience from DB2 on mainframe platforms to DB2 for Windows as well as Sybase ASE and Sybase SQL Anywhere to DB2 for Linux with the IBM DB2 Migration Toolkit.

Experience in operational 24x7 support, best practice trouble shooting, monitoring, and maintenance.

Technical Skills:

RDBMS: DB2 UDB v9.x, v10.x, v11.x, MY SQL, DB2, Oracle11g/12c, MS ACCESS, MS SQL 2012/17, MONGO-DB.

Languages: T-SQL, PL/SQL, UNIX, Shell Scripting, XML

Operating System: AIX, LINUX, UNIX, Z/OS, Windows

Data Modeling: Erwin, ErStudio, IBM Datastudio

ETL tool: Data Staging, Informatica, Abinitio, Data mirror Transformation Server, QMF and DataStage.

Clusters: TSA, HACMP

Business Intelligence Tools: Crystal Reports, Cognos, Business Objects

Third party tools: DBI, CA Log Analyzer, BMC Remedy, DB2Admin Tool, Data Studio, Fog light, TOAD

Shell Scripting: Korn, Bash, Bourne, and C Shell

ERP: SAP R/3 4.6C, BW 3.1C and PeopleSoft

Cloud: Amazon AWS

Experience:

DB2 UDB Database Administrator

Client: SCHOLASTIC, New York Jan’2018 to till date

Description: Scholastic books and educational materials are in tens of thousands of schools and tens of millions of homes worldwide, helping to open a World of Possible for children across the globe.

Responsible for backups, recovery, installing, configuring, design, patching/upgrade, monitoring, performance, tuning and providing support to production.

Responsibilities:

Supported DB2 UDB DBA software on AIX, Linux and Windows environment, Upgraded database from db2 LUW V9.1, V9.5, V9.7.4 to db2 LUW V11.1

Involved in managing log files and thereby ensuring high availability of database in a 24X7 scenario.

Supported Migration project of servers from AIX to Linux and checking all the required parameters are up to mark as per requirements comparing current configuration (AIX) to Linux configuration.

Restoring the databases from production to lower environments.

Worked on different type of SAN replication type and failures.

Data refresh from database to database using Admin_copy_Schema.

Moving of data from one server to another using Load Cursor.

Used DB2 Movement Utilities like EXPORT, IMPORT, LOAD. Provided solutions in Performance tuning the databases.

Provided solutions and monitored in running REORGCHK, REORG, REBIND, RUNSTATS, LOAD utilities against the large database and generated reports of database structure using DB2LOOK Utility.

Provided scripts for changing the data base and database manager configuration parameters.

Supported and upgrading db2 connect and supported and setup db2 clients.

Providing support on replicating data using Q-Replication.

Involved in setting up and troubleshooting databases involving Q-Replication.

Assisted Cloud team in Migrating Databases from On-premise to AWS cloud.

Involved in changing the shell scripts for daily maintenance tasks such as backups, reorgs and runstats.

Extensively worked on tuning complex SQL queries using EXPLAIN PLAN and recommended the improvements needed to reduce the execution time.

Worked on federated environment in setting up wrappers, mappings, and information integrator.

Experience in working on quarterly database health checks.

Worked on migration from AIX to Amazon AWS.

Planning and communication with the customer and client, discussing and providing report on daily basis.

Worked on different type of backup strategies and lowered the alerts generating through tools.

Follow up on team activities and planning resources as necessary to meet the SLA as per standard policies of client.

Adhere to ITIL processes and ability to work in PROD, DEV, TEST and QA environments.

Worked on HACMP clusters in resolving the issues and in testing RG failover and failback activities.

ENVIRONMENT: DB2 ESE/WSE V11.1/10.5/10.1/9.7/9.5/9.1, ASE V15, AIX 6.x/7.x, AWS, Q-Replication, Windows 2003/2007(SP2)/2008 Enterprise/2012 Standard

DB2 UDB Database Administrator

T-Mobile, Washington Bothell. April 2016 to December 2017

Description: T-Mobile is the brand name used by the mobile communications subsidiaries of the German telecommunications company Deutsche Telekom AG. The brand is active in Austria, the Czech Republic, the Netherlands, Poland, and the United States.

Responsibilities:

Designed the disaster recovery strategies, which involved the backup and recovery procedures, setting up of HADR across UNIX clusters, HADR with TSA (Tivoli Software Automations) Implementations.

Assisted Cloud team in Migrating Databases from On-premise to AWS cloud.

Scheduled the self-written shell scripts to do periodic runstats, reorgchks and REORGS if required (during the maintenance window) and all other database maintenance activities, like tablespace, container space monitoring, and database sizing scripts for Servers running on UNIX Operating Systems.

Implemented DB2 Audit Facility and SSL across multiple servers for the enterprise level DB2 Database.

Worked extensively on db2move, Export, Load for exporting it to a file and then importing from the file to the database respectively i.e. moving the data from one database to the other one.

Responsible for successful execution of the ticket, documenting status, providing feedback to the owner and closure of the tickets.

Support production environments, configuration, testing, and performance tuning of all DB2 database environments. Verify the database support requests and execute them in timely manner as the business SLA's.

24X7 Production DBA support for application development, deployment and support activities.

Extensive experience supporting DB2 system administration, application development,

Managed database loading, migrating and maintaining data with LOAD, EXPORT, IMPORT DB2LOOK.

Troubleshooting and resolving DB2 issues, performance tuning, monitoring data security and integrity.

Responsible for performance tuning, support, analysis and resolution of database problems that occurs during the critical time processing.

Environment: DB2 Version 10.1/10.5, AIX, LINUX, DB2 Connect V_10.1, AWS, Jira Ticketing tool, Shell Scripting, BPM, Websphere.

DB2UDB DBA

Fidelity Investment, Boston, MA July 2014-Mar 2016

Description: Fidelity Investments operates a brokerage firm, manages a large family of mutual funds, provides fund distribution and investment advice, retirement services, wealth management, securities execution and clearance, and life insurance. Primary responsibilities included Install, configure, monitor, upgrade, migration, maintain database production & non-production environments and provide database deployment support for development, test and production (future) environments.

Responsibilities:

Database sizing, tablespaces, indexes and log spaces design & implementation work.

Displaying and Setting up the environment variables. Updating the instance and database configuration parameters dbm cfg and db cfg respectively.

Ran db2move, Export, Load for exporting it to a file and then importing from the file to the database respectively i.e. moving the data from one database to the other one.

Responsible for successful execution of the ticket, documenting status, providing feedback to the owner and closure of the tickets.

Data modeling (logical and physical data modeling using ERWIN.

Responsible for backup, restore and moving the data between different databases/servers.

LOGGING and ARCHIVING Database LOGS.

Worked on OLTP Debit Card Fraud management system.

Creating new database objects and working on any database structural changes.

Heavily using data movement utilities like LOAD, EXPORT, and IMPORT.

Worked on utilities like REORG, RUNSTATS, REORGCHK and REBINDS.

Worked on HADR setup using TSA.

Physical database design, creation, implementation & maintenance operations (file system mount points & storage parameters) and logical database mapping to physical database (storage calculations, file systems, tablespaces, rollbacks, indexes, data files & logs

Involved in updating DB2 UDB 9.1.4 to 9.1.5 on production and development servers.

DB2 for SAP support such as tablespace maintenance and backups.

24X7 Production DBA support for application development, deployment and support activities.

Perform DB2 installation, configuration, and upgradation and install fixpacks to keep DB2 at most recent level on AIX, LINUX, Solaris servers including in HADR environment.

Drive intermediate Severity-1 and Severity-2 issues through to resolution.

Worked extensively with backups (Offline and online), restores, redirected restores and backups/Restore using TSM and table compression.

Responsible for performance tuning, support, analysis and resolution of database problems that occurs during the critical time processing.

Environment: DB2 Version 9.7.x/9.5.x/10.1/10.5, AIX, LINUX, DB2 Connect V_9.7, HP Service Manager, SAP R/3, Tivoli Storage Manager (TSM), Java, Microsoft Cluster, Control-M, Windows Server 2008 R2 enterprise, VMware, Shell Scripting, BPM, PowerShell and Websphere.

Db2UDB DBA

UBS AG - Jersey City, NJ Aug 2013 to July 2014

Description: UBS Investment Bank provides corporate, institutional, and wealth management clients with expert advice, innovative financial solutions, outstanding execution and comprehensive access to the world's capital markets. It offers investment banking and capital markets, research, equities, foreign exchange, precious metals and tailored fixed income services in rates and credit through its two business units, Corporate Client Solutions and Investor Client Services. The Investment Bank is an active participant in capital markets flow activities, including sales, trading and market-making across a range of securities. I was involved in providing solution running backup, recovery, reorg, performance maintenance and tuning the databases.

Responsibilities:

Administration of database, table and table spaces.

Moving the data by using EXPORT, IMPORT, LOAD, db2move utilities.

Monitored Databases using snapshot monitoring and Event monitoring.

Database backup & recovering the database as per business requests.

Implemented DB2 Security, Locking and Concurrency Control.

Constantly migrated instances, databases to current level of DB2 versions/fix packs to incorporate the new functionalities. Migrated from V8.2 to V9.1

Create and modify databases and database objects as per application requests.

Used SAP DB6 Cockpit, to maintain UDB DB2 SAP databases.

Provided on-call support and well exposed to 24x7 environments.

Implemented Q-replication method to sync data from OLTP to Data warehousing environment.

Daily and weekly database Maintenance activities such as backup, runstats, reorg and all related activities for databases.

Worked on SQL Tuning using db2advisor and db2explain tools.

Updated the DBM and DB configuration parameter.

Generated SQL Statements using DB2LOOK Utility.

Worked as part of a database administration team and provided support for critical and non-critical implementation and maintenance issues.

Environment: DB2 Version 9.7/9.5.x/9.1.x, DB2 Connect 9.5.x/9.1.x, AIX 6.1/5.3, Q-Replication, SAP R/3, Web sphere Federation Server 9.5.x, DB2 Client 9.5.x/9.1.x, BMC Patrol, HP Service manager, Control-M

DB2DBA

Baxter Healthcare, Deerfield, IL Jan 2012 – July 2013

Description: Baxter International Inc. is an American health care company with headquarters in Deerfield, IL. The company primarily focuses on products to treat hemophilia, kidney disease, immune disorders and other chronic and acute medical conditions. Supported in analyzing highly complex system, technical and product issues, working on tickets, responsible for ongoing support, upgradation and migration.

Responsibilities:

Provided 24*7 supports to over 100 database instances. This includes 15 UAT, 25 Development and over 50 Production DB2 Mission Critical databases running on AIX, and Windows 2000 environment. Databases included OLTP Batch Processing systems.

Installed and configured DB2 v9 .7fp5 on Linux, AIX and Windows.

Migrated DB2 v9.5 databases to DB2 V9.7

Change Management - Schedule change, get approvals, do broadcast and work on change tickets.

Data refresh at table level and database refreshes across prod/non-prod environments.

Performance Tuning of all UDB instances - identifying performance degrading factors and taking corrective measures to improve server and query performance. The tuning efforts ranged from physical I/O tuning, memory cache optimization, Application Tuning included query optimization and Proper index selectivity.

Monitor table space growth statistics for the production databases and estimate the size for the month/year by actively participating in Capacity Planning meetings with users and managements and drew out relevant statistics for upper management to study.

Performed day to day online/offline database backups using Commvault Console.

Used Remedy for Change Control/Change Management.

Moving databases from Development to Production after successful completion of application testing.

Installed/ Configured CDC in LUW/AIX.

Designed and implemented strategy for running data reorg/runstats on timely basis for large tables to avoid data fragmentation and improves performance and system throughput.

Supported developers to write SQL statements and test them before running it in Production environment. Take the backup of the database when restarting the dprop.

Worked on setting up log archiving to TSM using API.

Database backup & recovering the database at the time of crash.

Involved in HADR setup, monitoring, Rolling up upgrades.

Created DPF and Range partitioning tables, MQT.

Setup and monitored Replication between Operational Database and Reporting Database.

Environment: Db2 UDB V9.1, 9.5, 9.7 Commvault, BMC Patrol, Db2 Optim, Quest Central, TSM, Java, JSP, AIX, LUW, SQL Server, Oracle, MySQL.

DB2/Oracle DBA (SAP) July 2010 – December 2011

IBM GLOBAL SERVICES - INDIA

January 2010 to Dec 2011

Description: IBM Global Business Services (GBS) is the professional services arm of Global Services, including management and strategy consulting, systems integration, and application management services. The project is to handle the day-to-day database administrator tasks. This will include, but not limited to, backup, recovery, DB instance performance monitoring and tuning, creating database objects and migrating from one database to another database and installation of latest fixpacks.

Responsibilities:

Managed database instances for Consolidated Online trading system in DB2 UDB in version 8.x and 9.x on AIX 5.3 and Linux servers. Apply fixes and patches as necessary to DB2 UDB & Oracle database environment to keep track of cutting edge technology.

Installed, setup, configured and manage high availability topology for Oracle and DB2 UDB environment using RAC, Data Guard and DB2 high availability disaster recovery (HADR) respectively.

Manage and provide steady state support for Oracle database RAC environment after implementation and go-live.

Installed, setup, configured and manage federated systems using Oracle and DB2 UDB as data sources respectively.

Installed, set up and configured SAP Basis R3 4.6C on Oracle and DB2 UDB platform respectively.

Setup and configured the SAP Central Instance and other application servers within the Landscape.

Perform SAP architecture sizing and capacity planning to meet SAP enterprise deployment.

Recommend and implemented fail over solution for SAP architecture using Veritas HA solution and IBM HACMP capability.

Configured HADR and TSA for Automatic Replication (IBM CDC) failover.

Implemented disaster recovery of a highly transactional OLTP environment with HADR and TSA (Tivoli Software Automation).

Automated the Daily Online backups to TSM, Manually Archiving the Logs to TSM in case of backup failures, setting up the TSM prams for the Redirected restore.

Extracting the backup image of one database and redirecting to another database from TSM to disk. Configuring and fine tuningDB2 DBM and DB configuration parameters for better response, throughputs and proper utilization of Global memory. Experienced in using Imports, Exports, db2move utilities on the schema level and table level.

Worked on physical and logical designing, performance monitoring, maintenance, query analysis, optimization, backup, recovery, replication and migration.

Work with the Basis team to install the various SAP application servers and load balancing components and integrate such with the database servers on Oracle and DB2 UDB platforms.

Startup, shutdown the SAP Central instance and application servers as requested by the environment team and as situation demanded.

Disable unneeded Siebel server component groups and server components to conserve memory for other processes.

Perform SAP security administration tasks by creating users, assign them to login groups, assign responsibilities as requested using transaction SU01.

Setup SAP R3 system Landscape in development, test, staging and production environment.

Managed organizational visibility through positions and responsibilities and assigned different types of views visibilities such as personal, team base and organization base assignments.

Setup users and enforced security policies in DB2 UDB, Oracle and Sql server databases modules.

Configure linkages between the DB2 UDB databases and its SAP integration.

Configured and setup JDBC and ODBC connection layer for SAP interface with DB2 UDB databases.

Installed and configured MQSI broker and repository application server on top of a DB2 UDB and Oracle databases.

Setup and managed the security layer between master tax and vertex application server running on DB2 UDB and Oracle databases.

Configure the connections and network linkages between the Oracle 8i database and Ariba Buyer/Tibco Active enterprise.

Monitor MQSI flows and channels on DB2 UDB and Oracle databases that share data with Lawson environment.

Setup the integration interface for Mqsi flows and Ariba application to exchange metadata with oracle 9i database.

Constantly interact with end users and developers to troubleshoot their jobs as at when needed.

Perform installation of Oracle, DB2 UDB EE/EEE/ESE and Ms Sql Server RDBMS on Aix, Sun Solaris boxes and Windows.

Environment: DB2 Version 8.x/9.x, AIX, LINUX, Jira Ticketing tool, Shell Scripting, BPM, Informatica, Oracle, RAC, TIBCO, MQSI,

Quest Central, TOAD, SAP R/3, DB2 Migration Toolkit.

Contact this candidate