Senior DB2 DBA

BMO Capital Markets is a leading, full-service financial services provider. We offer corporate and investment banking, treasury management, as well as research and advisory services to clients around the world. #bmocapitalmarkets

Senior DB2 DBA

Drive the Data Platforms Powering One of Canada's Leading Financial Institutions

At BMO, we're driven by a shared Purpose: Boldly Grow the Good in business and life. Our technology teams play a critical role in delivering secure, reliable, and innovative banking solutions that millions of customers depend on every day.

We are looking for a Senior Database Administrator (Db2 z/OS) to join our Mainframe Platform & Application Services team. In this role, you'll help design, optimize, and support the mission-critical database environments that power enterprise applications across the bank. You'll collaborate with talented engineers, developers, architects, and business partners to ensure our platforms remain secure, resilient, and high performing.

If you're passionate about database technology, enjoy solving complex technical challenges, and want to make a meaningful impact within a large-scale enterprise environment, we'd love to hear from you.

What You'll Do

As a key member of our Db2 DBA Dev team, you will:

• Administer, monitor, and support enterprise-scale Db2 for z/OS environments.
• Design, implement, and maintain secure, scalable, and highly available database solutions in non-production environments.
• Prepare and deploy database changes through established change management processes into production environments.
• Partner with application development teams to deliver high-quality, performant, and resilient database solutions.
• Perform logical and physical database design while ensuring adherence to enterprise standards for data integrity, security, and performance.
• Provide expert guidance on SQL design, SQL optimization, performance tuning, backup and recovery strategies, stored procedures, and database architecture.
• Troubleshoot and resolve complex database, application, and connectivity issues, including distributed applications utilizing JDBC and ODBC/CLI connectivity.
• Analyze and optimize database performance to support business-critical workloads.
• Develop and maintain database security standards, governance practices, and operational procedures.
• Contribute to continuous improvement initiatives, automation opportunities, and modernization efforts across the database ecosystem.
• Collaborate with cross-functional technology teams to support strategic projects and enterprise transformation initiatives.
  
  
  

What You'll Bring

Required Experience & Qualifications

• 7+ years of hands-on experience supporting Db2 for z/OS environments.
• Proven experience with Db2 z/OS Version 12 or higher.
• Strong expertise in database design, implementation, administration, and maintenance.
• Solid experience with z/OS, JCL, TSO/ISPF, and mainframe technologies.
• Experience supporting distributed Db2 applications and connectivity solutions.
• Strong SQL performance tuning and query optimization capabilities.
• Deep understanding of Db2 security architecture and controls.
• Experience with Db2 utilities, plans, packages, access paths, Explain, LOBs, triggers, stored procedures, and user-defined functions.
• Experience with Db2 data sharing environments and high-availability solutions.
• Practical expertise in backup, recovery, and disaster recovery processes.
• Strong analytical, troubleshooting, and problem-solving abilities.
• Understanding of the Software Development Life Cycle (SDLC) and change management practices.
• Excellent collaboration, communication, and relationship management skills.
• Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent practical experience.
  
  
  

Preferred Qualifications

Experience with one or more of the following technologies and tools:

• Db2 Connect configuration and implementation utilizing AT-TLS
• RACF, ACF2, or other enterprise security products
• Db2 Explain
• ISPW
• GitHub
• Visual Studio Code with Db2 extensions
• ESP
• CICS
• Data replication technologies
• NDM
• IBM Change Management Tool Catalog Manager
• IBM Query Monitor
• IBM Log Analysis Tool
• Omegamon
• AQT
• QMF
• ServiceNow
  
  
  

Additional assets:

• Knowledge of COBOL, PL/I, Assembler, REXX, or CLIST
• Experience with data modelling and tools such as PowerDesigner
• Db2 for z/OS certification
• Experience working within large, regulated enterprise environments
  
  
  

Why Join BMO?

At BMO, you'll have the opportunity to work on large-scale platforms that support millions of customers while collaborating with some of the industry's most talented technology professionals.

You'll benefit from:

• Meaningful work with enterprise-wide impact
• A culture that values inclusion, collaboration, and continuous learning
• Access to leading technologies and modernization initiatives
• Career growth and development opportunities across a global organization
• Flexible hybrid work arrangements
• A supportive environment where your ideas and expertise help shape the future of banking technology
  
  
  

Hybrid Work Model: This role requires in-office presence two days per week.

Ready to make an impact? Join BMO and help build the secure, innovative data platforms that power the future of banking.

Group Overview

The Corporate Hedging Solutions group is a team within Global Markets’ Global Fixed Income (GFI) vertical, responsible for originating and executing hedging transactions for BMO’s corporate clients. Working closely with investment & corporate banking, the team serves as product experts with a coverage universe including interest rates and foreign exchange as well as structured solutions.

Mandate

Seeking a highly motivated and experienced Vice President to join the Corporate Hedging Solutions team, focusing on the marketing, origination and execution of interest rate derivative solutions within the U.S. universe of corporate clients. This individual will support client engagement and revenue generation through analysis, production of marketing and execution of customized interest rate derivative solutions for corporate clients. The ideal candidate has experience in fixed income markets, a strong analytical foundation, and a drive to win business and build relationships.

In this role, you will support the coverage of key corporate client relationships, including day-to-day analysis, marketing, pitching and execution across interest rate products with near-term growth opportunities into primary coverage activities. You will need to be comfortable speaking to the corporate finance rationale behind hedging strategies, as well as the technical details underlying the various products, to effectively work with mid- to large-cap corporations across multiple sectors. You will work collaboratively with Investment & Corporate Banking, trading, structuring, credit & risk management, research and back office to provide comprehensive coverage and efficiently deploy the bank’s resources. Familiarity and experience in foreign exchange products and strategies is also beneficial. The role is based in New York, New York.

Key Areas of Accountability

• Origination and Negotiation
• Enhancing Client Relationships
• Pricing and Execution
• Structuring and Modelling
• Working with Internal Partners
  
  
  

Accountabilities Defined

Origination and Negotiation

• Both supporting and leading pitching activities with contacts at corporate clients, including senior executives
• Support the effective and compelling marketing of BMO’s capabilities in interest rate products and solutions
• Contribute to value-add trade ideas that apply economic, political, and market trends
• Support the development and deployment of creative solutions for client risk management problems
• Assist in the negotiation of key derivative legal documentation
  
  
  

Enhancing Client Relationships

• Partner with Investment & Corporate Banking to support client relationships and business development
• Support expansion of the CHS client coverage map where there are blind spots and help enhance existing relationships
• Support frequent, thoughtful touchpoints with key client relationships to build trust and demonstrate value
• Help deliver high-touch, seamless service to key clients
  
  
  

Pricing and Execution

• Support the accurate pricing and execution of interest rate products, including swaps, options and cross-currency swaps
• Work collaboratively with traders across several desks to understand and help manage underlying risks
• Understand resource constraints and support the efficient management of client trading activity
  
  
  

Structuring and Modelling

• Analyze and understand the nature of structured requests from clients
• Accurately and efficiently model risks associated with client transactions and restructuring opportunities to support senior coverage
• Support trade structuring, precisely incorporating trader inputs
• Model scenario analysis under various hedging strategies
  
  
  

Working with Internal Partners

• Build strong internal relations with Investment and Corporate Banking and trading teams to offer value-added client solutions, while adhering to product and risk limits
• Coordinate with internal partners (including back office and legal) to assist in improving processes for the best client experience
• Contribute to a dynamic and collaborative work environment and support the development of junior team members
  
  
  

CROSS-FUNCTIONAL RELATIONSHIPS:

This job requires the incumbent to interact with the following processes and/or groups in BMOCM:

• Global Markets
• Investment and Corporate Banking
• Credit and Market Risk Management
• Derivative Operations
• Derivatives Legal Group
• Corporate Services: Compliance, Human Resources
  
  
  

Scope and Impact

This role has direct or indirect impact on the following:

The work product directly involves front-line revenue generation, impacts the growth initiatives within the Business Unit, impacts client exposures and multiple other aspects of market risk.

The successful candidate will contribute to the team through delivery of interest rate derivative and foreign exchange strategies and strategic recommendations to clients. This ultimately results in significant revenue generation for the Business Unit.

Knowledge And Skills

• 2+ years experience in Interest Rates or Foreign Exchange sales with a strong understanding of Fixed Income markets
• Some experience working directly with corporate clients
• Strong knowledge of Global Markets including fixed income, corporate debt markets and foreign exchange
• Undergraduate degree in Business, Finance, Mathematics, or a related field
• Experience with Calypso or equivalent systems
• Working knowledge of Bloomberg and MS Office (Word, Power Point, Excel)
• Strong sales skills and relevant experience
• Highly developed written and oral communication skills
• Strong interpersonal skills used within a demanding team environment
• Ability to be creative, insightful and resourceful in performance of duties
• Strong ability to attentively review, assess, and provide detailed information daily on multiple projects in an organized manner
• Excellent analytical and quantitative skills
• Strong capability in pricing and modeling interest rate derivatives
• Self-motivated to keep up to date on product knowledge and market news
• Understanding of hedge accounting concepts and applicability to client solutions
• Familiarity with concepts of XVA, RWA and bank resource management
  
  
  

Salary:

Please note base salary for this role is $260,000 USD

Salary:

Pay Type:

Salaried

The above represents BMO Financial Group’s pay range and type.

Salaries will vary based on factors such as location, skills, experience, education, and qualifications for the role, and may include a commission structure. Salaries for part-time roles will be pro-rated based on number of hours regularly worked. For commission roles, the salary listed above represents BMO Financial Group’s expected target for the first year in this position.

BMO Financial Group’s total compensation package will vary based on the pay type of the position and may include performance-based incentives, discretionary bonuses, as well as other perks and rewards. BMO also offers health insurance, tuition reimbursement, accident and life insurance, and retirement savings plans. To view more details of our benefits, please visit: https://jobs.bmo.com/global/en/Total-Rewards

About Us

At BMO we are driven by a shared Purpose: Boldly Grow the Good in business and life. It calls on us to create lasting, positive change for our customers, our communities and our people. By working together, innovating and pushing boundaries, we transform lives and businesses, and power economic growth around the world.

As a member of the BMO team you are valued, respected and heard, and you have more ways to grow and make an impact. We strive to help you make an impact from day one – for yourself and our customers. We’ll support you with the tools and resources you need to reach new milestones, as you help our customers reach theirs. From in-depth training and coaching, to manager support and network-building opportunities, we’ll help you gain valuable experience, and broaden your skillset.

To find out more visit us at https://jobs.bmo.com/ca/en

BMO is committed to an inclusive, equitable and accessible workplace. By learning from each other’s differences, we gain strength through our people and our perspectives. Accommodations are available on request for candidates taking part in all aspects of the selection process. To request accommodation, please contact your recruiter.

Note to Recruiters: BMO does not accept unsolicited resumes from any source other than directly from a candidate. Any unsolicited resumes sent to BMO, directly or indirectly, will be considered BMO property. BMO will not pay a fee for any placement resulting from the receipt of an unsolicited resume. A recruiting agency must first have a valid, written and fully executed agency agreement contract for service to submit resumes.