OBJECTIVE

• Seeking a position as a Database Architect, Database Administrator or Data Architect in the IBM DB2 Family of products: DB2 LUW Unix, Linux, AIX, Solaris, iSeries and zOS.
• Improved database availability for DB2 UDB/AIX from 80.1 to 99.999.
• Lead design and implementation of major database conversion project from DB2/i to DB2 LUW.
• Lead design and implementation of DB2 LUW, DB2/zOS, DB2/i Database Administration procedures and documentation.
• Lead design and implementation of Performance Tuning and Capacity Monitoring.
• Lead Design and implementation of Data Security, Backup and Recovery procedure.
• Lead Design and implementation of Data encryption at rest and in flight.
• Lead and implementation of server migration to AWS.
• Lead and implementation of server migration out of AWS.
• Reduced Licensing cost with Design and implementation of server consolidation.
• Design and implementation of a 300TB DB2 UDB DPF.
• Design and implementation of a multiple nodes DB2 Purescale.
• Design and implementation of database archiving on DB2/i.
• Design, code and implementation of data conversion from DB2/zOS to DB2 LUW.
• In depth knowledge of major modern database technologies: relational, and non - relational, IBM DB2 LUW, DB2 z/OS, DB2/400, SQL Server, MySQL. MariaDB, MySQL
• In depth knowledge and experience in Data Modeling methodologies: conceptual, logical physical, Dimensional (Data Warehousing) and OLTP(Normalized)
• Presented Database vision and direction to C level executive.
• Fluent in Agile Methodology using Confluence/JIRA.
• Strong Problem Solving, Troubleshooting and Root Cause analysis skill
• Strong Experience with OO design tools: Rational Rose, Erwin, Embarcadero, and Qdesigner.
• Planned, migrated DB2 severs from earlier to current 11.1 with zero downtime.
• Improved 50% Database server uptime from 80.1 to 99.999 for a 22 nodes 200TB 24x7 databases to be 24x7 from a Sluggish 80.10 uptime using DB2 UDB.
• Slashed 60% off servers and software's cost by consolidating 150 servers to 20 servers using DB2 UDB.
• Planned and Delivered migration project on time.
• Provide support in database architecture of the organization through database design, modeling and implementation
• Develop plans, strategies and standards for data within the enterprise
• Understand the end-to-end scope of work and design architectural solutions accordingly
• Integrate all data in the data management platform enabling accessibility
• Ensure that the database base is secured and updated
• Partner with all other teams (database management team, software development team, designers) and users to provide best solutions by maintaining the best standards of practice
• Oversee that the database back-up and recovery system are available in the enterprise for current and future use, including a potential crisis time
• Control and maximize the data resources and processes within the organization
• Migrate DB2 Connect Servers to 11.1
• Use database design and database modeling concepts to ensure data accessibility and security
• Understand the future requirements and model database concepts accordingly
• Support the organizational data warehouse through appropriate utilization of ETL tools
• Extensive Experience implementing Q Replication
• Extensive Experience with DB2 PureScale
• Extensive Experience with DB2 DPF

TECHNICAL SKILLS

• extensive experience modeling, designing, coding, testing, migrating on IBM DB2/UDB, SQL server and MariaDB environments.
• DB2 UDB LUW, DB2 z/OS, DB2/i, SQL Server, MariaDB, MySQL, AIX, Unix, Linux, z/OS, JDBC, DB2 PureScale, DB2 DPF, DB2 Connect.

PROFESSIONAL EXPERIENCE

Infrastructure Database Architect

Confidential, Dallas, TX.

Responsibilities:

• Lead, Planned and implemented Database migration from DB2/400 to DB2 LUW on AIX.
• Lead, Planned and Migrated DB2/LUW to Amazon AWS.
• Migrated DB2 Linux from AWS to in-House Data Center.

• Implemented the security requirement for DB2 and MariaDB on Data Encryption at rest and in flight(SSL).
• Converted DB2 LUW database to MariaDB with Galera Cluster.
• Designed and implemented DB2 PureScale for a 24x7 Availability.
• Provided day to day Performance tuning monitoring and implementation for DB2 LUW and DB2/400 using Doctor and Index Advisor (iSeries only).
• Planned and Executed migration from DB2 LUW 9.7, 10.1, 10.5 and 11.1.
• Planned and Implemented fix packs.
• • Migrate DB2 Connect Servers to 11.1 Setup DProp Replication.
• Setup SQL Server Replication and Q Replication.
• Designed and Implemented Journal Entries Audit for JDEdwards financial system using F0911 and F0411 tables.
• Planned and Implemented data archival for DB2 AS400(not a normal DBA jobs).
• Researched and Implemented Enterprise wide Monitoring tools(ManageEngine).
• Implemented Optim Performance Manager and Data Server Manager.
• Designed and implemented a Repository for Databases Portal, keeping track of backups, tablespaces utilization, space utilization, hosted on SQL Server; the Linux clients uses FreeTDS to connect to SQL Server after completing the backups. The Repository information is immediately available in Manage Engine.

Environment: DB2 AIX 9.7, DB2 UDB/Linux 101, DB2 UDB Linux 10.5, DB2 UDB Linux 11.1, DB2 iSeries 7.2, MariaDB 10.1, MariaDB10.2, MySQL, SQL Server 2016, Korn and Bash shell scripting.

Senior Database Architect/Administrator

Confidential, Bellevue, Washington.

Responsibilities:

• Administered a 100TB, 25 physical nodes, 72 Logical Nodes DB2 DPF Cluster using IBM/ISAS.
• Implemented Range Partitioning on Large Tables.
• Implemented DB2 Deep Compression yielding more than 84% compression rate and improve query performance.
• Supported IBM Campaign (Formally Unica).
• Managed WebSphere AS.
• Implemented a series of measure to bring stability.
• Implemented DB2 WorlkLoad Manager instead the Governor.

Environment: DB2 UDB 9.1, DB2 UDB 9.5 on Solaris and Windows.

Senior Database Architect

Confidential, Tampa, Florida.

Responsibilities:

• Converted DB2 UDB platform to 9.7 and 9.8 on AIX.
• Implementation DB2 Health Monitor with Nagios.
• Implemented DB2 Deep Compression yielding more than 84% compression rate and improve query performance.
• Implemented 2 nodes PureScale Data Sharing UDB.
• Design databases for availability and performance.
• Create and supported database on IBM UDB.
• Convert numerous databases from lower version to higher version of UDB.
• Wrote and implemented numerous specific Technical White Papers: Removing defunct SYSADM id from DB2/zOS; Achieving Higher Availability by converting from DMS raw devices to SMS JFS2 with direct IO, Auditing DB2/zOS data by putting SMS data into DB2 tables.
• Investigated, wrote reports, and implemented numerous Performance issues.
• Convert a vendor supplied DDL for higher availability in backup, recovery, and performance. This has been proven to be very effective and became the new standard for design.
• Implemented Direct IO in UDB, reducing memory footprint by more than 45%, saving in memory upgrade.
• Production support for DB2 UDB (AIX, Linux, Windows), DB2 z/OS and SQL Server.

Environment: DB2 UDB 5.0 on HP/UX, DB2 UDB 7.2/AIX.

Senior Database Services Consultant

Confidential, Tempe, Arizona

Responsibilities:

• Setup JCL for utilities: Reorg, Backup.
• Migrated DB2 Objects between environment using CA tools.
• Designed Database for Anti Money Laundering(AML).
• Designed Database for ATM fraud Detection.
• Production support for DB2 UDB (AIX, Linux, Windows), DB2 z/OS and SQL Server.

. Environment: DB2 UDB 5.0 on HP/UX, DB2 UDB 7.2/AIX, Korn and Bash shell scripting.

Senior Technical Architect

Confidential, Santa Barbara, California.

Responsibilities:

• Lead a Multimillion dollar conversion project from z/OS to AIX.
• Lead a total application and database conversion from z/OS to AIX, using a SOA deployment, Sonic MQ, WebSphere MQ, AEI, UDB, SQL Server, and PROGRESS using a SOA deployment, Sonic MQ, WebSphere MQ, AEI, UDB, SQL Server, and PROGRESS.
• Planned and implemented a 24X7 Availability solution for mission critical applications.
• Designed, modeled and Created a 100TB Data warehouse on DB2 UDB using DPF with multiple partition on AIX: 72 partitions on 25 physical nodes.
• Lead a total application and database conversion from z/OS to AIX, using a SOA deployment, Sonic MQ, Websphere MQ, AEI, UDB, SQL Server, and PROGRESS.
• Planned and implemented options for a SOA based application to scale horizontally.
• Planned and implemented a 24X7 Availability solution for mission critical applications.
• Planned and Implemented cost saving options, moving databases from AIX to Linux.

Environment: DB2 AIX 7.2, DB2 AIX 8.1, DB2 Linux 9.1, Korn and Bash Shell scripting.

Technical Architect,

Confidential, Tampa, Florida

Responsibilities:

• Windows client running IE.
• Two BigIP load Balancers.
• IBM HTTPs Servers.
• Websphere AS.
• Websphere MQ.
• ESL server programs.
• EAI Manager in Java.
• Sonic MQ (One may wonder why Sonic MQ and Websphere MQ together? The various vendors require it.)
• This project was implemented on a Sun Solaris, using UDB 8.2 with Data Portioning Facility (DPF); it started from UDB 7.2 on Solaris and Windows.
• This project consists of designing a Data Warehouse to comply with a government regulation called Bill Data Tape (BDT).
• I designed and implemented a 4TB database on a SUN Solaris using DB2 UDB; it started from Version 7.2 and currently is running on Version 8.2(7.2 with Fixapk 7).
• The front end application is a J2EE application using Weblogic as an application server.
• I designed the logical database and implemented the physical design from development to production.
• I also implemented a High Availability using UDB HADR.

Senior Database Consultant

Confidential, Chandler, Arizona

Responsibilities:

• Design and Create a large scale Operational Data Store (ODS), 26TB, on IBM UDB.
• Planned and implemented options for a SOA based application to scale horizontally.
• Planned and implemented a 24X7 Availability solution for mission critical applications.
• Planned and Implemented cost saving options, moving databases from AIX to Linux.

AIX/UDB Consultant

Confidential, Phoenix Arizona

Responsibilities:

• This project is to replace a manual process for Patient Verification. Between Midnight and 4:00am, the Mainframe is down, and the Hospitals have to use a microfiche, a day old, to verify patients information. The new software replaces the microfiche. Its main design is to download data from DB2 MVS to DB2 AIX on a daily basis. A Visual Basic front-end is used to verify patient information.
• My responsibilities includes: Install DB2 on AIX, setup Db2 Connect in order for data to be pulled from MVS, design physical databases and coded Visual Basic application to retrieve patient record from dB2 AIX.
• This application has replaced the microfiche process that has to be sent to all hospital overnight, saving 6 millions dollars a year.

Senior Application Architect

Confidential, Phoenix Arizona

Responsibilities:

• This project goal was to convert a manufacturing process application from OS/2 to Window NT 4.0.
• The original application was a mixture of OS/2 Rexx and Natural. The new platform is to run in Visual Basic 4.0 and 5.0.
• Develop all the class libraries for all the OLE servers.
• This project goal was to convert an existing IMS DB/DC system, serving all aspects of child welfare programs, into a client/server system, with a lot of business reengineering.
• The original platform consist of Window client running office automation software and a PowerBuilder application, with an OS/2 server running DB2/2 and DDCS/2, which in turn is connected to DB2 MVS via CM/2 and VTAM.
• The platform was recently converted to Window NT, DB2/NT, DDCS/NT, SNA Server, and still connected to DB2 MVS.
• My responsibility include the overall architecture and performance of the system, including Data Administration; Database Design and Administration;
• Software Migration, Application design; Performance Tuning and Network design; Definition of the GUI interface for consistency, easy of use;
• Definition of programming standard; Support of PowerBuilder, DB2/2 DB2 MVS,

Database Consultant

Confidential, Walnut Creek, California.

Responsibilities:

• My duty was to provide the database design and lead a team to startup the implementation.
• Produce a logical data model using ADW.
• Produce a physical data model using SYBASE and DB2.
• Design and implemented Flexible account structure using Stored Procedures and Triggers.
• Wrote White papers on all major design issues on Sybase and DB2.
• The application was behaving very sluggishly. My duty was to tune DB2 and the application to meet their response time, and to review the Database Administration procedure for quicker turnaround.
• Review batch program, recommended, and implemented changes.
• Review DSNZPARM parameter and review changes.
• Review production tablespaces creation and recommended the use of storage group, and implemented a conversion of more than 400 tablespaces and 1000 plans.
• Clean DB2 catalog from unused plans and packages.
• Evaluated the use of Platinum tools to help DBAs.
• Assisted programmers and DBA in debugging and resolving problems.

Environment: DB2, SYBASE, CSP, CICS, Platinum Tools, Bachman, IEF, XDB, DB2/2.