We provide IT Staff Augmentation Services!

Sr. Db2 Database Administrator & Hadoop Administrator Resume

SUMMARY:

A self - motivated, goal-oriented team player with demonstrated records of challenging achievements. An experienced professional with over 20 years of progressive IT experience in Database Administration, Hadoop administration and application development on multi platform environments including mainframe applications. An IBM Certified Advanced Database Administrator, having extensive experience in analysis, physical and logical database design, installation, configuration, maintenance, performance monitoring and tuning, query analysis, backup and recovery, high availability, SQL and Q replication. Extensive involvement on Data modeling, Design 24X7 databases using Cluster Environments (HACMP, HADR, Veritas’s VVR, GRIDSCALE, PURE SCALE), Data Warehouse, Pure Scale, Fault tolerance, Security and Disaster recovery planning. Work extensively with ETL tools like Data stage, Informatica and ETI Extract using VLDB environments. As Hadoop Administrator managed 700+ nodes multi-tenant production cluster on a MapR distribution. Management Knowledge on Hortonworks cluster for multi-tenant environment.

TECHNICAL SKILLS:

RDBMS: DB2 UDB AESE, ESE, DPF and Non-DPF, PURE SCALE, DB2 10.5, DB2 10.1, DB2 V9.8 (Pure Scale), DB2 V9.7, DB2 V9.5, DB2 V9.1, DB2 V8.2 & V8.1 ESE and all Earlier Versions, DB2/6000, DB2 MVS/ESA & z/OS, Oracle, MS-SQL Server, Sybase Adaptive Server and MS-Access

Languages: COBOL, COBOL II, JCL, SQL, C, Perl, Korn Shell, Bourne Shell, PL/SQL, C++ and Java

OLTP: CICS/ESA and CICS TS

GUI/Tools: IBM Data Studio, DB2 Development Workbench, Application Development Center, Visual Explain, Health Center, Design Adviser, Stored Procedure Builder, Quest, Todd, DBArtisan, DPROPR, TSO, ISPF, SPUFI, QMF, VSAM, MF-Revolve, Expeditor, DDL, DML, DCL, DB2 Utilities, File Aid DB2, Endeavor, IMS/ESA, BMC and PLATINUM Tools, DB2 Connect, GRIDSCALE, DB2 HPU and MS Office Professional.

BI/Tools: WLM, IBM Data Studio (Optim Products), Query Patroller, Appfluent, Syncsort, DB2 Alphablox, Business Objects, Cognos and Crystal Reports

App Servers: IBM Web Sphere and Web Logic Web Servers IIS, Apache and Apache HTTP Server

OS: z/OS, OS/390, MVS/ESA, UNIX (Solaris (5.8), AIX (3.x, 4.x, 5.x, 6.x & 7.x) Including SP2, ZLinux (SUSE 9 SP3, Red Hat), Windows Servers (NT 4.0, 2000, 2003, XP, Windows 7)

Hardware: IBM RS/6000, IBM POWER 6, P5 Series Servers P595, P575, P570, IBM P4 P690, SP2, IBM Mainframe ES/9000, IBM 9672, IBM RS/6000 with P-390, 64-bit Sparcv9, Sun Microsystems sun4u, Sun Spare Station 20, Compaq Prolaint PL6500R NT Server, IBM X SERIES 365, PC/AT 486-586, Pentium Machines

Open Source: Hadoop Distributions, MapR, Horton Works, Scoop, Pig, HBase, Hive, Streams, MapR MFS, MapR DB, MapR Streams, Many more Eco Systems used on Big Data Landscape.

EXPERIENCE HIGHLIGHTS:

Confidential

Sr. DB2 Database Administrator & Hadoop Administrator

Responsibilities:

  • Joined as a FTE of team of bright and energetic people. Working with them as a single focus in mind brings Pure Scale into the DB2 UDB (EE and EEE) landscape used in the enterprise and provides stability to the Hadoop clusters. Scooping data from different RDBMs (especially DB2 MF and UDB systems), bringing into Hadoop for analytics processing.
  • Hadoop Cluster with MapR distribution. Over 700 nodes production cluster. Participated in V5.1 upgrade initiatives. Also work on patching as it is available for us approximately each quarter.
  • Day to day operational support with our India team. Work closely with the vendor support team to get the solutions to the issues we face.
  • As SME for many clients, participated on the volume/sub volume creation work, Queue sizing and growth, making sure daily/weekly/monthly/yearend jobs meet the SLA attached to it.
  • Involved in Horton Works cluster for SBDL in the beginning. It started with single client and it is going though multi-tenant design called ETDL like other MapR environment.
  • Scripting effort to capture System performance related information from the cluster and its most use for troubleshooting the issues with MapR technical support team.
  • Leading daily operation calls with the all team members (onshore & offshore) to make sure all the issues resolved as soon as possible for the environments we support and complete many initiatives on time.

Environment: Linux 6.4, 6.5, 6.7 & 7.3, CentOS, NetApp Device, HP Tango and G9 Servers with local disks. VSphere and BDE (outdated). MapR Distribution for Hadoop, Hortonworks for Hadoop. DB2 V9.7, V10.5, V11.0 on both AIX and Linux.

Confidential

Sr. DB2 Database Administrator

Responsibilities:

  • Joined as contractor in system DBA team to support different DB2 systems and work on an active-active solution for UDP databases using DB2 pureScale.
  • Upgrade to DB2 V10.5 for different DB2 systems. Install and configure TSA for automatic failover for UDP HADR system.
  • Migrating a DPF 10 partition (logical) database to VCS cluster environment to give a failover solution for the database to fulfill business requirement.
  • Mentor teammates and coach as appropriate for the team to develop technical knowledge of DB2 pure Scale and many troubleshooting aspects. Execute all the technical duties as a team player and individually on day to day basis as a SME.

Environment: AIX 7100-03-04-1441 , RSCT, TSA, GPFS, Tivoli SAMP, HDS, EMC Data Domain, DB2 UDB V9.7, DB2 V10.5 ESE, AESE, PURE SCALE, DPF, DBI and DBArtisan.

Confidential

Sr. DB2 Database Administrator

Responsibilities:

  • Joined as FTE and the main focus on migration all DB2 LUW databases to DB2 V10.5 PURESCALE cluster environment. With this there will be no AIX/DB2 & all legacy HW will be decommissioned.
  • Moving the current DWH environment to new and better HW and DB2 V10.5. Design and implemented for upper environments and lower environment. Mutual Takeover high availability using TSA with 3 servers, 10 partitioned DPF environments with 4 TB raw data size for the DWH.
  • ITE, PROD and BCP, 3 PURESCALE clusters with 2 CFs and 3 Members each on LINUX environment.
  • Work intensively with IBM to setup pure scale clusters using RoCE RDMA. Moved 25 databases in to PURESCLAE cluster from legacy environments. Implemented LDAP Security during this migration process.
  • Apply Fixpak on PURE SCALE cluster using rolling and offline upgrade methods.
  • Performance analysis of PURE SCALE cluster by monitoring cluster caching facility main components such as GBP, GLM and SCA on the production cluster. Database performance grown more than 10 to 20 times with adaptive compression is in place and application load shared among 3 members in the cluster.
  • DB2 Pure Scale WLM (Work Load Management) does best load balancing as possible. Client Affinity tested and implemented for only single database.
  • Migrating DPF DB2 V9.7 FP8 database for TIW Thrivent Information Warehouse with 10 Partitions and 4 Linux Servers to DB2 V10.5 FP4 and 3 new powerful Linux Servers.
  • As TIW is important environment for business, configuring the DPF environment using TSA for a high availability purposes. ITE build completed successfully. Production is in progress.

Environment: AIX 7100-01-06-1241 , Linux Red Hat 2.6.32-431.11.2 , x86 64 GNU/Linux, RSCT, TSA, GPFS, Tivoli SAMP, IBM DS8800, EMC, DB2 UDB V9.5, DB2 UDB V9.7, DB2 V10.5 ESE, AESE, PURE SCALE and DPF.

Confidential

Sr. DB2 Database Administrator

Responsibilities:

  • Joined recently in this assignment and the main focus on migration to DB2 V10.1 and new HADR setup.
  • More than thousand databases in mixed environments. Linux VM, Solaris and AIX. DW is in AIX server with 36 partitions spread across 6 physical servers.
  • Working on migration from DB2 V9.7 & DB2 V9.5 to DB2 10.1. It is not in place migration. We are using new VMs and off line back up from source systems. During restore process databases get migrated.
  • Working with IBM lab and Confidential different teams to setup HADR in different environments considering all the security measures into consideration. This place has lot of security is in place and we must compile all the security measures and implement in HADR clusters.
  • Configure HADR pairs using TSA for automatic failover using db2haicu in a Linux and AIX environments.

Environment: AIX 6100-06-05-1115 , AIX 7100-01-06-1241 , Oracle Solaris 10, Linux version 2.6.18-348.6.1. e15, Red Hat 4.1.2-54, PowerPC POWER7, EMC, SRDF, DB2 UDB V9.5, DB2 UDB V9.7 ESE, AESE and DPF, DB2 V10.1, DB2 V10.5.

Confidential

Sr. DB2 Database Administrator

Responsibilities:

  • Completed Migration from DB2 V9.7 FP2 & FP4 to DB2 V10.1 FP2 for SAP R3, SAP BW databases.
  • Involve migrating SAP R3 and BW Environments from DB2 V9.5 to DB2 V9.7 FP2. Very large OLTP and OLAP (DPF) databases used for SAP professional systems. Sensitive applications and most used across the company. Downtime is not acceptable for the business owners and very intense SLA to complete the work on time. Later upgrading to V9.7 FP4.
  • Build new SAP ERP, CRM and PI systems for Reuters Markets System Initiative. Involve in Database design and HW selection (P6 & P7 Servers), Disk implementation for DB2 on different environments. All DB2 V9.7 automated features are implemented in new Environments.
  • Evaluated DB2 V9.8 (Pure Scale) architecture for the EDW and compare it with Oracle’s Exadata solution and Teradata. Evaluate EMC Avamar product for ORACLE & DB2 backup and restore purpose.
  • Linux X86 DB2 V9.7 FP4 Server Installation and maintenance for SAP R3, CRM databases

Environment: AIX 6100-06-05-1115 , AIX 7100-01-06-1241 , IBM,8233-E8B, PowerPC POWER7, Hitachi VSP, EMC VMAXe, DB2 UDB V9.1, DB2 UDB V9.5, DB2 UDB V9.7 ESE and DPF, DB2 V9.8 (Pure Scale), DB2 V10.1, DB2 V10.5, SAP R3 ECC 6.0 and SAP BW 7.1 on DB2, DB2 Connect Enterprise, DB2 Utilities (db2top, db2pd, etc…)

Confidential

Sr. DB2 Database Administrator

Responsibilities:

  • Involved building OCC DWH on DB2 V9.1 with 5 TB data warehouse application in a single server 6 logical partition environment. Range Partitioning, MDC and MQT are the driving force for this database with SAS application accessing the data in the warehouse. Very farm SLA to meet during data load through batch process.
  • DB2 V9.7 Certification process involved to certify all Managed Service scripts and also new PL/SQL feature to open ORACLE databases to migrate to DB2.
  • Migrated few demanding applications to DB2 V9.5 with DB2 Client and Gateway.
  • Voice Command Center (VCC), Work on implementing Tire 0 application using MQ Replication

Environment: AIX 5300-05-05, Solaris and Linux, POWER6, P 570 IBM P Servers, Hitachi, EMC and IBM’s Shark Disks, DB2 UDB V9.7, V9.5, V9.1, V8.x ESE and DPF including compression, Windows 2000 and 2003, DB2 Connect Enterprise, GRIDSCALE, Performance Export, Query Patroller, Sync Sort, Appfluent, CIM & DB2 utilities.

Confidential

Sr. DB2 Database Administrator

Responsibilities:

  • Involved in Migration from V8.1 databases to V9.1 & V9.5. Involved OS upgrade, AIX Kernel upgrade to 64 bit and DB2 upgrade to 64 bit before DB2 migration work.
  • HADR & HACMP Configured production servers have challenges involved during V9.1 migration.
  • ZLinux database servers migrated to V9.1, while HW needs to have 64 bit compatibility level. Work with system engineering to get the pre requites completed before DB2 migration.
  • Involved in Migrating of 16 partition data marts to V9.1 with some challenges. Very large DPF environment with 4 physical servers and 40 TB of disk attached in to it. SSH Configured between servers.

Environment: AIX 5.1, 5.2 and 5.3, Solaris and ZLinux (SUSE 9 SP3, Red Hat), P 570 IBM P Servers, Hitachi, EMC and IBM’s Shark Disks, DB2 UDB V7.x, V8.x, V9.1 ESE and V9.5 ESE, Windows 2000 and 2003, DB2 Connect Enterprise & DB2 utilities.

Confidential

Sr. DB2 Database Administrator

Responsibilities:

  • Involved in Migration from V8.1 EE database to V9.1 DPF database. Had lot of challenge during cutover time while moving close to 3 TB row data using High Performance Unload and load utility.
  • Active solutions using GRIDSCALE technology for tire1 applications. The applications are on non-partition (EE). Replacement of present HADR solutions. Design and Implement Gridscale. Involved in scripting most Gridscale processes and monitoring.
  • Automatic Storage databases across all managed service non partition and partition databases. RAW devices used on legacy environments and moving out of those to Managed Service Architecture.
  • Implemented Work Load Manager (WLM) using IBM’s Performance Export, Query Patroller, DB2Alphablox, Appfluent and CIM. Part of engineering team to analyze new technologies fit into managed service infrastructure.

Environment: AIX 5300-05-05, Solaris and Linux, P 570 IBM P Servers, Hitachi, EMC and IBM’s Shark Disks, DB2 UDB V7.x, V8.x, V9.1 ESE and V9.5 ESE, Windows 2000 and 2003, DB2 Connect Enterprise, GRIDSCALE, Performance Export, Query Patroller, Appfluent, CIM & DB2 utilities.

Confidential

Sr. DB2 Database Administrator

Responsibilities:

  • Involved in Migration from V8.2 (24 cpu/196 GB RAM) P681 to V9.1 (12 cpu/186 GB RAM) P570, large SMP system with approximately 6 TB of row data. 12 + 1 logical database partitions.
  • Converted ISO8859 code set to UTF-8 (UNICODE database), which involve capacity planning for Unicode conversion. There is 10 - 15 % more space required for Unicode conversion.
  • Moved 6 + TB of raw data from old server to new server using pipe load which almost take 2 days round the clock work. Total disk involved in production environment is approximately 20 TB.
  • Migrated SAP R3 and BW Environments from V8.x to V9.1. Face many challenges during this process. Resolved all issues with help from IBM and SAP Tech Support. Address many database performance issues on SAP BW environments.

Environment: AIX 5300-05-04, P 570 IBM P Servers, Hitachi TagmaStore Disk in SAN Environment, DB2 UDB V9.1 ESE, SAP R3 5.0 and SAP BW 3.5 on DB2, Windows 2000, DB2 Connect Enterprise, Hitachi Turecopy & DB2 utilities.

Confidential

Sr. DB2 Database Administrator

Responsibilities:

  • Involve in BCU and BPU architecture design for 5 environments. Development, Integration, Quality Assurance (also called DR) and located off site, Two production environments known as Atomic 1 and Atomic 2. The existing warehouse has approximately 1 TB of raw data and new environment is designed to grow at least 4x in size. Total disk involved in each environment is approximately 50 TB.
  • Converted DB2 to use ssh instead of rah using public key-based authentication and RSA encryption.
  • Involved building all the environments. Installation, Configuration, working with SAN architecture for disk allocation. All the environments having 9 BPU in single BCU with two physical P575 Servers. Development and Integration are exceptional.
  • Used IBM’s HPU V2.4 for moving data from old DWH environments to new DWH environments.
  • Involved in tuning optimum performance of quires used in DWH environments with multiple joins and MQTs. Automated Database backup and archive logs on to TSM.
  • Involved database Backup/Recovery/Roll Forward as part of DBA task. Restore a table from offline backup using DB2 HPU.
  • Created MDC and MQT have to get optimum performance of the SAS-Online Reporting Applications.

Environment: AIX 5.3, P 575 IBM Servers, Hitachi Disk in SAN Environment, DB2 UDB V8.2 ESE with DPF and EE, Windows 2000, DB2 Connect Enterprise, DB2 HPU & DB2 utilities.

Confidential

Sr. DB2 Database Administrator

Responsibilities:

  • Very Large & Multiple Data Warehouse environments for Development, Fail over Production environment (aka QA) and Production environment. Mixed UDB ESE V8.x & UDB V7.x environments. The production DWH is with 10 logical node spread across 2 physical sun servers with V7.x. Development (8 partitions, 2 servers) and QA (11 partitions and 2 servers) is ESE V8.x.
  • One of the tasks to migrate Production, QA and Development server to V8.x from V7.x. During migration we had experienced many challenges. RAW devices used for DMS tablespaces.
  • Many Data Marts are EE databases in Windows environments. Brio is used for reporting purposes.
  • Worked with Autoloader extensively on EEE - DW Environment. Involved conversion of autoloader scripts to load scripts for V8.x. Used load query command to check the status of load while loading very large tables.

Environment: Solaris 5.x, AIX 4.x and 5.x, Windows 2003 Advanced Servers, DB2 UDB V7.2 EEE and EE, UDB V8 ESE with DPF, Windows 2000, DB2 Connect Enterprise, DB2 utilities.

Confidential

Sr. DB2 Database Administrator

Responsibilities:

  • DB2 UDB ESE V8.1 Fixpak 5 Install, Configure and manage on AIX. Legato Backup server setup for database backups and archive logs to tape online.
  • Worked on setting IBM DB2 UDB ESE V8.2 (DPF) Install, Configure and manage on AIX V5.2 for EDW requirement on DBA Prospective. Striping 24 TB of SAN space in 24 partitions in 4 LPARS and building Informatica repository in the same frame. Technology involved Mainframe downloads using iWay and ETL tools on distributed side using Informatica to built complete solution for data warehouse and data marts (total 8 data marts in different LPARS).
  • Support IBM HACMP Configured databases for Integrated Architecture project using MQ product to communicate with Mainframe and different Bank Braches.

Environment: IBM PSeries 690, AIX 4.x and 5.x, DB2 UDB V7.2 EE and V8.1, V8.2 ESE, V8.2 ESE (DPF), Windows 2000, DB2 Connect Enterprise, DB2 utilities, IBM’S HACMP, Legato and Veritas.

Confidential

DB2 Database Administrator

Responsibilities:

  • Migrated EEE 4 nodes database to 7 nodes - 2 Physical Server into SP complex. Used IBM’s HPU and autoloader to complete the migration within 6 hrs time for 2.5 TB data.
  • DB2 UDB EEE V7.2 migrated from V6.X on AIX. 2.5-terabyte corporate data warehouse with more than 100 cron jobs triggered by ftps and database loads from OS/390 and Sybase. Automated the scripts to send email, page when any failure occurs. Supported database size varies from 500 GB to 2 TB. Provided 24x7x365 On Call Production Support for more than 70 applications.
  • Participated on tuning many stored procedures and also moved stored procedures from DEV to QA, QA to PROD and other different environments.

Environment: AIX 4.x, Solaris 5.x, DB2 UDB V7.2 EEE and EE, UDB V8 ESE, Windows 2000, DB2 Connect Enterprise, DB2 utilities.

Hire Now