Lead Database Engineer (DB2 Z/oS)

Job Description

Are you ready to make an impact at DTCC?

Do you want to work on innovative projects, collaborate with a dynamic and encouraging team, and receive investment in your professional development? At DTCC, we are at the forefront of innovation in the financial markets. We're committed to helping our employees grow and succeed. We believe that you have the skills and drive to make a real impact. We develop a growing internal community and are committed to creating a workplace that looks like the world that we serve.

Pay And Benefits

• Competitive compensation, including base pay and annual incentive.
• Comprehensive health and life insurance and well-being benefits, based on location.
• Pension / Retirement benefits
• Paid Time Off and Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and well-being.
• DTCC offers a flexible/hybrid model of 3 days onsite and 2 days remote (Tuesdays, Wednesdays, and a day unique to each team or employee).
  
  

The Impact You Will Have In This Role

The Development family is responsible for creating, designing, deploying, and supporting applications, programs, and software solutions. May include research, new development, prototyping, modification, reuse, re-engineering, maintenance, or any other activities related to software products used internally or externally on product platforms supported by the firm. The software development process requires in-depth subject matter expertise in existing and emerging development methodologies, tools, and programming languages. Software Developers work closely with business partners and / or external clients in defining requirements and implementing solutions.

The Application Support Engineering role specializes in maintaining and providing technical support for all applications that are beyond the development stage and are running in the daily operations of the firm. Works closely with development teams, infrastructure partners, and internal / external clients to escalate and resolve technical support incidents.

What You'll Do

• Work locally and remotely 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.
• Assist in the configuration and setup of distributed database connections using JDBC
• Provide support for Disaster Recovery tests, database infrastructure changes, application changes, and business operations.
• Automation of database support procedures and repetitive DBA tasks.
• Responsible for the integrity and security of data in these databases.
• Adhere to security controls for the DB2 database environment
• Participate in DB2 on-call and hot-line rotation.
• Monitors database activity and assist developers and business clients in the utilization of databases.
• Troubleshooting database and SQL related problems
• Support backup and recovery of DB2 databases
• Respond to alerts related to DB2 database environment.
  
  

Education

• Bachelor's degree or equivalent experience.
  
  

Talents Needed For Success

• Minimum of 6 years of related experience.
• Ability to work independently, with minimal supervision.
• Strong analytic and problem-solving skills.
• Ability to work on multiple projects simultaneously.
• Excellent communication (both written and verbal) and interpersonal skills.
• Requires hands-on expertise with DB2 for z/OS.
• Knowledge of SQL.
• 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
• Understanding of DB2 database statistics and DB2 SMF records.
• Experience with diverse workload of applications utilizing 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.
• Experience in a DB2 data sharing environment is a plus.
• Knowledge of distributed database connectivity configuration and setup are a plus.
• 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.
  
  

Actual salary is determined based on the role, location, individual experience, skills, and other considerations. We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

About Us

DTCC safeguards the financial markets and helps them run efficiently, in times of prosperity and crisis. We are uniquely positioned at the center of global trading activity, processing over 100 million financial transactions every day, pioneering industry-wide, post-trade solutions and maintaining multiple data and operating centers worldwide. From where we stand, we can anticipate the industry’s needs and we’re working to continually improve the world’s most resilient, secure and efficient market infrastructure. Our employees are driven to deliver innovative technologies that improve efficiency, lower cost and bring stability and certainty to the post-trade lifecycle.

DTCC proudly supports Flexible Work Arrangements favoring openness and gives people freedom to do their jobs well, by encouraging diverse opinions and emphasizing teamwork. When you join our team, you’ll have an opportunity to make meaningful contributions at a company that is recognized as a thought leader in both the financial services and technology industries. A DTCC career is more than a good way to earn a living. It’s the chance to make a difference at a company that’s truly one of a kind.

Learn more about Clearance and Settlement by clicking here .

About The Team

Enterprise Product & Platform Engineering transforms the way we deliver infrastructure to our business clients. A key construct of EP&PE will be the evolution of the IT Product Manager, who will partner with the Engineering organization, the Business Aligned Service Delivery organization, the DevSecOps organization as well as our operational support teams to ensure that this organization provides high quality, commercially attractive and timely solutions to support our business strategy.