Hemanth Bv Email & Phone Number

Bengaluru Area, India

• Support application teams in Development, testing, staging and production DB2 environments• Development of Performance monitoring and tuning for DB2 Subsystems• SQL tuning and advice application team for performance enhancement• Involved in performance testing issues and provided solutions.• Working with various DB2 utilities• Provided inputs for developing Database Design & Creation to change requests • Database Monitoring and Maintenance• DB2 security management• Performed backup and recovery for table space and data set under various circumstances• Data Refresh from Production to non-production environments.• DB2 capacity management• Knowledge on catalog tables metadata manipulation.• Monitoring DB2 Health Check Jobs.• Monitored, Altered the status of DB2 Objects using DB2 Commands.• Involved in Migrating DB2 Objects for V11 Compatibility- Converting simple Tables to UTS family- Converting objects from Index controlled to Tables controlled objects- Migrating Packages which are bound under v9- Coordination with business for converting Synonyms to Alias conversion• Setting up Q-replication jobs. • Created reports related to database health check, tables reaching maximum space limits, Tablespace requiring SYSCOPY cleanup, REORGs & Runstats.

Bangalore

• DBD, PSB, ACB, and MFS generation• IMS Data Management utilities • Database design changes in both test and system test environments. • IMS backup and recovery processes• Performance monitoring and tuning processes• Troubleshooting & resolution of IMS batch and online programs issues relating to database performance and functionality with application development teams• Analyzes problems and provide suggestions for application improvements where appropriate• HALDB migration from full function databases.• IMS Database space management • DB health checkup and reports.• Ensuring successful execution of the project as per project plan• Ensuring Quality standards and processes.• Conducted Project status meetings.• Performing Detailed Design, Coding, Unit Test Plan/Results, System Testing documents.• Reviewing components that are to be delivered to the client.• Providing functional and technical knowledge to team members.• Interacting with the client and the onsite coordinator for issues and queries in project. • DB2 Objects creation & support in development environment• Analyzing and fixing DB2 related jobs• Working experience with various DB2 utilities• Performing Requirement Understanding, Impact Analysis, Detail Level Estimates, Detailed Design, Coding, Unit Test Plan and Unit Test Results documents.• Handling tickets and creating Business Requirement Document in some cases.• Providing functional knowledge to team members.• Reviewing components that are to be delivered to the client.• Interacting with the client and the onsite coordinator for issues and queries in the project. • Performing Quality assurance audit for other teams in the project.

• Understanding requirement and writing design, coding and testing for various work requests.• Analyzing DCRs and solving them as per request.• Handling production job abends when it happens.

• Analyzing the specifications.• Development of online screens. • Coding CICS – COBOL – DB2 embedded programs.• Testing.