SUMMARY:

• Senior Database Administrator with over 35 years of experience in DB2 UDB Database Administration.
• Knowledgeable in all aspects of database administration and architecture, IBM Certified DB2 DBA for Linux, UNIX, and Windows V6 through V10.5, Oracle 9i, 10g, 11g Certified Database Administrator.

TECHNICAL PROFILE:

Relation Databases: Oracle 8i, Oracle 9i, Oracle 10g; DB2/UDB V7 through V10.5; Redbrick Data Warehouse

Languages: UNIX Scripting Korn, Bash shell

Performance Tools: IBM Data Studio, IBM Performance Expert, DBArtisan, Precise In - Depth, Quest Central for DB2, WebSphere 6.1, DB2 OPM v5.1, Toad for DB2

Software: Erwin, Embarcadero products ER Studio, Rapid Sql, Change Manager

Operating Systems: Windows 2000 and Windows NT, AIX 5.3.0.0, AIX 6.1.0.0, AIX 7.2.0.0, SUSE Linux Enterprise Server v10, Linux Red Hat v5.5, UNIX (HPUX 10.20, 11), SunOS 5.8

PROFESSIONAL EXPERIENCE:

Senior DB2 UDB DBA

Confidential, Raleigh, NC

Responsibilities:

• Executed scheduled HADR Disaster Recovery tests to verify the feasibility of the recovery process and certify the environments and databases can be restored with zero loss of data.
• Refreshed Dev/QA databases with Production data via redirected restore as per User request to facilitate Application system testing.
• Planned/installed DB2 UDB V9.7, V10.5 software and fixpak upgrades to enhance database functionality and improve productivity.
• Monitored DBA Work Request queue and resolved Application problems/alerts to satisfy SLA agreements in a timely manner
• Installed SQL Replication environments and migrated SQL Replication Control tables and Change-Data tables from V9 to V10.1 to ensure compatibility with DB2
• Created DB2 Federated databases to enable Users to join data across various relational and non-relational sources.

Senior DB2 UDB DBA

Confidential, North Hollywood, CA

• Executed scheduled HADR Disaster Recovery tests to verify the feasibility of the recovery process and certify the environments and databases can be restored with zero loss of data.
• Refreshed Dev/QA databases with Production data via redirected restore as per User request to facilitate Application system testing.
• Planned/installed DB2 UDB V9.7, V10.5 software and fixpak upgrades to enhance database functionality and improve productivity.
• Monitored DBA queue and resolved Application problems/alerts to satisfy SLA agreements.

Senior DB2 UDB DBA

Confidential. Burbank, CA

• Responsible for installing DB2 UDB ESE V8 and V9, V9.5, V9.7 and fixpak upgrades, migration of databases from V7 through V9.7 in Sun, AIX, Windows environments and subsequent hardware, software testing to ensure high level of performance, scalability and reliability.
• Implemented backup/recovery strategies for DB2 UDB databases, reorgs, migration of production data to various environments, executed Production and non-Production deployments, controlled modifications to DB2 objects and designed, managed database security, roles, user access to guarantee ongoing database security.
• 24x7 rotational on-call and off-hours deployment support, proactive tuning of all DB2 instances, databases and SQL utilizing database tools and DBA written monitor scripts to optimize the performance and integrity of the databases. Resolved application developer SQL problems, questions and requests by executing DB2 Explain Plan, db2advis and db2pd, Toad and Embarcadero DBArtisan. Mentored developers and junior DBA Team members in the efficient use of SQL and database CFG parameters.
• Developed Unix Korn and Bash shell scripts to carry out routine checks on databases. This includes checking whether all DB2 databases are available, Unix error messages, locking issues, tablespaces with less than 10% free space, checking for errors in db2diag and notify logs to ensure database availability and stability.
• Investigated and determined root cause, impact, solutions analysis for DB2 Production problems satisfied User requests/questions in DB2 LUW and DB2 zOS environments through traces, online logging facilities and DB2 Optim Performance Manager.
• Lead DBA on the implementation and testing of BCV backups for AIRS and STARS applications to reduce the backup window and provide near 24x7 database availability for the User community
• Implemented and supported SQL Data Replication environment for the STARS application to provide efficient, flexible, non-intrusive data extraction and transfer to other DB2 environments providing real-time data synchronization, eliminating downtime, protection against disasters, provide continuous service and increase performance.
• Documented all aspects of Database Administration functions including Best Practices for DB2 UDB, benefits of New Features of DB2 UDB V9.5, V9.7, Physical and Logical design/installation, database standards/architecture, Database Requirement documents, Capacity Planning and Disaster Recovery
• Installed, tested, recommended purchase of database support tools such as: DB2 Performance Expert, DB2 Optim Performance Manager, Embarcadero products, Toad, Quest Central for DB2, Precise In-Depth
• Supported AIRS application Informatica ETL process by creating databases, tables, views, partnered with designers/developers to make structural design changes and tune Workload sql.
• Lead DBA for Disaster Recovery implementation and testing for all Financial databases in a HADR and HADR/HACMP environments.