CIBC is building a relationship-oriented bank for the modern world and seeks talented professionals dedicated to clients. At CIBC, employees are empowered to make a meaningful impact and are valued for their contributions. As a Consultant, Database Management, you will join CIBC’s Capital Markets Technology group within the Credit Adjudication Technology team in Toronto. This role involves developing physical database models for database management systems and providing subject matter expertise for production and non-production databases in data development and maintenance. You will work on complex technical issues, mentor employees, and ensure consistency with existing database infrastructure. CIBC supports a hybrid work arrangement, allowing for 1-3 days per week on-site with other days remote.
CIBC is committed to creating an inclusive environment where all team members and clients feel like they belong. We seek applicants with a wide range of abilities and provide an accessible candidate experience. All posted roles are actively recruiting opportunities, and you must be legally eligible to work in Toronto.
Your Key Responsibilities
You will give meaning to data through expert data modelling. This includes performing and coordinating complex database modelling in Oracle and Postgres databases, designing application data infrastructure using modelling tools, and leading the design, development, and management of cost-effective and innovative solutions. You will engage in designing, developing, and maintaining database systems to meet organisational requirements, working individually on tasks such as database management, performance monitoring, troubleshooting, documentation, and collaboration.
Furthermore, you will contribute to strategic planning by developing multi-year technology roadmaps that align with the bank’s vision and business objectives, leading multiple complex projects involving backend systems, new technology, and application enhancements. You will also demonstrate leadership skills by acting as a database developer and administrator, facilitating discussions with the wider team to ensure project objectives are met, and supporting and mentoring intermediate and senior peers through knowledge sharing, collaboration, and problem-solving. You will effectively interact with stakeholders, end users, business analysts, and technical resources to gather requirements, prepare design specifications, and provide technical support for applications.
What You'll Bring
You will bring over seven years of hands-on experience with Oracle, Postgres, and SQL Server. This includes expertise in conceptual modelling to represent high-level data requirements, logical modelling to specify relationships between data entities and attributes, and physical modelling for database implementation including tables, columns, and indexes. You are skilled in data quality assurance to ensure accuracy, consistency, and completeness, along with database tuning and performance optimisation to monitor, identify, and improve database performance. Your experience extends to database backup and recovery, developing disaster recovery plans, and performing routine data backups.
You are proficient in code implementation, writing, testing, and maintaining SQL scripts, stored procedures, functions, and triggers, as well as analysing and tuning queries for efficiency. Automation skills are essential, demonstrated through developing Linux/Unix shell scripts for data loading, system monitoring, backups, and maintenance. A basic understanding of ETL skills, Agile, Scrum, OOP knowledge, data warehousing, data mining, Informatica basics, Databricks, Edge, ADF, and Cloud technologies is considered an asset. Beyond technical skills, you enjoy investigating complex problems, making sense of information, and communicating detailed information effectively. You are digitally savvy, seeking innovative solutions and adapting to evolving technologies, and you are passionate about continuous learning and growth. You embody CIBC’s values of trust, teamwork, and accountability.
Why CIBC
At CIBC, your career goals are a priority, with opportunities designed to tap into your full potential beyond just a paycheck. CIBC offers a competitive salary, incentive pay, banking benefits, a comprehensive benefits programme, a defined benefit pension plan, an employee share purchase plan, and a generous vacation offering. You will also receive wellbeing support and be recognised through MomentMakers, a social, points-based recognition programme. Our modern spaces and technological toolkit facilitate collaboration and innovation.
CIBC cultivates a culture that empowers ambition through initiatives like Purpose Day, a paid day off dedicated to your growth and development. We are committed to clarity in our hiring process and may ask you to complete attribute-based assessments or other skills tests. If you need accommodation during the application process, please contact Mailbox.careers-carrieres@cibc.com.
