Senior Database Architect

6 days ago


Toronto, Ontario, Canada Ontario Public Service Full time

About the Role

As a critical member of our team, you will play a key role in designing and developing mission-critical Police applications, leveraging your expertise in Microsoft SQL databases to drive excellence and innovation.

Our ideal candidate has proven knowledge and experience in supporting, administration and tuning of all versions of SQL Server database. They have the ability to prepare technical documentation and build books, and provide technical support.

Key Responsibilities:

  • Design and develop data management structures and large-scale database administration
  • Provide data management expertise in the development of information technology plans and strategies
  • Develop methodologies, techniques, and tools for reactive and proactive, and manual and automated database performance monitoring
  • Troubleshoot and repair problems arising from mission-critical production databases
  • Lead corporate projects for building, maintaining corporate data model, database design or developing Windows-based and Unix-based database systems
  • Develop and implement policies, standards, and procedures for management and use of ministry data
  • Evaluate and recommend technical design features and alternatives to ensure proper procedures for backup, recovery, and security of all ministry databases
  • Propose cost-effective use of new database products, data modelling tools and application development

Requirements:

  • Knowledge of information engineering methodologies, tools, techniques, and database management system design, information architecture, data modelling, database design and warehousing concepts and practices
  • Knowledge of Windows-based computer system technologies, understanding of database management using Windows operating system, and knowledge of data management and applications software
  • Knowledge of database development methodology, programming languages, database concepts, data types, data dictionaries, and data storage and retrieval techniques
  • Knowledge and experience in coding, testing and implementation of SQL, PL/SQL, triggers, stored procedures and others
  • Ability to prepare technical documentation and build books, and provide technical support
  • Proficiency in using testing tools and test, and implement the solution to various environment

Compensation and Benefits

The salary range for this position is $1,852.71 - $2,314.51 per week, based on a full-time schedule and within the location of Toronto or North Bay. In addition to competitive compensation, we offer a comprehensive benefits package, including medical, dental, and vision coverage, as well as a pension plan and paid time off.



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


  • Toronto, Ontario, Canada Tata Consultancy Services Full time

    About the RoleWe are seeking a skilled Senior Database Architect to join our team at Tata Consultancy Services. As a key member of our IT services organization, you will be responsible for designing, building, and administering SQL Server environments that meet the highest standards of quality and performance.


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


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

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


  • Toronto, Ontario, Canada PLANT Architect Inc. Full time

    We are seeking an experienced and licensed Senior Landscape Architect to oversee technical and design aspects of landscape projects in our studio. This role reports to a Partner and works closely with both Architecture and Landscape Architecture teams to ensure consistency and excellence in design from concept through to construction completion.About PLANT...


  • Toronto, Ontario, Canada PLANT Architect Inc. Full time

    About PLANT Architect Inc.PLANT Architect Inc. is a studio of landscape architects and architects who specialize in the making of personal and public space. Our primary areas of specialization include residential and institutional architecture and landscape architecture, adaptive reuse, interiors, urban infrastructure, feasibility studies, and master...

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


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


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

  • Database Architect

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


  • 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 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 PLANT Architect Inc. Full time

    Company OverviewAt PLANT Architect Inc., we are a studio of landscape architects and architects who specialize in creating personal and public spaces. Our areas of expertise include residential and institutional architecture, adaptive reuse, interiors, urban infrastructure, feasibility studies, and master planning.Job SummaryWe are seeking an experienced...

  • Database Architect

    2 weeks 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 Tata Consultancy Services Full time

    About UsTata Consultancy Services (TCS) is a global leader in IT services, consulting, and business solutions. With over 55 years of experience, we've helped many of the world's largest businesses transform their operations.Job DescriptionWe're seeking a highly skilled Senior Database Administrator to join our team. As a key member of our database...