DB2 Database Administrator

Primary 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 and 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.
• Aid Systems areas with tool upgrades and participate in Disaster Recovery drills.
• Define and execute databases recovery functions, definition and execution of standard database tuning procedures (e.g., runstats, reorgs).
• Monitor the health of the 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 of the work effort.
• Design and execute technical tests to ensure that vendor and FISA software deliveries address the business and technical problems in a manner consistent with FISA standards for quality and completeness.
• Perform the all system administration activities for the IBM InfoSphere Data Replication product.

Additional Information

The City of New York offers a comprehensive set of benefits and programs to employees, including health insurance, pension plan, Deferred Compensation Plan (with 457, 401K and Roth IRA options), pre-tax Commuter Benefit program, pre-tax Flexible Spending Accounts programs and more. Additional benefits such as prescription drug coverage, dental benefits, vision care benefits and more are also available through District Council 37 – Local 2627, the union that represents employees in this title.

Pay

$75,000.00 – $160,000.00

Schedule

35 hours Weekly/Day

Work Location

5 Manhattan West, NY, NY