Position: Database Engineer

Reporting To: Senior Director, Technology & Integration

Location: Mississauga, ON

Start Date: April 2024

Cedric Millar Integrated Solutions and Our Culture

We are ethical and hard-working professionals that are passionate about providing integrated supply chain management solutions (along with supporting services) to manufacturers and shippers across Canada and the US.

Each member of our team plays an important role in executing best-in-class supply chain solutions with the very best in people, process, suppliers, technology, and business intelligence. As a 4PL provider, we continue to develop collaborative cost-effective solutions that create flow, consistent service and eliminate waste in a customer's supply chain.

We add value by providing a variety of services:

Strategic Supply Chain Solutions/Technology, Freight Logistics Services, Small Package Services, Dedicated/Fleet Management Solutions, Pro-Fit Placement Services, and Consulting and Engineering Services.

The Ideal Candidate

• 5-8 years of database design administration and data modelling with strong focus in all versions of SQL Server on both on premise and Azure cloud environments
• Excellent knowledge of T-SQL with minimum of 4+ years of experience
• Experience in writing Stored Procedures / Functions.
• Experience with Snowflake and analytical pipeline is valuable
• Experience with SSIS, SSAS and Good knowledge of DevOps
• Knowledge of programming language such as C# and/or understanding of the various application layers
• Knowledge of data warehousing is desirable, including ETL/ELT patterns
• Highly numerate, detail-oriented, and able to use complex data sets
• Experience applying DevOps practices, automated deployment and testing is desirable
• Possess a comprehensive knowledge of various database design techniques
• Provide database solutions for basic to complex projects.

Responsibilities

• Perform DBA tasks (Indexing, Query Tuning, Manage Database security, etc.).
• Design, optimize and maintain database to meet business requirements
• Write stored procedure, functions and views to support application requirements
• SQL coding, debugging, and optimization on regular basis.
• Design data warehouse ETL patterns as well as implement the pipeline to data transformation.
• Design test cases to perform QA testing on applications being implemented.

• Write technical documents outlining the database set up as well as business requirements supported by the database design.
• Work with team to troubleshoot complex technical issues or business situations that involve critical database processes and hinder the achievement of service level requirements.

Soft Skills

• Strong analytical and critical thinking skills.
• Able to understand the impact of decisions on other disciplines.
• Excellent written and verbal communication skills.
• Excellent organizational skills and attention to details
• A proactive, “service-first” attitude combined with ability to work independently on projects with tight deadlines and minimal supervision.

Our Commitment to You

• An ethical and fair environment that is inclusive, high energy and best in class.
• Training and a structured Onboarding to ensure you are set up to succeed.
• Leadership, coaching and mentorship towards a rewarding carrier in Supply Chain
• The ability to participate in cross functional initiatives that will allow you to grow professionally and personally.
• Competitive overall compensation package that includes paid time off, full benefits and bonuses.
• An ongoing communication framework with senior leaders and company ownership.
• A deep understanding of how your role supports the company's strategy, and how the company's strategy supports you.

Cedric Millar is an equal opportunity employer and employs personnel without regard to race, ancestry, place of origin, color, ethnic origin, language, citizenship, religion, gender identity, sexual orientation, age, family status, disability, physical and/or mental handicap or financial ability.

While remaining alert and sensitive to the issue of fair and equitable treatment for all, Cedric Millar is committed to helping individuals with disabilities participate in the workplace and ensure equal opportunity to compete for jobs. If you require accommodation, please email [email protected] for further assistance. Please note this email address is intended for use only to request accommodation as part of the application process. Any other correspondence will not receive a response.