|
|
Title: |
Database Administrator
|
Location: |
US-Maryland-Baltimore
|
Work History: |
Education
Masters Degree Computer Science University of London
Bachelors Degree Computer Science University of London
Objective: To explore opportunities in applying extensive experience and expertise to Project Management, hands on Trouble Shooting and Performance Optimization skill sets to medium and large scale Systems in challenging environments, very beneficial to each Client. A committed professional who is highly organized and adjusts to all types of different Client situations. Learning new procedures quickly and applying a deft touch to all scenarios, always in keeping with the current state of the art expertise and forward tuned Enterprise Vision. The application of this expertise resulting in considerable gains in Time, expenditure per Project, and Return on Investment for the Client.
VISA Status:- US Citizen
Clearances:- Secret, BI Level 6
Databases:- DB2 V9, DB2 UDB V8.2, ORACLE V9i, ACCESS, IMS,
DATACOM-B, TERADATA.
Operating:- z/OS, UNIX, AIX, WNDOWS, MVS, LINUX, HP-UX, SUN
Systems
Languages:- ALC, C, C++, COBOL, JAVA, JCL, KORN SHELL, SQL, VB.
ROLES:- Database Administrator, Performance Tuner, Systems Architect,
Project Manager, Systems Engineer, DB2 Systems Programmer.
Applications:-
DB2 Systems Programming and DB2 Utilities.
DB2 Performance Tuning Strategies
DASD Space Management Capacity Planning .
NDM (Network Data Mover)
TERADATA, ORACLE DDMS_STATS
ORACLE Vs DB2 Bench Mark Tests.
DB2 Project Plans and Installs. SMP/E.
SQL, and KORN Shell Scripts. QMF
DB2 Install V6.1, V7.2 and 8.2. Fix Pack Upgrades
Database Design, DB2 Data Warehouse Builder. Health Care Data Warehousing.
Create, refresh, maintain and upgrade DB2 UDB instances and databases
in test, development, and production environments.
EEE (ESE) Installation and Performance Tuning. DPF (Database Partitioning Feature)
Translate Enterprise Vision into reality. Lead implementation team. UAT.
24 x 7 Production Support UDB. Implement Backup and Recovery procedures,
Database Configuration Management. Parallel SYSPLEX and Data sharing
Data Profiling. Conceptual, Logical and Physical Data Modeling
Erwin DDL Creation and Simulation. Erwin 7.1 Forward and Reverse Engineering
ETL, DW KIMBAL
Engineering - WLM (Work Load Manager).
VISIO
Brio and COGNOS Reporting.
Database Expertise
BMC MAINVIEW, Catalog Manager
DB2 Performance Configuration
DB2Batch, DB2advis, DB2explain, DB2look, DB2 High Speed Loader
DB2Dart, DB2 High Speed Unload
BMC UTILITIES. BMC Change Manager, Catalog Manager.
Platinum Tools
EMBARCADERO, QUEST Central, PVCS, AXCIO, DATASTAGE
ORACLE 9i vs DB2 UDB (White Paper) Benchmark Tests
Performance Tuning Mid-Tier and Mainframe Systems.
Enterprise Data Architect Data Warehouse to 30 TB.
Develop Overall Enterprise Strategies. Identify root cause of problems. Access Risk. ERP (Enterprise Resource Planning) to access costs, risks and changes involved in Conversions, Migrations and Hardware / Software upgrades.
Developed short and long term Tactical plans and implemented these plans
Provide technical training and mentoring for DB2 Administrators and Developers.
Advise Management on cost saving strategies and tactics. Project Management.
Conversions:- VSAM to IMS. IMS to DB2. ADABAS to DB2, ALC to COBOL IMSPARS Performance Analysis Reporting. Web Sphere Classic Federation, WAS (Web Application Server) with Q Replication.
Migrations:- DB2 to SYSPLEX. DB2 V2 to V5.2 to V6.1 to V7.1, to V8.2
Disaster Recovery, Triggers, Stored Procedures. Command & Control Centers.
Extensive Data Modeling using Erwin V4.1, Erwin V7.1, RDA
Designed, built and implemented databases and data warehouses for large complex financial systems, asset management systems and reporting systems.
Project Lead IMS Y2K conversion. DB2 Y2K conversion. CLI, LDAP
Establish Web Sphere (WAS) and Web logic interfaces. Build Data Marts and Warehouses. Evaluate risks, benefits and impacts to large Projects.
Installed and Configured UDB EE and EEE on WINDOWS, UNIX (Mid Tier) and zOS (Mainframe) for construction of trucks by Robots.
DATACOMB to DB2 Conversions. Claims Processing. Carrier Adjudication
Performance Tune numerous DB2 and DB2 UDB Systems form V2 to V8.2.
Production Support 24 x 7 for DB2 UDB under AIX.
Test MQ Series (WMQ). UNIX, AIX, HP-UX, LINUX.
FACT Tables and Star Schema.
XPEDITER, RACF, TSO, JCL, ENDEVOR, SPUFI
AUTHOR :- Multi-Platform Database Consulting ISBN :- 1418468797
Clients
Center for Medicare and Medicaid Services
VIPS (Viable Information Processing Sys)
Department of Human Resources
Penn DOT
Circuit City
Plymouth Rock
TSA (Classified)
Most Recent:- CMS (Centers for Medicare and Medicaid Services) Central DBA.
Shared responsibility for all the CMS/CME IBM Databases running under z/OS and DB2. Participated in ensuring the smooth running of all Production, Development and Test databases; full and incremental backups, REORGS and RUNSTATS. Trouble shoot DB2 database problems in various environments. Keep a close eye on DASD availability and Consumption. Be On Call as per a Rota System. Produce Explain diagrams and reports for all access paths. Use BMC Tools to achieve these goals. DB2 Version 9 Support. Use BMC Work Lists and Base Lines for object change and migration.
DASD Manager, Copy Image Copy, Clone Tables, SMP/E, Utilities, Recover Manager. ENDEVOR, DB2 9 and V8, Catalog Manager, Change Manager, SPUFI, XBM, CDL, XIM, ENUMROWS, OPERTUNE, MAINVIEW.
VIPS (Viable Information Processing Systems) DBA / Systems Engineer.
Heavily involved with the DDPS (Data Drugs Prescription System) of CMS (Medicare).
Participated in Mainframe (z/OS) and Mid-Tier (UNIX) Systems.
Unloading large DB2 and ORACLE Tables to flat file using BMC and PL*SQL.
NDM large Mainframe flat files to Landing Areas in UNIX.
Load large flat files in the UNIX/AIX Landing Areas to TERADATA Data Warehouse tables.
Numerous Mainframe and UNIX /AIX tasks.
Responsible for Month End Reports Schedule.
Create numerous JCL job types for running jobs in Development and Production.
Build and monitor the Teradata Data Warehouses.
Use Informatica ETL (Extract Transform and Load tools) to move source data to Staging Databases.
FURTHER DETAILS SUPPLIED ON REQUEST
|
Skills: |
DB2 DBA, DB2 UDB DBA, Project Manager, Systems
Engineer, Performance Tuner
AIX, UNIX, zOS, Windows
DB2, ORACLE, EXCELL, ACCESS, DATACOMB
ALC, C, C++, COBOL, JCL, SQL
|
Education: |
Masters Degree - Computer Science - University of London
Bachelors Degree - Computer Science - University of London.
|
Endorsements
|
 |
John has received 0 endorsements.
|
John has endorsed 0 Members.
|
| |
Rank |
Title |
Location |
Status |
Actions |
|
Public Messages
|
|
| From |
Date |
Message |
No public messages. |
|
|
