PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Senior Database Administrator, Senior System Programmer

Responsibilities:

• Performed database modeling, design and implementation.
• Supported IMS for z/OS Databases Version 15.
• Supported DB2 for z/OS Databases Version 11.
• Supported DB2 for LUW Version 11.1.
• Supported CICS.
• Installed and supported REHL 7.2.
• Performed System Programming support for z/OS software.
• Performed System Programming support for IMS and DB2.
• Supported SQL Server 2016
• Proficient with Stored Procedures, Triggers and Views.
• Proficient with SMP/E.
• Performed DBD, PSB, and ACB GEN's.
• Supported Database Recovery Control.
• Proficient with DB2 HADR.
• Scheduled reorganizations, backups and recoveries.
• Performed COBOL Programming.
• Performed SQL optimization.
• Performed tuning of databases.
• Provided disaster recovery backup, testing, and documentation.
• Followed Agile software development process.
• Provided 24x7 on - call production support.

Confidential, Columbus, OH

Senior DB2 Database Administrator

Responsibilities:

• Supported DB2 for LUW Databases Version 10.5Assisted application development teams.
• Performed SQL optimization.
• Performed tuning of databases.
• Provided 24x7 on-call production support

Confidential, Harrisburg, PA

Senior Database Administrator, Senior System Programmer

Responsibilities:

• Performed database modeling, design and implementation.
• Supported IMS for z/OS Databases Version 13.
• Supported DB2 for z/OS Databases Version 11.
• Supported DB2 for LUW Version 10.5.
• Supported CICS.
• Supported SQL Server 2016.
• Supported MySQL Databases.
• Supported Oracle Databases Version 12c.
• Supported Q Replication.
• Proficient with DB2 HADR.
• Performed System Programming support for z/OS software.
• Performed System Programming support for IMS and DB2.
• Proficient with SMP/E.
• Performed DBD, PSB, and ACB GEN's.
• Supported Database Recovery Control.
• Supported IMS HALDBs.
• Resolved technical issues using OMEGAMON.
• Scheduled reorganizations, backups and recoveries.
• Performed COBOL Programming.
• Proficient with IDAA.
• Proficient with AWS.
• Proficient with MongoDB.
• Proficient with HTML.
• Proficient with CSS.
• Proficient working in a cloud environment.
• Performed SQL optimization.
• Performed tuning of databases.
• Followed Agile software development process.
• Provides 24x7 on-call production support.

Confidential, Olympia, WA

Senior IMS Database Administrator

Responsibilities:

• Performed database modeling, design and implementation.
• Supported IMS for z/OS Databases Version 11.
• Supported CICS.
• Performed DBD, PSB, and ACB GEN's.
• Supported Database Recovery Control.
• Resolved technical issues using OMEGAMON.
• Scheduled reorganizations, backups and recoveries.
• Performed tuning of databases.
• Maintain IMS exits written in Assembler and COBOL.
• Provided disaster recovery backup, testing, and documentation.
• Proficient with JCL.TSO, ISPF
• Provides 24x7 on-call production support.

Confidential, Pontiac, MI

Senior Database Administrator, Senior System Programmer

Responsibilities:

• Performed database modeling, design and implementation.
• Supported SQL Server 2014.
• Supported Oracle Databases Version 11g.
• Supported IMS for z/OS Databases Version 10.
• Supported DB2 for z/OS Databases Version 9.
• Supported DB2 for LUW Databases Version 10.
• Performed System Programming support for z/OS software.
• Supported CICS.
• Supported Linux 5.8.
• Supported MySQL Databases
• Supported Percona Server for MySQL.
• Proficient with AWS.
• Performed DBD, PSB, and ACB GEN’s.
• Supported IMS HALDBs.
• Scheduled reorganizations, backups and recoveries.
• Performed SQL optimization.
• Proficient with SSIS, SSRS and SSAS.
• Proficient with T-SQL scripting.
• Proficient with OLTP and OLAP database models.
• Proficient with System Development Life Cycle and Database Life Cycle.
• Proficient with Data Warehousing.
• Performed monitoring and tuning of databases.
• Performed COBOL Programming.
• Proficient with Python
• Followed agile software development process.
• Proficient with HADR.
• Proficient with DB2 PureScale.
• Proficient with RHEL 7.
• Proficient with ArangoDB
• Proficient with AQL
• Proficient with MongoDB.
• Proficient with Couchbase database.
• Proficient with MariaDB.
• Proficient with Cassandra database.
• Provided 24x7 on-call production support

Confidential, Lanham, MD

Senior DB2 Database Administrator

Responsibilities:

• Supported DB2 for z/OS Databases Version 9.
• Scheduled reorganizations, backups and recoveries.
• Assisted application development teams.
• Performed SQL optimization.
• Performed tuning of databases.
• Performed data partitioning
• Received Interim Major Background Investigation

Confidential, Atlanta, GA

Senior DB2 Database Administrator

Responsibilities:

• Supported DB2 for z/OS Databases Version 9.
• Scheduled reorganizations, backups and recoveries.
• Assisted application development teams.
• Resolved technical issues received from BMC Remedy tool.
• Performed SQL optimization.
• Performed tuning of databases.
• Followed agile software development process.
• Provided 24x7 on-call production support

Confidential, Southfield, MI

Senior Database Administrator

Responsibilities:

• Supported DB2 for z/OS Databases Version 9.
• Supported SQL Server 2008
• Supported IMS Version 10
• Supported IMS HALDBs.
• Supported IMS Fastpath Databases
• Resolved technical issues received from BMC Remedy tool.
• Followed agile software development process.
• Scheduled reorganizations, backups and recoveries.
• Assisted application development teams.
• Performed SQL optimization.
• Performed tuning of databases.
• Performed data partitioning
• Provided 24x7 on-call production support/escalation.
• Followed agile software development process.
• Implemented Microsoft Dynamics GP 2010
• Performed database replication
• Provided 24x7 on-call production support

Confidential, Athens, GA

Senior IMS/DB2/Oracle Database Administrator, System Programmer, Cobol Developer

Responsibilities:

• Performed database modeling, design and implementation.
• Supported Oracle 10g Databases.
• Supported UNIX environment.
• Created Object Oriented Perl programs.
• Performed System Programming support for IMS and DB2.
• Performed System Programming support for z/OS.
• Supported DB2 Databases for z/OS V8.
• Resolved technical issues received from BMC Remedy tool.
• Performed SQL optimization.
• Supported IMS Version 10 databases
• Performed DBD, PSB, and ACB GEN’s.
• Supported Database Recovery Control.
• Supported IMS HALDBs.
• Scheduled IMS Change Accumulation Utility.
• Resolved technical issues using OMEGAMON.
• Scheduled reorganizations, backups and recoveries for IMS and DB2 databases.
• Performed data partitioning
• Proficient with JCL.
• Performed tuning of IMS and DB2 databases.
• Developed COBOL application code.
• Proficient with Assembler.
• Provided 24x7 on-call production support.

Confidential, Parsipanny, NJ

Senior DB2 Database Administrator - JAVA Developer - Cobol Developer

Responsibilities:

• Performed database modeling, design and implementation.
• Recommended training for Auto-Owners Associates.
• Liaison between CIO and development teams.
• Performed System Programming support for IMS and DB2.
• Assisted application development teams using COBOL programming.
• Assisted with SAP DB2 Issues
• Assisted with Data Modeling sessions using Embarcadero ER Studio.
• Supported DB2 Databases for z/OS Version 9.
• Supported DB2 Databases for Linux Version 9.
• Supported Oracle Databases.
• Supported MySQL Databases.
• Proficient with AWS.
• Resolved technical issues using OMEGAMON.
• Proficient with Perl.
• Performed tuning of databases.
• Performed SQL optimization.
• Developed JAVA application code.
• Developed COBOL application code.
• Proficient with Assembler.
• Followed agile software development process.
• Provided 24x7 on-call production support

Confidential, Southfield, MI

Senior IMS/DB2 Database Administrator

Responsibilities:

• Supported Visteon Corporation migration of IMS and DB2 databases from Confidential Company.
• Created process to migrate Visteon production environments to test systems.
• Supported DB2 for z/OS Version 7 to Version 8 migrate.
• Supported IMS Version 8 and Version 9 databases
• Performed DBD, PSB, and ACB GEN’s.
• Supported Database Recovery Control.
• Supported IMS HALDBs.
• Supported IMS Fastpath Databases.
• Scheduled IMS Change Accumulation Utility.
• Resolved technical issues received from BMC Remedy tool.
• Proficient using OMEGAMON.
• Scheduled reorganizations, backups and recoveries for IMS and DB2 databases.
• Proficient with JCL.
• Performed tuning of IMS and DB2 databases.
• Performed data partitioning
• Assisted application development teams using COBOL programming.
• Performed SQL optimization.
• Provided 24x7 on-call production support.

Confidential, Chicago, IL

Data Administrator - Senior DB2/SYBASE Database Administrator

Responsibilities:

• Resolved database issues resulting from migration of IDMS to DB2.
• Recommended vendor database products for purchase to senior management.
• Performed database modeling, design and implementation of DB2 for OS/390.
• Performed database modeling, design and implementation of DB2 for UDB.
• Performed database modeling, design and implementation of Sybase Databases
• Assisted with data loading and unloading.
• Created triggers.
• Assisted in IT Security Services Life Cycle.
• Proficient with JCL.
• Proficient with TMON
• Proficient with Image Copy, REORG, Runstat, Recovery using Computer Associate tool set.
• Performed SQL optimization.
• Performed Sybase replication
• Performed tuning of databases.
• Performed data partitioning
• Created technical and corporate training for database administrators.
• Prepared detailed disaster recovery plans:
• Performed risk analysis for corporate functional areas
• Established disaster recovery testing methodologies
• Assisted in disaster recovery implementation and testing
• Provided 24x7 on-call production support

Confidential, Troy, MI

Data Administrator - Senior IMS/DB2 Database Administrator

Responsibilities:

• Supported IMS and DB2 Databases.
• Resolved technical issues.
• Followed Six Sigma process.
• Performed database modeling, design and implementation for DB2 for OS/390.
• Performed database support for IMS applications.
• Scheduled reorganizations, backups and recoveries.
• Monitored database space management.
• Proficient with JCL.
• Performed SQL optimization.
• Performed tuning of databases.
• Resolved technical issues received from BMC Remedy tool.
• Proficient using OMEGAMON.
• Performed data partitioning
• Developed COBOL application code.
• Proficient with Assembler.
• Provided 24x7 on-call production support/escalation.