SUMMARY:

• A position as a Database Manager or Database Architect in a challenging environment that will allow me to expand my professional qualifications on a diverse set of data base technologies.
• Extensive experience in the Information Technology field, having functioned as a Database Administrator, Database Architect, and Database and Middlware Manager.
• Significant experience in leading projects from a database perspective, and database experience spans many relational platforms in a multitude of diverse corporate environments supporting a variety of applications.
• First 10 years or so were purely dedicated as a database administrator and database architect. started to evolve into the database management path, with the ability to maintain technical skills, which are now combined with over 20 years of management experience.
• Having held both technical and managerial positions, have provided the necessary skills and background to make career easier to manage and more enjoyable.
• Well recognized for technical background and the ability to make technical decisions based on own technical and managerial knowledge.
• Considered as an excellent team player, with an open and honest means of communication with management, peers, and clients.

PROFESSIONAL EXPERIENCE

Confidential

Database Team Lead

Responsibilities:

• Management responsibilities include planning and controlling all activities of the DBA and middleware staff and have full management responsibility for their performance and development in accordance with corporate strategic directions.
• Oversee development of overall project plans and timetables from a DBA and middleware perspective, including installation, configuration, evaluation and implementation of DBMS software, database tools, database environments and middleware components.
• Supervise the staff in the creation of database and middleware solutions, troubleshooting, and problem resolution.
• Provide technical expertise to clients, IT management, and staff regarding DBMS and middlware strategic direction and participate with the architecture area in the development of the corporate database and middleware environments.
• Provide leadership in disaster recovery exercises, SOX security controls & audits.
• Transitioned on - shore DBA and Middleware responsibilities to off-shore resources, while continuing managing on-shore and off-shore.
• Provide leadership in data center relocations (transitioning) and database upgrades/consolidation (transformation) projects.

Confidential, Northfield, Illinois

SENIOR BUSINESS SYSTEMS MANAGER

Responsibilities:

• Management responsibilities include planning and controlling all activities of the DBA staff and have full management responsibility for their performance and development in accordance with corporate strategic directions.
• Oversee development of overall project plans and timetables from a DBA perspective, including installation, configuration, evaluation and implementation of DBMS software, database tools, and database environments.
• Supervise the staff in the creation of database solutions, troubleshooting, and problem resolution.
• Provide technical expertise to clients, IT management, and staff regarding DBMS strategic direction and participate with the architecture area in the development of the corporate database architecture.
• Provide leadership in disaster recovery exercises, SOX security controls & audits, and management of customer and vendor relationships.
• Provide technical expertise to negotiate enterprise contracts with Oracle and BMC, saving Confidential thousands, if not millions of dollars.
• Stay up to date on trends and developments within functional area of expertise and the industry direction.
• Manage internal budgets ranging from 2.5 to 4 million dollars, including monetary expenditures to acquire software & hardware.
• Architected Oracle and SQL Server enterprise database environments to reduce/consolidate Confidential ’s distributed landscape.
• Architected “True” high availability environments in Oracle and SQL Server using RAC/Data Guard/HACMP, and Clustering respectively.
• Architected Oracle Named Server/SQLNet solution to improve connectivity from multiple locations.
• Logical design, physical design, test, implementation, 24X7 production support, and performance & tuning, for IMS, SQL/DS, DB2, and Oracle applications.
• Project leader/DBA for the conversion of: IMS dbases to DB2, SQL/DS dbases to DB2, and Teradata dbases to DB2.
• Development of Logical, Physical, and Relational database designs using BACHMAN, SylverRun, and Erwin modeling tools.
• Reverse engineering to create logical design of IMS systems being converted to DB2, and generated object definitions from Teradata to convert databases into DB2.
• Project Manager/DBA resource for Confidential conversions for all of the IMS environments, and also for all of the Oracle environments.

Confidential, Northbrook, Illinois

SENIOR SYSTEMS PROGRAMMER

Responsibilities:

• Logical design, physical design, test, implementation, 24X7 production support, and performance & tuning, for IMS and DB2 applications.
• Liaison for the DBA unit to coordinate the successful consolidation of six Regional Offices as well as the relocation of eight Regional Offices to three Data Centers.
• Duties included DASD configurations, DBRC recons, On-site support, "Round Robin" testing, Checklist creations, and other related aspects necessary to make the IMS, CICS environment operational.
• Project leader for the conversion of IMS dbases from HIDAM/OSAM to HIDAM/VSAM, and migration of IMS dbases from 3380 to 3390 DASD devices.
• Project leader for partitioning of existing IMS dbases, adding "Sparse" indexing to existing IMS dbases, Creation, documentation, and installation of Backup, Reorg, and Recovery utilities, DBRC registration of new dbases, Space management and budgeting, and Being on-call for production support.
• Development of Logical, Physical, and Relational database designs using BACHMAN CASE tool based upon IEW DA designs.
• Reverse engineering to create logical design of IMS systems being converted to DB2.
• Creation of DB2 objects to set-up test systems, "Pilot" installations, and country wide installations of relational applications.
• Database monitoring and tuning to better utilize resources and improve performance.
• Participated in the development and documentation of procedures, standards, and techniques, as well as a "Data dictionary" tool to maintain the integrity of naming conventions for DB2 objects.

Confidential, Springfield, Illinois

PROGRAMMER/ANALYST

Responsibilities:

• Logical design, physical design, test, implementation, 24X7 production support, and performance & tuning, for IMS and SQL/DS applications.
• Responsible for maintaining IBM Data Dictionary DBDs in all of their different subject categories to create DBDs and PSBs to produce DBDGEN and PSBGEN source for IMS libraries and data definitions for COBOL "Include" libraries.
• Setting up JCL procedures for production control to Backup, Recover, and Reorg existing databases.
• Create documentation for production jobs using flowcharting software package.
• Design and implement batch PAF programs to generate reports from data Dictionary.