Johnbolas

Freelance Database Expert & Database Designer

845
Location:Warren, Michigan, United States
Profile:https://www.freelanced.com/johnbolas
0
Kudos
5.0
2 Skills
$50
Rate/Hr
John Bolas
26386 Curie
Warren, Michigan, 48091
(517) 281-5056
E-mail bolasj@comcast.net

Work Experience:

10/12 to current Hewlett-Packard, Pontiac, MI

Assigned to: Blue Shield of California

Position: Senior IMS/DB2/SQL Server Database Administrator

Performed SQL Server 2008 installation, upgrades and maintenance
Proficient with Microsoft Dynamics Great Plains
Proficient with SQL Server Reporting Services
Proficient with SQL Server Integration Services
Proficient with CICS
Supported MQ Servers.
Performed database modeling, design and implementation.
Created SSRS reports using SQL 2008
Supported IMS for z/OS Databases Version 10.
Supported DB2 for z/OS Databases Version 10.
Supported DB2 for Unix Version 9
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.
Assisted application development teams.
Performed SQL, TSQL and Stored Procedure optimization.
Performed tuning of databases.
Provided disaster recovery backup, testing, and documentation
Proficient with JCL.TSO,ISPF
Followed ITIL software development process.
Preparing for PMP certification.
Provided 24x7 on-call production support.

01/12 to 06/12 Computer Services Corporation, Lanham, MD

Assigned to: Internal Revenue Service

Position: Senior DB2 Database Administrator

Supported DB2 for z/OS Databases Version 9.
Scheduled reorganizations, backups and recoveries.
Performed SQL optimization.
Performed database replication.
Proficient with JCL.TSO,ISPF
Received Interim Major Background Investigation

11/11 to 01/12 Pyramid Consulting, Atlanta, GA

Assigned to: Capital One

Position: Senior DB2 Database Administrator

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.
Proficient with JCL.TSO,ISPF
Performed SQL optimization.
Performed tuning of databases.
Resolved technical issues using OMEGAMON.
Followed ITIL software development process

07/10 to 11/11 SYNOVA Computer Services, Southfield, MI

Assigned to: Ford Motor Company

Position: Senior IMS/DB2/SQL Server Database Administrator

Supported DB2 for z/OS Databases Version 9.
Supported SQL Server 2008
Supported IMS Version 10
Supported IMS HALDBs.
Supported IMS Fastpath Databases
Supported MQ Servers.
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.
Resolved technical issues using OMEGAMON.
Performed data partitioning
Proficient with JCL.TSO,ISPF
Provided 24x7 on-call production support/escalation.
Followed ITIL software development process.
Implemented Microsoft Dynamics GP 2010
Performed database replication

12/09 to 07/10 University of Georgia, Athens, GA

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

Supported Oracle 10g Databases.
Supported LINUX environment.
Supported MQ Servers
Created Object Oriented Pearl programs.
Provided System programming support for z/OS software.
Supported DB2 Databases for z/OS V8.
Supported DB2 Databases for LUW V8
Created DB2 Version 8 to Version 9 migration plan.
Resolved technical issues received from BMC Remedy tool.
Liaison between DBA team and development teams.
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.TSO,ISPF
Performed tuning of IMS and DB2 databases.
Proficient with IBM Query Management Facility
Provided 24x7 on-call production support.

12/06 to05/09 SATYAM COMPUTER SERVICES, Parsipanny, NJ
Consultant
Assigned to: Auto-Owners Insurance

Position: Application Database Administrator – Senior DB2 Database Administrator – JAVA Developer – Cobol Developer

Recommended training for Auto-Owners Associates.
Liaison between CIO and development teams.
Provided System programming support for z/OS software.
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 LUW Version 9.
Supported MQ Servers.
Performed data partitioning
Resolved technical issues using OMEGAMON.
Proficient with JCL.TSO,ISPF
Proficient with CA Endeavor
Proficient with CA Erwin.
Performed tuning of databases.
Performed SQL optimization.
Proficient with IBM Query Management Facility
Developed JAVA application code.
Developed COBOL application code.
Proficient with Assembler.
Followed agile software development process.

08/03 to 12/06 SYNOVA Computer Services, Southfield, MI
Consultant
Assigned to: IBM Corporation – I supported the following IBM customers Visteon, Allied, American Express, Ameriprise, Amtrak, Disney, Macy’s, Michelin, BNSF Railroad, CareStream.

Position: Senior IMS/DB2 Database Administrator

Supported Visteon Corporation migration of IMS and DB2 databases from Ford Motor 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.TSO,ISPF
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.

10/02 to 04/03 The Options Clearing Corporation, Chicago, IL
Consultant
Position: Data Administrator – Senior DB2/SYBASE Database Administrator

Assisted application development team.
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 LUW.
Performed database modeling, design and implementation of Sybase Databases
Performed system administration for Solaris servers.
Assisted with data loading and unloading.
Created triggers.
Proficient with CICS
Proficient with JCL.TSO,ISPF
Proficient with TMON and
Proficient with Image Copy, REORG, Runstat, Recovery using Computer Associate tool set.
Performed SQL optimization.
Proficient with CA ERwin
Performed tuning of databases.
Performed data partitioning
Created technical and corporate training for database administrators.
Prepared detailed disaster recovery plans:
Established disaster recovery testing methodologies
Assisted in disaster recovery implementation and testing

10/01 to 10/02 DPM Consulting Services, Troy, MI
Consultant
Assigned to: Ford Motor Company

Position: Data Administrator – Senior IMS/DB2 Database Administrator

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.TSO,ISPF
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.

08/00 to 10/01 The Options Clearing Corporation, Chicago, IL
Consultant
Position: Data Administrator – Senior DB2 Database Administrator

Assisted application development team.
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 LUW.
Performed database modeling, design and implementation of Sybase Databases
Performed system administration for Solaris servers.
Assisted with data loading and unloading.
Created triggers.
Proficient with CICS
Proficient with JCL.TSO,ISPF
Proficient with TMON and
Proficient with Image Copy, REORG, Runstat, Recovery using Computer Associate tool set.
Performed SQL optimization.
Performed database replication.
Performed tuning of databases.
Performed data partitioning
Created technical and corporate training for database administrators.
Prepared detailed disaster recovery plans:
Established disaster recovery testing methodologies
Assisted in disaster recovery implementation and testing

09/97 to 08/00 Comsys Inc, Atlanta, GA
Consultant
Assigned to: BellSouth Telephone Company

Position: Data Administrator – Senior IMS/DB2 Database Administrator

Supported IMS and DB2 Databases.
Performed database modeling, design and implementation of DB2 for OS/390.
Performed tuning of databases.
Lead DBA for the TIRKS and ICIS applications.
Supported IMS Fastpath Databases.
Performed SQL optimization.
Resolved technical issues using OMEGAMON.
Assisted in troubleshooting production database issues.
Created technical training for database administrators.
Provided 24x7 on-call production support/escalation.

09/96 to 09/97 Consumers Energy Corporation, Jackson, MI

Responsible for design, problem analysis, maintenance and performance of DB2 for OS/390 databases. Provided 24 x 7 on call support.

12/94 to 09/96 Electronic Data Systems Corporation, Troy, MI

Project Manager responsible for pro-active initiatives for cost savings, customer satisfaction, feedback and continuous improvement.
Assisted in business process analysis and redesign with customer and support groups.
Liaison between Director of General Motors Milford Proving Grounds and EDS support teams.
Prepared and implemented new business proposals.
Performed architecture, security and technology assessments with customer. Planned, scheduled, monitored, controlled, and reported the activities on multiple projects.
Followed Electronic Data Systems Project Management methodology.
Supervised five application programmers in multiple locations.
Managed the performance of employees with the team goals and corporate goals.

12/89 to 12/94 Project Manager responsible for developing the Database Administration Internship Program for IMS and DB2.
Planned, scheduled, monitored, controlled, and reported the activities on the internship project.
Followed Electronic Data Systems Project Management methodology.
Created Basic, Intermediate, and Advanced courseware.
Developed a “Train the Trainer” course for all internship instructors.
Supervised twenty five application programmers in multiple locations.
Developed mentoring process for interns.
Created improvement process for courseware as software changes and course evaluation metrics collected.
Developed vendor relationship for selected in house training.
Supervised five technical writers.

09/88 to 12/89 Database Administrator responsible for design, problem analysis, maintenance and performance of IMS and DB2 for OS/390 databases. Provided 24 x 7 oncall support. Enhanced and trained employees on the Crosby Quality Improvement Process.

09/85 to 09/88 Michigan Bell Telephone Company, Southfield, Mi

Lead DBA for TIRKS, ICIS, and BSDOPAC applications. Operational Database Administrator responsible for implementation of maintenance release and problem analysis of IMS databases. Resolved technical issues using OMEGAMON.

09/79 to 09/85 Systems Associate responsible for batch execution and supervision of the financial system clerical staff.

Education: Lawrence Technological University, Southfield, MI

COBOL I & II, Mathematics, May 1982

References: Available upon request.
Skills (2) Rating
Database
Database Design