DB2 Database Administrator (OBA)

Salary range is between $75,000.00 to $ annually.

• Location:
  
  New York, NY
• Duration: 12 Months

• 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 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 company software deliveries address the business and technical problems in a manner consistent with company standards for quality and completeness.
• Perform all system administration activities for the IBM Info Sphere Data Replication product. High availability of the product is required, as it is a critical part of the City's Financial Management System.

• A baccalaureate degree from an accredited college in computer science, engineering, or a related field and a minimum of four years of satisfactory full-time experience related to datacenter engineering and operations, cloud engineering and operations, complex IT infrastructure engineering; or,
• A baccalaureate degree from an accredited college and a minimum of eight years of satisfactory full-time experience related to datacenter engineering and operations, cloud engineering and operations, complex IT infrastructure engineering; or,
• Education and/or experience which is equivalent to the above.

• 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.