• Vilas K
  • IT Consultant
  • Last/current workplace: Telstra Account
  • 68 years old from South Melbourne, VIC

Introduction

I have worked in IT industry for 35 years. I have experience in all facets of SDLC - Software Development Lifecycle. My soecialisation is in Large Database Systems.

Employment History

  • logo

    Telstra Account

    • Aug 1993 - Jul 2006
    Job schedulers (Cntl-M, CA-7, OPC), CICS, CoolGen, Netview, Omegamon, Platinum Database Tool set, Incident/Change/Problem Management Systems (ISM, Remedy, USD, SM9) 08//2006 Telstra Account (IBM GSA Australia), Australia DB2 and ORACLE DBA DBA Prod/Development/Security Support for Mobile'phone activation and billing system (MICA) Lead Release DBA Application Release Support Help Desk and Oncall Production Support
  • Ansett Airlines

    • Aug 1987 - Aug 1993
    Melbourne, Australia IMS Data Base Adminstrator and Dev. Support DB2/IMS DATABASE ADMINISTRATOR • IMS/ESA 3.1 implementation planning, execution, testing and new features exploitation • Application Development support , Detail design, implementation and debugging support and Help Desk functions for DB2 and IMS • IMS Production support including Onsite and Offsite coverage • Monitoring and Tuning of Production and Acceptance IMS Databases • Database Reorg, Backup, Recovery, Backouts,Change Accumulation, Database Tools, RECON cleanup & reorg. • Migration of Databases, Programs, PSBs, MFSs, DB2 Plans to production and Acceptance environments with fallback • Creation, Maintenance and Migration of DB2 objects between various environments using RC/MIGRATOR • IMS/DB2 interface implementation and support • Reorganizing DB2 Table and Index Spaces and use of other DB2 Utilities • Table Design using referential constraints, Application Development support and Help Desk functions • Developed QMF based system for IMS Transaction Analysis using QMF Queries, Forms and Procs for the user inquiry • Development and Maintenance of DBA Standards • Online Systems Performance Monitoring, Bufferpool Monitoring and Tuning • Database calls, Help in Tuning Programs and Production Jobs • Database Space, Growth trend,performance monitoring and Tuning • DBD, PSB, ACB Gens, Transaction, Lterm security and some general purpose programs implementation • DASD optimal utilisation and Dataset distribution to minimise I/O contention • Investigate/Resolve System Problems using tools such as IBM-Link and Liasion with IBM-ISC • Product installation and support of the following products: • DataVantage • File-aid/IMS • MSA/GL • MSA/AP
  • Ansett Australia

    • Aug 1987 - Aug 1993
    Ansett Airline Commercial Systems Project Description: Ansett Airline Commercial Systems IMS DBA Mainframe(z/OS) , IMS/DB2 Full-Function Database Administrator Responsible for IMS DBA Production, Development and Related Technical Support. Responsibility includes BAU, Development, Migration DBA Support, • Database Reorg, Backup, Recovery, Backouts,Change Accumulation, Database Tools, RECON cleanup & reorg. • Migration of Databases, Programs, PSBs, MFSs, DB2 Plans to production and Acceptance environments with fallback • IMS/DB2 interface implementation and support • IMS/ESA 3.1 implementation planning, execution, testing and new features exploitation • Application Development support , Detail design, implementation and debugging support and Help Desk functions for DB2 and IMS • IMS Production support including Onsite and Offsite coverage • Monitoring and Tuning of Production and Acceptance IMS Databases • Database Reorg, Backup, Recovery, Backouts,Change Accumulation, Database Tools, RECON cleanup & reorg. • Creation, Maintenance and Migration of DB2 objects between various environments using RC/MIGRATOR • IMS/DB2 interface implementation and support • Reorganizing DB2 Table and Index Spaces and use of other DB2 Utilities • Table Design using referential constraints, Application Development support and Help Desk functions • Developed QMF based system for IMS Transaction Analysis using QMF Queries, Forms and Procs for the user inquiry • Development and Maintenance of DBA Standards • Online Systems Performance Monitoring, Bufferpool Monitoring and Tuning • Database calls, Help in Tuning Programs and Production Jobs • Database Space, Growth trend,performance monitoring and Tuning • DBD, PSB, ACB Gens, Transaction, Lterm security and some general purpose programs implementation • DASD optimal utilisation and Dataset distribution to minimise I/O contention • Investigate/Resolve System Problems using tools such as IBM-Link and Liasion with IBM-ISC • Product installation and support of the following products: • DataVantage • File-aid/IMS • MSA/GL • MSA/AP
  • logo

    IBM Internal (IGA), Westpac Bank, CUSTOMS, MLC, VICPOL, Telstra

    • Sep 1985 - May 2016
    Project Description: - IBM Australia, Australia DB2 Mainframe(z/OS) and LUW DBA Responsible for DB2 DBA UDB Production, Development Support and SQL Tuning. Responsibility includes new Account set-up, 24x7 oncall Support and Change, Problem and Service Request management. Lead resource assigned to BAU and project Support to: IBM Internal, NAB-MLC509 Client Accounts and -BI (Business Intelligence) - Transition of IBIS from DB2 LUW to DB2 Z/OS platform -TKLM (IBM Tivoli Key Lifecycle Manager for z/OS) Implemented DB2 component including data refresh to a backup site.
  • DCC & DCI

    • Aug 1985 - Jul 1987
    • Data Dase design, implementation, monitoring , support and maintenance. • IMS Data Dictionary installation usage, security • IMS Backup and Recovery and IMS DB/DC performance and Tuning • IMS/DC SYSGEN Support and Security Gen support • Online programming, MFS Format design, implementation, ongoing support and Log analysis
  • SWIFT International Banking

    • Mar 1983 - May 1985
  • Tata Unisys

    • May 1981 - Mar 1983
    (Tata Unisys) Ltd - for UNISYS (Burroughs USA) software and sales Assignment History 09//2016 IBM Internal (IGA), Westpac Bank, CUSTOMS, MLC, VICPOL, Telstra DB2 z/OS DBA and Technical Support Project Description: - IBM Australia, Australia DB2 Mainframe(z/OS) and LUW DBA Responsible for DB2 DBA UDB Production, Development Support and SQL Tuning. Responsibility includes new Account set-up, 24x7 oncall Support and Change, Problem and Service Request management. Lead resource assigned to BAU and project Support to: IBM Internal, NAB-MLC509 Client Accounts and -BI (Business Intelligence) - Transition of IBIS from DB2 LUW to DB2 Z/OS platform -TKLM (IBM Tivoli Key Lifecycle Manager for z/OS) Implemented DB2 component including data refresh to a backup site.

Skills

  • Information Technology (IT) Skills

Certificates

  • Bachelor of Information Technology (IT)
  • Certificate II in Information Technology (IT)
  • Certificate in Information Technology (IT)

Education History

  • Osmania University

    • Ended Jan 1976
    BACHELOR OF ENGINEERING IN Electronics in Electronics and Communications Osmania University, Hyderabad, India, 1976 Thesis Title: Basic Arithmetic Unit, 1976 Professional experience