Urgent Need Sr DB2 DBA LinkedIn id

USM

Cincinnati (OH)

On-site

USD 90,000 - 120,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

A rapidly growing IT firm is seeking a Sr. DB2 DBA to lead the administration and support of its DB2 z/OS databases. The ideal candidate will be responsible for optimizing database performance, leading a team, and ensuring data integrity. Applicants should have over 5 years of experience in heavy DB2 z/OS database administration and be skilled in SQL performance tuning. This is a 12-month contract position located in Cincinnati, Ohio, with potential for extension.

Qualifications

Minimum of 5+ years of heavy DB2 ZOS database administration experience.
Experience with large systems in data sharing sysplex environment.
Hands-on experience with performance tuning of complex SQLs.

Responsibilities

Responsible for database design, development, and administration.
Lead, mentor, and provide guidance to less experienced database analysts.
Analyze Key Performance Metrics and make recommendations for improvements.

Skills

DB2 ZOS database administration

SQL performance tuning

Database capacity planning

Data modeling

Onshore/offshore teamwork

Education

Bachelor's degree in CS/MIS or equivalent

Tools

IBM Admin tool suite

Data Studio

Job description

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

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