DB2 Database Administrator

Work location: 5 Manhattan West, New York, NY. Mode of interview: phone, virtual, or in person. Project duration: approximately 36 months.

Responsibilities

• Ensure that all installation, configuration, and tuning of DB2 databases are completed efficiently.
• Author and validate procedures for all database processes.
• Identify potential issues and deliver modifications / updates for DB2 programs.
• Communicate with and deliver to Tech Support all elements to be migrated with specific instructions to be performed during the production migration.
• Assist Systems areas with tool upgrades and participate in Disaster Recovery drills.
• Define and execute database recovery functions and standard database tuning procedures (e.g., runstats, reorgs).
• Monitor the health of key database operations (backup/recovery processes, logging, system response times, etc.).
• Open and manage tickets logged with IBM to resolution.
• Work with application development teams to install and migrate software releases (DB2 tasks) and support execution of data fixes (backups, packaging for production, etc.).
• Perform DB2 DB troubleshooting of online and batch programs during production, user acceptance testing, integrated system testing, performance testing and development phases.
• Design and execute technical tests to ensure that vendor and FISA software deliveries address business and technical problems consistent with FISA standards for quality and completeness.
• Perform all system administration activities for the IBM InfoSphere Data Replication product; high availability is required as it is a critical part of the City's Financial Management System.
• The selected candidate will participate in on-call rotation and flexible work hours to support project development.

Requirements

• Experience with IBM DB2 V12 or higher.
• Demonstrated experience working with application teams to build and maintain data propagation solutions using IBM InfoSphere Replication Server.
• Experience with CICS transaction server.
• Ability to author REXX scripts.
• Ability to troubleshoot assembler code.
• Installation, configuration, and tuning of new DB2 databases.
• Ability to troubleshoot issues with DB2 embedded within COBOL programs.
• Ability to perform all database admin duties (backup/recovery, reorgs, DB troubleshooting).
• Performance tuning at a DB2 system level or individual SQL statements/procedures.
• Knowledge of the Oracle Transparent Gateway product.
• Knowledge of DB2 UDB (experience with DB2 Connect).
• Experience installing and troubleshooting IBM Tivoli LDAP server product running on AIX.
• Ability to install and manage DB2 on AIX platforms.
• Deep experience with large‑scale, enterprise‑wide, governmental budget and accounting solutions.
• Experience with IBM IMS database management or higher (preferred), including ability to perform a checkpoint restore of an IMS database.
• Education: A baccalaureate degree in computer science, engineering, or related field plus four years of full‑time experience in datacenter/cloud/IT infrastructure engineering; OR a baccalaureate degree plus eight years of such experience; OR equivalent education/experience.

Pay

Rate: $90.00 per hour

Schedule

Hybrid schedule (alternating days on‑site), 40 hours per week.