SQL Server Database Design Engineer

1 week ago

Mississauga, Ontario, Canada Apex Systems Full time
Sr Data Architect

Apex Systems is a global IT services provider, and our staffing practice has an opening for a Sr Data Architect with 5+ years' experience as a DBA/ ETL Developer and or Data Architect with a focus on data modelling, with strong knowledge with PostgreSQL, Snowflake, and data warehousing skills, to place at our client an Enterprise Fleet Management company.


Enterprise Fleet Management Company

Permanent

It is best to apply via the medium on which you are seeing this posting.

If you encounter technical difficulties submitting your resume, please send a Word version of your resume to Cole Edwards at .

Please reference Data Architect

Perform Data Architecture support for projects and enhancements.
Craft and execute data management, architecture, integration, and governance strategies
Provide technical leadership for architecture, design, documentation, and maintenance of databases and related systems; creates database storage structures, resolves database issues, and maintains system security
Support development and implementation of business applications that optimize statistical efficiency and data quality
Identify, analyze, and interpret trends or patterns in complex data sets
Monitor daily operations of data loads and identify data discrepancies, data quality issues, and work to ensure data consistency and integrity
Participate in project and enhancement estimation exercises and project team meetings
Provide required input, status on tasks, identification of risks and corresponding mitigations as well as issue management
Collaborate with business partners to transform business requirements into environment specific ETL, reporting, and data validation designs; Design relational databases to support business enterprise applications and physical data modeling according to project requirements for data acquisition and security
Collaborate with internal and external personnel, including system architects, software developers, database administrators, design analysts and information modeling experts to determine project requirements and capabilities, and strategize development and implementation timelines
Review changes to databases to ensure no performance or functionality impacts
Develop architectural strategies for data modeling, design, and implementation to meet stated requirements for metadata management, operational data stores and Extract Transform Load environments
Collaborate with the Application Development team to analyze, identify, design, and implement processes for sourcing new data
Generate DDL scripts from data modelling tool and to ensure the script's proper function
Create and test physical data models for a variety of business data, applications, database structures and metadata tables to meet operational goals for performance and efficiency
Support database administrators, network designers and IT personnel to create effective and secure methods for data safeguarding
Review existing data architectures to determine overall effectiveness and compliance with original objectives, develop comprehensive strategies for improving or replacing underperforming areas and present these plans to managers and executives
Research new technologies, data modeling methods and information management systems to determine which ones should be incorporated into company data architectures, and develop implementation timelines and milestones
Bachelor's degree in data architecture, information management or similar field
At least five years of DBA/data development and data architecture experience (combined)
Proficient in the use of data modeling tools, and producing/maintaining logicaland physical designs
Strong ETL development knowledge (SSIS, ADF (Azure Data Factory), Boomi or equivalent) and data warehouse architecture techniques
Team experience, including working closely with business professionals as well as technical resources and acting as a bridge between the two groups including liaison with vendors
Experience in optimizing, loading, and processing large datasets from different data sources and formats
Demonstrates careful attention to quality and accuracy of data and ETL processes
Creative problem-solver with strong communication skills
Collect business requirements and develop as well as document data models to satisfy those requirements
Adept at query development, report writing, and presenting findings
Familiar with fundamental Data Governance and security concepts and processes
Experience in the Fleet Management business is preferred
Click here to Register for our Talent Network

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law.

If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at .We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law.

If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at .Apex Systems is a world-class IT services company that serves thousands of clients across the globe.

We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package.

  • SQL Database Administrator

    1 week ago

    Mississauga, Ontario, Canada Coforge Full time

    SQL Database AdministratorCanadaFull time roleDBA Responsibilities Responsible for installation, Configuration & managing database server and applying security patches & other Patches for upgrading versions of SQL Server database on different platforms like Unix and Windows. Experience on SQL 2012, 2016 database creations Manage database objects like user,...

  • SQL Database Administrator

    1 week ago

    Mississauga, Ontario, Canada Coforge Full time

    SQL Database Administrator Canada Full time role DBA Responsibilities Responsible for installation, Configuration & managing database server and applying security patches & other Patches for upgrading versions of SQL Server database on different platforms like Unix and Windows. Experience on

  • SQL Database Administrator

    1 week ago

    Mississauga, Ontario, Canada Canada Cartage Group Full time

    An iconic Canadian company with over 100 years of helping companies grow and succeed in Canada, we provide national dedicated fleet solutions, general freight services, managed transportation, fulfillment & distribution, and home delivery. With a national network of terminals, cross-docks, and distribution centers, we are one of Canada's largest and most...

  • Senior .NET Developer/C#/SQL

    1 week ago

    Mississauga, Ontario, Canada Stackitrecruitment Full time

    Our client in Mississauga is looking for a Senior .NET Developer to join their growing team You are a highly skilled Senior .NET Developer who has expertise in the Full Stack, using Microsoft and Javascript technologies. Your responsibilities will encompass the entire software development lifecycle, from designing and implementing diverse programming...

  • Azure SQL DB admin

    1 week ago

    Mississauga, Ontario, Canada Randstad Canada Full time

    One of our major client is looking for a Azure DB admin to join their fantastic team. The successful candidate will join the team in harmonizing multiple Databases and servers. The incoming candidate will be responsible for DB design, installation, configuration, troubleshooting , backup and recovery, performance, security and data...

  • Administrator, Database

    1 week ago

    Mississauga, Ontario, Canada Hitech Space Inc. Full time

    Education: Bachelor's degree Experience: 3 years to less than 5 yearsWork setting: Data processing and computersTasks: Collect and document user's requirements Data Science Design and develop database Design, construct, modify, implement and test data models and database management systems Operate database management systems to analyze data Develop and...

  • Database Analyst

    1 week ago

    Mississauga, Ontario, Canada GTT, LLC Full time

    Database Analyst - Oracle (Remote)Contract Duration 6 monthsJob Description:Job Accountabilities:Advise on our client's DB standards as required on projects (eg. Audit processes, database access, job configuration)The Database Analyst will create new databases (OCAC PDBs - CDBs)AWR reporting, tuning, and optimization of DatabaseUpdates to database schema...

  • Data Engineer Python SQL

    1 week ago

    Mississauga, Ontario, Canada Synechron Full time

    Role: Python Data Engineer(Databricks/Pyspark, SQL, Azure) Mississauga, ON (hybrid/3 days in a week) Looking for an Integration engineer responsible for daily support and project based development of credit risk management systems. ETL developers are responsible for designing and creating the data warehouse and all related extraction, transformation and load...

  • Database Developer

    1 week ago

    Mississauga, Ontario, Canada Synechron Full time

    Database Developer (MemSQL) Mississauga, ON (hybrid/3 days in a week)Overview: We need a senior database developer who has good experience working on MemSQL 10+ years in SQL programming ~ Good understanding in data modeling and schema design ~ Experience with SQL queries ~ Experience in analyze and enhance SQL queries, stored procedures, functions and views...

  • Database, Cloud Architect

    1 week ago

    Mississauga, Ontario, Canada Bell Canada Full time

    Press Tab to Move to Skip to Content Link Select how often to receive alerts (in days): Create alert Our team is advancing how Canadians connect with each other and the world, and developing breakthrough technology plays a vital role in making our purpose a reality. Contribute your experiences, talents and perspectives as we develop innovative digital...

  • Senior Data Engineer, Insurance Data Services

    4 weeks ago

    Mississauga, Ontario, Canada RBC - Royal Bank Full time

    Job SummaryJob DescriptionSenior Data EngineerWhat is the opportunity?As Senior Data Engineer in Insurance Data Engineering Services team within Insurance Technology, you will design, implement, and support Data Engineering solutions and processes in multiple Agile Labs. We are looking for a passionate data management enthusiast with strong data architecture...

  • Senior Data Engineer, Insurance Data Services

    2 months ago

    Mississauga, Ontario, Canada RBC - Royal Bank Full time

    Job SummaryJob DescriptionSenior Data EngineerWhat is the opportunity?As Senior Data Engineer in Insurance Data Engineering Services team within Insurance Technology, you will design, implement, and support Data Engineering solutions and processes in multiple Agile Labs. We are looking for a passionate data management enthusiast with strong data architecture...

  • data engineer

    1 week ago

    Mississauga, Ontario, Canada Clientserver Tech Systems Inc. Full time

    Education: Bachelor's degreeExperience: 1 year to less than 2 yearsTasksData ScienceDesign, develop and implement information systems business solutionsOperate database management systems to analyze dataDevelop and implement data administration policy, standards and modelsDevelop and implement policies and procedures throughout the software development life...

  • SQL Architect

    1 week ago

    Mississauga, Ontario, Canada Coforge Full time

    Job Title: C# Architect Skills: SQL, T-SQL (Queries/Stored Proc/DDL), (C#), ADO pipelines, NUget repo Experience: 7+ Years Location: Mississauga, Ontario Job Type: Full-time We at Coforge are hiring SQL Database Architect with the following skillset: Responsibilities Senior-level SQL experience with T-SQL (Queries/Stored Proc/DDL) - minimum 7 years...

  • OAS/OBIEE Data Engineer

    3 weeks ago

    Mississauga, Ontario, Canada The Cigna Group Full time

    The job profile for this position is Software Engineering Advisor, which is a Band 4 Senior Contributor Career Track Role.Excited to grow your career?We value our talented employees, and whenever possible strive to help one of our associates grow professionally before recruiting new talent to our open positions. If you think the open position you see is...

  • Senior Data Engineer, Insurance Data Services

    1 week ago

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

    Job Summary Job Description Senior Data Engineer Exciting Opportunity Join our team as a Senior Data Engineer in Insurance Data Engineering Services team within Insurance Technology. Your main responsibilities will include designing, implementing, and supporting Data Engineering solutions and processes in multiple Agile Labs. We are seeking an enthusiastic...

  • Administrator/in, IT-Administrator/in

    1 week ago

    Mississauga, Ontario, Canada Pharma Medica Research Inc. Full time

    Pharma Medica Research (PMRI) is a Contract Research Organization that strives for innovation and original solutions in a highly regulated and competitive industry. We are a full service contract research organization specialized in conducting early phase clinical trials in healthy volunteers, special and patient populations. We are currently looking for an...

  • Net Developer

    1 week ago

    Mississauga, Ontario, Canada Broadbase Human Resources Full time

    DeliverablesDesign, Configure, develop and optimise based workflows for the Infor Public Sector application object modelCreate new or update existing .net web applications that integrate with Infor Public Sector applications using SOAP or REST protocolsReview and convert existing Oracle 19c packages to workflows or REST based solutionsKey Skills:Must have...

  • Database Developer with MemSQL

    1 week ago

    Mississauga, Ontario, Canada Synechron Full time

    Senior Database Developer (MemSQL) Position at SynechronLocation: Mississauga, ON (hybrid work arrangement - 3 days in the office)Overview: Synechron is seeking a highly experienced senior database developer specialized in MemSQL.Requirements:10+ years of solid experience in SQL programmingExpertise in MemSQLIn-depth knowledge of data modeling and schema...

  • Data Architect

    1 week ago

    Mississauga, Ontario, Canada goeasy Full time

    Embark on a journey with one of Canada's fastest growing companies – welcome to goeasy We have been honored with recognitions such as Waterstone Canada's Most Admired Corporate Cultures, the 2022 Report on Business Women Lead Here, Report on Business for Canada's Top Growing Companies and TSX30 as one of the best performing companies on the TSX. We've also...