PROFESSIONAL SUMMARY:

• IBM Certified Database Administrator for DB2 LUW v5 - v10.5 and MongoDB. Vast 27+ years IT experience in Database Administration and Software Development. Expertise include working knowledge of MySQL, SQL Server and others DBMS.
• Expertise in DB2 database performance tuning, replication configuration, database design, change management, systems development life cycle (SDLC), problem analysis and resolution, database security, ETL, DB2 patching/upgrades, reconfiguring databases due to changes/growth, High Availability Disaster Recovery HADR, and usage of IBM Optim Tools and Masking sensitive data. Software tools include Dell TOAD for DB2, Data Studio and IBM Data Server Manager (Database Performance Monitoring tool). Past and current security clearances include DoD Secret, Public Trust Security Clearance and IL State Clearance.

PROFESSIONAL EXPERIENCE:

Database Administrator

Confidential - Jacksonville, FL

Responsibilities:

• Assigned to many fast paced Healthcare DB2 UDB projects.
• Expert experience on IBM DB2 for LUW Database Editions 9.7 and 10.5.
• IBM DB2 for LUW backup and restore processes.
• Strong experience troubleshooting and supporting DB2 for LUW database instances.
• Experience providing customer and developers support.
• Data Extract, Transformation and Load experience ETL.
• Experience with DB2 for LUW live monitoring and performance tuning.
• Excellent verbal and written communication skills.
• Ability to communicate effectively with technical and non - technical customers and staff.
• Knowledge of DB2 for LUW high availability and DR solutions.
• Knowledge of SQL performance tuning.
• Knowledge of Agile Methodology.
• Database design and development concepts for OLTP and DSS skills.
• Government State and Federal project experience.

DB2 Database Administrator

Confidential - Moline IL

Responsibilities:

• Mission is to implement key DB2 production warehouse components that will optimize inventory, improve in stock position, reduce shrink, improve the customer’s shopping experience, thereby enabling an increase in sales and allow Delhaize America to become the best class chain organization in the US.
• Used standard data management tools and techniques for the creating, support and administration of database objects

Contract Sr. DB2 LUW and SQL Server Administrator

Confidential - Raleigh, NC

Responsibilities:

• DB2 Database configuration requires additional file systems/LUNS.
• Performed data management such as metadata management, data mining, data modeling, data cleansing, transformation and matching, data integration, data security
• Online DB2 monitoring is required for testing and going-live
• MQ selected as HADR - Understand the risk is required
• Change management software is required - Current manual method introduces inconsistent environments
• Database Security Audit required - DBA authority granted to non-DBA staff
• Incorrect DB2 Index Advisor usage - Excessive number of unused indexes created
• Application testing requires additional level of testing to ensure reliable deployment.
• IBM Optim DB2 DBA software tools not installed for project
• DB2 growth management must be known and analyzed.

IBM Optim DB2 Database Admin

Confidential - Greenwood Village, CO

Responsibilities:

• Short IT Project for one of the largest Confidential - focus using IBM InfoSphere Optim for DB2 for z/OS 7.1. Optim software used to access, classify, subset, archive, store enterprise application data across databases and platforms.
• Primary focus utilized Data privacy features which prevent misuse of information by de-indentifying, masking, obfuscating, and privatizing rmation that is propagated outside production environment.

DB2 Database Administrator/DBA

Confidential - Kansas City, MO

Responsibilities:

• Assist Mainframe Conversion to UNIX based computing environment
• Responsible for High Availability Disaster Recovery configuration and testing
• Responsible for High Availability DB2 instance configuration utility
• Database performance tuning, problem analysis and resolution
• Monitor database performance and tuning
• High Availability Disaster Recovery setup and support
• IBM Optim Query Tuner and IBM Optim Database Administrator and Performance Manager

DB2 Database Administrator/DBA

Confidential - Las Vegas, NV

Responsibilities:

• Assisted Allegiant Airline modernization project; Database conversion from MYSQL to DB2 LUW.
• Support for MYSQL conversion to DB2 UDB v9 on AIX and Linux
• Responsible for database performance tuning, problem analysis and resolution
• Increased system performance by monitoring and tuning databases
• Created export and load procedures/ ETL
• Responsible for High Availability Disaster Recovery setup and support
• Optim Query Tuner, Optim Database Administrator and Performance Manager
• Frontline Support and IBM liaison

DB2 Database Administrator

Confidential - Annapolis, MD

Responsibilities:

• US Department of Homeland Security, Transportation Security Administration, Transportation Threat Assessment & Credentialing, Annapolis, MD
• DB2 UDB Database Administrator for AIX Federal Classified Government project
• Secure Flight is a classified government airline passenger prescreening program created by the US Dept of Homeland Security and Transportation Security Administration (TSA).
• This classified program was developed to compare passenger information from Passenger Name Records against terrorist watch lists for passengers who may be wanted by US law enforcement or other countries.
• Primary duties were building, tuning, creating Database & OS Alerts and maintaining many DB2 UDB ESE Database servers, instances and databases on site and at fail-over sites.
• Responsible for DB2 upgrade v8 to v9 on IBM P Series

DB2 Performance Database Administrator/DBA

Confidential - Bloomington, IL

Responsibilities:

• Performance DBA for non-DPF and DPF databases. Selecting, installing, testing, submitting final recommendation for DB2 Performance/Admin software.
• Assisted with DBA DB2 performance and provided numerous application project teams with DB2 and Oracle support.
• Responsible for identifying potential bottlenecks and correct database problems.
• Many proactive procedures and best practices adopted due to effort. Platform: IBM P Series.

DB2 Unix & Mainframe Administrator - DB2 DBA Contractor

Confidential - Springfield, IL

Responsibilities:

• Responsibilities included: Re-engineering the Criminal History database and create DB2 UDB on AIX Reporting database by exporting criminal history data from an Oracle database. The criminal history database interfaces with FBI and the National Crime Information Center.
• Software included: DB2, Oracle, Erwin 4.0, Microsoft Project, SQL Navigator Pro and Lotus Notes. Database Conversion data from Oracle to DB2.
• Platform included: IBM Mainframe R45, DB2 Version 5 for OS390, DB2 UDB on AIX, Oracle 7.3 for OS/390 and Oracle 7.3 for AIX.

Database Administrator - Contractor

Confidential -Springfield, IL

Responsibilities:

• Primary responsibilities included: implementation, maintenance and security of all DHS DB2 databases. Databases included the partitioned EBT (Electronic Benefits Transfer database also known as the IL LINK database.) Child Care database, Clinical Restraint/Seclusion/Injury database, Unit Dose Database, In Confidential t Database, ROCS database, Cornerstones database and VCM (Virtual Case Management database.)

Confidential -Tallahassee, FL

Responsibilities:

• Database Administrator Promoted to overseeing IT group of Computer Operators, Programmers, DBAs and Network monitors).
• Primary responsibilities included: design, organization, definition, security, implementation and maintenance of all Data Center's DB2 databases.

Systems Project Analyst

Confidential - Tallahassee, FL

Responsibilities:

• Primary responsibilities included: design and implementation of statewide intranet/internet applications and DB2 databases on MVS and Unix.
• System development tools included: Microsoft FrontPage, Cactus Developing software, Photoshop and FOCUS.
• Technology platform included: Oracle, DB2, FOCUS, IIS Web Server, and Netscape Enterprise Server.

Computer Program Manager/Analyst

Confidential -Tallahassee, FL

Responsibilities:

• Responsible for developing, testing, debugging and documenting complex computer programs as requested from the University Controller Staff.
• Databases include: DB2, SQL Server. Designed and created DB2 Surplus Property System, which included a web application for University departments.
• Served as Departmental Security Coordinator for mainframe application and database access. Program Development included: SQL, JCL, COBOL, FOCUS, MS Access, and HTML.
• Mainframe Environment: IBM ES9000. Location: NWRDC (Northwest Regional Data Center). Technology Platform experience included: MVS, DB2, IMS, TSO/ISPF, FOCUS and VSAM.
• Received National from SACUBO (Southern Association of College and University Business Officers).