Consultant, Database Management

We’re building a relationship-oriented bank for the modern world. We need talented, passionate professionals who are dedicated to doing what’s right for our clients.

At CIBC, we embrace your strengths and your ambitions, so you are empowered at work. Our team members have what they need to make a meaningful impact and are truly valued for who they are and what they contribute.

To learn more about CIBC, please visit CIBC.com

What You'll Be Doing

You’ll be joining CIBC’s Enterprise Data & Technology Operations Team as a Consultant, Database Management to Manage, Secure and Optimize our organization’s data systems.

The role is responsible for developing physical database models for database management systems, providing subject matter expertise in production and non-production databases for data development and maintenance. The role works on complex issues involving one or more technical areas, mentoring employees in database development and ensuring consistency and integration with existing database infrastructure. The role troubleshoots complex issues for all levels, analyzing data from various sources related to database structure and application to develop solutions that address problems or performance improvements. The role exercises independent judgement and decision making within ownership of projects, extracting and analyzing data requirements from information, and generating logical data models that represent business data needs and business rules.

At CIBC we enable the work environment most optimal for you to thrive in your role. Details on your work arrangement (proportion of on-site and remote work) will be discussed at the time of your interview.
How You'll Succeed

• Design and Development – Design, install, configure and maintain reliable database systems ( Oracle/ Oracle Appliance – Exadata) to support business applications and data processing functions.

• Performance Tuning – Monitor database performance and conduct tuning to ensure efficient data retrieval, minimizing latency and optimizing resources.

• Security and Compliance - Work closely with our Information Security partners to build and regularly update the roadmap related to Data Security domain. This includes working closely with Data Governance, Enterprise Architecture and other stakeholders to deliver and mature the data security services and capabilities that can be leveraged across the enterprise for protecting the bank's assets and digital crown jewels.

• Data Integrity and Availability  - Maintain database backup, recovery and high availability strategies. Regularly test recovery processes and ensure failover mechanisms are in place.

• User Access Control: Setup and monitor user roles, permissions and access to ensure security while providing necessary access to users.

• Database Design and Development: Work closely with developers and IT teams to design database schemas and support application development needs.

• Automation and Scripting: Automate routine database administration tasks using scripts or tools to improve efficiency.

• Monitoring and Alerting: Setup monitoring tools to detect issues before they impact operations and proactively troubleshoot any problems.

• Documentation: Maintain documentation of database configurations, processes, security measures and system changes.

• Capacity Planning: Analyze database storage, memory, and CPU usage patterns to forecast future capacity needs.

• Support and Troubleshooting: Provide support and guidance to other IT team members regarding database -related issues.

Who You Are

• You demonstrate experience in the following areas:
  • At least 3 years of experience in Oracle database administration.
  • Professional certifications from Oracle, Microsoft and others are also valuable.
  • Effective database administrators must have attention to detail, a strong customer-service orientation and the ability to work as a team.
  • Strong SQL skills, including query optimization and troubleshooting.
  • Experience with database tuning, indexing and partitioning.
  • Knowledge of database backup and recovery processes.
  • Nice to have – Experience with cloud database management (Azure SQL, AWS, etc.) is a plus
• You embrace and champion change. You'll continuously evolve your thinking and the way you work in order to deliver your best.
• Your influence makes an impact. You have ability to manage multiple and changing priorities and meeting deadlines. You know that relationships and networks are essential to success. You inspire outcomes by making yourself heard.
• You’re digitally savvy. You seek out innovative solutions and embrace evolving technologies. You can easily adapt to new tools and trends.
• You're driven by collective success. You know that collaboration can transform a good idea into a great one. You understand the power of an inclusive team that enjoys working together to create a shared vision.
• Values matter to you. You bring your real self to work and you live our values - trust, teamwork, and accountability.

What CIBC Offers

At CIBC, your goals are a priority. We start with your strengths and ambitions as an employee and strive to create opportunities to tap into your potential. We aspire to give you a career, rather than just a paycheck.

• We work to recognize you in meaningful, personalized ways including a competitive salary, incentive pay, banking benefits, a benefits program*, defined benefit pension plan*, an employee share purchase plan, a vacation offering, wellbeing support, and MomentMakers, our social, points-based recognition program.

• Our spaces and technological toolkit will make it simple to bring together great minds to create innovative solutions that make a difference for our clients.

• We cultivate a culture where you can express your ambition through initiatives like Purpose Day; a paid day off dedicated for you to use to invest in your growth and development.

*Subject to plan and program terms and conditions

What you need to know

• 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 we provide an accessible candidate experience. If you need accommodation, please contact [email protected]

• You need to be legally eligible to work at the location(s) specified above and, where applicable, must have a valid work or study permit.

• We may ask you to complete an attribute-based assessment and other skills tests (such as simulation, coding, French proficiency, MS Office). Our goal for the application process is to get to know more about you, all that you have to offer, and give you the opportunity to learn more about us.

Job Location

Toronto-81 Bay, 27th Floor

Employment Type

Regular

Weekly Hours

37.5

Skills

Analytical Thinking, Database Development, Database Management Systems (DBMS), Database Modeling, Mentoring Staff, Performance Improvements, Technical Knowledge