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.