We provide IT Staff Augmentation Services!

Infra Technology Specialist Resume

Teaneck, NJ

SUMMARY:

Working as a Mainframe DB2 Engineering and Application DBA for around 9+ years.Expertise in DBA activities which includes Database design, Database migrations, Optimizing SQL queries, Monitoring entire subsystems, Production support, Providing recommendations to app teams and Database Maintenance activities.

TECHNICAL SKILLS:

Hardware: IBM Mainframe

Operating System: Z/OS

Databases: IBM DB2, IMS DB

Tools: TSO, ISPF, SDSF, Flasher, JCL, Erwin Data Modeler, BMC Catalog Manager, BMC Change Manager, BMC Recover Manager, IBM DB2 Admin tool, CA - RC Query, CA - RC Migrator, CA - Database/Plan Analyzer, IBM Optim Data Management, SPUFI, QMF, CA7, BMC Main view, IBM Data Studio, IBM Omegamon, SAR, EOS, RMDS, Endevor, HPSM, BMC Remedy.

PROFESSIONAL EXPERIENCE:

Confidential, Teaneck, NJ

Infra Technology Specialist

Responsibilities:

  • Designed, developed and maintained data models using data modeling tools
  • Designed, created, and maintained DB2 database objects
  • Granted and controlled access to DB2 database objects
  • Altered, renamed and dropped DB2 database objects
  • Created plans and packages; Granted bind and execute authorities to plans and packages
  • Bound and Rebound plans and packages
  • Freed plans and packages
  • Loaded and refreshed non-production databases for application testing
  • Scheduled maintenance utilities(image copy, reorg and modify recovery) for newly created Production database objects
  • Performed reset of pending status like chkp, copy, reorp, rbdp, recp by running appropriate utilities against the affected database objects
  • Performed quiesce and runstats on database objects
  • Reorganized table space and rebuilt Indexes to improve space organization and performance
  • Ran stand-alone utilities dsn1comp, dsn1copy and dsn1print
  • Performed various DB2 commands locks, claimers and use
  • Provided 24/7 on call support for production databases on a rotation basis
  • Assisted developers in database and application tuning for optimal performance
  • Reclaimed Space by cleaning up unused database objects
  • Involved in projects like simple to uts conversion and vcat to stogroup conversion
  • Performed SMP/E for installations, migrations and maintenance of software products
  • Installed, migrated and upgraded DB2 systems, CA tools, optim and other software products
  • Applied Maintenance on DB2 systems, CA tools, optim and other software products
  • Participated in monitoring and tuning of system software components
  • Analyzed, debugged and resolved system software issues
  • Provided technical assistance for resolution of production incidents
  • Conducted detailed research of new technologies and process enhancements.
  • Ran accounting, auditing and statistics Omegamon PE reports

Hire Now