Database Systems Architect

1 week ago


Toronto, Ontario, Canada CI Financial Full time

Job Title: Database Systems Architect

About CI Financial: We are a global wealth management and asset management advisory services company, driven by a commitment to provide individuals and institutions with the highest-quality investments and advice.

Job Summary: We are seeking an experienced Database Systems Architect to join our Infrastructure team. The ideal candidate will have expertise in designing, creating, managing, and troubleshooting AWS Cloud databases used by applications to store and retrieve data.

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)
  • Migrate and Transform data from Sybase Database to PostgreSQL or MySql using AWS DMS and SCT
  • Develop and maintain ETL processes to extract, transform, and load data from various sources
  • Optimize and monitor data pipelines and systems for performance and efficiency
  • 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
  • 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
  • Manage and maintain all DB inventory and standards
  • Participate in on-call rotation and off-hours support activities

Requirements:

  • 7+ years of experience in technical areas such as: DB environments (SQL, Oracle, PostgreSQL), Operating Systems (AIX, Windows, Red Hat), and cloud technologies, notably AWS
  • 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.
  • Good understanding of CI/CD pipeline
  • University Degree in Computer Science or equivalent
  • Relevant Technical Certifications

Salary: $140,000 - $170,000 per year, depending on experience



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


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


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

    Astra North Infoteck Inc. is seeking an experienced Database Systems Architect. This role requires a strong technical understanding of database systems, specifically DB2 on various operating systems.Key Responsibilities:Design and implement high-performance database solutions using DB2 on AIX and other operating systems.Develop and maintain complex batch...


  • Toronto, Ontario, Canada Amazon Full time

    OverviewWe are a fast-paced team at Amazon, building scalable and reliable database services for our customers. Our mission is to provide innovative solutions that meet the evolving needs of businesses in the cloud.About UsWe are part of the Amazon Web Services (AWS) team, which provides on-demand cloud computing platforms and APIs to individuals, companies,...


  • Toronto, Ontario, Canada KDigitalLabs INC Full time

    Job DescriptionWe are seeking a skilled Database System Architect to join our team at KDigitalLabs INC. In this role, you will be responsible for designing and developing database systems that meet the needs of our clients.About the JobThis is a permanent position with a salary range of $60,000 - $80,000 per year, depending on experience.Key...


  • Toronto, Ontario, Canada Apex Systems Full time

    Job Summary:We are seeking an experienced Senior Oracle Exadata Database Architect to join our team at Apex Systems.About the Role:This is a 12-month contract opportunity with a large Financial Institution in downtown Toronto. As a Senior Oracle Exadata Database Architect, you will lead the design and implementation of data warehouses for Global Markets...


  • Toronto, Ontario, Canada Nimbus Distro Full time

    About the RoleWe are seeking an experienced Database Systems Architect to join our team at Nimbus Distro. As a key member of our IT department, you will be responsible for designing and developing database systems that meet the evolving needs of our organization.Job DescriptionThis is a permanent position offering a competitive salary of $90,000 per year,...


  • Toronto, Ontario, Canada Amazon Full time

    At Amazon, we are seeking an experienced Cloud Database Architect to join our Amazon Aurora PostgreSQL Engine team. This is a unique opportunity to design and develop large scale database systems that run across thousands of servers worldwide.About the RoleWe are looking for a technical expert in relational databases and large scale storage system...

  • Database Architect

    4 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...


  • Toronto, Ontario, Canada Amazon Development Centre Canada ULC Full time

    Amazon Development Centre Canada ULC is a leading provider of cloud-based database services. We are currently seeking a skilled Cloud Database Architect to join our team in Toronto, ON, CAN.About the RoleWe are looking for an experienced architect to design and implement highly scalable distributed database systems that provide availability, reliability, and...

  • Database Architect

    2 months 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...


  • Toronto, Ontario, Canada CMiC Full time

    **About CMiC**CMiC is a software Development firm specializing in enterprise financial and cost management systems designed for the Construction and Engineering industries.We are seeking an experienced Database Systems Architect to join our team on an evening shift. As a key member of our database team, you will be responsible for deploying, developing,...


  • 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

    1 week ago


    Toronto, Ontario, Canada Tata Consultancy Services Full time

    Job DescriptionTata Consultancy Services is a global leader in IT services, consulting and business solutions with over 55 years of experience in partnering with some of the world's largest businesses. Our commitment to culture and diversity reflects in our people stories across our workforce implemented through equitable workplace policies and processes.We...


  • Toronto, Ontario, Canada Randstad Full time

    We are pleased to offer a new contract opportunity for Database Developer/ Architect-Start: ASAP-Estimated length: 12 months-Hybrid role in Toronto.About the RoleAs a seasoned Database Developer/ Architect, you will have an opportunity to work with a leading employer in the local market. This is a great chance to advance your career and gain new...

  • Database Architect

    1 week ago


    Toronto, Ontario, Canada Aviso Wealth Full time

    Aviso Wealth is a leading wealth management organization that seeks an experienced Database Architect to join its IT team. With over $130 billion in total assets under administration and management, the company is committed to leadership, innovation, partnership, responsibility, and community.The ideal candidate will possess advanced level experience with...


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

    Sira Consulting, an Inc 5000 company is seeking a skilled Cloud Database Architect to join our team. We are looking for a highly experienced professional who can design and implement scalable database solutions on cloud platforms such as Azure MySQL/Azure SQL.About the Role:This is a remote opportunity that requires a strong understanding of relational...


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


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


  • Toronto, Ontario, Canada Randstad Full time

    Job Opportunity for Database Developer/ArchitectWe are pleased to offer a new contract opportunity for a skilled Database Developer/Architect to join our team in Toronto. This is a hybrid role, with 3 days per week spent working from our office.About the RoleThis is an excellent opportunity for you to work with a leading employer in the local market and...