SUMMARY:

Innovative and dynamic Manager, Architect and Administrator of IT with 20+ years of experience across industries encompassing software, financial, government, insurance and manufacturing organizations. Excellence in database administration, system administration, application development and project management.

CORE COMPETENCIES

• Database Administration Application Development
• Project Management SDLC Management
• Staff Management Vendor Negotiation

TECHNICAL PROFICIENCIES:

PLATFORMS: z/OS, z/VM, ESX, VMWare, AIX, SOLARIS, LINUX, HP - UX, Windows, AS/400

DATABASES: DB2, IMS, IDMS, ORACLE, SQL Server, MySQL, Sybase

OLTP: CICS, UNIKIX

MIDDLEWARE: MQSeries, NDM, DB2 Connect, DB2 Gateway, CICS Gateway

MONITORING: MAINVIEW, OMEGAMON, TMON, PATROL, Netview, DB2 PM

SECURITY: RACF, Top Secret, ACF2, Active Directory

BACKUP: Tivoli Storage Manager (TSM), NetBackup, CommVault

LANGUAGES: COBOL, Assembler, PL/SQL, T-SQL, FORTRAN, SAS, ADS/O, RPG-II, BASIC

SOFTWARE: SMP/E, IBM Utilities, TSO/ISPF, SDSF, FDR, DADS, Hiperstation

STORAGE DEVICES - SAN: EMC, HDS, 3PAR

MICROSOFT PRODUCT SUITE: Word, Excel, PowerPoint, Project, Visio

PROFESSIONAL EXPERIENCE:

Confidential, Rochester, NY

Project Manager

Responsibilities:

• Performed Database Administration and Systems Programming duties associated with DB2 versions 2.3 through 9.1, CICS versions 1.7 through Transaction Server 4.2, IMS versions 1.3 through 9.1 and IDMS versions 10.2 through 16.0. Maintained DB2, CICS, IMS and IDMS software using SMP/E.
• Maintained ISV software associated with DB2. Products included DB2 Connect, Data Propagator, Omegamon and Mainview for DB2, Platinum / CA DB2 utilities, Insight for DB2, Proedit for DB2 and Fileaid for DB2.
• Developed JCL for running utilities for Loads, Unloads, Image Copies, Reorgs, Runstats, etc.
• Conducted database maintenance with DB2 System Administration Tools.
• Provided DB2 Database support to System Administration Team during upgrades.
• Provided DBA services for migrating and installing application systems from customer sites.
• Performed Database, Tablespace, Table and View definitions and configuration.
• Reviewed DB2 subsystem DASD capacity and added volumes when necessary.
• Performed space management and reorganizations of partitioned tablespaces.
• Checked implementation of tables of client systems; verifying structures of Tables, Indexes, Stored Procedures, etc. against the design.
• Developed and tested online database reorganizations to improve system availability.
• Performed massive data loads and database subsystem refreshes in order to implement new data repositories.
• Customized DB2 subsystems to customer requirements. Modified various DB2 assembler exits to enable userid translation from one business environment to another. Modifying these exits enabled users to have single sign-on capability.

Confidential

Sr. DBA

Responsibilities:

• Performed DB2-RACF administration along with DB2 native security administration.
• Performed DB2 performance and tuning. Created Omegamon and Mainview performance reports. Performed Explains and DB2 system traces when necessary. Reviewed various hit ratios and tuned the environments accordingly to improve performance.
• Implemented DB2 reports that analyzed the overall DB2 environments which were reviewed daily and acted upon accordingly.
• Designed and implemented proactive database monitoring on key application performance indicators. Proactively notified customer of potential problems and provided a recommended resolution. Reduced potential application performance issues by 100%.
• Performed Database, Tablespace, Table and View definitions and configuration.
• Reviewed DB2 subsystem DASD capacity and added volumes when necessary.
• Assured all DB2 subsystems were properly backed up and recoverable.
• Interfaced with customers providing assistance with debugging, coding, application design and tuning of DB2, CICS, IMS and IDMS subsystems.
• Participated in quarterly Disaster Recovery exercises assuring Operating System, CICS and Database system recoverability. Developed and executed disaster recovery processes for all participating customers.
• Assisted in designing and converting RCA’s Inventory Management System from a batch COBOL environment to an online Database environment.
• Developed and maintained MRP, Insurance and Financial DB2 based applications.
• Performed software evaluation and provided cost-benefit analysis.
• Assisted in determining shop programming standards.
• Maintained IDMS/COBOL based ERP and financial applications.
• Provided 24 x 7 on-call support for all DB2 Database systems and affiliated software.
• Managed full project lifecycle: planning, development, testing and user acceptance.
• Drove strategy, standards and implementation of technology solutions that enabled SunGard to achieve operational, financial and exceptional customer service goals.
• Managed testing and implementation of new technologies, including methods, policies and procedures for installation, management, monitoring and support.
• Escalated technical challenges encountered by the project team to executive sponsor.
• Oversaw key milestones and managed technical expectations during project implementation.
• Led and matrix managed personnel from hardware, network, engineering, system administration, storage management, database, security, customer service and application teams.
• Ensured all technical team members were contributing effectively to their designated projects. Prioritized staff responsibilities based on project significance.
• Mentored staff by promoting active engagement which facilitated a cohesive project team.

Confidential

Sr. DBA

Responsibilities:

• Managed full software development lifecycle: requirements, design, implementation, verification and maintenance. Oversaw key milestones and managed technical expectations during life cycle.
• Functioned as the technical lead responsible for all technical aspects on multiple projects. Assessed the business requirements and planned budget to effectively implement solutions that adhered to fiscal, technical and vendor best practices.
• Managed global staff of 20 administrators and programmers across 7 Data Centers.
• Maintained 1000+ OLTP and Database Systems as well as providing backup for 1500+ client nodes.
• Systems based in CICS, DB2, MQSeries, IMS, UNIKIX, ORACLE, SQL SERVER and MYSQL.
• Successfully combined Mainframe and Midrange team members to support all online, database, MQ and network environments independent of the operating system platform. Streamlined the support group and produced 100% capability with 30% less staff.