*** Please send the resumes to [email protected] ***<[email protected]%20***>
Hi… Let me know if you have any consultant for the below position. Position : *Sr. Database Analyst* Location : CA Duration : 6 to 12 months contract Interview : F2F Local candidates Preferred. *Sr. Database Analyst* 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 *Smitha* *Zieta Technologies *** * **----We make it happen* PH: 678-248-2096 X251 [email protected] www.zietatech.com [image: cid:[email protected]] CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain information which is confidential to, and/or privileged in favor of, ZIETA or its affiliated companies or ZIETA’s customers. Any review, use, reproduction, disclosure or distribution by the recipient is prohibited without prior written approval from an authorized ZIETA representative. This notice must appear in any such authorized reproduction, disclosure or distribution. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message and any attachments. Thank you [image: cid:[email protected]] -- You received this message because you are subscribed to the Google Groups "KNOW.IT" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/know_it_az?hl=en.
