3 Days Left Senior Database Architect

3 weeks ago

Mississauga, Ontario, Canada Verathon Inc Full time
As a member of the Data Governance and Analytics team, the Senior Database Architect will be responsible for architecting, designing, and implementing data structures and tables, and recommending architecture for ETL/ELT pipelines from/to on-prem and cloud data sources. The Senior Database Architect will work closely with the development teams, DBA and business stakeholders to understand business outcomes and requests and translate them into clear, actionable technical requirements. The Senior Database Architect will apply knowledge of SQL, t-SQL, stored procedures, and ETL/ELT to perform PoCs (proof of concept) to ensure the validity of proposed solutions. The Database Architect will work closely with other members of the Enterprise Applications & Data (EAD) team to understand and implement roadmap initiatives to drive business outcomes.

Responsibilities:

- Understand business requirements and perform technical implementations by leveraging knowledge of enterprise applications and technical expertise.
- Strong understanding of data warehouse/data lake implementation methodologies/concepts (Ralph Kimball, Bill Inmon, Dimension modelling, etc.).
- Design and develop efficient techniques for fast, optimized data access and transfer of on-prem or cloud database systems.
- Design, implement, and test novel data structures, data search, query, and retrieval solutions to enable access to and processing of data access across different scales and complex datasets.
- Research and recommend latest and stable data architecture methodologies.
- Provide end user support, system maintenance/security and incident resolution to ensure stable and resilient business operations of enterprise applications.
- Ensure enhancements, changes and systems configurations are appropriately documented.
- Participate in agile team ceremonies including sprint planning, daily stand-ups, backlog grooming, and retrospectives.
- Maintain professional and technical knowledge by attending educational workshops, reviewing professional publications; develop personal networks, and participate in professional groups.

Requirements:

- Bachelor's degree in business, computer science, or a related field of study, or equivalent experience.
- 10+ years of relevant experience (on-prem and AWS cloud).

People Skills:

- Strong problem-solving and analytical skills.
- Comfortable as both a team member and individual contributor/independent thinker.
- Pragmatic problem-solving and decision-making skills with excellent written and verbal communication.
- Relentless passion and commitment to operational excellence, delivering within scope, on time, and within budget to exceed internal customer expectations.

Technical Skills:

- Creating data models (conceptual, logical, and physical) that specify how data is formatted, stored, and retrieved inside an organization.
- Architecting, designing, building, implementing, maintaining, and optimizing databases, tables, data structures to meet business and technical needs, obtaining approval from DBA and Dev Leads as needed.
- Collaborating and advising on appropriate database size, servers, and standardization in cloud (AWS) and on-prem.
- Monitoring and advising enterprise data operations team on ETL/ELT workflows, stored procedures, and other data pipelines to seamlessly transport data between systems (utilizing on-prem and cloud (AWS) data pipeline experience).
- Staying current with industry trends, best practices, and advancements in data management through continuous learning and professional development.
- Implementing data quality tools and practices to detect and resolve data issues.
- Ensuring that strict standards are followed throughout the life cycle of a database, including data modelling, data types, naming conventions, table types, connections, data security, etc.
- Ensuring adherence to regulations and guidelines for data systems.
- Utilizing AWS services like RDS (Relational Database Service), Aurora, and Redshift to manage SQL Server instances.
- Leveraging AWS IAM (Identity and Access Management), security groups for database access control.
- Monitoring AWS cloud health and resource utilization for SQL Server instances.

Preferred Qualifications:

- Experience with QAD or SAP ERP.
- Experience migrating databases from on-prem to cloud.

Physical Requirements: Sedentary Work - Exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, push, pull, or otherwise move objects.

Working Conditions: Generally agreeable working conditions such as those found inside offices or equivalent work areas for more than 70% of the time.

#J-18808-Ljbffr

  • Senior Architect, Data

    4 weeks ago

    Mississauga, Ontario, Canada CEI Fleet Collision and Safety Full time

    Get started on an exciting career at ElementElement employees make a difference in the lives of others every day. We are re-defining the fleet management industry to be people first, then business – delivering on our promise of a superior client experience. This takes hard work and innovation, and we need more like-minded people on our team.What We...

  • Senior Architect, Data

    4 weeks ago

    Mississauga, Ontario, Canada Element Fleet Management Full time

    Senior Data Architect Job DescriptionAt Element, we are re-defining the fleet management industry to be people first, then business – delivering on our promise of a superior client experience. This takes hard work and innovation, and we need more like-minded individuals on our team.What We NeedWe are seeking a Senior Data Architect to join our team. As the...

  • 3 Days Left: Senior Flutter Developer

    4 weeks ago

    Mississauga, Ontario, Canada Myant Inc Full time

    About UsAt Myant, we are creating the world's first expressive and continuous digital presence platform, enabled by integrating technology directly into clothing and augmented by other devices, wearables, and IoT. We see the evolution of society where every member gets to participate from anywhere and anytime through a whole-body experience, mostly in a...

  • Senior Architect, Data

    4 weeks ago

    Mississauga, Ontario, Canada CEI Fleet Collision and Safety Full time

    Get started on an exciting career at Element. Element employees make a difference in the lives of others every day. We are re-defining the fleet management industry to be people first, then business – delivering on our promise of a superior client experience. This takes hard work and innovation, and we need more like-minded people on our team.What We...

  • Database Architect

    3 days ago

    Mississauga, Ontario, Canada Tata Consultancy Services Full time

    About UsTata Consultancy Services (TCS) is a leading IT services, consulting, and business solutions organization. With over 55 years of experience, we have been partnering with many of the world's largest businesses in their transformation journeys. Our unique Location Independent Agile delivery model has earned us recognition as a benchmark of excellence...

  • Senior Scrum Master 3 Days Left

    4 weeks ago

    Mississauga, Ontario, Canada Tamanna Technology Full time

    Job Opportunity: Senior Scrum MasterLocation: Mississauga (Hybrid - 3 days in the office, 2 days remote)Industry: InsuranceOverview:Our direct insurance client is looking for an experienced Senior Scrum Master to join their dynamic team. This role offers a hybrid working arrangement, requiring in-office presence for 3 days per week and the flexibility to...

  • Database Architecture Specialist

    7 days ago

    Mississauga, Ontario, Canada Verathon Inc Full time

    About Us:At Verathon Inc., we are committed to providing exceptional service to our customers and delivering high-quality solutions that meet their needs. We are seeking a talented Senior Database Architect to join our team and contribute to our success.Job Description:This is a senior-level position responsible for leading the design and implementation of...

  • 3 Days Left Python Developer

    3 weeks ago

    Mississauga, Ontario, Canada Synechron Full time

    We are:At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron's progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps,...

  • Senior Java Architect

    3 days ago

    Mississauga, Ontario, Canada Iris Software Inc. Full time

    3 days ago Be among the first 25 applicantsDirect message the job poster from Iris Software Inc.Recruitment Executive – Talent Acquisition at IRIS Software || Ex NTT DATAWe are hiring for Java Architect for our financial client.Required Skills: Java architecture, Spark/ SQLLocation: Charlotte NC OR Irving TX OR Tampa FL (3 days required to work...

  • 3 Days Left: Senior UI Developer

    4 weeks ago

    Mississauga, Ontario, Canada Citigroup Inc. Full time

    Senior UI DeveloperWe are seeking an experienced Senior UI Developer who is passionate about solving business problems through innovation and engineering practices.Responsibilities:Apply depth of knowledge and expertise to all aspects of the software development lifecycle, partnering with stakeholders on a regular basis.Develop and engineer solutions within...

  • 3 Days Left Fuel Accounting Analyst

    3 days ago

    Mississauga, Ontario, Canada Cargojet Full time

    Under the direction of the Senior Manager, Fuel and De-icing, the successful candidate will perform daily reconciliation activities for high-value inventory items such as jet fuel and de-icing fluid. This role requires meticulous attention to detail to ensure timely and accurate reporting, advanced database management skills, and the ability to leverage...

  • Only 24h Left: Senior Backend Developer

    4 days ago

    Mississauga, Ontario, Canada Myant Inc. Full time

    About UsAt Myant, we are creating the world's first expressive and continuous digital presence platform, enabled by integrating technology directly into clothing and augmented by other devices, wearables, and IOT. We see the evolution of society where every member gets to participate from anywhere and anytime through a whole-body experience, mostly in a...

  • Senior Software Architect

    4 days ago

    Mississauga, Ontario, Canada HCLTech Full time

    At HCLTech, we are looking for a seasoned Senior Software Architect to join our team.As a Senior Software Architect, you will be responsible for designing and implementing new or revised application systems and programs in coordination with the Technology Team. Your overall objective will be to build robust, high-performance, large-scale applications.Key...

  • AWS Architect

    2 weeks ago

    Mississauga, Ontario, Canada Jade Global Full time

    time left to apply End Date: April 4, 2025 (25 days left to apply)job requisition id R-102559AWS ArchitectWe are looking for an AWS Architect to join our team and play a key role in designing, deploying, and maintaining cloud infrastructure. The ideal candidate will have a deep understanding of AWS architecture, experience with Infrastructure as Code...

  • AMJA197- Senior Java architect

    4 weeks ago

    Mississauga, Ontario, Canada S M Software Solutions Inc Full time

    Job Title – AMJA197- Senior Java ArchitectClient Name: CITIOffice Location: Mississauga, Canada (Onsite)Type: FulltimeDescriptionClient is looking for someone who can do coding in day-to-day activities as an architect. He/she should have experience with draw.io and PowerPoint. Do not share candidates with 25-30 years of experience as they will not be so...

  • 3 Days Left Lead Python Data Engineer

    2 weeks ago

    Mississauga, Ontario, Canada Synechron Full time

    We areAt Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron's progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps,...

  • AMJA197- Senior Java architect

    4 weeks ago

    Mississauga, Ontario, Canada S M Software Solutions Inc Full time

    Job Title – AMJA197- Senior Java ArchitectClient Name: CITIOffice Location: Mississauga, Canada (Onsite)Type: FulltimeDescriptionClient is looking for someone who can do coding in day-to-day activities as an architect. He/she should have experience with draw.io and PowerPoint. Do not share candidates with 25-30 years of experience as they will not be so...

  • Enterprise Data Solutions Architect

    7 days ago

    Mississauga, Ontario, Canada Verathon Inc Full time

    Company Overview:Verathon Inc. is a leading provider of innovative medical devices and software solutions. We are committed to delivering high-quality products and services that meet the needs of our customers and improve patient outcomes.Job Title: Senior Database ArchitectJob Summary:We are seeking an experienced Senior Database Architect to join our team...

  • 3 Days Left) Manager

    3 weeks ago

    Mississauga, Ontario, Canada Maple Leaf Foods Inc. Full time

    The Opportunity:The Manager of Marketing Insights and Syndicated Research is responsible for the management and effective use of all syndicated information sources used at Maple Leaf Foods. The role ensures that Maple Leaf Commercial teams across North America can fully leverage information and insights from available data to drive timely business decisions....

  • Java Architect

    4 weeks ago

    Mississauga, Ontario, Canada OpsTalents LLC Full time

    Senior Software ArchitectWe are seeking an experienced Senior Software Architect to join our team at {company}. This role will play a key part in shaping the technical direction of our software applications, ensuring they are scalable, efficient, and aligned with industry best practices.About You15 years' relevant experience in software development and...