We provide IT Staff Augmentation Services!

Title Senior Db2 Database Administrator Resume

TECHNICAL SKILLS:

Software DB2 Administration tool: IBM Cloning, FDR, DSS, File - aid, File-aid for DB2, AQT, Omegamon, DB2 Query Monitor, DB2 Automation Tool, BMC Mainview, TSO, ISPF, Pro Edit, QMF, Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Monarch, Winfax, Reflections, NDM, SAP

Operating System: z/OS, OS390/MVS, DOS/VSE, NT, Windows 7, Unix, Linux

Languages: MicroFocus COBOL, COBOL, SQL/DB2, Easytrieve Plus, CICS Command Level, JCL, Active Server Pages, VB scripting, PL/SQL, Oracle Applications

Databases: DB2 V11, Oracle, MS Access

PROFESSIONAL EXPERIENCE:

Confidential, Jackson, Mississippi

Title Senior DB2 Database Administrator

  • SMPE install DB2 and related software. DB2 V11
  • Apply PTF fixes as needed.
  • Responsible for administering 5 DB2 subsystem including backup recovery and create new subsystems.
  • Ensure integrity, availability and performance of DB2 database systems by providing technical support and maintenance.
  • Administer People Soft on DB2 z/OS.
  • Implemented DB2 subsystem object level cloning software.
  • Monitor database performance and recommend improvements for operational efficiency.
  • Assist in capacity planning, space management and data maintenance activities for database system.
  • Perform database enhancement and modification as per the requirements.
  • Perform database recovery and backup tasks on daily and weekly basis.
  • Identify and recommend database techniques to support business needs.
  • Assist in implementation of new features and program fixes in databases.
  • Maintain database security and disaster recovery procedures.
  • Perform troubleshooting and maintenance of multiple databases.
  • Resolve any database issues in accurate and timely fashion.
  • Monitor databases regularly to check for any errors such as existing locks and failed updates.

Confidential, Jackson, Mississippi

Title Senior DB2 Database Administrator

  • SMPE install DB2 and related software. DB2 V11
  • Apply PTF fixes as needed.
  • Responsible for administering 15 DB2 subsystem including backup recovery and create new subsystems.
  • Ensure integrity, availability and performance of DB2 database systems by providing technical support and maintenance.
  • Implemented DB2 subsystem volume level cloning software.
  • Implemented DB2 subsystem object level cloning software.
  • Monitor database performance and recommend improvements for operational efficiency.
  • Assist in capacity planning, space management and data maintenance activities for database system.
  • Perform database enhancement and modification as per the requirements.
  • Perform database recovery and backup tasks on daily and weekly basis.
  • Identify and recommend database techniques to support business needs.
  • Assist in implementation of new features and program fixes in databases.
  • Maintain database security and disaster recovery procedures.
  • Perform troubleshooting and maintenance of multiple databases.
  • Resolve any database issues in accurate and timely fashion.
  • Monitor databases regularly to check for any errors such as existing locks and failed updates.

Confidential, Location Jackson, Mississippi

Title Senior Programmer/Analyst

  • Analyzed existing lab result processing for the conversion to the Ingenium (SOLCORP) Cobol/DB2 based software. Rewrote programs for DB2 processing. Determined specific data requirements for parallel processing.
  • Handled interface programming defects by using a Java/HTML based programming language.
  • Setup and system tested job streams for completed lab result and reporting jobs.
  • Lead on-call for system testing new business batch systems.
  • Developed and maintained CICS programs.

Confidential - Chattanooga, TN

Title Programmer/Analyst (Contractor)

  • Planned, analyzed and wrote Cobol program specifications for a major accounts reporting system. Specifications are interpreted from existing MS Access, SAS, SAP, and FoxPro PC based programs along with Cobol and Easytrieve mainframe programs.
  • Analyzed data by Ad-hoc programming using SQL/DB2, Easytrieve Plus, and MS Access.
  • Setup and system tested job streams for completed report sections.
  • Designed and wrote a system which pulls data from a FoxPro database, reformats data in to a DB2 format, FTP s data to the mainframe, verifies data on the mainframe and loads to a DB2 table. System utilized VB scripting, FoxPro, FTP, Cobol, DB2 load utility, JCL, and scheduling software.
  • Wrote MS Access Proto type programs for proof of concept.

Confidential

Title Programmer/Analyst

  • Planned, analyzed, designed, coded and implemented a conversion from mainframe financials to Oracle financials, using extensive data analysis in interpreting data integrity, wrote Cobol conversion programs, parallel system testing, and scheduling jobs. Primary financial sections included general ledger, inventory, and aggregates. Worked with team members to resolve design issues.
  • Ad-hoc reporting using MS Access, MS Excel, Oracle, Monarch, and Easytrieve Plus.
  • Maintained legacy financial systems during Oracle conversion using Cobol, CICS, Easytrieve, and VSAM.
  • Designed a Company Web portal, utilizing ASP, VB scripting, and HTML.
  • Wrote and designed Oracle applications using PL/SQL.
  • Modified CICS applications for data integrity. Edits were incorporated into programs for company name and addresses where previously none had existed.
  • Removed CICS financial applications from the CICS system after Oracle project was complete. Utilized design, analytical and programming skills to solve conflicts between CICS financials and other CICS applications.
  • Responsible for finding a aggregate billing error which allowed the company to recover over 100k in lost revenue and increased revenue by over 25k per month.
  • Production support on call 24/7.

Confidential, Birmingham, AL

Title Contract Programmer

  • Gathered data, analyzed and designed Cobol programs for pulling history data for a major long distance company. Created JCL job streams, scheduled jobs for running and supervised three other programmers during project. Completed project on time with little development or deployment delays.
  • Modified Cobol programs for the carrier access billing system (CABS).
  • Used IMS, DB2 databases and VSAM files.

Confidential - Chattanooga, TN

Title Contract Programmer

  • Developed reporting system for Tennessee Valley Authority’s membership including currently active and historical numbers. Reports were broken down by location, membership type, age, and activity. Utilized Cobol, DB2, Easytrieve and JCL.
  • Maintained membership and billing mainframe system, utilizing Cobol, CICS, DB2, Easytrieve and JCL.
  • Ad-hoc reporting using Cobol and Easytrieve.
  • Wrote Cobol programs from specifications for a company buy out of Blue Cross and Blue Shield of Memphis.
  • Rotating production on call.

Confidential, Jackson

Title Programmer I/Technical Specialist II

  • Worked on the Work First Tax credit system. Gathered data from subject matter experts, wrote CICS applications and batch Cobol programs for the system. Modified applications after implimentation.
  • Ad-hoc reporting for internal and external customers.
  • Production on call 24/7.
  • Converted Easytrieve programs to Easytrieve Plus.
  • Responsible for daily file updates and maintaining of approximately fifty kiosks units, utilizing mainframe batch processing, PC skills, and help desk skills.
  • Completed federal program updates on a regular schedule or as needed.

Hire Now