Pages


Friday, March 16, 2012

We are in desperate need for DB2 Mainframe administrator..... Send resumes to kumar@javaji.com


Dear Folks / Business Partners,

This is Kumar From Javaji System Solutions Inc.,

We are in desperate need for DB2 Mainframe administrator..... Send resumes to kumar@javaji.com

Position: DB2 Mainframe administrator

Location: Nashville, TN

Duration: 6 Months+


Skills & Job Requirements:

·         Responsible for supporting the organization’s DB2z databases and ensuring their performance, availability, and security.
·         Responsible for database design, development and administration of large scale Operational, OLTP and Analytical data structures including logical and physical design
·         Provide SQL performance tuning on both OLTP and Data warehouse environments
·         Optimize DB2 resource utilization by tuning queries (static and dynamic), recommending indexes, and configuring database parameters
·         Provide data migration support
·         Provide trend analysis to management team to enable them to make informed decisions regarding resource management
·         Lead, mentor and/or provide guidance to junior DBAs including guidance for troubleshooting escalated issues
·         Partner with offshore DBA resources and thoroughly document processes to ensure successful implementation by offshore staff and Production Control
·         Provide on-call rotational 24/7 Incident Response to database alerts from production monitoring tools and Command Center personnel
·         Analyze Key Performance Metrics and make recommendations for improvements
·         Provide input on the selection and implementation of all database administration tools
·         Maintain the integrity of data within the production environment including the execution of proper backup and restoration policies and procedures which provide point-in-time restore capabilities (disaster recovery)
·         Perform database capacity planning and trend analysis
·         Deploy database changes in strict accordance with change management policies and procedures
·         Interact and coordinate work with System Administrators, Project Managers and fellow team members to support various project requests

Required Skills:

·         Bachelor's degree in CS/MIS or equivalent experience
·         Minimum of 7 years of heavy DB2z database administration experience and production support
·         Experience with DB2z V8 or V9
·         DB2 V8 or V9 database certification
·         Experience working with database partitioning schemes
·         Experience working with large systems in data sharing sysplex environment
·         Experience working with IBM Admin tool suite, Query Monitor, and Omegamon (DB2 PE)
·         In-depth knowledge of DB2 utilities such as LOAD, UNLOAD, RUNSTAT, REORG, COPY, MERGECOPY, and MODIFY.
·         Solid understanding of DB2 client tools such as DB2 Data Studio, Visual Explain, Optimization Service Center
·         Hands on experience with performance tuning of complex SQLs
·         Experience with DB2 Stored Procedures (SQL and COBOL)
·         Experience with Erwin or RDA data modeling tools
·         Candidate must have excellent communication skills
·         Preferred experience in data modeling with Star Schema and *Operational Data Store* concepts
·         Prefer experience with IBM Optim Move for DB2
·         Prefer that the candidate has worked in an onshore/offshore model


If interested please send me your resume, and also answer to the questions below

·         Candidate Contact Number
·         Candidate Visa Status
·         Candidate Convenient time to take up the telephonic discussion
·         Candidate convenient time to take up the face to face discussion
·         Candidate Employer details if in case of H1B
·         Candidate Current billing rate
·         Candidate Expected billing rate
·         References of direct supervisor


     
Kumar
Javaji System Solutions Inc.,
703 880 4142
703 880 7232 (Fax)
kumar@javaji.com
Google/Yahoo IM: kumar4mjss
http://jobsfromjavajisystemsolutionsinc.blogspot.com/
www.javaji.com