*Direct Client Req **Database Analyst - Sr. !! Lakewood, CA !! 12 Months* * * *Please send me good matching profile ; ma...@tpiteam.com* ** *Local there must F2F interview*
Greetings to Dear Business Partners, We came across your profile on Hot Jobs; Dice; Monster and we have an urgent job requirement with our client, please go through it and if you are comfortable than please forward your updated resume with expected pay rate ASAP. *Title: **Database Analyst - Sr.*** *Location: Lakewood, CA** **Duration: 12** Months* 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 Embarcadero E/R Studio Data 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 to application 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: o DDL o Data Sharing o DB2 subsystem storage pools (bufferpool, RID pool, Sort pool, EDM pool) o Triggers o Stored Procedures o WLM environments o UDF o DRDA · Develop test and document DB2 utilities. o Reorganization (batch and online) o Recovery (Restore and recover) for Local and Disaster Recovery o Backup (Image Copy and other backup utilities) for Local and Disaster Recovery o Repartitioning of Tablespaces o Repair o 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 to improve 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 to develop 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 to corporate policy and direction Good to have skills but not necessary: · Performed test and documented software upgrades. · Coordinated effectively any software changes and informed these activities to all 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 Thanks Madhu 562-275-3546 ma...@tpiteam.com -- You received this message because you are subscribed to the Google Groups "DATAWAREHOUSE VENDORS" group. To post to this group, send email to datawarehouse-vend...@googlegroups.com. To unsubscribe from this group, send email to datawarehouse-vendors+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/datawarehouse-vendors?hl=en.