19 Nov
|
Bank N.a.
|
Toronto
Job Family Group: Technology Senior DB2 DBA Drive the Data Platforms Powering One of Canada's Leading Financial Institutions Our technology teams play a critical role in delivering secure, reliable, and innovative banking solutions that millions of customers depend on every day. 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. Robust expertise in database design, implementation, administration, and maintenance. ~ Solid experience with z/OS, JCL, TSO/ISPF, and mainframe technologies. ~ Strong SQL performance tuning and query optimization capabilities. ~ Deep understanding of Db2 security architecture and controls. ~ Experience with Db2 data sharing environments and high-availability solutions. ~ Understanding of the Software Development Life Cycle (SDLC) and change management practices. ~ Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent practical experience. Db2 Connect configuration and implementation utilizing AT-TLS Data replication technologies IBM Change Management Tool Catalog Manager IBM Query Monitor IBM Log Analysis Tool ServiceNow Additional assets: Knowledge of COBOL, PL/I, Assembler, REXX, or CLIST Experience with data modelling and tools such as PowerDesigner 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. A culture that values inclusion, collaboration, and continuous learning 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 .
📌 DBA Senior (Toronto)
🏢 Bank N.a.
📍 Toronto