DB2 Database Administrator

About the role

Orion Innovation is a premier, award-winning, global business and technology services firm. Orion delivers game-changing business transformation and product development rooted in digital strategy, experience design, and engineering, with a unique combination of agility, scale, and maturity. We work with a wide range of clients across many industries including financial services, professional services, telecommunications and media, consumer products, automotive, industrial automation, professional sports and entertainment, life sciences, ecommerce, and education.

Summary: DB2 Database Administrator (DBA) with proven experience supporting DB2 v12 (or higher) on an IBM z/OS platform. 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).

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 / 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 database recovery functions and standard database tuning procedures (e.g., runstats, reorgs)
• Monitor the health of 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
• Design and execute technical tests to ensure that vendor and Client software deliveries address the business and technical problems in a manner consistent with Client standards for quality and completeness
• Perform all system administration activities for the IBM InfoSphere Data Replication product; high availability of the product is required as it is a critical part of the City's Financial Management System

Requirements

Experience with IBM DB2 V12 or higher.

Skills

• Demonstrated experience working with application teams to build and maintain data propagation solutions – using “IBM InfoSphere Replication Server”
• Experience with CICS transaction server
• Ability to author REXX scripts
• Ability to troubleshoot assembler code
• Installation, configuration, and tuning of new DB2 databases
• Ability to troubleshoot issues with DB2 embedded within COBOL programs
• Ability to perform all database admin duties (backup/recovery, reorgs, DB trouble shooting)
• Performance tuning at a DB2 system level or individual SQL statements/procedures