We provide IT Staff Augmentation Services!

Technical Consultant Resume

5.00/5 (Submit Your Rating)

Troy, MI

SUMMARY

  • Over 10 Years of experience as DB2 & IMS database administrator on z/OS platform and application performance tuning analyst.
  • Strong in RDBMS concepts, Logical and Physical database design.
  • Sound knowledge on stored procedure development, SQL Query development and its tuning.
  • Sound knowledge on Application Tuning - thru Monitoring, Setting Trace and using 3rd party tools such as Apptune and IBM data studio.
  • Expertise in using BMC and CA tools and utilities
  • Knowledge on configuring and maintenance of large data sharing IMS and DB2 systems.
  • Has good experience in handling business critical issues on 24/7 basis as Primary DBA.
  • Developed mission critical backup, recovery and disaster recovery strategies for smooth operation.
  • Expertise in setting up the IDAA to accelate the query and imprive the performance.
  • Expertise in setting up and maintenance of replication using QREP and DPROP.
  • Extensively used DB2 Connect, Type 4 JDBC driver, IBM Data studio
  • Developed mission critical backup, recovery and disaster recovery strategies for smooth operation
  • Has good knowledge on various utilities such as REORG, RUNSTATS, LOAD, UNLOAD, COPY, RECOVER etc for DB2 and similar utilities in IMS
  • Has extensive knowledge and experience in using various third party tools from IBM, BMC, CA, and NEON in addition to the native tools for DB2 and IMS database utilities.
  • Strong understanding of the z-Series architecture, z/OS components such as SDSF and other job schedulers, and the security RACF/ACF2 features.
  • Has developed various in house automated tools for space monitoring and reporting, automatic RC look up for abended jobs etc.
  • Has strong experience in REXX, CLIST and ISPF programming.
  • Has strong knowledge on Configuring and maintenance of large data sharing SYSPLEXes
  • Strong in database design and regular maintenance activities such as Reorg, performance monitoring, online changes etc. for DB2 and IMS databases
  • Has good knowledge in setting up the Batch jobs, writing JCLs etc for Database as well as general purpose activities
  • Has good knowledge of ACBGEN, PCBGEN, DBDGEN and SYSGEN for IMS system
  • Has strong analytic, problem solving and good documentation skills wif a fast learning curve
  • Has knowledge on preparing Root Cause Analysis for the business critical issues and involved in process improvement wif good documentation skills
  • Has good knowledge on the business process and SLA adherence

TECHNICAL SKILLS

Languages: COBOL, JCL, JAVA

Operating Systems: Zos and Windows

Databases: DB2 for Zos and LUW. MongoDB

Applications: Insurance, Credit cards and Share market Brokerage

Middleware: XML, Java Virtual Machines and Database systems.

Methodologies: Agile and Waterfall

Other: REXX, CICS and EAZYTRIVE

PROFESSIONAL EXPERIENCE

Technical Consultant

Confidential, Troy, MI

Responsibilities:

  • Maintained various business critical database Servers for a Fortune 500 Insurance client (based in Central Illinois).
  • 35 Individual Production LPARs, 3 Complex System Production Haplexes each Haplex having 4 data sharing members. (Has multiple Development, Test, Issuance Testing, Pre-Prod regions - over 200 LPARS)
  • Designed, Implemented and supported various transactional, ODS, warehouse and analytic databases in DB2. (DB2 v9, v10 and V11)
  • Involved in Upgrades and enhancements of the DB2 from V9 till V11.
  • Involved in data design activities using ER Studio
  • Involved in SQL review, SQL tuning and development of SQL queries, SQL PL stored procedures
  • Involved in setting up and maintenance of QREP and DPROP for replication across 1 regions
  • Involved in implementing IDAA for analytic projects
  • DB2 Database and application performance tuning using BMC Apptune for SQL Reviews.
  • Day-to-Day maintenance work using BMC and IBM DB2 utilities, BMC Mainview for DB2, Insync (File-Aid) tools, BMC Catalog Manager, BMC Change Manager, BMC Log Analyzer, BMC DASD manager
  • Involved in daily Database maintenance activities, and designing disaster recovery strategies
  • On a tuning effort, I has introduced TEMPORAL tables (Bi Temporal and Business temporal tables) for Claims Audit project and Payment plan project and Saved Thousands of $ for the client.
  • Saved millions of $ for the client thru Tuning effort and automation process.
  • Developed a process dat generate unused objects report across various regions and send the details to corresponding team.
  • Developed REXX routine dat incorporates the TEMPORAL syntax for the ER-studio extracted DDL
  • Implemented automatic switch over to IBM XML Unloads and Loads during destructive changes on the table (BMC utilities fail in few scenarios)
  • Extensive knowledge of using BMC DML for mass schema changes (CM/pilot scripting). proactively worked to convert over 1000 segmented tablespaces to UTS PBG (Universal Tablespace)
  • Proactively worked to convert classic index and table controlled partitioned tables to UTS PBR
  • Improved the Data Refresh and update process using BMC High Speed Apply

IT Specialist - Database analyst III

Confidential

Responsibilities:

  • Maintained various business critical database Servers for a Fortune 500 companies ( Fidelity)
  • Designed, Implemented and supported various DB2, IMS databases wif CA-Endevor and DSIMS for change management. (DB2 v8,v9, IMS DB/DC v9,v10)
  • Involved in Upgrades and enhancements of the DB2 and IMS
  • DB2 Database and application performance tuning using CA Insight and BMC tools
  • Used Neon and IBM IMS utilities, CA and IBM DB2 utilities, BMC Mainview for IMS, Control - D, CA Endevor, DSIMS Data Dictionary, Insync (File-Aid) tools
  • Involved in daily Database maintenance activities, and designing disaster recovery strategies
  • Performance tuning for business-critical PPO application for DB2 DYNAMIC SQL using CA INSIGHT
  • Restructured the process for LOAD jobs for the very large DB2 databases
  • DASD Monitoring - dis project is designed to monitor High Extents, Dataset Maximum Allocation (in terms of %), SMS Storage Group Capacity (in terms of %) and Excessive Object Growth Rate (in terms of %) and get the automated threshold violation notification messages thru Email. dis project enables DBAs be able to do DB2 DASD usage trending and forecast.
  • Restricted Objects and Abended Utilities - dis project is designed to monitor the abended utilities and Restricted objects in any particular Db2 systems and get the automated notification thru Email.

Senior Database Analyst

Confidential

Responsibilities:

  • Maintained various business critical database Servers for a Fortune 500 WALL Street Company ( Confidential )
  • Designed, Implemented and supported various DB2 databases wif BMC - Catalog manager, Change manager, CA-Endevor and ASG Data Dictionary for change management. (DB2 V8,V9, IMS DB/DC v8.1, CICS, COBOL,JCL,CICS)
  • Involved in Upgrades and enhancements of the DB2 versions and Vendor tools like BMC tools.
  • Used CA and IBM IMS utilities, CA and IBM DB2 utilities, Omegamon tool (DB2, IMS, CICS) for performance monitoring, and RACF for security features
  • Involved in daily Database maintenance activities, and designing disaster recovery strategies
  • Involved in Project Management Documentation as Offshore Lead from Jan 2008
  • Has acquired knowledge on Six-Sigma implementation
  • Production Database Space Estimation Report: dis Space estimation report is generated for production database objects for both Partitioned and Non-Partitioned Tablespaces and Indexspaces. If the allocated space is exceeded more TEMPthan 75% of the total dataset size/piecesize, tan ALARM flag would be set as "Y".
  • Recurring REORG objects for past 8 weeks Report - The report is used to find objects been reorged more TEMPthan once in the past 8 weeks. Some of the objects would be reorged by different authids for analysis and the same can be ignored. Other objects needs to be reviewed.

We'd love your feedback!