PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Database Manager / DBA

• Managed staff of 7 including one data modeler, and DB2 LUW, Sybase, Oracle and SQL Server DBA’s.
• Worked with outsourced vendor to push adoption of DB2 LUW 11.1, Sybase 16 and SQL Server 2016 to initiate database upgrades. Opened technical exceptions to get early approval to start movement to DB2 LUW 11.1
• Provided DBA support for SQL Server when primary DBA retired until replacement could be hired.
• Supported DB2 LUW V10.1 & 10.5 for Confidential Identity /Access management tools including coordinating HADR failover setup.
• Worked with outsourced vendor on upgrade of DB2 LUW V9.7 to DB2 LUW V11.1 including re - architecting the environment to from raw logical volumes to automatic storage and implementing database encryption.
• Mentored staff to on DB2 LUW environment / concepts to provide additional support for DB2 LUW.
• Supported Public Education Information System, Data Warehouse systems, and GED database systems in DB2 LUW including database maintenance, security, Unix shell scripting, client troubleshooting, database federation, and performance tuning.
• Created and updated Unix / Linux scripts for database space monitoring, automated reorgs, database availability monitoring and automation of yearly database object creation.
• Worked with outsourced vendor on issues on implementing HADR for Db2 LUW for identity management systems.
• Worked with outsourced vendor to get platinum support set up for Oracle environments to facilitate patching by Oracle.
• Worked with project management to put together patching schedules and software upgrades including Oracle 12 C patches, migration to new Exadata hardware, Db2 Luw V11.1 upgrades, and SQL Server 2016 upgrades.
• Coordinated efforts to address Oracle Exadata performance issues, including opening Oracle SR’s, implementation of bug fixes, baselines, statistics and SGA/PGA changes as recommended for TEA’s most critical data collection systems.
• Provided input to budget process for database staffing, training, software, hardware to support TEA database environments.

Confidential, Austin, TX

Database Administrator

• Senior Database Administrator supporting DB2 LUW, SQL Server, & Sybase database systems.
• Maintained legacy Perl and ksh scripts for the Sybase environment, resolving issues with group membership for database restores and standardizing scripts across environments,
• Analyzed memory settings for Sybase on development and test environments and recommended changes to take advantages of increased memory on servers as part of server refresh.
• Supported Sybase environment for The Workforce Information System of Texas (TWIST), including supporting application releases, coordinating with outsourced vendor on space allocation, production restores to test environments, security for jboss implementation, and user access at the database level,.
• Architected new DB2 LUW V10.5 environment in to support agency DB2 LUW initiatives including, defining server storage settings using Confidential best practices; working with Linux Administrators on security infrastructure implementing LDAP for DB2; assisted with data modeling and table, index, view and trigger definitions; set up trusted context security for jboss servers access to DB2 LUW
• Worked on proof of concept to implement DB2 LUW on zLinux.
• Supported Embarcadero tool sets including troubleshooting access issues, resolving desktop

Confidential, Austin, TX

Database Architect

• Provided Database and DevOPs support for Doubleline educational data management systems.
• Implemented database functionality to support AlwaysOn Availability groups in SQL Server 2012 for client database systems to provide High availability and read-only secondary functionality.
• Implemented performance improvements to physical infrastructure for the SQL Server 2008 R2 data warehouse environment by implementing partitioning by district and clustering of data by SchoolYear.
• Supported the Oracle 11G development environment including installation of Oracle 11G on windows, creation of database objects to support educational dashboard and data ware house databases, migration SQL Server data to Oracle using SQL Developer, creation of schema backups using data pump, and support for development team.
• Provisioned a SQL Server virtual machine on Windows Azure for staging and production client installation. Configured environment to support DLP software implementation, restored metadata databases from development, set up linked servers, set up transparent data encryption and created maintenance plans.
• Supported DLP SQL Server 2008 & 2012 environments including creation of maintenance plans, creation of T-SQL SQL Server agent jobs, development / maintenance of SQL Server functions and stored procedures,, implemented of transparent data encryption, performance analysis, modification of SSIS packages and development import / export scripts using bulk copy.
• Supported Doubleline systems including using Powershell software infrastructure, GITHUB code management, TeamCity for Load processing, and Agile methodology for software development.

Confidential, Austin, TX

Database Manager / Database Administrator

• Managed staff of Database Administrators supporting Sybase, DB2 LUW, DB2 Z/OS, ADABAS, and Natural
• Managed the installation of Mainframe software to support data migration from DB2 UDB to ADABAS including Classic Event Publisher, Classic Federation Server & MQ.
• Managed the upgrade of Mainframe software including CICS, ADABAS, Natural, DB2 Z/OS and associated products.
• Supported the T2 initiative to redesign the Child Support system as the primary DB2 LUW DBA. Supported database design, maintenance, tuning, and configuration for predev, dev, test, UAT, stage, training and production database environments.
• Worked with Contract vendors on review of proposed data models, replication strategies, database security and physical architecture for T2 initiative.
• Analyzed production performance issues for long running queries, generating/analyzing query execution plans, reviewing of indexes and recommendation of performance solutions. Performance recommendations included increasing memory, implementation of additional indices, and optimizer settings modifications. Queries that previously would not complete and other queries that took up 20 seconds to complete improved to sub-second and 6 second response time respectively after performance recommendations implementation.
• Created standards for configuration of SQL Server and DB2 LUW database environments for T2 initiative. Worked with Architecture Review Board to gain approval for SQL Server 2008 R2 as standard, conforming to production environment.

Confidential, Austin, TX

Database Administrator

• Senior Database Administrator supporting the Texas Tollways databases in DB2 LUW on Linux, including support of software releases, performance analysis, database maintenance and database monitoring.
• Modeled enhancements to current system to include customer concentric model from vehicle/tag centric model, including relationships with the capacity to handle multiple addresses, contacts, tags and merging and separating of vehicle / tag relationships from customer and keep history of current and prior relationships.
• Created scripts to automate the refresh DB2 LUW reporting database on a weekly basis from production system. Scripts included automated sizing derived from production statistics and email notification upon completion of refresh.
• Maintained QA environments using scripts to snapshot environments at as requested by QA team in support of testing for application releases.

Confidential, Austin, TX

Database Manager / DBA

• Managed database administration staff supporting Sybase, DB2 UDB, Oracle and SQL Server.
• Coordinated with project management office to allocate resources for project support, planning and implementation scheduling.
• Coordinated software upgrades including upgrade from DB2 UDB v9.1 to V9,5 & V9.7, upgrades from SQL Server 2000 to SQL Server 2005/2008, and upgrade of Sybase
• Coordinated of database side of migration of PeopleSoft from Sybase to Oracle, working with project team to complete migration on time and on budget.
• Work with outsourced staff in data center consolidation to coordinate issues with physical database implementation and issues, database upgrade and patches, production issues, and system support.
• Work with project teams on database hardware and software architecture for funded projects.
• Provided input to budget process for database staffing, training, software, hardware to support TEA database environments.
• Supported Public Education Information System, Reporting systems, and GED database systems in DB2 UDB V9.1, V9.5 & V9.7 including database design, database upgrades, database patch implementation, database object implementation, database maintenance, security, Unix shell scripting, client troubleshooting, database federation, and performance tuning.
• Supported database systems in DB2 for Z/OS until 2010 when mainframe systems were retired.

Confidential, Austin, TX

Database Administrator

• Senior database administrator responsible for DB2 UDB V8 on AIX and Ingres as part of the State of Texas outsourcing.
• Implemented DB2 fixpaks & created physical database objects for both DB2 UDB and Ingres.
• Provided on call support for DB2 UDB and Ingres.
• Created / modified shell scripts to support database backups, database object migration, database monitoring and database maintenance for DB2 UDB on AIX.

Confidential, Austin, TX

Database Administrator

• Senior database administrator responsible for support of database systems on DB2 UDB V8 on AIX & DB2 for Z/OS.
• Created new database objects to support PEIMS data collection for both DB2 mainframe and DB2 on AIX.
• Created / modified shell scripts to support database backups, object migration, monitoring and maintenance for DB2 UDB on AIX.
• Defined / migrated database objects using BMC Change Manager & setup/maintained database utilities using BMC DASD Manager for DB2 for Z/OS.
• Implemented software patches and upgrades for DB2 UDB and Quest.
• Managed UNIX id’s and database security for DB2 UDB access.
• Monitored performance and analyzed problem queries.

Confidential, Austin, TX

Contract Database Administrator

• Senior database administrator responsible for DB2 UDB V8 on AIX & DB2 for Z/OS.
• Created new database objects to support data collections periods for both DB2 mainframe and DB2 on AIX.
• Created / modified shell scripts to support database backups, object migration, monitoring and maintenance for DB2 UDB on AIX.
• Defined / migrated database objects using BMC Change Manager & setup/maintained database utilities using BMC DASD Manager for DB2 for Z/OS.

Confidential, Austin, TX

Lead Database Administrator

• Lead database administrator responsible for DB2 UDB V7 & V8 on AIX supporting internal systems for Confidential .
• Supported DB2 UDB partitioned database for SAS Market Max data warehouse, including production support, upgrade implementation, database sizing, tuning, and maintenance.
• Supported DB2 UDB development project for SAS Markdown Optimization. Coordinated with project team, created database objects, implemented database maintenance procedures, and worked on issue resolution.
• Managed BMC SmartDBA performance tool implementation project, including creation of documents for review boards, creation of work plans, and coordinating resources.
• Primary DBA responsible for maintenance and enhancement of database scripts, including scripts for reorgs, backups, backup purge, database bounce, database alerts, space reports and database monitoring.

Confidential, Austin, TX

Senior Quality Assurance Engineer

• Senior QA engineer responsible for release and fix testing for Informatica software mainframe products.
• Primary QA engineer for mainframe port of Informatica PowerCenter server and Repository server. Set up of database objects in DB2 and IMS, modified existing PowerCenter tests for mainframe environments, modified database scripts for repository creation to DB2 for OS/390, tested core functionality, integration of PowerCenter with Power Exchange change capture products, and install procedures.
• Primary QA Engineer responsible for testing PowerExchange Microsoft SQL server change data capture product. Worked closely with development engineers to set up test scenarios, verify product functionality, identify problems, test fixes, prepare training for service engineers and assist with beta program.
• QA Engineer responsible for support of EDP change capture and apply fixes, including set up of database objects including DB2, IMS & VSAM, specialized testing, and regression testing.

Confidential Columbus, OH

Database Administrator - Lead

• Lead database administrator for DB2 UDB V8.1 on Solaris supporting commercial banking.
• Setup new production environment using Veritas clustering. Defined instances, migrated database objects, created / modified shell scripts for database maintenance, and tested failover.
• Supported application development efforts for DB2 UDB V8.1 including implementation of database objects, stored procedures, performance tuning, data propagation, troubleshooting, and problem resolution.
• Configured and implemented Confidential ’s Task Center to automate scheduling of database maintenance scripts including backups, index reorgs, runstats and rebinds.

Confidential Columbus, OH

Manager Data Administration / Senior Database Administrator

• Lead database administrator for startup software development company supporting DB2 on OS/390 including data analysis, logical data modeling using ERWin and ModelMart, physical modeling, physical implementation, performance tuning, data propagation and release support.
• Installed, configured and implemented UDB V7.2 database and Warehouse Manager for scheduling of OS/390 jobs. anage data administration staff including data modeler, Oracle DBA and junior level DB2 DBA including resource allocation for project estimates.

Confidential Columbus, OH

Senior Database Administrator

• Lead database administrator supporting DB2 on OS/390 for Victoria’s Secret Catalog including new project development including data analysis, database object creation, implementation and tuning. On-call support for DB2 for OS/ x7 production systems.
• Installed, configured and implemented DB2 UDB database system for DB2 OLAP solution with Visual Warehouse on a Sun Solaris UNIX system. Defined database objects, created data extraction, cleansing and loading processes and set up database maintenance. Provided production 24x7 support for ETL processes.
• Installed and configured Informatica and Teradata tools on Sun Solaris platform for ETL processes to extract data from OS/390 to load into Teradata data warehouse.
• Installed and configured DB2 Connect on windows and Sun Solaris platforms for remote connectivity to OS/390 database systems.
• Supported release of Victoria’s Secret Catalogue Internet site utilizing DB2 UDB on a Sun Solaris UNIX system. Support included database object creation, database security administration, database tuning and shell script development for data loading, database backup and maintenance and file transfer.
• Supported DB2 for OS/390 implementation for catalogue code expansion project involving modification to 36 tables, development of interim environment for phasing of changes, production implementation, and performance analysis on over 300 programs.

Confidential Austin, TX

Database Administrator IV

• Manage data administration staff including DB2 and Sybase DBAs, including resource allocation, performance reviews, budget estimates, and recruiting.
• Supported agency’s DB2 for OS/390 database systems including database object creation, unloading/loading of data, database backup, maintenance and recovery.
• Maintained agency database standards.
• Consulted on support of agency’s data warehouse system in Sybase on Unix.
• Conducted requirements review and data modeling sessions for redesign of agency’s Appeals system.

Confidential . Austin, TX

Senior Software Engineer

• Developed GUI frames for data review and manipulation using Oracle 2000.
• Worked with team for standards development for Oracle environment.
• Established Oracle PL/SQL blocks for data validation, transformation and loading into Oracle tables.
• Developed and maintained C applications for manipulation of flat files and loading into Ingres tables.
• Troubleshooting, tuning and maintenance of 4GL applications for Ingres.

Confidential Austin, TX

Database Administrator III

• Supported agency’s DB2 for OS/390 database systems including data modeling, database object creation, unloading/loading of data, database backup, maintenance and recovery.
• Supported database design, sizing, tuning and procedure implementation for agency’s Benefits redesign using DB2 with Natural.
• Evaluated data modeling tools and database maintenance and monitoring tools.

Confidential Austin, TX

Database Administrator II

• Supported agency’s Ingres database systems including data modeling, database object creation, unloading/loading of data, database backup, security, maintenance and recovery;
• Designed objects and developed programs using C for migration of systems from Unisys 1100/73 to Ingres.
• Supported database requirements phase for migration of database systems from Unisys to Oracle on Unix.
• Participated in database design reviews and data modeling, and developed database tools using C and embedded SQL.