SUMMARY

• Technical Expertise in Linux/Unix DB2 LUW DBA; experience as UNIX system administrator tasks and of shell scripting; formal education in operations research and statistics.

TECHNICAL SKILLS

• 20+ years cumulative experience with IBM, Atlanta, GA
• DB2 Pure Data for Transactions (PDTX) Administration and Certification; using Pure Scale architecture
• DB2 Pure Scale architecture, upon which DB2 Pure Data for Transactions (PDTX) is based
• Hands on experience with PDTX hardware repair
• UNIX Shell scripting (Born, Korn and C shell)
• Perl script creation and modification
• DB2 administration - up to v10.5 on Windows/AIX/Linux
• DB2 LUW 7, 8.0, 9.5, 9.7,10.1, 10.5
• CA ERWIN data modeling tool
• DB2 Data Partitioning Facility (DPF)
• Disaster Planning, Backup and Recovery
• DB2 Range and Table Partitioning
• SAS Version 9 programming on UNIX
• DB2 Version and Fixpack Updates
• Extensive performance tuning on DB2 9.7, 10.1, 10.5
• Physical Database Design and storage sizing
• SQL Procedure editing
• High Availability Disaster Recovery (HADR)
• DB2 SQL Replication
• Migration of DB2 LUW 10.1 to DB2 on Cloud 11.1
• IBM Data Studio

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Database Administrator

Responsibilities:

• Participate in meetings and advise developers in setting up HADR in a Pure Scale Cluster environment
• Hardware support of Pure Data for Transactions chasses.
• As a member of the DBA team, supported development, test and production databases in a large payment institution: skills used include configuration; troubleshooting performance tuning, creating and modifying tables, indexes and stored procedures; database backup and recovery; assisting the data modeler with creating DB design; implementing design and keeping up with design changes
• DB2 Database Administrator 10.5 for transition from Oracle to DB2.
• PureData for Transactions (PDTX) software and hardware configuration and support.
• Document and execute system test cases for PDTX.
• Extensive documentation of PDTx command and processes.
• Assisting Oracle DBAs to learn DB2 and migrate their databases from Oracle to DB2.

Confidential, Atlanta, GA

Database Administrator

Responsibilities:

• The following activities took place over a 4.5-year period.
• Responsible for HADR compliance across all test and production databases: implementing, writing scripts to monitor the status of HADR, creating new HADR configurations and retiring old HADR configurations.
• As a member of the DBA team, supported development, test and production databases in a large financial institution: skills used include configuration; troubleshooting; performance tuning, creating and modifying tables, indexes and stored procedures; database backup and recovery; assisting the data modeler with creating DB design; implementing design and keeping up with design changes.
• Support users of DB2 data warehouses with Data Partitioning Feature (DPF or multi-node) in a financial environment with very large databases up to 100 terabytes
• Install and configure DB2 v9.5 and V9.7 on Windows and AIX platforms
• Analyze queries generated by Cognos for performance improvement opportunities
• Create database maintenance scripts to perform database backups, runstats, reorgs

Confidential, Norcross, GA

Database Engineer

Responsibilities:

• Responsible for HADR compliance across all test and production databases: implementing, writing scripts to monitor the status of HADR, creating new HADR configurations and retiring old HADR configurations.
• Supported transactional databases for payment applications as member of a team of DBAs: skills used include configuration; troubleshooting; performance tuning, creating and modifying tables, indexes; and stored procedures /\;
• database backup and recovery; assisting the data modeler with creating DB design; implementing design and keeping up with design changes
• Install and configure DB2 v9.5 (and v8.2) on multiple servers with appropriate fix packs to accommodate necessary databases
• Decrease CPU and Disk utilization by evaluating and improving database performance through DB2 utilities such as Snapshot Monitor and Event Monitor
• Improve overall database reliability and uptime by spearheading effort to incorporate DB2 HADR feature.
• The activities listed here took place over an 11-year period
• Supported Analytic Database and Enterprise Information Warehouse as primary DBA: skills used include configuration; troubleshooting; performance tuning, creating and modifying tables, indexes and stored procedures; database backup and recovery; assisting the data modeler with creating DB design; implementing design and keeping up with design changes
• Participates in the development and implementation of short and long-term database strategies of multi-user, multi-functional systems
• Develops database solutions that meet business objectives that optimize the use and accessibility of data
• Develops strategies for the continued planning, designing and documentation of standards for physical data storage, maintenance, access and security administration in order to standardize environments and improve efficiency
• Supports the technical and architectural implementation of databases on a variety of platforms (UNIX and MVS)
• Demonstrated knowledge of related database architecture and development methodologies
• Demonstrated proficiency in structured analysis and technical design techniques
• Develop Perl and Korn shell scripts to monitor Data Propagator and validate the successful movement of data between MVS and AIX host systems
• Automate the loading of very large database using Perl and Korn shell scripts, including error handling and notification
• DB2 UDB version 8 and 9 DBA for very large Data Warehouse projects on AIX platform (up to 10 terabytes), utilizing the Data Partitioning Feature (DPF) across multiple data nodes
• Performance tuning of DB2 databases on AIX platform
• AIX Administration support tasks for DB2 Warehouses with DPF, such as determination of space allocation, userid support and file system management
• Create DB2 Data Propagator scenarios to and from MVS and AIX host systems.
• Design DB2 layout using DPF using OLAP and star-schema design
• Utilize ERWIN Data Modeling software to update data warehouse model
• Configure Federated Databases to ensure data integrity across databases
• Utilize Brio Enterprise software to build reports
• SAS Programming to analyze data from Enterprise Information Warehouse
• These activities took place over a 6-month period as a contractor.
• Develop Korn Shell scripts to execute all tasks in configuring and monitoring Oracle DB
• Oracle V7 DBA
• UNIX Administrator (Sun Microsystems/Solaris)
• These activities took place over an 8-month period as a contractor
• UNIX Administrator (Sun Microsystems/Solaris)
• Develop C Shell scripts to execute all tasks in configuring Sybase DBA
• These activities took place over a 6-month period as a contractor
• SAS Programming in support of medical statistical models on TSO/MVS platform
• Create a front-end application using SAS/Access to run SAS reports
• These activities took place over a 1 year 3-month period
• UNIX Administrator (Sun Microsystems/Solaris)
• Develop C Shell scripts to maintain backups, ensure security and protect SAS files
• Create statistical models of credit data using SAS programming and Equifax proprietary statistical methods
• These activities took place over 6-year period
• Create mathematical models of performance for application programs
• Responsible for build activities of large applications on TSO/MVS platform
• Maintain code library for large applications