PROFESSIONAL SUMMARY

** ***** ** ******* ** experience mainly in IBM DB2 LUW Database and also in Netezza, SAP Hana platforms.

Experience with other databases like SAP HANA, Oracle and SQL Server

Fast Learner and Exception problem solving ability.

Proficiency with Installation, Creation and maintenance of the DB2 and Netezza Databases.

Team player and self starter in getting the DBA level tasks accomplished.

Applied DB2 Fixpack Upgrades, good at Backups and Restores, Reorgs, Runstats, Rebind

Good at performance tuning making use of DB2 innate tools like snapshots and query tuning.

Have hand on working on TSA, HADR, SQL Repliction, CDC replication,Table partitioning, database partitioning, query tuning.

Proficient in using DB tools like Toad, DBA cockpit, service now, control center, ITAM,TSM, DD boost, Networker etc.

Knowledge of IBM DB2 Pure scale Technology, and Q replication

Netezza DB proficiency in groom,genstats, troubleshooting, NZ_Migrate, Nzload, Nzresponders, nzhealthcheck etc.

Good at both OLTP and OLAP type workload administration. Build physical and logical table and Database designs.

Well versed with Unix shell scripting, batch job scheduling for automating tasks. Process oriented and follow ITIL processes like Incident Management, Problem Management, Change Management, and Capacity Management

Secondary skills in other RDBMS such as Oracle, and SQL Server.

Technical Skills:

Database: DB2 LUW,IBM pure Data systems(Netezza),SAP HANA,

Languages: Java – Core Java, J2EE – JSP, Servlets, EJB, JMS; C++,C;

O.S: UNIX, Windows XP, Windows 2000, Linux, Mainframe OS

Tools: IBM Optim, IBM Data Studio, Control Center, Toad,SVN, HPSA,DBA Cockpit,HANA Studio, Aginity

Scripting: K-Shell Scripting,Bourne Shell,C shell, AWK, Perl,

Ticketing: Service Now, Remedy, HP Quality Assist etc.

WORK EXPERIENCE

Period

Designation

Company

Apr2015 to Till date

Tech Specialist

Branch Bank and Trust

Oct 2013- Apr2015

Associate Operations Manager

Academy Sports and Outdoors

Jul 2011-Jun 2012

System Analyst/Senior System Admin

Aviva

Aug 2010 – Dec 2010

Assistant Systems Engineer

Tata Consultancy Services Ltd

Apr 2007 – May 2009

System Operations Lead Specialist

IBM India Private Ltd

Nov 2005 – Mar 2007

System Administrator

Maples ESM Technologies

TECH SPECIALIST AT BB AND T (BANK BRANCH AND TRUST)

Administer and maintain a set of several database servers in Production, Test, QA and Dev environments under DB2 UDB, and Netezza Systems and Hana database.

Take care of Backups, Restore, load, instance startup and stop.

Maintenance activities such as Runstats and Reorg.

DB2 fixpack upgrades

DB2 Load Test and Performance Tuning

Query tuning

Add and detach table partitions, purging data, and fix pack upgradation etc..

Netezza Genstats, NZLOAD, Create table external, NZSTATE, NZSQL commands, NZBACKUP, NZRESTORE, Aginity Workbench and NZADMiN tool.

Plan for DR activities such as failover.

Moving data and perform referesh activities in DB systems.

Environment: IBM DB2 UDB V9.7 FP11, V10.1,Advanced Enterprise Server edition, Enterprise Server edition, HADR, Partitioning Feature, Netezza IBM Pure Data System for Analytics N3001 model,SAP R3,DBA cock Pit,HANA DB.

Oct 2013 – Apr 2015

Associate Operations Manager

Academy Sports and Outdoors (USA Retail, Texas),

Some of the roles performed are listed as follows and there are more roles but this is not the complete exhaustive list.

Support client databases running on DB2 UDB V9.1, DB2 UDB V9.7, and V10.1

Apply Fixpack and Migrate databases to higher Versions

Be responsible for L1, L2 and L3 activities, problems and Changes for the databases. Attend Client Bridge calls whenever a P1 issue occurs.

Ensure Backups are completed, monitored and documented. Restore databases from one server to another, one environment to another.

Proactively monitor the DB for impending problems and foresee solutions

Perform Recovery activities as and when needed as requested by Applications team

Drive the service improvement plan level changes for the client.

Coordinate with onsite DBA counterparts and work in harmony

Produce weekly Reports and Dashboards for the client and CTS internal stakeholders.

Recommend solutions to performance problems faced by the client.

Interact and participate in meetings with Client Managers.

Drive Service improvement Plans

Environments: Prod, Systest, UAT, Sandboxes, AIX, DB2 UDB ESE products, TSM client, Oracle 11i, CDC V10

AVIVA, UK Jul 2011 – Apr 2012

System Analyst/Senior Systems Admin

A well known Insurance company located in Norwich having international offices worldwide and very popular in UK dealing with insurance as the main business focus. The job role here demands supporting and maintaining not only DB2 UDB v9.7 databases but also SQL Server 2005 and 2000 databases.

Manage change and related activities co-ordination with other team, getting things done from team members and other teams

Accountable and managed Effectively- Incident management, Defect management

Liaising between teams to drive forward and fix issues.

Participation in CAB (Change Approval Board) meetings for change intimation, schedule clearance and approval

Represent First and Single Point of Contact against any DB Incidents

Review Deployments and manage tech commissioning work related to databases after every release activity

Review scripts/DB code for deployment

Data loads, extracts, purge and refresh activities also occur from OM mainframes Server to DB2 database SDC on periodic basis

Undertaken careful and well planned implementation with back-out plans

Queried and cross verified the table contents first to determine the validity of data and compare it with the application flow which walks through Websphere portals, ESB servers, DB2,OM and Unisure applications

SQL Server activities involves periodic clearing of Pay G application whenever refresh activity is needed. The workflow of this PAYG application is a complicated mechanism and goes through a cyclic process of task execution across subsystems such as SABRE mainframes backend, OM work manager, and PAY G SQL Server database. On Demand and need basis, restore of SQL Server DB. Among these, other Admin tasks carried out

Environment: WCC, Mainframes, ESB Servers, DB2 V9.7 and SQL server 2000/2005 products used are present in Dev, SYSTEST, SIT, UAT, Preview, and Pre-prod

Tata Consultancy Services, India AUG 2010 – JAN 2011 Assistant Systems Engineer

The TCS Client, UK at Basingstoke is a well known player in entertainment field of business having a reputed brand image in Europe and rest of the world. The databases supported here include Mainframes, AIX and Windows boxes of which the DBA is responsible for creation and maintenance of several AIX and windows UDB boxes and providing application support to end users.

Carried out admin activities such as : import, export, Tablespace and DB monitoring, building DB systems,DB2 connect configuration against mainframes, handling database and table partitioning, HADR, and Data-warehousing

Environment: DB2 UDB 9.4, AIX 5L, Windows 2000 server, DB2 Connect

IBM India Pvt Ltd, APR 2007 – May 2009 Systems Lead Operations Specialist,

(Sweden) MAR 2008 – MAY 2009 IBM DB2 Consultant, P590 Implementation Project

WPG was originally residing in Oracle databases. The data was then migrated to DB2 UDB. The DB2 UDB database is used as a message store house for message-oriented Websphere-MQ application. This OLTP application demands high performance throughput. The messages are critical for IBM’s Client as they store information related to their businesses from various places across the world.

Tuned Performance and brought speed up with a number of analysis and tuning

Implemented High Availability Disaster Recovery

Wrote Korn Shell Scripts. Developed and deployed routine jobs, runstats etc

Environment: IBM DB2 9.1, AIX Operating System, IBM Websphere MQ, IBM WPG

Lean Metrics

Lean Metrics project does data collection about various services across the globe where an Enterprise service delivery based model is implemented. A typical service model would contain an SLA for each problem/change ticket. The on-boarded accounts consist of those that have Manage Now Ticketing Tool. All these data will be transformed later and stored in a Data Warehousing database. The BIRT tool will query the database to extract useful information. This information will help to generate sophisticated statistics

Created and Monitored Users, authorities and responsibilities and password management.

Enhanced the application performance, by running RUNSTATS, REORGCHK and REORG utilities.

Backup & Recovery of Database, Online database backup, archived redo log file and offline database backup.

Created logical/physical design for the datawarehouse. Formulate backup/recovery strategy.

Work with system admins to make system available for production.

Inspected and Ran SQL script on Mainframes and UNIX databases

Ran batch queries

Extracted input files and data using PHP and ran them against Java program for processing and then loading that data into database.

Environment: DB2 UDB V9.1 on Linux for QA system and on AIX for Prod System, SQL replication, backup and recovery, restoration point-in-time, export, import, load, reorg

IBM Global Services, India APR 2006 – APR 2007, Systems operation Lead Specialist

Division: Enterprise Business Hosting Services, UK Region

EBHS is a whole set of enterprise service provided to a group of customers like RSA, Wimbledon, Arcadia Systems Asthellas, Debbenhams, O2 etc... The services provided include Database support, UNIX support, Windows, Tivoli, Storage support, Network support etc.

Product sets include databases which are at DB2 UDB V7 Level to DB2 UDB V8.

Performed hands-on database engineering tasks in the development of OLTP databases

Provided technical recommendations to service managers/leaders & technical direction to team members

Analyzed technical problems and created solutions involving the use of existing techniques or tools

Configured and maintained DB2/TSM interface

Conducted Database recovery

Monitoring, Performance Tuning, support and maintenance

Prepared and documented DBA Config sheets and Backup config sheets

Developed Cron jobs for tasks such as scheduling / re-scheduling of back-ups; Completed database housekeeping activities which mostly occurred during HACMP upgrade, AIX upgrade, MQ Series upgrade etc.

Performed Daily and Quarterly health-checks complying to IBM processes; GSD331 Health checks

Resolved HACMP (High Availability) failover issues and recommended solutions.

Highly documented. Process oriented and Good Communication Skills

Scheduled online backups on Windows servers using batch scripts

EDUCATION

Bachelors of Engineering in Computer Science at University of Madras 2000- 2004

Masters in UK, MBA at University of Northampton, UK 2009-2011

IBM DB2 DBA Certification

IBM Netezza Pure Data Systems Certification.

Contact this candidate