SUMMARY:

• Experience providing support for the DB2/UDB family of products on all operating systems.
• Expertise in the installation and configuration of UDB for LUW, UDB for Z/OS and DB2 Connect.
• Proficient in Data Modeling (Logical & Physical Design of Databases) using tools such as Erwin.
• Experience as Systems Integrator, Systems and Application Architect
• Experience with the Business Intelligence suite of products
• Experience with multiple implementations of Transactional Servers
• Experience with Data Architecture (modeling) tools
• Experience in Performance Tuning, Space Management and Planning Backup & Recovery Strategies.
• Experience in system and application performance tuning and expert in implementing and maintaining 24 * 7 production environments in partitioned and non - partitioned UDB DB2 databases.
• Experience in implementation and maintenance of HADR environments and knowledge of QREP and SQL replication.
• Excellent in problem solving and logical, analytical, verbal, written skills.

TECHNICAL SKILLS:

Operating Systems: AIX, HP-UX, Solaris, Windows, LINUX (RedHat, Suse), Z/OS

Middleware: CICS, IMS DC, Tuxedo, WebSphere Server, Webshere MQ

Databases: UDB/DB2 for z/OS, UDB/DB2 for Linux, UNIX and Windows, DB2 Connect, IMS DB

Languages: Java,C, C++, Assembler, COBOL, REXX, CLISTS, Shell Scripting, JCL

Data Modeling: ERWin and BACHMAN tools, Logical and Physical database design

PROFESSIONAL EXPERIENCE:

Confidential

DB2 LUW DBA

Responsibilities:

• Senior Database Administrator in the Architecture group
• Install configure and tune Websphere Server to serve as the Transaction Manager for the application
• Install and configure complementary products to DB2 including IBM Infosphere Datastage and Cognos provide interoperability with Oracle and Peoplesoft software
• Provide guidance and assistance to users to generate and automate report generation using multiple end user query and data extraction tools
• Provide routine database system support including backup, restore, recovery, reorganization, performance monitoring and performance tuning.
• Provide application DBA support including creating databases and database objects.
• Run Explain and db2dvis on SQL statement to aid application performance tuning.
• Perform DB2 and Websphere installations of base level code as well as for corrective FixPacks.
• Create instances of DB2 on multiple server and create databases in the instances
• Install High Availability Disaster Recover (HADR) on multiple pairs of databases for 24 hour uninterrupted processing . Troubleshoot, resolve HADR issues.
• Create clustered environment to facilitate automatic failover of HADR pairs utilizing the db2haicu utility to configure the Tivoli System Automation for Multiplatforms (TSA MP)
• Implement SQL Replication and Q Replication on databases using ASN command APIs
• Utilize IBM Data Studio, IBM Optim Performance Monitor and IBM Recovery Expert in support of the environment.
• Implement Federation of DB2 and Oracle databases
• Create shell scripts to automate some repetitive task and schedule them through CRON where necessary
• Implement Audit capabilities on the database
• Implement DB2 Workload Manager (WLM).
• Install, configure and utilize Optim Performance Manager to address performance
• Implement SSL and data encryption in DB2

Confidential

Sr. DB2 LUW DBA

Responsibilities:

• Provided database support for the application including backup, recovery, reorganization and troubleshooting on UDB 9.7.
• Created and tuned databases and performed backup and recovery.
• Performed installation, troubleshooting, and problem determination using both native and vendor tools.
• Provided training in AIX for clients
• Assisted application developers with database access methods and made recommendations for new/altered technologies that would contribute to system cost savings.
• Migrated data from disparate sources including flat files and Excel into UDB/DB2.
• Implemented High Availability Disaster Recovery (HADR) on PROD and QA DB system.
• Developed and documented Business Continuity and Disaster Recovery procedures for the bank.
• Conducted classes for management and employees on the new BC/DR procedures.
• Designed and implemented conceptual and physical modeling using ERwin tool.
• Author an Information Systems Security document for a bank
• Provided ongoing technical support for UDB/DB2 and tune applications that access the database
• Installed and configured Enterprise Content Manager on Windows to connect to UDB/DB2 and WebSphere on Linux for the demonstration and trial of the Content Manager product.

Confidential, Jacksonville, FL

Sr. DB2 LUW DBA

Responsibilities:

• Supported UDB/DB2 on AIX, Linux and Windows and Webshere Server on Linux.
• Provided the installation, maintenance, performance, monitoring, and security for multiple database systems.
• Performed problem analysis and resolution and created and tune, databases and perform backups and recovery.
• Developed shell scripts to automate maintenance activities and schedule through CRON.
• Performed installation, troubleshooting, and problem determination using native and vendor tools.
• Implemented High Availability Disaster Recovery (HADR) on databases
• Worked with other technical groups, developers and management to resolve complex business, computer system and data communication problems. Install, upgrade and maintain database and database-related software products.
• Designed, implemented, and promoted databases, tablespaces, tables, indexes, views, and triggers in Development, QA, UAT and Production DW environment using Erwin system.
• Handled complex production and operational problems requiring individual judgment and latitude for independent action to solve these problems.
• Perform recovery activities on databases, identified reoccurring and potential operations problems. Recommended controls for prevention. Reported results from technical research, system performance reports and problem resolutions to upper-management.
• Coordinated initiatives with other departments to maximize efficiencies.
• Made recommendations for new/altered technologies that would contribute to system cost savings and/or productivity improvements.

Confidential

Sr. DB2-UDB DBA Linux, UNIX

Responsibilities:

• Managed all aspects of a company of fifteen and oversaw the software development process.
• Conducted reviews of existing DR/BC plans as well as architect new plans for client companies.
• Designed, documented, implemented and assisted in testing DR/BC plans for clients.
• Created data model to support application development effort.
• Created logical and physical database design in support of the project.
• Assisted application development effort utilizing UDB/DB2 on Linux.
• Implemented High Availability Disaster Recovery (HADR) on internal systems.
• Installed and configured UDB 9.7 and created database objects to support project.
• Designed and implemented conceptual and physical modeling using ERWin tool.
• Formulation and implementation of strategic plans,
• Provided consulting and architectural services to clients,

Confidential, Gaithersburg, MD

DB2 DBA

Responsibilities:

• Served as a consultant on a large scale development effort utilizing DB2 (UDB) V8.2 and V9 on AIX, WebSphere and Siebel.
• Installed, configured and supported DB2 and Websphere Server on multiple servers
• Resolved problems encountered in the developments efforts related to database including tuning database parameters, modifying SQL and providing alternative architectural direction.
• Monitored the performance of the databases and instances and adjust the appropriate tuning parameters. Developed shell scripts to automate maintenance activities and schedule through CRON.
• Capacity planning responsibilities included determining file systems to be created, determining disk capacity to support the multiple instances and databases and projecting disk usage requirements.

Confidential, Atlanta, GA

DB2 DBA

Responsibilities:

• Database administrator working with large data warehouse implementation utilizing UDB V8.2 and V9 on AIX.
• Major part of the data warehouse utilized the Data Partitioning Feature (DPF) of UDB on eight (8) logical partitions on two (2) physical nodes accessing terabytes of data.
• UDB with the single node configuration also utilized for some of the databases in the warehouse.
• Utilized the federation feature of UDB to access UDB on the z/OS platform.
• Provided DBA support for SAP and PeopleSoft applications utilizing Websphere and UDB databases
• Worked with ETL tool Informatics and end user tools Cognos, Quest and others to access the UDB database.
• Created and implemented stored procedures and functions.
• Designed and implemented conceptual and physical modeling using ERWin tool
• Performed all routine DBA functions as backup, restore, reorganize, recover and performance tuning of applications and the database.

Confidential, Jacksonville, FL

DB2 DBA

Responsibilities:

• Database administrator working with large data warehouse implementation utilizing UDB V7 and V8 on AIX.
• Major part of the data warehouse utilized the Data Partitioning Feature (DPF) of UDB on twelve (12) logical partitions on six (6) physical nodes accessing terabytes of data.
• UDB with the single node configuration also utilized for some of the databases in the warehouse.
• Utilize the federation feature of UDB to access UDB on the z/OS platform.
• DBA support for SIEBEL and PeopleSoft applications running on UDB
• Performed tuning of SQL in applications and user queries by means of EXPLAINs, monitoring tools, snapshots and event monitors.
• Performed instance and database configuration tuning as well as physical database design to optimize overall system performance.
• Designed and implemented conceptual and physical modeling using ERWin tool
• Installed and supported data analysis tools Cognos and data transformation tool Datastage.
• Provided backup and recovery database structures utilizing TSM. Install, configure and use DB2 Performance for diagnosing and tuning the system.
• Installed, configured and used Query Patroller and the DB2 Governor to manage the applications. Involved the migration of DB2 V7 to V8 on both AIX on z/OS.

Confidential, Tallahassee, FL

DB2 DBA Confidential /Linux

Responsibilities:

• Provide architectural and technical guidance for the project
• Performed duties as a DB2 database designer and administrator in support of large development effort.
• Duties included installing and tuning UDB and DB2 Connect on Sun Solaris, NT and SCO UnixWare utilizing TCP/IP protocols.
• Installed, administered and tuned multiple UDB OS/390 subsystems on the mainframe.
• Designed, implemented, and promoted databases, tablespaces, tables, indexes, views, and triggers in Development, QA, UAT and Production DW environment using Erwin system
• Offered guidance to developers on design and debugging of SQL applications.
• Worked with the data modeling team in devising optimal join strategies for the physical design.

Confidential, Jacksonville, FL

DB2 DBA

Responsibilities:

• Performed duties as a DB2 database designer and administrator in support of multiple database management subsystems.
• Installed, migrated and tuned multiple subsystems using products from PLATINUM and LANDMARK.
• Provided ongoing support and maintenance of existing DB2 and UDB databases and DB2 Connect.
• Assisted programmers in the application design and preparation in a DB2/CICS environment. Hardware and operating environments consists of NT and AIX servers, NT workstations and IBM mainframe running OS/390.

Confidential, Boca Raton, FL

DB2 DBA

Responsibilities:

• Provided technical and project management expertise in support of large insurance application. Performed capacity planning on the data needs of the application and provided database administration support.
• Architect solutions for managing the data environment as well as installing new software and migrate existing applications. Interface with Oracle and Sybase database management software systems running on AIX and NT servers.
• Configured, tuned and administered UDB/DB2 Connect gateway from NT workstation clients to DB2 on the mainframe.