Database Analyst

Description

Computer Skills Hardware platforms IBM Mainframe, PCs Program Language COBOL, REXX, MVS CLIST Operating Systems MVS, OS/390, z/OS, Microsoft Windows System Utilities ISPF Dialog Management, z/OS, Microsoft Office, RACF Database Systems DB2 z/OS Database Utilities IBM DB2 Utility Suite, Omegamon for DB2, DB/Explain for DB2, DB2 Performance Monitor, DB2 Connect EmbarcaderE/R StudiData Modeling Tool, DBArtisan DB2 Query Tool Computer Associates DB2 Utilities (Log Analyzer, Detector), EZtrieve for DB2 Compuware File Aid for DB2 CDB Software DB2 Utility Suite ASG TMON for DB2 DB2 Technical Skill Required Skills Application system analysis and defining database specifications prior tapplication programming. Data analysis, data modeling, logical and physical database design, and index design analysis. Transaction analysis, SQL analysis, and DB2 program analysis for performance. Proficiency in DB2 database object DDL Data Sharing DB2 subsystem storage pools (bufferpool, RID pool, Sort pool, EDM pool) Triggers Stored Procedures WLM environments UDF DRDA Develop test and document DB2 utilities. Reorganization (batch and online) Recovery (Restore and recover) for Local and Disaster Recovery Backup (Image Copy and other backup utilities) for Local and Disaster Recovery Repartitioning of Tablespaces Repair Check data Monitor DB2 subsystems using TMON for DB2, Detector, and Omegamon for DB2; troubleshoot DB2 operation malfunctions, abends, and error messages; and take appropriate action as needed. Interpret reports generated by TMON and Omegamon for DB2 and provide recommendations or take appropriate actions as necessary. Document, distribute, and maintain system documentations. Conducted feasibility studies including system reviews and evaluation of existing systems. Prepare project status, design documentations, requirement documentations, business case and other related reports. Develop cost/benefit assessments and provided recommendations timprove production and resolve problems. Provide on 24 x 7 on call support that includes problem determination and coordination of various activities with personnel from applications and operations. Willing tdevelop inherent leadership skills Manage multiple complex tasks, while prioritizing requests from the application support team Resolve problems that may include significant involvement with vendor support teams. Make decisions effectively in context tcorporate policy and direction Good thave skills but not necessary Performed test and documented software upgrades. Coordinated effectively any software changes and informed these activities tall areas of the organization that were affected by the software upgrade or maintenance. Analyzed application failures through examination of system dumps, DB2 or SMF traces. Understand multidimensional database designs using star schema logical models for the Data Warehouse decision support systems. Develop in house DB2 utilities either in mainframe or as client server utilities. Oracle and SQL Server