City Of New York

DB2 Database Administrator

City Of New York • $110K — $130K *
New York, NY 10025In-Person
Information Technology
Less than 5 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • 5-7 years of experience as a DB2 Database Administrator (v12 or higher) on IBM zJOS platform.
  • Strong background in data fixes and database recovery functions.
  • Proficient in database tuning procedures, including runstats and reorgs.
  • Experience with system administration for IBM InfoSphere Data Replication product.
  • Ability to work collaboratively with application development teams.

Responsibilities

  • Ensure efficient installation, configuration, and tuning of DB2 databases.
  • Author and validate comprehensive procedures for database processes.
  • Identify issues promptly and implement solutions for DB2 programs.
  • Communicate migration details to Tech Support effectively.
  • Assist in system upgrades and participate in Disaster Recovery drills.
  • Monitor database operation health, including backups and system response times.
  • Perform troubleshooting for DB2 online and batch programs during various testing phases.

Benefits

  • Health insurance coverage and comprehensive medical benefits.
  • Pension plan options through the city's retirement system.
  • Deferred Compensation Plan options (457, 401K, Roth IRA).
  • Pre-tax Commuter Benefit and Flexible Spending Accounts available.
  • Additional benefits such as dental and vision care plans.
Full 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

To Apply

Applicants may visit the Jobs NYC website: www.nyc.gov/jobs and apply to Job ID: 788490. While all complete applications will be given consideration, only candidates selected for an interview will be contacted.

Hours/Shift

35 hours Weekly/Day.

Work Location

5 Manhattan West, NY, NY

IT INFRASTRUCTURE ENGINEER - 95714

Qualifications

1. 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,

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,

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

About City Of New York

The City of New York is the most iconic and dynamic city on the planet. With a population of more than 8.4 million people, New York is not only the largest city in the United States — it is the academic, cultural, commercial, and financial capital of the world. City government is filled with opportunities for talented individuals seeking to improve their communities and make a meaningful difference in the lives of their fellow New Yorkers. Every day, the City’s more than 300,000 employees improve infrastructure, provide vital social services, build technology, protect health and safety, and so much more.

City of New York Careers

There has never been a better time to explore the diverse job opportunities at the City of New York—the hub of professional growth and innovation in the public sector.

Work You’ll Do

Join the City of New York’s dynamic team to contribute to the community and enhance the city’s services across a broad spectrum of disciplines. The City of New York offers a unique opportunity to engage in meaningful work that impacts the lives of millions while navigating through a career filled with learning and growth. Transform the metropolitan landscape and enrich the lives of its residents with the best minds in public administration, urban planning, and community services. The City of New York stands at the forefront of urban management and innovation. Lead with a unique position in public service, at the intersection of technology, community needs, and sustainable development. Work alongside a diverse team of professionals dedicated to improving city operations and enhancing the quality of urban life. Collaborate with the largest network of public service experts in the nation, fostering leadership, diversity training, and professional development.

Introducing the City of New York Public Service Careers

The team is building a market-leading public service career path to help professionals master their roles and contribute effectively to the city’s development.

Do Innovative Work

Join a vast network of experts—dedicated professionals at the intersection of governance, community service, and urban innovation.

Drive Change in Public Service

Deliver targeted solutions and policies that enhance city living and maintain New York as a leading global city through a depth and breadth of expertise that’s second to none.

Be Part of a Great Team

Engage in a wide range of city projects utilizing cutting-edge technology and strategies, harnessing the unparalleled capabilities, scale, and collaborative spirit of a dedicated public service team.

Future-proof Your Career

Advance your career with limitless opportunities in the public sector, supported by unmatched training, development programs, and certification support.

Explore

From improving city infrastructure to enhancing public safety, the City of New York offers a platform for professionals to apply their skills, innovate, and lead.

The City of New York Public Service Initiative

The combined efforts of various departments help overcome urban challenges and lead transformation in city management. Professionals around the globe look to the City of New York for new strategies and solutions to drive significant change and growth in urban living. ## Stay Connected

Join the Team

Search open positions that match your skills and interests. The City of New York looks for passionate, curious, creative, and solution-driven team players. SEARCH CITY OF NEW YORK JOBS

Keep Up to Date

Stay ahead with career tips, insider perspectives, and industry-leading insights you can put to use today—all from the people who serve here.

READ CAREERS BLOG

Job Alert Emails

Personalize your subscription to receive job alerts, latest news, and insider tips tailored to your preferences. Discover what exciting and rewarding opportunities await in the City of New York.
Learn more about City Of New York
Industry
Education, Government & Non-Profit
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at City Of New York

More Information Technology Jobs

Find similar DB2 Database Administrator jobs:

NationwideNew York, NY