Senior DB2 and MYSQL Database Administrator

• Apr 2022 - Present

Microsoft Certified Trainer

• Sep 2021 - Present

Microsoft Certified Trainer Azure Solutions Expert Certified Azure Administrator Certified Associate Microsoft Certified Trainer Azure Solutions Expert Certified Azure Administrator Certified Associate

Database Administrator

• Feb 2016 - Apr 2022

Teradata 14 Certified Professional | Teradata 16 Vantage Certified Associate - Senior Database Administrator assigned at The Home Depot in Marietta, GA, USA - Excellent understanding of Teradata infrastructure, tools and techniques - BTEQ, SQL Assistant, TARA/BAR, Viewpoint, Workload Management - Proficient in SQL performance tuning techniques such as query rewrite and stats collection - Implemented several projects on database creation, user and security management - Excellent in UNIX shell scripting: Developed scripts for password notifications and invalid database objects detection - Backup and Recovery: TARA Management and Scripting of Backup/Recovery jobs - Experience working with global teams both in US and Manila - Excellent understanding of logical and physical database design, datawarehousing, ETL, and analytic techniques - Knowledge in using analytics tools such as Tableau, PowerBI and SAS Show less

Financial Advisor

• Jul 2020 - Dec 2021

Instructor

• Aug 2013 - Jul 2018

• Mentoring courses for Database Management, Datawarehouse and Knowledge Management, Analytics/Data Mining Techniques • Tools: MS SQL Server, R Programming, SAS, Tableau, QlikView, PowerBI • Thesis Consultant and Adviser – facilitates and provides inputs for 4th year students in technical aspects for developing the software for thesis • Mentoring courses for Database Management, Datawarehouse and Knowledge Management, Analytics/Data Mining Techniques • Tools: MS SQL Server, R Programming, SAS, Tableau, QlikView, PowerBI • Thesis Consultant and Adviser – facilitates and provides inputs for 4th year students in technical aspects for developing the software for thesis

Senior DB2 LUW Database Administrator - Prudential Financial (US)

• May 2013 - Jan 2016

Providing end-to-end database administration support for DB2 LUW databases DB2 Version 9.7.x, 10.x - advanced troubleshooting, maintenance, installation HADR, PureScale: Build and Implementation AIX 6.1.x - scripting and code reviews Providing end-to-end database administration support for DB2 LUW databases DB2 Version 9.7.x, 10.x - advanced troubleshooting, maintenance, installation HADR, PureScale: Build and Implementation AIX 6.1.x - scripting and code reviews

Senior DB2 LUW Database Administrator

• Jan 2013 - May 2013

• Advanced database administration for DB2 UDB ESE Versions 7.x, 8.x, 9.x on AIX and Red Hat Linux: Backup and Restore (Veritas NetBackup), Runstats and Reorgs, Tablespace Management, Filesystem/Disk Management, Archiving and Purging • Schedule jobs via Control-M • Incident and Change Management using BMC Remedy 7.x • Technical consultations and assistance for application owners and UNIX administrators • Advanced database administration for DB2 UDB ESE Versions 7.x, 8.x, 9.x on AIX and Red Hat Linux: Backup and Restore (Veritas NetBackup), Runstats and Reorgs, Tablespace Management, Filesystem/Disk Management, Archiving and Purging • Schedule jobs via Control-M • Incident and Change Management using BMC Remedy 7.x • Technical consultations and assistance for application owners and UNIX administrators

DB2 LUW Database Administrator

• Apr 2010 - Dec 2012

• Advanced database administration and support for DB2 Version 9.7 and 9.5 • Daily and weekend on-call support for SAP, non-SAP, and MaxDB database systems for database incidents • Timely implementation of DB2 solutions for scheduled database upgrades and fixes. • Installation of DB2 9.7 software on AIX 6.1 and on SLES 11 • Backup and Restore procedures using Tivoli Storage Manager (TSM); Schedule jobs via Tivoli Work Scheduler • Project management and roll-out of database system refreshes, restore and password security changes for system maintenance. • Capacity Planning and Disk Utilization Management • Authoring, development and migration of new functions in UNIX shell scripts for database backups via TWS and performance monitoring. • Testing and simulation for disaster recovery scenarios • Change management alignment across technical teams • Technical documentation for database functions, procedures, enhancements • Performance Merits Received: Effective Performer – October 2011 Performance Review; SCJ Now Thanks Award – Asia Shared Service Center 2nd Anniversary – Organizing Core Team Member; SCJ Now Thanks Award – Asia Shared Service Center – Strategy 2011 Video Production – Director/Videographer Show less

ETL Database Developer

• Apr 2008 - Apr 2010

• Functional and Technical requirements analysis for datawarehouse development using Oracle 10g Database, Informatica PowerCenter and TIBCO BusinessWorks for Procter & Gamble Master Data • End-to-End Data Transformation Testing (Unit/SIT Test, QA Test, Cutover Test) • 3rd Level Support for critical Production issues related to data transformations • High-level Project Management and Documentation • Key Projects: P&G Master Datawarehouse – Customer Master Data; 24x7 Refresh via UNIX Shell Script Automation; Gillette Product Database to P&G Database Migration • Trainer: Informatica PowerCenter version 8.5 • Performance Merits Received: Consistent Performer Rating – 2008 to 2010 Performance Reviews; “Management By Walking Around” Award – Nov 2008; Business Report Outstanding Award: 9.0 Excellent Score – Oct 2008 Show less

Netgear Technical Support Engineer

• Jan 2007 - Apr 2008

Providing first-line troubleshooting for Netgear customers in North America • Level 1 customer support via phone for technical issues & setup of Netgear wired & wireless devices • Level 2 email support for technical escalations • Performance Merits Received: Consistent +90% KPI Rating; Achieved 100% CSAT Score – June 2007; Consistent 100% QA score Performer Providing first-line troubleshooting for Netgear customers in North America • Level 1 customer support via phone for technical issues & setup of Netgear wired & wireless devices • Level 2 email support for technical escalations • Performance Merits Received: Consistent +90% KPI Rating; Achieved 100% CSAT Score – June 2007; Consistent 100% QA score Performer