Mayavinodhan S

DB2 z/OS DBA Lead with 13+ years of experience in DB2 database administration, production support, performance tuning, database design, and mission-critical mainframe environments. Currently leading a 6-member DB2 DBA team, providing technical direction, work allocation, production support, incident management, and coordination with application and infrastructure teams. Strong expertise in DB2 V13, performance optimization, index and tablespace management, PBG/PBR conversions, DB2 utilities, backup and recovery, database change implementation, and complex production troubleshooting.

Experienced in mentoring team members, driving continuous improvement, and delivering database modernization and automation initiatives.

Lead Administrator – Mainframe Infrastructure (DB2 z/OS DBA) - WIPRO TECHNOLOGIES PRIVATE LIMITED - Northwestern Mutual

(2019-05)

• Currently lead a 6-member DB2 z/OS DBA team, providing technical direction, work allocation, task prioritization, and day-to-day operational support.
• Coordinate DB2 production and non-production activities, ensuring timely completion of critical database changes, maintenance, and support requests.
• Act as a primary technical point of contact for complex DB2 issues, production incidents, performance problems, and application-team escalations.
• Review and provide technical guidance for DB2 changes, database design, performance optimization, utilities, and production implementation activities.
• Coordinate with application, infrastructure, scheduling, and other support teams to ensure smooth implementation of DB2 changes and timely issue resolution.
• Monitor team workload, prioritize critical activities, and ensure SLA compliance for production support and ServiceNow tickets.
• Mentor team members on DB2 z/OS administration, performance tuning, utilities, troubleshooting, and production support procedures.
• Support critical production incidents through issue analysis, resolution, technical communication, and post-incident follow-up.
• Perform daily DB2 support activities including health-check monitoring, job-abend resolution, locking and contention analysis, space-related issues, authorization issues, and scheduling administration.
• Create, alter, and maintain DB2 objects including databases, tablespaces, tables, indexes, views, and aliases across test and production environments.
• Synchronize DB2 objects between environments and migrate approved changes using IBM DB2 administration tools.
• Execute and troubleshoot DB2 utilities including LOAD, UNLOAD, REORG, RUNSTATS, MODIFY, and STOSPACE for database maintenance and data management.
• Perform backup and recovery activities and support data refresh activities across test and production environments.
• Review application SQL and DB2 EXPLAIN output prior to production implementation to identify potential performance risks.
• Create change-management packages and stage components for production fixes and database changes.
• Provide technical support to application development and production support teams and resolve DB2 issues within agreed SLAs.
• Manage and track incidents and service requests through ServiceNow while maintaining operational and SLA commitments.
• Converted application UNLOAD jobs from DBA project code to the respective application code, improving ownership and operational alignment.
• Converted conventional UNLOAD jobs running under DSNUPROC to High Performance Unload (HPU) using the INZUTILB utility.
• Delivered a DB2 performance improvement initiative by optimizing index column ordering from DESC to ASC; 300 indexes were completed as part of the initiative.
• Supported conversion of DB2 tablespaces from Partition By Growth (PBG) to Partition By Range (PBR) to meet data-retention and data-management requirements.
• Managed partition additions and partition reuse for date-based PBR tablespaces when date-limit keys approached configured thresholds.
• Provided end-to-end DB2 support for Informatica PowerExchange and Qlik replication activities across DB2 environments.
• Supported database design, implementation, migration, performance analysis, production troubleshooting, and maintenance for large-scale mission-critical DB2 databases.
• Contributed to operational improvement and automation initiatives to reduce manual effort and improve consistency of DB2 support activities.

DB2 z/OS DBA - CAPGEMINI TECHNOLOGY SERVICES INDIA LTD - MetLife Project

(2013-01 - 2019-05)

Environment: IBM z/OS 2.3, DB2 for z/OS. Project Period: Aug 2013 – May 2019

• Supported conversion of simple tablespaces to Universal Table Spaces with Partition By Growth (PBG) as part of DB2 V10 modernization activities.
• Supported conversion of classic partitioned tablespaces to Universal Table Spaces with Partition By Range (PBR).
• Managed partition additions when limit keys approached the maximum threshold for PBR tablespaces.
• Supported partition rotation and reuse strategies for date-based PBR tablespaces to maintain controlled data retention.
• Created DBA maintenance-trial setups covering Image Copy, REORG, RUNSTATS, and OPC scheduling for newly created databases.
• Supported conversion of PLAN_TABLE and related EXPLAIN tables from DB2 V8 to DB2 V10.
• Updated GDG base limits and utility/job-name standards consistently across production environments.
• Supported removal of unused packages from production environments across regions.
• Supported BMC V11.2 QA upgrade activities associated with new DB2 subsystem conversion.

Bachelor of Engineering (B.E.) - Electrical and Electronics Engineering - Anna University, Chennai