We provide IT Staff Augmentation Services!

Database Management Analyst Resume Profile

3.00/5 (Submit Your Rating)

NY

PROFESSIONAL SUMMARY

25 years experience in software engineering encompassing all SDLC phases surrounding database administration DBA , system analysis and design, software design, implementation, integration, conversion, system/unit testing, support and documentation of web apps, online and batch systems. Environments utilized include IBM CICS, COBOL, DB2, IMS, MQ, REXX, z/OS .

TECHNICAL SKILLS

Languages/Tools: DB2 Sysplex, DB2 Native Stored Procedures, Mainview, IBM Data Studio, BMC Catalog Manager, BMC Change Manager, BMC LogMaster, APPTUNE, CA RC Suites, CA Detector, CA Insight, IBM IDAA Netezza, REXX, TSO/ISPF OS/JCL, TOAD DB2 / Oracle , PL/SQL, Ansi SQL, CICS, Cobol/Cobol II, CMM Level II, Candle's Explain, FILE-AID DB2, CA-1, SPUFI, VIASOFT, XPEDITER, OMEGAMON XE PE, PROEDIT, DFSORT, MS Project, MS Office Word, Excel, PowerPoint , Librarian, SDF II, FTP, IBM Utilities, PANVALET, Control-M, Endeavor, ACF2, Visio, Lotus Notes, JSS Job Scheduling System

Databases: DB2 z/OS v10.1, Oracle 9i

Environments: IBM z/OS, MVS

PROFESSIONAL EXPERIENCE

Confidential

Database Management Analyst

  • Accomplishments include DB2 v10 CM8 skip migration for the HUDCAPS General Ledger
  • Inventoried DB2 subsystem attributes and application level objects for 3 subsystems, 15 Development, 1 Regression and 1 Production environment
  • Ensured Installation, Migration, System Operation, Utility, Command, Backup and Recovery, Security, Rebind, Catalog and Plan Table conversion
  • Constructed/Implemented subsystem and application Pre-Post Migration Protocols and Test Plans
  • Created generic REXX/DB2 routines to generate DB2 Utility JCL for COPY / REORG / RUNSTATS / REBIND / BIND / RECOVER / REPAIR
  • Recommended DB2 Pre-Post v10 NFM upgrade functionality for POC consideration

Confidential

Database Management Analyst

Accomplishments include:

  • Provide DB2 / IMS, Data Replication, DASD, MQ application requirements / support for High Availability Very Large Resilient Systems
  • Performance Tune DB2 z/OS v10 subsystems and SQL queries including but not limited to Predicate Staging, Optimizer estimation, Access Path Strategies, Join Methods using IBM EXPLAIN utility, and IBM Data Studio's Visual Explain
  • Monitor Production subsystem KPI's using CA Detector, BMC Mainview analyzing/investigating variances regarding constraint relief of DB2 trace reports and SMF data
  • Design/Build/Implement Historical CA Detector database to provide trending DB2 package and statement level statistics for Performance analysis and troubleshooting
  • Restructure segmented spaces into Partition By Range objects optimizing SYSPLEX parallelism using DB2 v10 attributes to reduce Heavy OLTP with HA workload CPU costs
  • Install, configure and update IBM Data Replication, Websphere CDC and Data Studio software suites
  • Transport 3 TB's across 3 SYSPLEXES with 10 LPARS at 5K TPS
  • Generate DB2 v10 utility jobs using REXX routines and recursive SQL to produce repeatable processes for Very Large Databases across multiple workloads
  • Create DBA Dashboard SOP monitoring and Application Management reports using
  • REXX and DB2 Catalog data
  • SMS storage group utilization
  • Replication threshold, error and usage
  • Configured IBM IDAA Netezza Proof of Concepts showing 90 reduction of SQL Query Elapsed Time
  • Analyze and Modify DB2 Buffer Pool configurations to optimize DBM1 address space usage
  • Design and Create physical DB2 z/OS v10 objects using CA RC/Query and RC/Migrator
  • Develop and Maintain cost saving solutions surrounding zEC12 CPU consumption, DASD utilization, DBMS utility overruns and contention
  • Provide 24x7 On-Call support engaging infrastructure and enterprise teams where appropriate

Confidential

Accomplishments include:

  • Design and Create physical DB2 z/OS v9 objects and System security
  • Production subsystem monitoring Key Performance Indicators using BMC Mainview
  • Deploy Native Stored Procedures
  • Resolve DB2 z/OS v9 data capacity issues surrounding monitoring and resizing
  • Provided DBMS/DBA Standard Operating Procedures

Confidential

Accomplishments include:

  • Performance Tuning DB2 z/OS v8 reducing high workload CPU utilization
  • Buffer Pool Tuning strategic planning and implementation/monitoring
  • Utility RECOVER, REORG, COPY restructuring to reflect DB2 v8 performance enhancements
  • DBMS performance recommendations surrounding EDM, SORT, RID pools and Locking
  • Application SQL Tuning reducing In DB2 Time
  • Optimize DB2 z/OS objects to reflect v8 standards
  • Design and Create physical DB2 z/OS v8 objects and System security
  • Performance Tune DB2 z/OS v8 SQL queries including but not limited to Predicate Staging, Optimizer estimation, Access Path Strategies, Join Methods using IBM DB2 EXPLAIN utility
  • Production subsystem monitoring Key Performance Indicators using Omegamon DB2PE , analyzing Performance, Accounting and Statistic traces
  • Resolve DB2 z/OS v8 data capacity issues surrounding monitoring and resizing
  • Provided DBMS/DBA Standard Operating Procedures

Confidential

Accomplishments include:

  • Lead the team to successful completion of daily and weekly activities
  • DB2 z/OS v8 data and object migration across SCHEMA/LPARs using Unload/Load/Cross Load/ DDL migration tools with integrity checking
  • Create physical DB2 z/OS v8 objects, Stored Procedures, System security
  • Maintain Data Replication Propagator Capture and Apply servers
  • Plan/Create/Maintain backup and recovery of database information
  • Resolve DB2 z/OS v8 data capacity issues managing parallelism and disk / tape
  • Optimize DB2 z/OS objects to reflect v8 standards

Confidential

Sr. Programmer Analyst

Accomplishments include:

  • Analyze and enhance Extraction, Transformation and Loading ETL of legacy to Oracle Data Warehouse using Stored Procedures
  • Create optimized SQL for both DB2 and Oracle 9i databases
  • Project plan and lead to completion daily, weekly and monthly activities
  • Provided RDBMS vendor technical support information regarding issues
  • Installed, upgraded and patched Oracle software. Setup brand new machines including Oracle software installation, Oracle side configuration, third party software
  • Install GASTAR application and Oracle database client services
  • Oracle Provider for OLE DB 9.2.0.4.8
  • Oracle ODBC Driver 9.2.0.5.4
  • Configuration for Oracle clients
  • Conversion of Choice EDI subsystems to Customer Information Management System supported EDI subsystems.
  • Produce EDI 810 Invoices, 814 Enrollments, 820 Payments, 867 Usage, 824 Advice.
  • Debug CICS/COBOL/DB2/JCL applications running under JSS/ESP Job Scheduling System

We'd love your feedback!