Sign in

Design Assistant

Burnaby, BC, Canada
September 13, 2018

Contact this candidate


Nahid Gorji



Systems Analyst /DBA with more than 20 years of progressive experience in Application and Database Design, Development, and maintenance


Databases & File systems : DB2 UDB,VSAM, DB2 utilities & Commands, IMS/DB

Operating systems : MVS, WINDOWs, Z/OS

Operating environments : MVS / TSO,ISPF, MVS/JCL and Procedures, RACF

Programming Languages : PL/I, COBOL,Assembler, Embedded SQL, DB2 stored procedures &

triggers, CICS command-level programming, MQ Series


Database Connectivity Tools : DRDA, ODBC,JDBC

Productivity Tools : MS WORDS, Endevor, FileAid, CICS Debugging tools

Networks & Protocols : TCP/IP, SNA

Monitoring systems : Tivoli Omegamon for DB2, CICS TS, CICS TG, ZOS


ISC Co. (banking sector) 2008 – Feb. 2017

Application Support/Developer

Participated in analysis, Coding, Implementation of the new requirements.

Participated in analysis and development of enhancement requests.

Finalized Documentation of applications and led a team for creating user’s guides

Improved clients Legacy systems performance developed with COBOL/CICS/DB2/IMS

Helped Database group with the design, implementation and testing the required tables.

Defined CICS resources using RDO

Debugged Application with CICS EDF

Developed DB2 stored procedures

Improved SQL statement performance for applications accessing DB2

Created DB2 triggers

Ran several courses on DB2, CICS and COBOL

Installed Omegamon for DB2 and CICS to Monitor DB2 & CICS

Installed IBM DataStdio to create & deploy DB2 Stored Procedures

Used IBM datastudio explain to improve the performance of SQL statelements

Embedded in applications

Mellat Bank IT Corporation 2004 - 2007

Application DBA

- Developed a COBOL /embedded SQL system for Replicating Operational

Database to another instance of DB2 used for back office reports.

- Developed DB2 Stored Procedures for Java clients accessing DB2 databases

- Participated in design and implementation of a database for a banking payment Switch

- Developed An archiving system utilizing COBOL/DB2

Telus Enterprise Solutions (Canada, Vancouver) Jan 2000 - Aug 2002

Senior DB2 DBA

- Maintained DB2 databases under VM and MVS for TES’ clients

- Developed new MVS PROCs for DB2 utility jobs and minimized operator interventions

- Helped TES’ clients with database designs and physical storage estimations

- Attended major releases for Telus-BC applications and managed database changes

- Attended DBA forums and meetings with TES’ Clients

- Improved the performance of SQL statement

- Participated in annual DRP test

Data Processing Iran Company Oct 1985 – Aug 1999

(Ex. IBM Branch )

DB2 DBA 1994-1999

Systems Support Department

- Attended Courses for DB2 Administrations

- Participated in design and development of new Databases for DPI & DPI customers

- Performed regular DBA jobs for DB2 Databases (Backup, restore, Reorg

Information Systems Department :

Senior Designer & Programmer : 1991-1994

Designer and Programmer : 1990-1991

First Assistant Designer and Programmer 1985-1990

- Performed Function / Data analysis and developed SRSs for programmers

- Led 5 developers for 3 year to implement the "Integrated Customer Services"

system for PC section of DPI Company, in COBOL/DB2/CICS,

composed of several sub-systems (Maintenance,Contracts, Sales, Billings…)

- Attended DB2 application programming courses

- Participated in Design and Implementation of the listed Batch systems To Online

System deploying COBOL/CICS/ VSAM :

- OEI ( Online Equipment Information ) system

- Spare parts Inventory

- Customer Information System

- Supply System

- Finalized Documentation of applications and led a team for creating user’s guides

- Managed a group of users to test applications before final delivery

Software Trainee : (6 month): 1985

- As the preparation stage, attended several courses held by DPI education center

Educations :

- Bachelor in Computer Sciences and Engineering, Engineering Faculty

International Shiraz (ex. Pahlavi) University, Shiraz-Iran.

- Master studies : Operational Research, Isfahan Institute of Technology (incomplete)

- Further Trainings : Several professional courses in DPI and IBM Education centers

Such as :


- DB2 for Z/OS



- COBOL, Assembler, PL/1

Contact this candidate