Principal Database Engineer (DB2)

Title: Principal Database Engineer (DB2)

Location: Tampa, Dallas, Jersey City, NJ

JOB DESCRIPTION:

• The Database Engineering team is responsible for managing 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.

RESPONSIBILITIES:

• Work with Mainframe DB2 team, area management, and related technical support groups in the process of engineering mainframe database solutions.
• Evaluate, install, configure, and maintain DB2 for z/OS, related software products and supporting tools.
• Communicate issues with software vendors.
• DB2 system-level performance tuning.
• Automation of database support procedures and repetitive DBA tasks.
• Responsible for the integrity and security of data in these databases.
• Enforce security controls for the DB2 database environment.
• Participate in DB2 on-call and hot-line rotation.
• Supervise database activity and assist developers and business clients in the utilization of databases.
• Provide support for Disaster Recovery tests, database infrastructure changes, application changes, and business operations.
• Troubleshoot database and SQL related problems.
• Support backup and recovery of DB2 databases.
• Respond to alerts related to DB2 database environment.
• Assist in the configuration and setup of distributed database connections using JDBC.
• Mitigate risk by following established procedures and monitoring controls, spotting key errors, and demonstrating strong ethical behavior.

QUALIFICATIONS:

• Bachelor's degree and/or equivalent experience.
• Minimum of 8 years of related experience.
• Expertise with DB2 for z/OS.
• 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, and 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 include TSO/ISPF, JCL, RACF, REXX, and ISPF/CLIST programming are a plus.
• Strong analytic and problem-solving skills.
• Ability to work on multiple projects simultaneously, independently with minimal direction.

Job Type: Full-time

Pay: $160,000.00 - $180,000.00 per year

Experience:

• DB2: 10 years (Preferred)
• Z/OS: 10 years (Required)
• Cloud architecture: 6 years (Required)
• Database development: 10 years (Required)
• SMPE: 6 years (Preferred)
• BMC: 7 years (Required)

Ability to Commute:

• Jersey City, NJ 07310 (Required)

Ability to Relocate:

• Jersey City, NJ 07310: Relocate before starting work (Required)

Work Location: In person