Principle Scrum Master for the Digital DevOps team for AT&T Digital DevOps team from their prepaid brand of Cricket Wireless.

Client: E-Trade/Morgan Stanley  Atlanta, GA March 2022 – July 1st 2022• Used db2expln and db2advis to tune the expensive queries that ran against the production data.• Used DB2 utilities like Snapshots, db2batch, db2exfmt, event monitor, for performance tuning and monitoring.• Worked on long term assignments handling Decision Support Systems (DSS) with DB2 as backend.• Instrumental in physical designing of DB2 Database Servers on both UNIX (AIX) and Linux environments.• Handled different Backup policies, and did hands on restores (version and point-in-time) and redirect restores as and when needed. • Understands the OS level to the extent the DBA is needed to, to interact or work hands-on to layout DB Servers, file system perspective.• Experienced in disaster recovery methodologies like HADR.• Used shell scripts to automate and maintain DB Server activities.• Experienced in performance tuning and monitoring of OLTP applications and DSS applications.• Worked as Development DBA, Production Support DBA and DB2 UDB Database Engineer.• Worked as Database engineer and heavily involved in POC, testing and certifying new tools.• Understands the pro-activeness needed for the DBA, and resorts to automate most of the administrative tasks.• Evaluated DB2 new versions and features and suggested migrations from DB2 lower versions to current versions.• Delegated work to the DBA offshore team members by giving required check lists for the DBA’s to follow for lower life cycle and production systems

•Created and Developed a centralized framework for Azure DevOps by establishing limited governance to align for business needs but individual teams remained autonomous.•Member of ITSS Azure DevOps Expansion Team that used my centralized framework approach to start the expansion of DevOps across the organization for the work ITSS teams for the tracking and reporting of Process Improvement work.•Created and Developed the Template Concept for Centalizeds Work Item Taxonomy for roll up reporting that PowerBi leveraged for unfied data hooks across directors.•Engineering the DB2 LUW offering on the cloud (Azure) and DB2 LUW Golden Template for faster Deployments.•DB2 Platform Lead that facilitated a Road Map of the DB2 LUW v9.7 retirement while getting Aligning with the Application and OS Team.•Implementing Best Practices, Knowledgebase Documents, and Interactive Working Sessions for the •Partnered with the Desktop Team, Helpdesk, and the Asset Management Team to implement a framework to Retire DB2 Connect (Licensing Implications).•Created a Deployment Package with DB2 Runtime Client (Free) and offered it on YUM's centralize software repository. Offered a Step-by-Step Installment Guide.•Worked closely with DBA Operations Team to Identify Performance Issues and Implemented Performance Enhancements around Automation, Runstats, Reorgs, Backups, Process, and Standard Templates.• Obtained my Professional Scrum Master Certification and took on a New Role as a Part-Time Scrum Master and worked with teams on implement the Agile Scrum Framework.• As a Scrum Master worked with teams to establish true velocity and story points by coaching them in the Scrum methods and which helped the business gain the maimum efficiency from the team and have more visibility in the working being done.

Employer: Yum Brands!, Louisville, KY, June 2017 – April 2019•Team Lead in charge of offshore DBA and Project DBA.•Worked on engineering new solutions for Archiving Databases for Audit purposes.•Worked on creating a project plan to upgrade environments from db2 9.7 to db2 10.5 while also working closely with IBM on PVU licensing.•Worked on creating and DB2 LUW team culture and regular meetings to touch bases with all DBA’s on my team also assigned work during this time and took status reports.• SME for DB2 LUW on the WebSphere Portal V8 to V9 upgrade.•Implemented best practices for DB2 and Operating System once taking over the Platform.•Created scripts to force of idle threads on the Operating System and alert DBA/Application team when this happened. •Lead the effort to create standards for Database LPAR/VM request for the System Admin to build.•Modernized the DB2 Security and Operating System groups for all DB2 environments providing better security for the business.•Team Lead that was in charge of mentoring junior DBA’s and helping them when the issue was escalated.• Eliminated barriers with the Security(Tivoli) team to tune the Identity Management and Access Management Database.•Worked relentlessly to identify Database Performance issues that came from I/O bottlenecks and OS parameters not set correctly and provided it to the team as a Standard for DB2 servers.•Designated as a Technical Expert for DB2 LUW projects that identified Database Task and partnered with Project Managers to make sure Business goals were met with lower cost.•Created Knowledge documents so Junior DBA’s could follow for basic trouble shooting and task.

End Client: Eli Lilly and Company•Lead DB2 dba for TCS and worked with Client to come up with Capacity Planning, Database Upgrade Schedule, POC, and Debugging.•Lead DBA in charge of status reports, project estimation, DR, client coordination, and implementation of DB2 database solutions.•Lead the DBA Team in maintaining project work for Z, D, J, Q, S, P, X, Y environments with multiple databases under them.•Lead DB2 DBA for knowledge transfer to other TCS DBA on other platforms such as Oracle and SQL Server.• Helped in the maintenance of SAP databases on DB2.•DB2 upgrades to version 10.5 ftp 6 from V.9.5, V9.7, V10.1.•Configuring HADR systems for the SAP Databases.•Performed manual Hadr takeover for Primary and Standby databases. •Participated in the migration of WMware to Extreme IO storage option.•During Storage Migration migrated the database from 9 data containers to 4 data containers.•Data/DDL Movement from database to database on separate servers.•Database Restores/Database Backups,Database monitoring and performance tuning.•Worked directly with the SAP Administrators on the Project to implement DB2 solutions.•Created SOP documents for the Client. •Worked to identify RCA with Database issues.•Worked with very large databases some over 20 TB in size.

End Client: Ricoh Americas Corporation• Helping in the migration from DB2 z/os to DB2 LUW on AIX v10.5.• Implementing different database jobs such as reorg, runstats, etc.• Tuning Jasper reports that run on the database server.• Backups, Restore, Tuning and debugging of the database.• Maintaining a HADR cluster where the standby is read only and running reports off of.• Working with the DBA team to come up with a security structure for the client's environment for DB2 LUW.• Working with the developers to make code changes that are needed from Mainframe to LUW.• Created and executed a data compression activity for Ricoh that saved them almost 3TB of space.• Built out Ricoh’s environment for Development, Month End, and Production.• Performed fix pack upgrades for the client all the way to Fix Pack 3b on v10.5.• Created Documentation for the client and to use for their reference to troubleshoot.• Tuning Long Running SQL by creating indexes or working with the developer to optimize SQL statements.• Created a solution for data migration to different target databases.• Created Documentation for the client and to use for their reference to troubleshoot.• Maintaining the user/group access to the AIX server until our Unix Engineers can take over.• Created shell scripts needed for database Maintenance, health checks, and user interface script for data loading and unloading.• Created a structured process to replatform the database from MF to LUW. Had to also come up with an error handling process to check DDL changes, Data exports (Mainframe), Data Loads (LUW), etc.• Created Shell Scripts to automate process such as month end data unloads and loads.• Performed Standard day to day activities as performance tuning databases for the best though put for users. • Created the file system and the Database Architecture standard for Ricoh on DB2 LUW.

End Client: Yum! Brands• Helping in the migration from DB2 z/os to DB2 LUW on AIX v9.7.• Implementing MDC partitioning on DB2 LUW databases.• Bring my extensive knowledge in DB2 LUW to the migration team.• Collaboration with the DBA team to come up with a standard process for the Migration.• Scripting portions of the migration activities to significantly reduce time taken.• Working with the DBA team to come up with a security structure for the client's environment for DB2 LUW.• Actively performance tuning the databases for maximum efficiency/stability .• Will be setting up HADR for the new DB2 LUW environments.• Participating in POC for vendor tools to chose a replication tool and set a standard for the client.• Working closely with the PeopleSoft team to troubleshoot problems they are facing.• Sharing knowledge with DBA's present at the client site to further their db2 knowledge.• Working on PeopleSoft upgrade during a parallel re-platforming of DB2 from z/os to LUW.• Troubleshooting issues that arise during the migration with speedy turn around.• Creating the zos db shell on LUW by getting information from the mainframe system tables.• Validating object counts in between mainframe and the LUW shell.• Normal Backup, Restore, Runstats, and Reorg for the databases.• Created Federation for different databases.• Migrated data from db2 on Mainframe to db2 on LUW.• Conducting POC for db2 v10.5 for the client.• Migrated databases from DB2 v9.7 to db2 v10.5. fix-pack 3a• Working on Peoplesoft suites CRM, HCM, FIN, PRT, re-platforming from zos to LUW.This was a peoplesoft upgrade project for HCM, FIN, PORTAL, and CRM.

On the Visa security team that maintains the security network for all credit cards to be transmitted over.

End Client: Prudential Financial, Roseland• Helped in the migration from Sybase to DB2.• Installation of DB2 V9.7 on new servers after Sybase Migration.• Worked on design and creation for Prudential’s new DB2 environments for Group Insurance Division.• Worked on multiple applications to insure best performance of Stored Procedures, Triggers, data loads (batch) and Database cfg.• DBA that worked with a developer for creation of Unix scripts to Scrub Privacy data in Development regions.• Worked on scripts to automate Backups, Restores, Runstats, Reorgs, Table Space Reports, File System Reports, Log Compression, Database Privileges, etc.• DBA that introduced an idea of server consolidation and design of to consolidate servers.• Creating the design for multiple Development DB2 servers.• DBA that Created Audit databases shell scripts for client audits.• Created multiple Audit database for various fortune 500 hundred with all of them being successful (receiving high praise from Prudential and the Auditors).• Worked closely with 4 application teams to develop new projects and gave input on how to optimize ddl, triggers, views, and stored procedures.• Helped implement a standard for DB2 for release management to production.• Used utilities like Db2 Top, Db2 Advice, and Db2 Explain to help trouble shoot.• Identified security issues with database and created shell scripts to fix them.• Coordinated release management to production.• Worked vigorously on deadlocks and lock timeouts to fine tune the quarry and insure the problem was resolved.• Performed regular day to day monitoring activities for the development server to ensure the best performance.