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 compensationHealth Dental and Vision InsuranceGroup Life Insurance401kHSAFSAPre Tax Transportation BenefitsGenerous PTO and Holiday BenefitsMANDATORY 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 environmentsSCOPE OF SERVICES Ensure all installation configuration and tuning activities for DB2 databases are completed efficientlyAuthor and validate procedures for database processesIdentify potential issues and develop modifications or updates for DB2 programsCommunicate with Technical Support and provide all elements required for migration along with specific instructions for production implementationAssist Systems teams with tool upgrades and participate in Disaster Recovery drillsDefine and execute database recovery functionsDefine and execute standard database tuning procedures including RUNSTATS and REORGsMonitor the health and performance of key database operations including backup and recovery processes logging and system response timesOpen manage and track support tickets with IBM through resolutionWork with application development teams to install and migrate software releases involving DB2 related tasksSupport the execution of data fixes including backups and packaging changes for productionTroubleshoot DB2 database issues affecting online and batch programs during production User Acceptance Testing Integrated System Testing performance testing and development phasesDesign 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 completenessPerform all system administration activities for the IBM InfoSphere Data Replication productMaintain high availability of IBM InfoSphere Data Replication due to its critical role within enterprise financial systemsSupport database environments associated with major payroll pension payroll and financial management systemsUNIVERSAL Technologies is an equal opportunity employer
Interested in this role?