IBM Certified Sr. System Administrator, Database Administrator
AVAILABLE|
Remote Only
|
Recruiters OK
|
US
|
Posted on Dec 06, 2020
Rashid Jiwani
Engineer, MBA (IT/Finance)
IBM Certified AS400 iSeries Sr. System Administrator & Database Administrator
Cell: +1 (678) 480 – 9999
Email: RashidJiwani@gmail.com
Over 20 years’ experience as IBM AS400 iSeries – Sr. System Administrator & Database Administrator
Objective:
To obtain a management position to help develop, support, security, service to the success of the company through utilizing my rich experience and technical skills in the most productive manner
Education:
Master’s in Business Administration, MBA (IT / Finance)
IBM Certification on IBM i Administration and Control
IBM i System Configuration, Installing LIC (Licensed Internal Code), OS (Operating System), Licensed Programs
Creating multiple LPARS (Logical Partitions), Disk Parity Protection, adding disk units to ASP, Product Keys, System Migration
HW used IBM iSeries Power 7/8408-E8D, Power 7/8202-E4D, Power 8/9119-MME
Upgrade OS/400 Operating System. Recently, upgraded OS/400 to V6R1, V7R1, V7R2 on multiple LPARS, Planning on upgrading OS/400 to V7R3
Managed Server and LPARS using HMC (Hardware Management Console) 7042-CR7. Upgrade HMC to V9R1
Maintaining Tape Library 3573 with multiple Magazines, High Density LTO5 Backup Tapes
Installing IBM PTF (Fixes), FTP directly from IBM Fix Central to the iSeries using Image Catalog, SNDPTFORD
Install and maintain Powertech Antivirus Tool on all LPAR’s
Allocating & Optimizing System Resources, DASD, CPU, Shared Pool Memory
IBM DB2 Web Query for I (Power Security Compliance), Generating & comparing reports from all LPAR’s
System Performance Tuning using iDoctor, Job Watcher, Disk Watcher, PEX Performance Analyzer, Plan Cache
System i Performance Navigator for GUI Interface
System Networking, Line Description, Controller Description, TCP/IP, NETSTAT, Printer setup, Spooled files
System Audit, Remote Journaling for Security Audit Trails, Sarbanes Oxley (SOX) Audit, PWC Audit
System Values for the security purpose. Integrated File System (IFS)
System Cleanup and Maintenance, Creating Indexes, Reorganizing Large Files, Archiving Files
Secure FTP / SSL, EDI (Electronic Data Interchange) between various systems, TELNET
Creating Sub-Systems to run jobs, other than QBATCH, QINTER, etc. Using Job Scheduler (same as ROBOT)
Designing iSeries environments like DEV, UAT, PRD, etc. for QA Testing
User Account Management, user-id, password security to sync with the server, grant / revoke special authority, private authority to users. Maintaining job description for proper user access
MQ Series WebSphere, Channels, Queues, Queue Managers, and other encrypted software's for Data Exchange
Maintaining DB2/400 databases, PDM (Programing Development Manager), SDLC (Software Development Life Cycle), Reorganizing Large Databases, SQL/400, Query/400
BRMS System Backup and Restore, Disaster Recovery Planning, Restoring system on a different server
High Availability replicating software’s like Mimix, iTera, etc.
Change Management Software’s, TURNOVER, COOL2E, PTC Implementer, etc.
Use of SST (System Service Tools), DST (Dedicated Service Tools) to identify and diagnose the system issues
Installing, Configuring, Supporting, Upgrading third party applications, running on AS400 iSeries
Data Mining and extraction from different platforms across the network
Worked extensively on various ERP / BPCS Modules (same as JD Edwards, SAP):
Financials – Account Receivables, Account Payables, General Ledger, Financial Retrieval System
Distribution – Inventory, Purchasing, Order Entry, Billing & Sales, Forecasting
Interact with HW/SW vendors, PC connection with AS400 using ACS (Access Client Solutions)
Content Manager OnDemand
Excessive use of Microsoft Office products, Excel, Access, etc.
Provide 24X7 system support, ensure 100% system high availability, and helpdesk coverage
2000 - 2002UPS Capital CorpIBM AS400 iSeries System Administrator & App. Administrator
System Configuration, Installing LIC & OS (Licensed Internal Code, Operating System), Creating multiple LPARS (Logical Partitions), Disk Parity Protection, adding disk units to ASP, Installing Licensed Programs, Product Keys, System Migration
System Administration of AS400 iSeries, Upgrading OS400 from V5R3 to V5R4
Installing IBM PTF’s (Fixes), FTP directly from IBM Fix Central to the iSeries using Image Catalog
Installing, Implementing, Maintaining & support of commercial International Factoring software I-FACTOR, and its upgrade from V4.1 to V5.2. Specialized training from its vendor Hill Price Davison in London, UK
Installing, Implementing, Maintaining & support of ERP software BPCS, and its upgrade from V4.3 to V6.05. Also had specialized ERP training from its vendor
System Tuning, Performance & Optimization, DASD storage, User Profiles and their sign-on menus, User Access commands, Job queues, Out queues, IP Address, Spool files, Re-route spool files to another printers, Job Scheduler, BRMS System Backup & Recovery, System IPL
Connectivity and support with AS400 iSeries offshore remote users from UK, Hong Kong, Taiwan, etc.
DB2 Database Administration, Data Transfer between LPAR’s on iSeries and across network, Secure FTP
Assisting programmers using PDM Tools
Installing, Prototyping, User’s Training on SW applications incl. ERP / BPCS modules:
Financials – Account Receivables, Account Payables, General Ledger, Financial Retrieval System
Distribution – Inventory, Purchasing, Order Entry, Billing & Sales, Forecasting, Multi Currency
1997 - 2000GlaxoSmithKline Pharmaceutical CompanyManager – MIS
User Interface, Prototyping, Installing, Implementation of ERP BPCS products on AS400 at the client’s location
Installing, Prototyping, User’s Training on SW applications incl. ERP / BPCS modules:
Financials – Account Receivables, Account Payables, General Ledger, Financial Retrieval System
Distribution – Inventory, Purchasing, Order Entry, Billing & Sales, Forecasting, Multi Currency
Worked extensively on ERP BPCS Financials and Distribution modules, BPCS Training at client’s location
Managed a team of programmers to amend the source of BPCS module, and tailor to client’s specifications
Change System Values to configure BPCS modules, Create diff. environments in BPCS, like DEV, UAT, PROD
Change User Profiles for BPCS users, granting object and special authorities
Creating Initial Sign-on Menus for BPCS users
My Specialties
IBM AS400 (iSeries) System Administrator, Database Administrator