Urgent Need Sr DB2 DBA LinkedIn id

USM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development, IT Outsourcing and Technology assistance supplier. We offer world-class ability in giving most astounding quality and administrations through industry best practices. The organization has corner qualities in building and dealing with a Business Oriented IT environment with rich involvement in technology innovation, ERP and CRM counselling, Product Engineering, Business Intelligence, Data Management, SOA, BPM, Data Warehousing, SharePoint Consulting and IT Infrastructure.

Requirements

• Bachelor's degree in CS/MIS or equivalent experience
• Minimum of 5+ years of heavy DB2 ZOS database administration experience and production support
• DB2 V10 or above experience
• Experience working with very large database partitioning
• Experience working with large systems in data sharing sysplex environment
• Preferred experience in data modeling with Star Schema and Operational Data Store concepts
• Experience with evaluating and consolidating database workloads to maximize hardware resources
• Experience working with IBM Admin tool suite, Query Monitor, and Omegamon v5.1 or above (DB2 PE)
• In-depth knowledge of DB2 utilities such as LOAD, UNLOAD, RUNSTAT, REORG, COPY, COPYTOCOPY, MERGECOPY, MODIFY and SPUFI.
• Solid understanding of DB2 client tools such as Data Studio, and Omgeamon XE Client
• Hands on experience with performance tuning of complex SQLs
• Experience with XML
• Experience tuning complex SQL
• Experience with DB2 Stored Procedures (SQL, Native and COBOL)
• Prefer experience with IBM Optim Move for DB2
• Prefer experience with Erwin or IDA data modeling tools
• Prefer that the candidate has worked in an onshore/offshore model