DB2 Systems Programmer

Professional Summary

*.* years of IT infrastructure experience provided DB2 Database Administration and Systems Programming

Experience in supporting multiple large scale development, QA and production DB2 database environments

On-call 24x7 Support for Production environments for DB2 batch jobs and DB2 subsystems/instances

Z/OS systems programming installation skills including ISV product installation and support.

Excellent analytical, co-ordination skills and experience in managing projects (DB2 upgrade, 3rd party software product upgrades) and delivering quality work with relatively large number of interrelated processes

Experience in problem analysis and troubleshooting database related issues/incidents

Have ITIL knowledge and understanding of IT concepts and architecture with proven experience of successfully managing and maintaining IT infrastructure services

Performed business analysis and requirements-gathering for current, new or changing/re-engineered business processes

Developed, implemented, administered, and maintained policies and procedures for ensuring the security and integrity of the company database

Developed and managed relational databases, as well as VSAM files. Supported multiple distributed databases, data warehouse applications

Implemented data models, database designs, and data access and table maintenance codes

Worked on database release changes and supported migration of release changes from dev, test environments to pre-production and production environment through SDLC

Considered system features, configuration, compatibility and performance issues to recommend business operation changes to effectively use system resources

Established and enforced data security policy definition and administration as applicable to the organization

Responsible for selection, planning, and implementation of changes to subset of the Information Technology infrastructure

Performed root cause analysis for every incidents and issues

Provided DB2 database administration support on AIX, Linux, Windows and ZOS operating systems

Monitored CPU, Memory, Paging space, Disk I/O and analyse using Mainview and other tools

Installation of DB2 software and Fix Packs

Knowledge in UNIX Shell Scripting, REXX automation

Highly adaptable in a changing technical environments and ready to accept new changes as per the organizational requirements

Have worked with offshore team and ensured customer deliverables are delivered on time

Excellent customer service manner and built good relationships with the customers/clients

Ability to effectively interpret technical and business objectives and challenges, and articulate solutions

Ability to think abstractly and deal with ambiguous/under-defined problems

Demonstrated willingness to learn new technologies, process

Ability to work on own un-supervised and deliver on time to budget

Proven success as a professional technical worker in similar technical areas

Served as a seasoned/proficient technical resource

Technical Skills

Databases

DB2 UDB/LUW V9.5, 9.7 & 10.1, CA-DATACOM V11, Mainframe DB2 V8, V9, V10 and V11

Operating Systems

RHEL/CentOS 5.5, 6.5, Ubuntu 12 /14, Windows Windows 7 and ZOS1.13, ZOS2.1

Utilities

TSO/ISPF, QMF, ENDEVOR, OMEGAMON, CHANGEMAN, SPUFI, CLIST, REXX, CA DATACOM,CA-INSIGHT,RCUPDATE,SMPE,IBM LOG ANALYSER, DFDSS,

CA7 SCHEDULER, CONTROL-M, XCOM, (BMC)MAINVIEW CATALOG MANAGER, CHANGE MANAGER, SAVRS,ATTUNITY,TFS

Tools

Ticketing Tool

ServiceNow, BMC Remedy

Query Languages

SQL,PIG,HIVE

Backup Tool

Tar, gunzip, FDR and ADRDSSU

Programming Languages

COBOL, C, C++, Core Java Basics, C# Dot Net, JCL

File Systems

HDFS, VSAM, GDGs, PDS & PS

Training and Certification

IBM Certified DB2 9 Family Fundamentals Exam 730

Sun Certified Java Associate

Brain bench Certified in DB2 programming

Completed DB2 Universal Database Administration training for OS/390 version 8.1 in Data Software Research and Co. Ltd

Completed DB2 9 for Z/OS System Administration training (Course Code CV850) by IBM

Completed Basic Hadoop Administration training by PRWATECH.

Academic Qualification

Bachelor of Engineering from Visveswaraiah Technological University Belgaum in 2008

Awards and Professional Affiliations

Received Certificate of Achievement on successful completion of Dovetail Program in Mainframe Track in 2011

Received an Appreciation from Client for outstanding performance and lasting contribution in 2012

Received Cognizant IT IS Spot Award 2013 for the contribution to Marks & Spencer Project in United Kingdom

Received Cognizant IT IS Star SQUAD Award 2016 for the contribution to PEMCO Project in United States

Experience Summary

Cognizant Technology Solutions US April 2016 – Till date

Role: DB2 Database Administrator and Systems Programmer

Client: PEMCO Insurance

PEMCO Insurance is an American personal-lines mutual insurance company based in Seattle, Washington.

PEMCO is the Northwest’s largest local personal-lines insurer, providing auto, home, boat, life and umbrella coverage to general public.

Responsibilities:

He organizes, installs and maintains DB2 database and 3rd party software products in support of mainframe and distributed applications.

Provides consulting services to customers and helps provides support/solutions to complex DB2 environments.

Assists upper management and users in assigning priorities and planning future activities.

Participates in the development and implementation of complex databases, often using Mainframe DB2 database and UDB.

Works under minimal supervision with general guidance from more seasoned consultants or managers.

Works on complex problems where analysis of situations or data requires an in-depth evaluation of various factors.

Reviews requests for services, provides analysis and designs options to meet identified system/business needs.

Develops DB2 programs, tests and debugs critical mainframe DB2 applications and batch processes/jobs.

Prepares system specifications, develops projects schedules, with meaningful and observable milestones, and assigns tasks. Identifies and eliminates inhibitors.

Coordinates production schedules among production release areas at critical time frames.

Serves as senior technical staff member for assigned projects.

Participated in weekly/ monthly/ customer meeting and provided activities report

Have done maintenance on Control-M, BMC Catalog Manger and Change Manager

Environment:

Hardware: z-Series ZBC12

Operating System: z/OS 2.1

Software: JES2, SMF, RMF, SMS, SYNCSORT, RACF, Savrs, Attunity, Ratabase, Endevor

Tools: SMP/E, Mainview-2016 QMF, QUICKREF, Control-M

Infosys Ltd July 2015 – February 2016

Role: Database Administrator

Client: The Royal Bank of Scotland plc

The Royal Bank of Scotland is one of the retail banking subsidiaries of The Royal Bank of Scotland Group plc, and together with NatWest and Ulster Bank, provides banking facilities throughout the UK and Ireland. The Royal Bank of Scotland has around 700 branches, mainly in Scotland though there are branches in many larger towns and cities throughout England and Wales.

Responsibilities:

Identifies database requirements by interviewing customers; analyzing customer’s applications, programming and operations; evaluating existing systems and designing proposed systems.

Recommends solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.

Installs revised or new systems by proposing specifications and flowcharts; recommending optimum access techniques; coordinating installation requirements.

Maintains database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.

Supports database functions by designing and coding utilities.

Maintains quality service by establishing and enforcing organization’s business process standards.

Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; participating in professional societies.

Environment:

Operating System: AIX 5.3

Databases: DB2 V9, 9.7 &10.1

Tools: DB2 Connect, IBM Data Studio, BMC Remedy

Cognizant Technology Solutions Pvt Ltd India May 2010 – June 2015

Role: Database Administrator and Systems Programmer

Includes 1 year work permit onsite experience at client location in London UK

Includes 4 months business travel to Budapest Hungary and Manila Philippines

Client1: Marks and Spencer plc, United Kingdom

Marks & Spencer (M&S) is a major British retailer, with over 1000+ stores in more than 30 countries around the world, over 800 domestic and 300 international. It is the largest clothing retailer in the United Kingdom.

Client2: UBS (Union Bank of Switzerland): UBS is a Swiss global financial services company, incorporated in the Canton of Zurich and co-headquartered in Zurich and Basel. The company provides wealth management, asset management, and investment banking services for private, corporate, and institutional clients worldwide.

Responsibilities:

On-call 24x7 Support for Production environments for DB2 batch jobs and online regions

Developing & maintaining naming standards for database objects such as table spaces, Tables, Indexes & Views

Designing & creating relational database objects such as tables, views & indexes

Preparation of jobs for Load and Unload utilities and its execution

Database refresh from production to non-prod systems

Recover database as part of the Backup and Recovery procedures

Creating storage group, database & different types of table-spaces for users

Cloning DDLs of DB2 objects for non-prod regions from production

Creating Plan & Packages and granting BIND, EXECUTE PLAN access

Setting authorization to the newly created databases

Using both On-line utilities & Stand-alone DB2 utilities

Controlling access to DB2 Objects (Grant and Revoke) & Database

Connecting and Disconnecting CICS(& other services) from DB2

Modifying DSNZPARM parameters, PARMLIBs and PROCLIBs changes

Having knowledge on SMPE to upgrade DB2 related products as per the check list

Working knowledge on utilities like DSNJU003, DSNJU004, DSNJLOGF & DSNJCNVB etc

Ordering, customizing and applying 3rd party product’s maintenance and upgrade

CA-Datacom database Administration

Having knowledge on SMPE to upgrade database related products as per the check list

Working knowledge on utilities like DSNJU003, DSNJU004, DSNJLOGF & DSNJCNVB etc

Maintaining Active and Archive logs

Maintaining Boot strap dataset (BSDS), Bufferpools requirements

Ordering, customizing and applying DB2, DATACOM preventative maintenance

Have worked in new DB2 Subsystem builds

Configuration of SMS base environment (SCDS, ACDS and COMMDS) and Modify ACS routines

Environment:

Hardware: z-Series Z196 & Z10

Operating System: z/OS 1.13

Software: TFS, ES2, TSO, JCL, ISPF, SDSF, SMF, RMF, SMS, DFSORT, RACF, DB2, CA-DATACOM, CICS

Tools: SMP/E, Ca7, CA-Solve, RC-update, CA-insight, QMF

Only IT Consulting PVT Ltd, India August 2008 – April 2010

Role: DB2 SQL PL Developer

Responsibilites :

DB2 UDB EE Database development and support

Altered tables and added check constraints and referential integrity

Created and maintained Databases, Tablespaces, Tables, Views, Stored Procedures, Triggers and Indexes

Interact with business team and development teams for incorporating new functionality

Participated in enterprise-wide application and database production releases

Developed shell scripts to handle DBA tasks and alerting systems

Documented plans and procedures in terms of backups, restores and disaster recovery

Checking the consistency of the databases using different db2 commands

Data maintenance activities like REORG, RUNSTATS, LOAD, UNLOAD, IMPORT and EXPORT

Tuning application queries, databases and systems for best performance

Performed performance tuning and capacity planning using the parameters of dbm configuration file & db configuration file and various db snapshots

Environment:

DB2 UDB V8.x, DB2 Connect, SQL Server 2000, AIX, Windows 2000, WIN NT, Web Sphere, Java 1.2, .Net, JSDK 2.0, JDBC, JavaScript, Apache Web Server EJB (J2EE), XML

Contact this candidate