DB2 Database Administrator


Job Location:

New York City, NY - USA

Salary: Not Disclosed
Experience Required: 5years
Posted on: 3 hours ago
Vacancies: 1 Vacancy

Job Summary

Title: DB2 Database Administrator

Location: 5 Manhattan West New York NY 10001


Job Description


FISA is in search of an experienced DB2 Database Administrator (OBA) with proven experience supporting D82 v12 (or higher) on an IBM zJOS platform. Primary responsibilities include working with application development teams to install and migrate releases support execution of data fixes define new and execute databases recovery functions definition and execution of standard database tuning procedures (e.g. runstats reorgs). The target systems for which support is required are: the Payroll

Management System (PMS) the Pension Payroll Management System (PPMS) and the Financial Management System (FMS).

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 I 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 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 lnfoSphere Data Replication product.

High availability of the product is required as it is a critical part of the Citys Financial Management System.

Minimum Qualification Requirements:

1.A baccalaureate degree from an accredited college in computer science engineering or a related fieldand four years of satisfactory full-time experience related to datacenter engineering and operations cloud engineering and operations complex IT


2.A baccalaureate degree from an accredited college and eight years of satisfactory full-time experience related to datacenter engineering and operations cloud engineering and operations complex IT infrastructure engineering; or

and/or experience which is equivalent to "1" or"2" above.


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 nations fastest-growing companies.



Required Skills:

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 I 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 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 lnfoSphere Data Replication product. High availability of the product is required as it is a critical part of the Citys Financial Management System.


Required Education:

Bachelors degree in information systems Computer Science or equivalent experience

Title: DB2 Database AdministratorLocation: 5 Manhattan West New York NY 10001 Job Description FISA is in search of an experienced DB2 Database Administrator (OBA) with proven experience supporting D82 v12 (or higher) on an IBM zJOS platform. Primary responsibilities include working with application ...