Database Engineer

job
  • CI Financial
Job Summary
Location
Toronto ,ON C6A
Job Type
Contract
Visa
Any Valid Visa
Salary
PayRate
Qualification
BCA
Experience
2Years - 10Years
Posted
14 Jan 2025
Share
Job Description

Senior Database Engineer


At CI, we see a great place to work as one that is a safe place for everyone to have a voice, where people are empowered to take ownership over meaningful work, where there is an opportunity to grow through stretching themselves, where they can work on innovative products and projects, and where employees are supported and engaged in doing so.


We are seeking a highly skilled and motivated individual to join our Infrastructure team as a Database Engineer. The successful candidate will be required to collaborate with peers, support teams and partners to develop solutions, provide advanced technical support, work in a creative, fast-paced agile environment, and show a keep interest in solving highly complex technical problems.


WHAT YOU WILL DO:


  • Provide day-to-day operational and emergency support of core Database DB infrastructure systems including SAN, OS and associated platforms and hosting solutions (On-Prem, Cloud and Hybrid)
  • Design and Implement hybrid DB infrastructure systems that are scalable, stable and efficient
  • Migrate and Transform data from Sybase Database to PostgreSQL or MySql using AWS DMS and SCT.
  • Write CloudFormation and Terraform code to build RDS instances on AWS cloud.
  • Develop and maintain ETL processes to extract, transform, and load data from various sources
  • Designs, creates, manages, and troubleshoots AWS Cloud databases used by applications to store and retrieve data.
  • Optimize and monitor data pipelines and systems for performance and efficiency
  • Developing a migration path to upgrade PostgreSQL to the latest version
  • Administering other aspects of the DB infrastructure (security, scaling, etc.)
  • Monitor DB systems and Identify patterns that affect the performance, reliability, or availability of a system or service and drive them out of the system through automation or other technical innovations
  • Implement automation of recurrent tasks through scripting where possible
  • Maintain documentation regarding configurations, operations and troubleshooting procedures for both internal and customer-facing systems
  • Participate in post-mortem and root cause analysis
  • Participate in evaluating new requirements for DB’s; technical designs, the definition of standards, guidelines, best practices and metrics as directed
  • Responsible for DB incident, problem, change and configuration management processes for the infrastructure platforms, including license management
  • Ensure operational stability of DB’s by maintaining security patching and vulnerability remediation on a regularly scheduled basis
  • Manage and maintain all DB inventory and standards
  • Provide solution and system architecture support for new DB products and services
  • Participate in on-call rotation and off-hours support activities
  • Research industry trends, best practices and new technologies that will provide operational insights to Infrastructure teams


WHAT YOU WILL BRING:


Experience

  • 7+ years of expertise in technical areas such as:
  • DB environments (SQL, Oracle, PostgreSQL)
  • Storage / Backup and Recovery / DR Solutions
  • Experience working in a complex environment, writing scripts for monitoring, creating high and low level design documents
  • Experience with full stack monitoring tools
  • Knowledge of data warehousing concepts and architectures such as star schema, snowflake schema, etc.
  • Exposure working with cloud, notably AWS, will be an asset
  • Operating Systems (AIX, Windows, Red Hat)
  • Good understanding of CI/CD pipeline


Education/Training

  • University Degree in Computer Science or equivalent
  • Relevant Technical Certifications


Knowledge, Skills and Abilities

  • Self-motivated, with a proven ability to motivate and inspire others
  • Proven ability to plan realistic process and solution designs requirements appropriate to identified risk scenarios
  • Must be naturally and innately curious, a lifelong learner, have a thirst for knowledge, and can remain calm and composed in times of uncertainty and stress, inspiring the same in others
  • Strong strategic planning and transformation discipline, which experience building and communicating business cases for technology change
  • Demonstrated ability to build strong relationships with both business and IT stakeholders and leaders, as well as related IT project and operations teams



WORKING CONDITIONS:

  • During peak periods, an irregular work schedule may be expected
  • On-call Required


CI Financial is an independent company offering global wealth management and asset management advisory services through diverse financial services firms. Since 1965, we have consistently anticipated and responded to the changing needs of investors. We are driven by a commitment to provide individuals and institutions with the highest-quality investments and advice.Our commitment to the highest levels of performance means that whatever their position, CI employees must be comfortable in a fast-paced environment that will stretch them to tap into their highest potential. Employees with a healthy dose of ambition, a desire to commit to a curious mindset for continuous learning, and a willingness to go the extra mile thrive at CI.


WHAT WE OFFER


  • Modern HQ location within walking distance from Union Station
  • Flexible & Hybrid Work Program
  • Equipment Purchase Program
  • Training Reimbursement
  • Paid Professional Designations
  • Employee Share Purchase Program (ESPP
  • Corporate Discount Program
  • Enhanced group benefits
  • Parental Leave Top–up program
  • Fitness membership discounts
  • Volunteer paid Days
  • Complimentary vending machines



We are focused on building a diverse and inclusive workforce. If you are excited about this role and are not confident you meet all the qualification requirements, we encourage you to apply to investigate the opportunity further.


Please submit your resume in confidence by clicking “Apply”. Only qualified candidates selected for an interview will be contacted. CI Financial Corp. and all of our affiliates (“CI”) are committed to fair and accessible employment practices and provide reasonable accommodations for persons with disabilities. If you require accommodations in order to apply for any job opportunities, require this posting in an additional format, or require accommodation at any stage of the recruitment process please contact us at , or call 416-364-1145 ext. 4747.

Other Smiliar Jobs
 
  • Toronto, ON
  • 12 Hours ago
  • Toronto, ON
  • 12 Hours ago
  • Toronto, ON
  • 12 Hours ago
  • Toronto, ON
  • 12 Hours ago
  • Montreal, QC
  • 12 Hours ago
  • Montreal, QC
  • 12 Hours ago
  • Toronto, ON
  • 12 Hours ago
  • Toronto, ON
  • 10 Days ago
  • Toronto, ON
  • 10 Days ago
  • Toronto, ON
  • 12 Hours ago