Overview
Hybrid
$65 - $70
Accepts corp to corp applications
Contract - Independent
Contract - 08 Month(s)
No Travel Required
Skills
BMC
IBM OMEGAMON
IBM DB2
JCL
z/OS
SQL
Tivoli
TSO
Mainframe
ETL
Job Details
Title: Database Administrator
Client: Commonwealth of PA
Duration: 08 Months
Location: (400 N St., Harrisburg, PA 17120
Note: The position is hybrid. Telework Monday, Tuesday and Friday. Onsite (5th floor of The Keystone Building (400 N St., Harrisburg, PA 17120)) Wednesday and Thursday.
Job Description:
- Design and maintain DB2 Database applications which have the following characteristics:
- Design for high availability.
- Design for maximum performance.
- Maintain and develop techniques and procedures to provide 24x7 availability.
- Provide production and test database support in a complex environment.
- Perform all functions which are performed by a DB2 Database Administrator, such as: SQL code reviews.
- Performance Monitoring and Tuning DB2 at the application database level.
- Enforce appropriate DB2 security standards.
- Collaborate with the DB2 systems programming staff to appropriately manage DSNZPARM settings.
- Create, manage and support DB2 Stored Procedures, DB2 Triggers, and DB2 Referential Integrity.
- Create Change Requests, Resolve Service Requests, Provide 24x7 On call support.
- Provide DB2 Connect configuration access support for individual users and distributed systems.
- Coordinate with team members on technical decisions and directions.
- Work with Management to develop project schedules.
- Provide Database performance and tuning which typically involves collaboration between Data Center, Technical Operations, Database Design and Administration, and the various software development areas.
- Responsible for the evaluation and creation of appropriate backup and recovery strategies for new database requirements.
- Participate in Disaster Recovery planning.
Required Skills:
- 10+ years DB2 experience
- Excellent knowledge of DB2 z/OS Database Support, including but not limited to the following-
- z/OS DB2 12 for zOS or higher in a production environment with high transaction rates
- High availability 24x7 designs and techniques
- Managing large data stores
- DB2 V10 utilities setup and execution
- DB2 performance and tuning
- Data Modeling expertise logical and physical design
- Complex SQL coding / tuning
- Data Warehouse design with an understanding of OLAP design and query solutions
- DB2 attachments/interfaces include DRDA, DB2 Connect
- DB2 tools skill set will include, but not limited to the following: QMF & IBM (Data Studio, OPTIM Workload Query Tuner, File Manager, Tivoli OMEGAMON)
- DB2 tools skill set will include, but not limited to the following: IBM DB2 (Administration Tool, Automation Tool, Explain, Query Monitor)
- z/OS Mainframe skills, but not limited to the following: TSO & ISPF, JCL, DFSORT &/or ICETOOL, REXX, z/OS Utilities
- Problem solving and analytical skills
- Ability to organize and prioritize workflow and projects
- Excellent written and oral communication skills
- DB2 V9 or V10 Certification preferred
- IMS Database experience
- IMS Database Utilities (IBM, BMC, NEON, etc.)
- ETL tools experience (Info Shere, Informatica, etc.)
"If you are: bright, motivated, skilled, a difference-maker, able to get things done, work with minimum direction, enthusiastic, a thinker, able to juggle and multi-task, communicate effectively, and lead, then we would like to hear from you. We need exceptionally capable people for this role for our client, so get back to us and tell us why you think you are a fit."
About Us:
Since 2000, Tri-Force Consulting Services () has been an MBE/SDB certified IT Consulting firm in the Philadelphia region. Tri-Force specializes in IT staffing, software development (web and mobile apps), systems integration, data analytics, system automation, cybersecurity, and cloud technology solutions for government and commercial clients. Tri-Force works with clients to overcome obstacles such as increasing productivity, increasing efficiencies through automation, and lowering costs. Our clients benefit from our three distinguishing core values: integrity, diligence, and technological excellence. Tri-Force is a six-time winner among the fastest-growing companies in Philadelphia and a four-time winner on the Inc. 5000 list of the nation's fastest-growing companies
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.