DBA DB2 LUW

Nag Yenagandla

Address: *** *********** *****, **********, ***** 75056 Phone: 469-***-****

Email: *******@*****.*** LinkedIn: www.linkedin.com/in/yenagandla/

Highly innovative IT professional with 19 years of experience in administering, monitoring, implementing, and testing database products, including DB2 LUW and Oracle within DevOps environment.

Areas of Expertise

Database Installation, Upgrade, and Maintenance Cloud Migration Software Engineering Capacity Planning

Data Analysis Space Management Security Audit Performance Tuning Query Optimization Staff Supervision

Technical Acumen

Databases:

DB2 LUW (v8.x/v9.x/v10.x) Oracle DB2 on Mainframes (z/OS & OS/390) (v7.2)

Redbrick Db2 Connect AWS PostgresSQL

Cloud Services:

AWS OCI (Oracle Cloud)

Operating Systems:

UNIX (AIX) Linux Windows z/OS on IBM Mainframes

Programming Languages:

Unix Shell Scripting Perl Scripting SQL COBOL JCL

Other Tools:

Oracle SQL Developer Toad

Professional Experience

Verizon Enterprise Solutions, Irving, TX

Senior Database Administrator (DBA)/Technical Lead Apr 2000–Present

Effectively administer and execute various heterogeneous operational databases in company’s portfolio, including DB2 LUW; Oracle; AWS and Oracle Cloud (OCI) migrations from system requirements to post-production support

Manage both onshore and offshore teams in assigning, tracking, and guiding administration and support activities to ensure 24/7 systems availability

Maintain active involvement in support activities, including installing, configuring, and deploying database changes across all environments, as well as in capacity planning and space management

Conduct configuration of Websphere federation server to access Oracle, Adabas, AS/400 databases from DB2 LUW, as well as DB2 Connect to connect to mainframe(z/OS) databases

Implement validations and alerts across database systems to minimize application downtime from hours to minutes; as well as High-Availability Disaster Recovery (HADR) setup for disaster recovery and High-Availability Cluster Multi-Processing (HACMP) for high-availability cluster

Key Highlights:

Succeeded in completing more than 100 medium- to large-scale implementations by managing projects from business requirements analysis to solutions delivery and support

Significantly mitigated multiple manual health checks with automated database processes of enterprise databases in DB2, Oracle, and UNIX and Linux

Brought substantial reduction to database support tickets by 50-60%, which resulted in the increase of the company’s revenue and business

Led the migration of database instances from previous version (Db2 LUW) to current version with minimum application downtime

Played a key role in enforcing automated backup strategy which helped with successful database restorations in various occasions without losing data

Established reputation for receiving the following awards:

–Vice President Spotlight Award in October 2017;

–Chief Information Officer All-Star Award for June 2007; and

–Chief Information Officer All-Star Award for May 2005

Earlier Career

Innovative Solution Technologies, Colorado Springs, CO

Application DBA (ETMS) Programmer Analyst (CSM Y2K Phase I & II)

Senior Software Engineer, MCI Telecommunications Mar 1998–Mar 2000

Education

Master of Business Administration in Project Management: Jun 2010

Colorado Technical University, Colorado Springs, CO, USA

Master of Business Administration in Technology Management: Dec 2008

Colorado Technical University, Colorado Springs, CO, USA

Bachelor of Technology in Mechanical Engineering: Jun 1995

Nagarjuna University, Guntur, AP, India

Professional Development

Certification:

Amazon Web Services (AWS):

Certified SysOps Administrator Associate, 2018

Certified Developer Associate, 2018

Certified Solutions Architect Associate, 2017

IBM:

Certified Advanced Database Administrator – Db2 LUW ( v8.x, v9.x, v10.x)

Project Management Institute:

Certified Project Management Professional (PMP), 2009

Colorado Technical

University:

Professional Certification in Project Management, 2010

Professional Certification in Technology Management, 2008

Professional Certification in Business Management, 2008

Training:

MongoDB University Udemy:

M103: Basic Cluster Administration, 2019 M201: MongoDB Performance, 2019

M310: MongoDB Security. 2019 M312: Diagnostics and Debugging, 2019

Activities

Coordinator and Project Manager, SiliconAndhra ManaBadi (2011–2017)

Contact this candidate