Job Title: Principal Database Engineer - Mainframe DB2/DBA
Location: Jersey City, NJ// Tampa, FL// Dallas, TX (Hybrid)
Duration: Direct Hire
The impact you will have in this role:
The Database Engineering team is responsible for managing Client's public and private cloud databases and responsible for the design, build, and operational aspects of the database. The Principal Database Engineer is an SME and senior member of the DB2 team.
Must have:
• DB2 DBA experience in z/OS (mainframe platform)
• SMPE
• BMC
• DB2 disaster recovery, data sharing, systems performance, monitoring/tuning, configuration, troubleshooting
• DB2 Upgrading and maintenance
• Troubleshooting database and SQL related problems
• Ability to work on multiple projects simultaneously, independently with minimal direction.
Nice to have:
• Experience with IBM Infosphere Data Replication (Q-Rep or CDC).
• General z/OS skills in areas that including TSO/ISPF, JCL, RACF. REXX and ISPF/CLIST programing.
Qualifications:
• Minimum of 8 years of related experience
• Bachelor's degree and/or equivalent experience
Talents Needed for Success:
• Expertise with DB2 for z/OS.
• Requires general knowledge and hands-on experience with SMPE, planning and applying DB2 maintenance, configuring and supporting DB2 data sharing, DB2 systems performance monitoring and tuning, configuring database security, troubleshooting database issues.
• Experience with DB2 disaster recovery and database failure scenarios
• Experience with diverse workload of applications using DB2 for z/OS including batch, RRS, CICS, WebSphere on z/OS and distributed platforms, JZOS, and java batch on distributed platforms is a plus.
• Understanding of DB2 database statistics and DB2 SMF records.
• Knowledge of distributed database connectivity configuration and setup.
• Knowledge of third-party vendor software products that support DB2 for z/OS - BMC (database utilities, Catalog and Change Manager, SQL Explorer and Apptune) and CA Sysview are a plus.
• Experience with IBM Infosphere Data Replication (Q-Rep or CDC) is a plus.
• General z/OS skills in areas that including TSO/ISPF, JCL, RACF.
• REXX and ISPF/CLIST programing are a plus.
• Strong analytic and problem-solving skills.
• Ability to work on multiple projects simultaneously, independently with minimal direction.
