Company:
Multihires
Location: Jersey City
Closing Date: 25/10/2024
Salary: £100 - £125 Per Annum
Hours: Full Time
Type: Permanent
Job Requirements / Description
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
#J-18808-LjbffrShare this job
Multihires
Useful Links