DB2 Database Administrator

City of New York; New York (NY); On-site; USD 75,000 - 160,000; Full time

Job summary

City of New York seeks an experienced DB2 Database Administrator (OBA) to support D82 v12+ on IBM zJOS. You will work with app teams to install, migrate releases and implement data fixes, and define DB2 recovery and tuning procedures for PMS, PPMS and FMS.

Responsibilities include DB2 installation and tuning, DR readiness, issue diagnosis, and coordinating production migrations with IBM and internal teams.

Qualifications

• Bachelor's degree in computer science, engineering or related field with 4+ years of full-time IT infra experience.
• Equivalent combination of education and experience acceptable.

Responsibilities

• Install, configure, and tune DB2 databases and related components.
• Collaborate with development teams to migrate releases and support data fixes.
• Define and implement database recovery procedures and runstats/reorgs.
• Coordinate production migrations with production and tech-support teams.
• Support DR drills and tool upgrades; monitor DB health and performance.
• Open IBM tickets and drive resolution; ensure high availability of systems.

Skills

DB2

zJOS

Data replication

Disaster Recovery

IT infrastructure

Education

Bachelor's degree

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 City's Financial Management System.

Additional Information

P-525

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

Hours/Shift

35 hours Weekly/Day.

Work Location

5 Manhattan West, NY, NY

IT INFRASTRUCTURE ENGINEER - 95714

Minimum Qualifications

• A baccalaureate degree from an accredited college in computer science, engineering or a related field and 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 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 "1" or "2" above.

Public Service Loan Forgiveness

As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at https://studentaid.gov/pslf/.

Residency Requirement

New York City Residency is not required for this position

The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.

, $75,000.00 – $160,000.00