Mainframe DB2 DBA

REKHA JYOTHI SIDDAMSETTI

Mainframes z/OS DB* DBA

E-mail: *****.***********@*****.*** Phone : +1-615-***-****

PROFESSIONAL SUMMARY

Having 8+ years of IT industry experience and working as Mainframes DB2 z/OS Database Administrator in Manufacture Domain for the past 7+ years. Worked extensively in production and development environments till date.

Worked on oracle and PostgreSQL database Administration

Worked on Application packaging

Worked on z/OS, UNIX, AIX and Linux platforms.

A good team player with excellent communication and interpersonal skills.

Alternately work independently and take leading responsibilities to achieve objectives.

Professionally prospect to work in line with clients and winning clients confidence.

Adaptable to work in any kind of environment and to take up challenges

Experience in preparing Technical Documents on relevant topics.

Able to work in multi technologies.

Coordination between the Client ( BA’s and users) and the offshore team.

Mentoring the offshore team and assisting them to improve their business knowledge.

Identifying the new areas of work, conducting regular meetings with key customers, collecting the feedback and driving the initiatives to improve customer satisfaction.

Track, measure and ensure adherence to established metrics.

EDUCATION

Qualified B.Tech in Srinivasa Institute of Engineering & Technology in the year 2013.

TECHNICAL SKILLS

Good knowledge on DB2 z/OS Database Administration.

Hands on experience in create/maintain database objects.

Familiar with Mainframes TSO ISPF, JCL.

Experience in usage of IBM utilities.

Experience in BMC tools and utilities.

Familiar with COBOL-DB2 program development process.

DB2 performance analysis with tools such as Strobe and Omegamon.

Experience in developing home-grown REXX scripts and COBOL programs to benefit

DBA activities.

Experience in Disaster Recovery Exercise (DRE).

Resolving Job abends. Working on executing the DDL’s on all database environments when provided with necessary approvals.

Having knowledge on Oracle, Postgresql

Got an exposure to the DB migration projects to AWS cloud platform.

Operating Systems

z/OS, Linux, AIX, Unix, Windows.

Languages

PL/SQL, COBOL, JCL, C, C++, SQL, REXX script

Databases

z/OS DB2 (V7 – V12), Oracle-12c, PostgreSQL, Mysql

Tools & Utilities

BMC, TSO, ISPF, SPUFI, ISPW, OMEGAMON, CA-7, PANVALET, STROBE, Endevor, RMAN /User Managed, OEM, Data pump import & export, PEM, PGADMIN, AWS Schema Conversion Tool, HADR, RMAN, RAC, SQL Developer, EDB Loader, TOAD for Oracle, VMware, AWS DMS tool

Domain Knowledge

Manufacturing

PROFESSIONAL EXPERIENCE

Tech Mahindra : 2014 – Till Now

Current Project : Nissan (March, 2015 – Till now)

Simultaneously supported different flavours of databases in Nissan (z/OS DB2, Oracle, Postgresql, Mysql)

Project 1 – March, 2015 – Till now

Client : NISSAN NORTH AMERICA, Franklin, Tennessee

Project : NNA AMO COE - DBA-Child PID

Role : z/OS DB2 Database Administrator

NISSAN NA is an Automobile giant which stands among the top 5 automobile

companies. NNA AMO COE - DBA-Child PID is the Module of NNA DBA which will maintain the Databases. NNA DB2 DBA Remediation and Upgrade is upgradation

project which majorly involves in library upgradation and providing database

administrative and maintenance services like daily backup and recovery.

Skills & Tools

z/OS DB2 (V7 – V12),JCL, COBOL, REXX, BMC, TSO, ISPF, SPUFI, ISPW, OMEGAMON, CA-7, PANVALET, STROBE, ENDEVOR,ABEND-AID

ROLES & RESPONSIBILITIES

Provide technical support to application team in their daily database related activities.

Analyse performance issue with DB2 programs.

Creating DB2 objects like tables, views etc. depending upon the application team

requirement

Analyse and fix job fails.

Supporting in the CMT activities for production support.

Checking the table space alerts and adding space to avoid the table load failures in production environment.

Worked for the project to change all the existing reorgs to NGT reorgs to get the better performance.

Scheduling the Daily, weekly and monthly backup jobs to run based on the requirement and monitoring their healthy run.

Work on validating and executing DDL’s in production and development

environments when provided with necessary approvals.

Work with different tools within mainframe based on requirement (BMC, SPUFI,

OMEGAMON, STROBE, ISPW, CA-7 etc.).

Involve in DB2 upgradation process.

Creating and maintaining REXX scripts and COBOL programs for DBA related

activities.

Involve in granting authorization and privileges for DB access. Resolving the tickets and working on OSS tasks.

Attending the status calls with client.

Coordinating with onsite team and offshore team.

Giving knowledge transition to new joiners.

Participating in Disaster recovery activity that happens every 6 months.

Providing new project ideas to business for achieving a better performance of environment.

Worked on Remedy Incident Management tool and Service now Tool for ticket

management.

Handling Regular Backup and Recovery.

Nissan: Feb, 2021– Till now (Project 2)

Client : NISSAN NORTH AMERICA, Franklin, Tennessee

Project : Oracle to Aurora PostgreSQL Migration

Role : Database Administrator

Skills & Tools:

Oracle – 12c

RMAN /User Managed, OEM, Data pump import & export, PEM, PGADMIN, AWS Schema Conversion Tool, HADR, RMAN, RAC, SQL Developer, EDB Loader, TOAD for Oracle, VMware, AWS DMS tool

ROLES & RESPONSIBILITIES – Oracle and PostgreSQL DBA

Provided support for the regular maintenance activities.

Provided support for the data refresh activities for various environments.

Working on executing the DDL’s on all database environments when provided with necessary approvals.

Worked on Space utilization alerts and maintaining the database healthy.

Regular health check of databases.

Good exposure to capacity planning for future growth of database.

Proficient in using PostgreSQL’s PGADMIN, Postgres Enterprise Manager, High Availability, Backup and Recovery Tool, Performance Tuning, Database Maintenance like patching & up gradation and PL/PGSQL queries.

Very strong experience in Oracle to AWS Aurora migrations and in using AWS Schema conversion and AWS DMS tools.

Skilled at troubleshooting all sort of critical issues related to database systems - applications and allied tools.

Structural migration from Oracle to Aurora PostgreSQL using AWS Schema conversion tool.

Data Migration and validation from Oracle to Aurora PostgreSQL using AWS DMS tool.

Assigning proper roles to the users.

After successful migration, providing the regular RTB support for the PostgreSQL environment.

Nissan: July, 2021– Dec, 2021 (Project 3)

Client : NISSAN NORTH AMERICA, Franklin, Tennessee

Project : Mysql to Aurora PostgreSQL Migration

Role : Database Administrator

Skills & Tools

Mysql – 5.7, PGADMIN, AWS Schema Conversion Tool, AWS DMS tool

ROLES & RESPONSIBILITIES

Requirements Analysis, Cost Estimates, Technical Design Creation and Design reviews.

Preparing architectural design documentation, creating new environments, creating database instances to host the new applications.

Attending the daily status calls with Nissan Business and solution Architects to coordinate and design the implementation plan

Coordinate with business clients, support the database and implement the process as per specifications provided.

Structural migration from Mysql to Aurora PostgreSQL using AWS Schema conversion tool.

Data Migration and validation from Mysql to Aurora PostgreSQL using AWS DMS tool.

Assigning proper roles to the users.

After successful migration, providing the regular RTB support for the PostgreSQL environment.

BASF : May, 2014 – Feb, 2015

Client : BASF Business Services Holding GmbH

Project : Application Packing

Project Description :

BASF is the leading chemical company: The Chemical Company. With more than 112,000 employees, six sites and 376 additional production.

BASF SE is the largest chemical producer in the world and is headquartered in Ludwigshafen, Germany. Worked with BASF which is a German client. It is a migration project which majorly deals with testing of the applications which are already built in Win 7 and needs to be tested in Win 8 64 bit environment.

Functional Skills : Re-certification, Packaging, VMware

ROLES & RESPONSIBILITIES

In this BASF project, has been a part of the service line Recertification.

Worked in developing the applications from .msi files and making them to be executable applications.

Testing the application functionalities in VMware machines.

Documenting the instructions and guidelines to use the application

Provided continuous services to the Recertification service line throughout the project.

The project requires a regular customer interaction and it has helped me to improve my communication skills and also made me technically sound.

Received award for delivering the maximum number of applications in the allocated timelines.

ACHIEVEMENTS

Received Bravo award twice from project.

Appreciations from clients and application teams for successful on time project delivery.

Contact this candidate