Database Solutions Architect

3 weeks ago

Toronto, Ontario, Canada CI Financial Full time

 

About the Role

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 keen interest in solving highly complex technical problems.

Key Responsibilities

  • 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 We're Looking For

We are looking for a highly skilled and motivated individual with a strong background in database technologies. The ideal candidate will have a strong understanding of database systems, including database design, implementation, and administration. They will also have experience working in a fast-paced agile environment and be able to collaborate with peers, support teams and partners to develop solutions.

Requirements

  • 8-10 years of expertise in technical areas such as:DB environments (MS SQL, Oracle, DB2, Sybase, MySQL, PostgreSQL)Operating Systems (AIX, Windows, Red Hat)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
  • Proficiency in SQL and at least one programming language such as Python, Java, etc.
  • Knowledge of data warehousing concepts and architectures such as star schema, snowflake schema, etc.
  • Good understanding of CI/CD pipeline
  • University Degree in Computer Science or equivalent
  • Relevant Technical Certifications

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
  • Volleyball 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.

  • Database Solutions Architect

    3 weeks ago

    Toronto, Ontario, Canada ZAPCOM GROUP INC Full time

    Database Solutions ArchitectWe are seeking a skilled Database Solutions Architect to join our team at ZAPCOM GROUP INC. As a critical member of our team, you will be responsible for developing high-quality database solutions using MS-SQL queries and procedures. Your expertise will be invaluable in creating custom reports, modifying ERP user forms, and...

  • Database Solutions Architect

    3 weeks ago

    Toronto, Ontario, Canada Astra North Infoteck Inc. Full time

    At Astra North Infoteck Inc., we seek a "Database Solutions Architect" who will spearhead the development of our enterprise data mart, utilizing their extensive experience in large SQL data marts.Key Responsibilities:Design and implement efficient data extraction, load, and reporting solutions for our business partners, utilizing their expertise in...

  • Database Solutions Architect

    2 weeks ago

    Toronto, Ontario, Canada Randstad Canada Full time

    Job Description:We are pleased to offer a challenging opportunity for a skilled Database Solutions Architect to join our team in Toronto. As a key member of our technology team, you will play a crucial role in designing and implementing highly scalable database solutions that meet the needs of our clients.About the Role:Design and develop complex database...

  • Database Solutions Architect

    2 weeks ago

    Toronto, Ontario, Canada Sira Consulting, an Inc 5000 company Full time

    Sira Consulting, an Inc 5000 company is seeking a skilled Database Solutions ArchitectThis is a remote role that offers the opportunity to work with cutting-edge technology and be part of a dynamic team.Salary Range: $120,000 - $180,000 per annum, depending on experienceAbout the Role:We are looking for an experienced Database Administrator to join our team....

  • Database Solutions Architect

    1 month ago

    Toronto, Ontario, Canada Moneris Full time

    Unlock Your Career Potential at MonerisThe SQL Database Solutions Architect will provide technical leadership and oversight on the technical architecture of Moneris, on-premise and cloud-based, database systems to ensure scalability, reliability, security, and operational efficiency.Key ResponsibilitiesProvide technical leadership for the architecture,...

  • Database Solutions Architect

    2 weeks ago

    Toronto, Ontario, Canada Moneris Full time

    OverviewMoneris is a leading payment processing company seeking an experienced Database Solutions Architect to lead the technical architecture of our on-premise and cloud-based database systems.CompensationThe estimated annual salary for this position is $150,000 to $200,000 based on industry standards and location in Toronto.Job DescriptionThe SQL Database...

  • Database Architect

    1 month ago

    Toronto, Ontario, Canada CB Canada Full time

    Job Title: Database ArchitectJob Summary: We are seeking a skilled Database Architect to design and develop database architecture for our clients.Key Responsibilities:* Design and develop database architecture* Develop data integration processes using tools such as Matillion, Microsoft SSIS, or other open source products* Implement and maintain relational...

  • Database Specialist and Solutions Architect

    2 weeks ago

    Toronto, Ontario, Canada Royal Bank of Canada> Full time

    Job OverviewWe are seeking a skilled Database Specialist and Solutions Architect to join our team at the Royal Bank of Canada. In this role, you will be responsible for leading DB2 z/OS projects and initiatives, working closely with experienced DB2 z/OS and IMS DBAs.

  • Database Architect

    4 weeks ago

    Toronto, Ontario, Canada Maarut Inc Full time

    Job Title: Database ArchitectJob Summary:We are seeking a highly skilled Database Architect to join our team at Maarut Inc. The ideal candidate will have extensive experience in designing, implementing, and managing enterprise-level databases.Key Responsibilities:Design and implement scalable database architectures to support business growth.Develop and...

  • Database Architect

    3 weeks ago

    Toronto, Ontario, Canada Nimbus Distro Full time

    Job Title: Database ArchitectCompany: Nimbus DistroJob Type: Full-timeAbout the Role:We are seeking a skilled Database Architect to join our team at Nimbus Distro. The successful candidate will be responsible for designing and implementing database systems to support our business operations.Responsibilities:Design and develop database systems to meet...

  • Database Solutions Architect

    2 weeks ago

    Toronto, Ontario, Canada Amazon Full time

    Job SummaryWe are seeking an experienced Database Solutions Architect to join our team in Canada. This role involves providing technical leadership and expertise in designing and implementing database solutions for our customers.About the RoleIn this role, you will work closely with cross-functional teams to develop and implement database solutions that meet...

  • Senior Database Architect Lead

    2 weeks ago

    Toronto, Ontario, Canada Maarut Inc Full time

    Job SummaryMaart Inc is seeking a highly skilled Senior Database Architect Lead to lead the development and implementation of database solutions.About Maarut IncMaarut Inc is a leading organization in the industry, committed to delivering innovative solutions. We offer a dynamic and collaborative work environment, competitive salary, and opportunities for...

  • Database Systems Architect

    2 weeks ago

    Toronto, Ontario, Canada Astra North Infoteck Inc. Full time

    Job Title: Database Systems ArchitectWe are seeking a skilled Database Systems Architect to join our team at Astra North Infoteck Inc. in a full-time position.About the Role:The ideal candidate will have a minimum of 6-8 years of experience in designing and implementing large-scale database systems, with a strong focus on data extraction, design, load, and...

  • Database Architect and Engineer

    2 weeks ago

    Toronto, Ontario, Canada Randstad Canada Full time

    Job SummaryWe are seeking a highly skilled Database Architect and Engineer to join our team at Randstad Canada.About the RoleThis is a 12-month contract opportunity for a Database Developer/Architect to work with a leading employer in the local market. The successful candidate will have the opportunity to work on various application development teams,...

  • Database Systems Architect

    3 days ago

    Toronto, Ontario, Canada pt Health Full time

    OverviewLifemark Health Group, a market leader in customized healthcare solutions, is seeking an experienced Database Systems Architect to join our Application Development Team.Job SummaryWe are looking for a highly skilled Database Systems Architect to design and implement database systems that meet the needs of our C# and .NET Core applications. The ideal...

  • Cloud Database Architect

    4 weeks ago

    Toronto, Ontario, Canada Amazon Full time

    Transform Database Services in the CloudWe're looking for a talented Cloud Database Architect to help us revolutionize the way databases are built for the cloud. As a key member of our team, you'll have the opportunity to design and develop high-performance, scalable database systems that meet the needs of hundreds of thousands of AWS customers. If you're...

  • Database Architect

    2 weeks ago

    Toronto, Ontario, Canada Interac Corp. Full time

    Unlock Your Potential as a Database Architect at Interac Corp.At Interac Corp., we're redefining the way Canadians interact with their money. As a leading fintech company, we're shaping the future of digital payments and transforming lives. If you're passionate about innovation and customer-centricity, join our dynamic team of experts.We're seeking an...

  • Senior Database Architect

    2 weeks ago

    Toronto, Ontario, Canada CA001 Marsh Canada Limited Full time

    Job DescriptionWe are seeking a highly skilled Data Platform Engineer to join our team at Marsh McLennan Canada Limited in Toronto, Ontario. This is a hybrid role that requires working at least three days a week in the office.In this exciting position, you will have the opportunity to design, implement, and maintain cutting-edge data platforms, working with...

  • Senior Database Architect and Engineer

    6 days ago

    Toronto, Ontario, Canada Randstad Canada Full time

    Job OverviewWe are seeking an experienced Senior Database Architect and Engineer to join our team in Toronto. As a key member of our technology team, you will be responsible for designing and developing complex database solutions that meet the needs of our clients.

  • Senior Database Architect

    2 weeks ago

    Toronto, Ontario, Canada Tata Consultancy Services Full time

    We are seeking a skilled and experienced Enterprise SQL Server Administrator to join our team at Tata Consultancy Services. As an expert in database administration, you will be responsible for designing, building, testing, deploying, and maintaining high-quality database solutions using SQL Server.This is a key role that involves working with various...