USM
Overview
USM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development, IT Outsourcing and Technology assistance supplier headquartered in Chantilly, VA. We offer world-class ability in giving most astounding quality and administrations through industry best practices planned to convey remarkable worth to our customers.
Utilizing our industry knowledge, administration service offering expertise and innovation abilities, we distinguish new business and innovation slants and create answers for help customers around the globe, giving top of the line solid and practical IT benefits which are cost effective services.
Established in 1999, 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. Our other offerings include modified solutions and administrations in ERP, CRM, Enterprise architecture, offshore advisory services and e-commerce.
USM, a US ensured Minority Business Enterprise (MBE) is perceived as one of the fastest developing IT Systems Integrator in the Washington, DC zone. Most as of late, USM was positioned #9 on the rundown of the Top administrations organizations in the DC Metro Area - Washington Business Journal (2011). We are a project-driven firm that reliably meets the IT needs of our State and Government customers through development and business keenness.
Job Description OPT EAD, GC EAD, GC, TN and Citizens Only
Hi Friends,
Hope you are doing great,
I have an urgent requirement from one of my esteem client, I will appreciate if you can have an eye on the below requirement and send me your consultant updated profile ASAP.
Title: Sr. DB2 DBA with LinkedIn id
Duration: 12 Months+ Contract (Potential for extension)
Job Description:
This is a Sr. DB2 z/OS DBA (DB2 Mainframe) Lead position, responsible for supporting the organization’s DB2 ZOS databases and ensuring their performance, availability, and security. The Lead is viewed as an expert in the administration and support of database technology. The candidate is expected to communicate common goals and direction for the team and also provide superior technical leadership.
DUTIES & RESPONSIBILITIES:
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, recommending indexes, and configuring database parameters
Provide trend analysis to management team to enable them to make informed decisions regarding resource management
Lead, mentor and/or provide guidance to less experienced database analysts where applicable 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)
Enhance site monitoring to improve availability and performance
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
DESIRED EXPERIENCE :
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
Additional Information If my requirement matches your resume, then please do reply on my email id alih (at)
usmsystems(dot)com and contact no is
703-955-3955
#J-18808-Ljbffr
Utilizing our industry knowledge, administration service offering expertise and innovation abilities, we distinguish new business and innovation slants and create answers for help customers around the globe, giving top of the line solid and practical IT benefits which are cost effective services.
Established in 1999, 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. Our other offerings include modified solutions and administrations in ERP, CRM, Enterprise architecture, offshore advisory services and e-commerce.
USM, a US ensured Minority Business Enterprise (MBE) is perceived as one of the fastest developing IT Systems Integrator in the Washington, DC zone. Most as of late, USM was positioned #9 on the rundown of the Top administrations organizations in the DC Metro Area - Washington Business Journal (2011). We are a project-driven firm that reliably meets the IT needs of our State and Government customers through development and business keenness.
Job Description OPT EAD, GC EAD, GC, TN and Citizens Only
Hi Friends,
Hope you are doing great,
I have an urgent requirement from one of my esteem client, I will appreciate if you can have an eye on the below requirement and send me your consultant updated profile ASAP.
Title: Sr. DB2 DBA with LinkedIn id
Duration: 12 Months+ Contract (Potential for extension)
Job Description:
This is a Sr. DB2 z/OS DBA (DB2 Mainframe) Lead position, responsible for supporting the organization’s DB2 ZOS databases and ensuring their performance, availability, and security. The Lead is viewed as an expert in the administration and support of database technology. The candidate is expected to communicate common goals and direction for the team and also provide superior technical leadership.
DUTIES & RESPONSIBILITIES:
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, recommending indexes, and configuring database parameters
Provide trend analysis to management team to enable them to make informed decisions regarding resource management
Lead, mentor and/or provide guidance to less experienced database analysts where applicable 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)
Enhance site monitoring to improve availability and performance
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
DESIRED EXPERIENCE :
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
Additional Information If my requirement matches your resume, then please do reply on my email id alih (at)
usmsystems(dot)com and contact no is
703-955-3955
#J-18808-Ljbffr