DB2 Database Administrator

Universal Technologies; United States; Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Health Insurance

Dental Insurance

Vision Insurance

401k

HSA

FSA

Pre Tax Transportation Benefits

Generous PTO and Holidays

Job summary

UNIVERSAL Technologies LLC in New York seeks an experienced DB2 Database Administrator for a hybrid role. You will support IBM DB2 V12+ on z/OS, ensure high availability, manage backups, run RUNSTATS/REORG, and collaborate with development teams on data propagation and disaster recovery.

The ideal candidate has 4+ years in data center/IT infrastructure, proven experience with InfoSphere Data Replication, and strong problem-solving skills to support enterprise systems and on-call rotations.

Qualifications

• Four or eight years of full-time experience in data center engineering and operations or complex IT infrastructure engineering.
• Proven experience with IBM DB2 V12 or higher on an IBM zOS platform.
• Experience with IBM InfoSphere Replication and maintaining high availability in mission-critical environments.

Responsibilities

• Ensure installation, configuration and tuning of DB2 databases and related systems.
• Define and execute database recovery and maintenance procedures (RUNSTATS, REORG).
• Collaborate with application teams to migrate software releases and resolve DB2 issues.
• Open, manage and track IBM support tickets through resolution.
• Support data propagation and replication responsibilities using InfoSphere tools and COBOL/DB2 interfaces.

Skills

DB2 DBA

z/OS

CICS

REXX scripting

COBOL

Backup & Recovery

DB2 tuning

SQL & Stored Procedures

Education

Baccalaureate degree in Computer Science or related field

Tools

InfoSphere Data Replication

InfoSphere Replication Server

DB2 Connect

Tivoli LDAP on AIX

Job description

UNIVERSAL Technologies LLC is seeking an experienced DB2 Database Administrator DBA for a hybrid position in New York NY with proven expertise supporting IBM DB2 V12 or higher on an IBM zOS platform Active LinkedIn preferred The DBA will support mission critical enterprise systems and work closely with application development systems and technical support teams to install and migrate software releases execute data fixes perform database recovery and tuning troubleshoot DB2 environments and maintain high availability of key database technologies The selected candidate will participate in an on call rotation and must be available for flexible work hours to support project development and production needs Approximately 36 month project.

WHO WE ARE

UNIVERSAL Technologies LLC is a certified Women Owned Business Enterprise MWBE providing IT solutions and consulting services to government and private sector clients Our areas of expertise include Application Development BusinessSystemsData Analysis Project Management Cyber Security Data Analytics InfrastructureNetwork Engineering and High Level Systems Architecture

WHAT WE OFFER

• Competitive compensation
• Health Dental and Vision Insurance
• Group Life Insurance
• 401k
• HSA
• FSA
• Pre Tax Transportation Benefits
• Generous PTO and Holiday Benefits

MANDATORY SKILLSEXPERIENCE

A baccalaureate degree from an accredited college in Computer Science Engineering or a related field along with four 4 years of satisfactory full time experience in datacenter engineering and operations cloud engineering and operations or complex IT infrastructure engineering; orA baccalaureate degree from an accredited college and eight 8 years of satisfactory full time experience in datacenter engineering and operations cloud engineering and operations or complex IT infrastructure engineering; orEducation andor experience equivalent to the requirements aboveProven experience with IBM DB2 V12 or higher on an IBM zOS platformDemonstrated experience working with application teams to build and maintain data propagation solutions using IBM InfoSphere Replication ServerExperience administering and supporting IBM InfoSphere Data Replication including maintaining high availability in mission critical environmentsExperience with CICS Transaction ServerAbility to author REXX scriptsAbility to troubleshoot Assembler codeExperience installing configuring and tuning new DB2 databasesAbility to troubleshoot issues involving DB2 embedded within COBOL programsAbility to perform all DB2 database administration functions including backup and recovery reorganization database troubleshooting and maintenanceExperience performing database recovery functions and standard database tuning procedures including RUNSTATS and REORGsExperience with performance tuning at the DB2 system level and with individual SQL statements and stored proceduresKnowledge of Oracle Transparent GatewayKnowledge of DB2 UDB including experience with DB2 ConnectExperience installing and troubleshooting IBM Tivoli LDAP Server running on AIXAbility to install and manage DB2 on AIX platformsDeep experience supporting large scale enterprise wide governmental budget and accounting solutionsExperience with IBM IMS database management is preferred including the ability to perform a checkpoint restore of an IMS databaseStrong troubleshooting skills supporting online and batch DB2 programs across production User Acceptance Testing UAT Integrated System Testing IST performance testing and development environmentsAbility to work effectively with application development systems technical support and vendor teamsAbility to participate in an on call rotation and work flexible hours as required to support project development and production environments

SCOPE OF SERVICES

• Ensure all installation configuration and tuning activities for DB2 databases are completed efficiently
• Author and validate procedures for database processes
• Identify potential issues and develop modifications or updates for DB2 programs
• Communicate with Technical Support and provide all elements required for migration along with specific instructions for production implementation
• Assist Systems teams with tool upgrades and participate in Disaster Recovery drills
• Define and execute database recovery functions
• Define and execute standard database tuning procedures including RUNSTATS and REORGs
• Monitor the health and performance of key database operations including backup and recovery processes logging and system response times
• Open manage and track support tickets with IBM through resolution
• Work with application development teams to install and migrate software releases involving DB2 related tasks
• Support the execution of data fixes including backups and packaging changes for production
• Troubleshoot DB2 database issues affecting online and batch programs during production User Acceptance Testing Integrated System Testing performance testing and development phases
• Design and execute technical tests to confirm that vendor and internally developed software solutions address business and technical requirements in accordance with established standards for quality and completeness
• Perform all system administration activities for the IBM InfoSphere Data Replication product
• Maintain high availability of IBM InfoSphere Data Replication due to its critical role within enterprise financial systems
• Support database environments associated with major payroll pension payroll and financial management systems

UNIVERSAL Technologies is an equal opportunity employer