Logo
Universal Technologies

DB2 database Administrator

Universal Technologies, New York, New York, us, 10261

Save Job

UNIVERSAL Technologies is seeking an experienced DB2 Database Administrator with deep expertise supporting DB2 v10 or higher on IBM z/OS platforms. This hybrid role supports enterprise-scale financial and payroll applications, including PMS and PPMSthe Citys payroll and pension payroll systems. The ideal candidate will bring extensive database administration experience, system integration skills, and a strong understanding of IBM InfoSphere, CICS, and related technologies. WHO WE ARE UNIVERSAL Technologies, LLC is a Women-Owned (M/WBE) IT solutions and consulting company focused on delivering enterprise systems that significantly improve our clients' IT performance. We work across the IT spectrum including Development, Business/Systems/Data Analysis, Project Management, Cyber Security, Network Engineering, and High-Level System Architecture. We take pride in placing talented professionals on mission-critical technology projects that drive public sector transformation and operational excellence. WHAT WE OFFER Our W2 employees can expect the following benefits: Competitive pay

Health/Dental Insurance

Group Life Insurance

401K

HSA/FSA

Pre-Tax Transportation Program

Generous Paid Time Off/Holiday package

MANDATORY SKILLS/EXPERIENCE Bachelors or Masters Degree in Computer Science or a related technical/business discipline is required.

Hands-on experience supporting DB2 v10 or higher on IBM z/OS platforms

Experience with IBM IMS V12 database management or higher

Ability to perform core DBA duties: backup/recovery, reorgs, and DB troubleshooting

Experience with CICS Transaction Server

Ability to author REXX scripts

Proficiency in troubleshooting assembler code

Expertise in resolving issues with DB2 embedded within COBOL programs

Ability to design solutions using Oracle Transparent Gateway

Experience designing and implementing BMC BPPM Monitoring software

Skilled in installing and troubleshooting IBM Tivoli LDAP Server on AIX

Demonstrated experience building and maintaining data propagation solutions using IBM InfoSphere Replication Server

Experience installing and managing DB2 on AIX platforms

Deep experience supporting large-scale, enterprise-wide financial and payroll applications built on commercial off-the-shelf (COTS) solutions

SCOPE OF SERVICES Support City payroll and pension payroll applications (PMS and PPMS)

Install, configure, and tune DB2 databases on IBM z/OS platform

Author and validate procedures for all database processes

Identify and implement modifications/updates for DB2 programs

Collaborate with Technical Support to deliver migration components and instructions

Execute data fixes and recovery functions

Perform standard database tuning procedures (e.g., runstats, reorgs)

Assist in tool upgrades and participate in Disaster Recovery drills

UNIVERSAL Technologies is an equal opportunity employer.