Consultant, Database Management
Job Location:
Monthly Salary:
Posted:
Application Deadline:
Vacancies:
Job Summary
Were building a relationship-oriented bank for the modern world. We need talented passionate professionals who are dedicated to doing whats 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
What Youll Be Doing
Youll be joining CIBCs Capital Markets Technology group within Credit Adjudication Technology team. As a Consultant Database Managementyou will be 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.
At CIBC we enable the work environment most optimal for you to thrive in your role.Youll have the flexibility to manage your work activities within a hybrid work arrangement where youll spend 1-3 day per week on-site while other days will be remote.
How Youll Succeed
- Data ModelingYou give meaning to data!Withvery goodtechnical skills you willperform and coordinate complex database modeling in Oracle and Postgres databases. Design the applications data infrastructure using data modeling tools utilities and testing the design development & management of cost-effective and innovative solutions.
- Database Design Development and Maintenance -Engage in designingdevelopingandmaintainingdatabase systems to meet organizational requirements. Work on assigned tasks individually including database management performance monitoring troubleshootingdocumentationand collaboration.
- Strategic Planning -Develop multi-year technology roadmaps that align with the banks vision strategy and businessobjectives. Lead multiple complex projects involving backend systemsnew technology and the enhancement of existing applications.Effectively interact with stakeholders end users business analysts and technical resources to gather requirements prepare design specifications and provide technical support for applications as instructed by senior team members.
- Leadership skills - Act as the database developer and administrator andrundiscussionswith the wider team to ensure the project is on track to meetobjectives. Support and mentor intermediate and seniorpeersby sharing knowledgecollaboratingand problem solving.
Who You Are
- You can demonstrate 7 years experience in Oracle Postgres SQL Server with the following hands-on activities:Conceptual Modeling: Develop conceptual models thatrepresentthe data requirements ata high level.Logical Modeling: Create logical models that specify the relationships between data entities and attributes.Physical Modeling: Design the physical implementation of the database including tables columns and indexes.Data Quality Assurance: Ensure data accuracy consistency and completeness.Database tuning and Performance Optimization: Monitor database performanceidentifyissues andoptimizedatabase performance.Database backup and recovery: Develop disaster recovery plans and perform routine data backups. Code Implementation: Write test andmaintainSQL scripts stored procedures functions and triggers. Analyze and tune specific queries for performance and efficiency. Automation via Shell/Perl Scripting: Developing Linux/Unix shell scripts to automate data loading system monitoring backups and maintenance tasks. Nice to have:Basic understandingof :ETL skillsAgileScrum OOPknowledge data warehouse mining Informatica basicsData BricksEdgeADFCloud technologies.
- Youre skilled at developing conceptual models that represent high-level data requirements creating logical models to define relationships between data entities and attributes and designing the physical implementation of databases including tables columns and indexes.
- You ensure data accuracy consistency and completeness through rigorous data quality assurance and you proactively identify and address performance bottlenecks to optimize database performance.
- You give meaning to data. You enjoy investigating complex problems and making sense of information. Youre confident in your ability to communicate detailed information in an impactful way.
- Youre digitally savvy. You seek out innovative solutions and embrace evolving technologies. You can easily adapt to new tools and trends.
- You love to learn. Youre passionate about growing your knowledge and you know that there is no limit to what you can achieve.
- 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
CIBC is committed to clarity in our hiring process. All roles posted are opportunities were actively recruiting for unless stated otherwise.
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 test (such as simulation coding French proficiency).
We use artificial intelligence tools during the recruitment process. 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 23rd FloorEmployment Type
RegularWeekly Hours
37.5Skills
Azure Data Factory Database Management Databricks Platform ETL (Informatica) Informatica PowerCenter Microsoft Azure SQL Microsoft SQL Server Oracle PostgreSQLRequired Experience:
Contract
