We provide IT Staff Augmentation Services!

Application Database Administrator (contract) Resume

Charlotte, Nc

PROFESSIONAL SUMMARY:

  • Senior IT Consultant with extensive years of experience, functioning in capacities ranging from operator to Database Administrator.
  • Experience includes Adabase, DB2 LUW v9.7, DB2 v11 for Z/OS, Native Stored Procedures, Qreplication, software application development, SQL tuning, production support, migration, conversion, quality assurance, testing, release, integration, deployment, maintenance, mentoring other DBA’s and programmers, disaster recovery, performance tuning, ETL tools, operations, and database administration.
  • Strong client relationship management skills.
  • Experience spans from mainframe to client/server.
  • Business processes supported from an IT perspective include manufacturing, contract administration, insurance, accounting, billing, finance, purchasing, material scheduling, material control, vehicle order management/scheduling, inventory, warehouse management, accounts payable, general ledger, parts sequencing, and lot tracking.
  • Superior team building and troubleshooting skills with a proven record of success with flexibility, accuracy, speed and performance.

TECHNICAL SKILLS:

Languages: SQL, JCL, JAVA, JAVASCRIPT, XML, HTML, COBOL, COBOL II, PL/SQL, TCL, Korn Shell Scripting, CICS, PL/1 (light), FORTRAN (light)

Operating Systems: Windows, UNIX, Z/OS, MVS OS/390, IBM 3278, DOS 5.0, DOS 6.0, Windows XP/NT/ 2000/98/95/3.1

Data Base Systems: Adabase, DB2 LUW v9.7, DB2 v11 for Z/OS, SQL Server 2005/2008, Oracle version 8i, MS - Access, IMS DC

Data Management: MQ Series

Office Automation: MS-Access, MS-Word, MS-Excel, MS-Outlook, WordPerfect, MS-PowerPoint

Mainframe Tools: Mainview, REXX, File-Aid, Endeavor, Xpediter, Omegamon for DB2, CA-7, CA-11, TSO/ISPF, Clist, Panvalet, VSAM, ISAM, DB-Delivery, Panvalet, Control-M

Methodologies: SLC

Project Management: Project Manager Workbench, MicroSoft-Project

Industries: Government, Manufacturing, Insurance

ETL Tools: Informatica Power Center V7

Testing Tools: IBM Data Studio, SQL Server Management Studio, DB2 Administration Tool, Oracle Enterprise Manager, Mainview, Xpediter, Omegamon

Reporting Tools: Mobius

Functional Expertise: Contract Administration, Membership Eligibility, Benefits, Commission, Accounting, Billing, Insurance, Financial Services

Other Tools: Native Stored Procedures, IBM Data Studio, SQL Server Management Studio, DB2 Administration Tool, SAP, Peoplesoft, VISIO, Mainview for DB2, IBM Performance Expert V2, IBM Optimization Service Center, TOAD for DB2, BMC Catalog Manager, BMC Change Manager, IBM DB2 utilities, CA Platinum Tools, Toad, Oracle Enterprise Manager, Oracle 8i Statspack.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Application Database Administrator (Contract)

Responsibilities:

  • Successful conversion of Omniplus application databases from Vsam files to DB2 databases in the Sandbox, Unit, Pfix, Sys2, Sys4, IT1, Devit, Devit2 and Production environments.
  • Successful implementation of CICS IA tool into DB2 databases in the Sandbox, Pfix, and Production environments.
  • Creation of DDL to create Databases, Tablespaces, Tables and Indexes.
  • Creation and maintenance of JCL for Reorgs, Runstats, Unloads, Loads, Recoveries and Repairs of those databases.
  • Database performance monitoring, diagnosis and tuning.
  • Application SQL review for possibilities of optimization and systems performance improvement suggestions, and monitor databases for size changes.
  • DB2v11 for Z/OS, Adabase, DB2 Administration Tool, Omegamon for DB2.

Confidential, Columbia, SC

Application Database Administrator (Contract)

Responsibilities:

  • Successful QReplication maintenance of NLR application databases from DB2 Subsystem to DB2 Subsystem using MQ Series in the Implementation and Production environments.
  • Creation of DDL to create Databases, Tablespaces, Tables, Indexes, Constraints, Triggers, Stored Procedures and Sequences.
  • Creation and maintenance of JCL for Reorgs, Runstats, Image Copies, Queisces, Unloads, Loads, Recoveries, Repairs, Check Data and Modify Recovery of those databases.
  • Database performance monitoring, diagnosis and tuning.
  • Application SQL review for possibilities of optimization and systems performance improvement suggestions, and monitor databases for size changes.
  • MQ Series, DB2v10 for Z/OS, Native Stored Procedures, BMC Catalog Manager, BMC Change Manager.

Confidential, Phoenix, AZ

Application Database Administrator (Contract)

Responsibilities:

  • Creation of DDL to create Databases, Tables, Indexes, Constraints for DCL project.
  • Creation of Stored Procedures for DCL project.
  • DB2v9.7 for LUW, Native Stored Procedures.

Confidential, Phoenix, AZ

Business Analyst, Application Database Administrator (Contract)

Responsibilities:

  • Analysis and Creation of a strategy and plan to create a staging area for the separation of Confidential Club Applications/Data.
  • MS-Word, MS-PowerPoint, MS-Excel.

Confidential, Phoenix, AZ

Application Database Administrator (Contract)

Responsibilities:

  • Successful QReplication development and implementation of EMM Arrangement Manager, EMM Arrangement Manager International and Costco/Gen databases from DB2 Subsystem to DB2 Subsystem using MQ Series.
  • Creation of DDL to create Databases, Tablespaces, Tables, Indexes, Constraints, Aliases, Triggers, Stored Procedures, Synonyms, Storage Groups, Sequences and Grants.
  • Creation and maintenance of JCL for Reorgs, Runstats, Image Copies, Queisces, Unloads, Loads, Recoveries, Repairs, Check Data and Modify Recovery of those databases.
  • Database migration, capacity planning and on going performance monitoring, diagnosis and tuning.
  • Application SQL review for possibilities of optimization and systems performance improvement suggestions, and monitor databases for size changes.
  • MQ Series, DB2v9.1 for Z/OS, Native Stored Procedures, BMC Catalog Manager, BMC Change Manager, BMC Apptune.

Confidential, Lafayette, IN

Application Database Administrator

Responsibilities:

  • DB2 LUW v9.7 for Windows installation.
  • Creation and deployment of DB2 mainframe Databases to the windows server.
  • Creation and deployment of Native Stored Procedures.
  • Completed migration from DB2v8 for Z/OS to DB2v9,1 for Z/OS.
  • Project providing database conversion from IMS to DB2 and maintenance support for multiple large DB2 databases on Mainframe and Client Server environments.
  • Replication of databases from Mainframe to Client Server environment.
  • Creation of DDL to create Databases, Tablespaces, Tables, Indexes, Constraints, Aliases, Triggers, Stored Procedures, Synonyms, Storage Groups, Sequences and Grants.
  • Creation and maintenance of JCL for Reorgs, Runstats, Image Copies, Queisces, Unloads, Loads, Recoveries, Repairs, Check Data and Modify Recovery of those databases.
  • Database migration, capacity planning and on going performance monitoring, diagnosis and tuning.
  • Application SQL review for possibilities of optimization and systems performance improvement suggestions, and monitor databases for size changes.
  • DB2 LUW v9.7 for Windows, DB2v9.1 for Z/OS, IBM Data Studio, Native Stored Procedures, SQL Server Management Studio, DB2 Administration Tool, DB2v8 for Z/OS, SQL Server 2005, MS-Access, IBM Performance Expert V2, IBM Optimization Service Center, TOAD for DB2.

Confidential, Columbus, Ohio

Application Database Administrator (Contract)

Responsibilities:

  • Short term project providing database development and maintenance support for multiple large DB2 databases.
  • Creation of DDL to create Databases, Tablespaces, Tables, Indexes, Constraints, Aliases, Triggers, Sequences and Grants.
  • Creation and maintenance of JCL for Image Copies, Queisces, Unloads, Loads, Recoveries, Repairs, Check Data and Modify Recovery of those databases.
  • Database migration, capacity planning and on going performance monitoring, diagnosis and tuning.
  • Application SQL review for possibilities of optimization and systems performance improvement suggestions, and monitor databases for size changes.
  • DB2v8 for Z/OS, MS-Access, DB2 Administration Tool, Stored Procedures

Confidential, Columbus, Ohio

Application Database Administrator (Contract)

Responsibilities:

  • Mentoring DBA’s.
  • Design, development and execution of ETL process.
  • Conversion of Supra data.
  • Design and development of the Mocas Rehost Mainframe DB2 databases.
  • Creation and maintenance of JCL for Disaster Recovery, Image Copies, Queisces,
  • Unloads, Loads, Recoveries, Repairs, Check Data and Modify Recovery of those databases.
  • Database migration, capacity planning and on going performance monitoring, diagnosis and tuning.
  • Application SQL review for possibilities of optimization and systems performance improvement suggestions, and monitor databases for size changes.
  • BMC tools, CICS, MS-Access, DB2v7 for Z/OS.

Confidential, Michigan

Modeler/Application Database Administrator (Contract)

Responsibilities:

  • Developed skills as a Modeler/Application DB2 Database Administrator over a 4-week period with a major insurance carrier utilizing IMS and DB2.
  • Provided analysis and a new logical model in Visio of the client’s provider application database utilizing Visio.
  • BMC tools, DB2v7 for Z/OS, IMS and Visio.

Confidential, Dearborn, Michigan

Application Database Administrator/Mainframe Technical Lead (Contract)

Responsibilities:

  • Successfully completed my role as Cluster 2 Mainframe Technical Lead providing technical assistance to the application teams in North America and Europe. The result of this was the successful launch of 150+ applications (including SAP and Peoplesoft applications), 76,000 programs, 150 million lines of code for Confidential .
  • Application DB2 Database Administrator over a 13-month period with major software services company providing production and oncall support for multiple Confidential Databases being cloned/migrated into the Confidential environments.
  • Responsibilities included support for a Peoplesoft/DB2 database being cloned from Confidential mainframe computers into Confidential mainframe computers.
  • Responsibilities also included Mainframe Technical Lead providing all levels of technical assistance to the application programmers in North America and Europe, production oncall support for the databases being cloned from Ford to the Confidential environment, database migration, capacity planning and on going performance monitoring, diagnosis and tuning, application SQL review for possibilities of optimization and systems performance improvement suggestions, and monitor databases for size changes.
  • SAP, Peoplesoft, BMC tools, CICS, MS-Access, DB2v7 for Z/OS.

Confidential, Troy, Michigan

Application Database Administrator/Consultant (Contract)

Responsibilities:

  • Provided development, production and oncall support for multiple Confidential Databases.
  • Responsibilities included application security, database migration, capacity planning, on going performance monitoring, diagnosis and tuning, maintenance and design, oncall production support, application SQL review for possibilities of optimization and systems performance improvement suggestions, and monitor databases for size changes.
  • UNIX, PL/SQL, Korn Shell Scripting, TCL, Oracle version 7.3 and 8i.

Confidential, Troy, Michigan

Application Database Administrator/Consultant (Contract)

Responsibilities:

  • Provided development, production and oncall support for multiple Confidential Databases including the Confidential Data Base Vehicle Order Management, GM Financial Database BARS, and Engineering Material System.
  • Responsibilities included application security, data modeling, database migration, capacity planning, on going performance monitoring, diagnosis and tuning, maintenance and design, oncall production support, application SQL review for possibilities of optimization and systems performance improvement suggestions, and monitor databases for size changes.
  • BMC tools, CA Platinum tools, CICS, MS-Access, DB2v5 for OS/390.

Confidential, Troy, Michigan

Application Database Administrator/Consultant (Contract)

Responsibilities:

  • Provided development, production and on call support for the Confidential Data Base Vehicle Order Management.
  • Responsibilities included application security, data modeling, database migration, capacity planning, on going performance monitoring, diagnosis and tuning, maintenance and design, oncall production support, application SQL review for possibilities of optimization and systems performance improvement suggestions, and monitor databases for size changes.
  • BMC tools, CA Platinum tools, CICS, MS-Access, DB2v5 for OS/390.

Confidential, Troy, Michigan

Application Database Administrator (Contract)

Responsibilities:

  • Provided development, production and on call support for the Confidential Data Base Engineering Material System.
  • Responsibilities included application security, data modeling, database migration, capacity planning, on going performance monitoring, diagnosis and tuning, maintenance and design, oncall production support, application SQL review for possibilities of optimization and systems performance improvement suggestions, and monitor databases for size changes.
  • BMC tools, CA Platinum tools, CICS, MS-Access, DB2v4 for OS/390.

Confidential, Dearborn, Michigan

Application Database Administrator (Contract)

Responsibilities:

  • Successfully developed skills as a DB2 Database Administrator with a major software services company providing development, production and on call support for the multiple Databases.
  • Responsibilities included application security, database migration, capacity planning, on going performance monitoring, diagnosis and tuning, maintenance and design, oncall production support, application SQL review for possibilities of optimization and systems performance improvement suggestions, and monitor databases for size changes.
  • CICS, MS-Access, DB2v3 for OS/390.

Confidential, Dearborn, Michigan

Field Manager (Contract)

Responsibilities:

  • Responsible for seven field consultants. Management responsibilities include salary administration, performance reviews, and career counseling and client interviews.

Confidential, Dearborn, Michigan

Project Manager (Contract)

Responsibilities:

  • Responsible for program maintenance, system development and language conversion projects for a Division of a major automotive manufacturer.
  • Maintenance was performed on a variety of systems primarily utilizing COBOL, IMS DB/DC, DB2, SAS, CLIST, FOCUS and MARK IV technologies.
  • Development was concentrated primarily in the areas of COBOL, IMS DC and DB2.
  • Conversions included DLI to BMP, MARK IV to COBOL and MARK V to IMS DC/COBOL. All processing was performed on an IBM 3090 computers in the MVS/XA environment using Panvalet interface and UCC scheduling software.

Hire Now