Database Administrator

17 hours ago

New York, United States Baanyan Software Services, Inc. Full-time
New York, NY: In Person Interview Required
• Looking for DB2 Database Administrator (DBA) with proven experience supporting DB2 v12 (or higher) on an IBM z/OS 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., run stats, 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). Required

Skills:
• Experience with IBM DB2 V12 or higher.
• Candidate must have 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.
• Knowledge of the Oracle Transparent Gateway product
• Knowledge of DB2 UDB (ie., experience with DB2 connect)
• Experience installing and troubleshooting IBM Tivoli LDAP server product running on AIX.
• Ability to install and manage DB2 on AIX platforms.
• Deep experience with large-scale, enterprise wide, governmental budget and accounting solutions
• Experience with IBM IMS database management or higher (preferred). Including ability to perform a checkpoint restore of an IMS database.
• A selected candidate will participate in on-call rotation and flexible work hours to support project development. Education and experience

requirements:
• A baccalaureate degree from an accredited college in computer science, engineering, or a related field, along with four years of satisfactory full-time experience in datacenter engineering and operations, cloud engineering and operations, or complex IT infrastructure engineering; or
• A baccalaureate degree from an accredited college and eight years of satisfactory full-time experience in the same fields