Manager Engineer/ Lead DB2 DBA /Sr. Data Engineer

Vijay Bandari

404-***-**** acrd3w@r.postjobfree.com

Summary

Seasoned IBM DB2 DBA manager, and technology consultant with global experience in Cross Database Competitive Technology. Have extensive experience while working on a range of projects involving detailed technical exploration of multiple database products and emerging technologies in Big Data. Certified in planning & project management, and db2/Teradata administration.

Professional Experience

Teradata Corporation March 2010–Present

Atlanta, GA

Senior Software Engineer/Competitive Technology Analyst

Primary responsibilities included competitive research and investigation into the strengths, weaknesses, opportunities, and threats of competitor products and services in comparison to the strengths and weaknesses of my company’s products and services. I prepared and presented presentations on my findings and offered guidance to product management and engineering on how to improve our position versus the competition.

Worked on a range of projects involving detailed technical exploration of multiple database products and technologies:

Provided design strategies for optimized parallel data access to Hadoop via Hadoop connectors and database federation solutions

Made presentations periodically to Teradata R&D and Engineering teams to provide competitive analysis

Provided input to leadership team on short, medium, and long term trends of competition’s technology strategies

Worked with Product Management and Engineering in the planning and review of Teradata features/functionality for cross database comparisons

oPerformance analysis studies of Teradata database solutions

oMulti-temperature data feature studies

oWorkload management

oAnalytic ecosystems

oMulti-tenancy

oEvaluation of SQL:2011 Temporal standards

oStreaming technologies

oR Integration strategies

oCloud Solutions (IaaS, PaaS, DwaaS)

oSQL on Hadoop technologies

oSQL acceleration solutions

oMetadata services

oHigh availability solutions

Performed Cross Vendor Industry technology studies in support of Product Marketing and Engineering on the following topics:

oIn-memory

oColumnar

oSIMD/Vectorization

oAutomatic compression techniques

oJSON/NoSQL support

Competitive benchmarking advice and strategies in support of global Teradata benchmark efforts and customer migration efforts:

oDeveloped and deliver competitive benchmarking course for the global Teradata sales force

oProvided advice to Account Team/Benchmark Team for:

Converting customer database model to Teradata physical database model

Data type mapping between databases

Parallel data distribution approaches/migration to Teradata physical implementation

Achieved Teradata Certified Professional certification

Distributed Database Support and Administration March 2007–February 2010

IBM Integrated Technology Delivery

Smyrna, GA

DB2 LUW DBA Manager

Provided complete support for WellPoint:

Client environment contained data Centers in California, Virginia and MA. Major activity involved Migration of the datacenter from California to Virginia. Managed 150 instance environment, Warehousing DPF environment contained 16 partitions.

IBM Commercial client environment supported:

Target ADW warehousing Production environment contains 81+TB DB2 DPF database environment, 133 partitions running on 21 servers, with 3 coordinating partitions/one per server, Stage/test 18 partitions 4 servers, Dev 3 partitions and a Sand box environment with 3 partitions. Monitoring db hosted on an independent LPAR. Workload management tools in user QP, Governor, db2 Audit, and Performance Expert. Tools used for administration are Data Studio (administration), changes promoted through Erwin models. SSH used for inter-partition communication, RAH retired for enhanced security.

Formulated action plan, performed benchmarks to evaluate continuous improvement in service delivery, implemented in IBM STG and AHE data centers:

Created automated script to identify potential SQLs creating bottleneck, analyzing those by explaining access plan find new indexes to speed up and reducing the cost by using tools like db2adviser, db2expln

Created automated DB performance monitoring scripts which included long running SQL report, Deadlock report, timeout and CPU utilization exceeded alert

Developed technique to use db2pd utility with db2cos to track down detail information about timeouts like lock holding and lock waited SQL, both application detail and actual timeout occurrence time

Configured and used db2governer to control application behavior from database side

Used different development, maintenance and monitoring tools like Quest Central, Spotlight, DB2 Toad, DB2 Query petrol and Command Central

Implemented MQT’s and MDC’s to optimize query performance

Researched DB2 9 compression, Label Based Access Control (LBAC), Performance Expert Installation and Configuration, and Replication

Performed re-layout of bufferpools and tablespaces in existing production database and increase bufferpool hit ratio to 97 %.

Developed and implemented database monthly, weekly and daily maintenance strategy thru Control-M jobs, which include online-offline backup, runstats, package rebinding, dropping recreating nicknames, table and index reorgcheck

Performed Installation of db2 client on application server and cataloging database

Actively participated in testing and developing of proof of concept for db2 replication.

Automated moving db2diag.log, Server space monitoring, tablespace size monitoring by setting up dynamic threshold level.

Extensively used Unix OS performance tools like top, prstat, mvstat, iostat and more to identify any resource bottlenecks.

Extensively used different Database Table Snapshot Functions to monitoring database, develop Queries using DB Table Snapshot Function to find bufferpool hit ratio, lock timeouts, lock waiting and holding SQL, long running SQL

Used several DB2 utilities including db2move, Redirect Restore, db2recover, db2pd, db2cos, db2gov

Involved in testing of Stored procedures, views and SQL to see resource consumption, execution time and overall process cost by using different DB2 utilities like db snapshot, event monitor, database table snapshot functions, and db2batch

Performed backend monitoring during the performance tests and generated summary reports for total execution time, individual execution time for all SQL runs during the tests, most expensive SQL runs during the tests, report on deadlocks and timeouts detected during the tests, CPU and IOwait state

Performed load test in order to reduce total load time from primary DB to secondary DB using different scenarios and as a final result converted SMS tablespace to DMS and reduced total load time by 40%

Performed modifications in CLI.ini file at client level and at Websphere to change default isolation level for all the requests coming from Websphere. This has reduced Production deadlock and timeout by 70%

Enhanced database structure by using MDC’s, MQT’s, introduced new indexes and tuned db2 bufferpools which helped reducing query execution time, I/O wait and CPU utilization

Created and maintained infrastructural diagram with the help of Microsoft Visio Diagram

Used db2pd during performance testing to check individual sql behavior, isolation level and locking behavior

Managed space in database filesystem, backup filesystem, transaction log filesystem and archive log filesytem by looking at database activity and growth

Provided guidance to ETL team on total space requirements from estimated total load rows count and increasing and decreasing tablespace accordingly. Used AutoResize tablespace option in QA and Dev to reduce daily maintenance and space error occurrences due to insufficient space

Developed “done” file technic in daily backup and runstat scheduling process which has reduced daily 7hours of maintenance time

Used different project and time management tools like E-labor and Clerity

Took courses on Corporate responsibility, Anti-Money Laundering ILC

Achieve certification ‘certified db2 administrator’

Environment: UDB DB2 V9.5 DPF,DB2 V9.1, 8.2 ESE, IBM Shark ESS SAN, Cognos V8.1, Data Warehouse Manager, AIX 6.1.0, Quest Central, Tivoli Storage Manager (TSM), p570, Java, Informix, SQL Server

IBM Global Services December 2005 – March 2007

Atlanta, GA

Lead UDB DB2 DBA

Developed, implemented, and provided steady state support for Common Portal Engine (CPE). CPE built as a common solution to reduce time to deploy portals, sites and communities, to reduce the investment cost and to reduce maintenance and ongoing support operations. There was lack of common or consistent “OneIBM” experience for the end user on the web. CPE’s objective was to focus on an enabling infrastructure for OneIBM and the portal strategy. IBM portal/site/communities utilize multiple solutions that lacked efficiency, and CPE’s purpose was to create a framework that potentially all ibm.com portals/communities/sites could utilize, that eliminates/reduces the need to create unique portal sites, from scratch, over and over again.

Developed, implemented, and supported a number of merchandising applications from the database perspective including Store Ordering, Purchase Orders, Receiving, Direct Store Delivery and Replenishment.

Executed Server build Transition and provided steady state support to various IBM internal and commercial customer accounts like Electronic Service Pack SSO2, WMI-SPoE Employee, CRS, Global Credit Solution, and MySupport.

Common tasked performed are:

Served as the lead DBA for the development, installation, and support of all online applications including implementation of discount provision for AAA customers

Designed and documented monthly updates load process and scripts

Installation of DB2 instances on AIX

Migrating data from DB2 7.1 to DB2 8.2

Migrating Sybase ASE V 10.5 to UDB DB2 V 8.2

Process flow preparation for the migration from Sybase to UDB DB2

Used Erwin to migrate the Sybase data model to UDB DB2 data model (a reverse engineer and a forward engineer would fit the purpose)

BCP utility in Sybase to migrate data from one database into ASCII comma files to load UDB DB2 tables.

Used DataJoiner tool for replicate, data transfer to another Sybase database

Compared Sybase Isolation levels with UDB DB2 isolation levels and implemented requisite bind parameter on DB2 for a smooth running of the application on DB2 without any potential of locks

Dealt with locking mechanisms on both databases extensively for a smoother application migration

Analyzed the SQL-CW (conversion work bench) from Mantech Systems Solutions Corp., for data migration techniques, and used unload and load commands from the tool for data migration

Helped out programmers in migrating Sybase Stored procedures to DB2 Embedded SQL programs written in Java

Conversion of remotely called stored procedures into UDB DB2 remote stored procedures using NFS mounted file systems

Conversion of Views built on other views from Sybase to DB2

Conversion of unique identifier from Sybase to DB2

Performance monitoring and tuning for DB2 databases

Creating EXPLAIN tables and running the visual explain utility on SQL statements

Run the capacity testing, perform benchmark testing, design and implement procedure for capacity testing

Production support to various db servers and participated in On-Call rotation on weekly basis

Acted on the tickets opened in ManageNow, on production servers providing level 2 support and on some projects providing level 3 support

Configured and implemented the entire IVT server including setting up the database filesystems (with sudo root access privileges) and implemented the full physical design for a VLDB Data warehousing environment.

Environment: UDB DB2 V 8.2 ESE, RS/6000 p-series, 5.3, Websphere Commerce Suite, Erwin, Teamsite, AS/400, Oracle V 7.1, Quest Central, DJRA V 2.1, SQLGuy (Evaluation version), PeopleSoft, Sun Solaris, DB2 Connect.

Consultant February 1997–November 2005

Hyderabad, India

Provided Consultancy Services to various clients as Software Analyst and Database Administrator handling DB2 on both AIX and Linux

Contact this candidate