Database Developer

Purolator Inc; Mississauga; On-site; CAD 75,000 - 95,000; Full time

Job summary

A logistics leader in Peel Region is seeking a skilled Database Administrator to manage database solutions. The successful candidate will hold a degree in Computer Science or IT, with extensive experience in SQL and NoSQL databases, cloud platforms such as AWS, and a commitment to data security. This role is essential as it optimizes performance and supports multi-technology environments through collaboration and effective management.

Benefits

Equal opportunity employer

Diversity and inclusion initiatives

Qualifications

• Proven experience with multi-platform database technologies.
• Hands-on experience with SQL and NoSQL database systems.
• Expertise in data modeling tools.

Responsibilities

• Design and optimize database systems in a multi-technology environment.
• Collaborate with DevOps for cloud database management.
• Monitor and enhance database performance.

Skills

SQL Programming

Database Optimization

Cloud Integration

Data Security

Problem Solving

Education

Bachelor’s degree in Computer Science or Information Technology

Tools

AWS Aurora

MSSQL

DynamoDB

Docker

Kubernetes

Job description

It’s not a package. It’s a promise®.

As Canada’s leading integrated freight, package, and logistics provider, we’ve been helping promises get where they need to be for more than 60 years. How does the magic happen? The journey starts with you . The places we go, the elements we brave, the promises we deliver – it’s all possible because of our people. So, whether you’re looking to build new skills, make an impact in your community, or inspire your team, we go there for you.

Description

Purolator is seeking a skilled and detail-oriented Database Administrator (DBA). The ideal candidate will be responsible to assist with design, development, implementation, and maintenance of multi-platform database solutions. Working closely with cross-functional teams to ensure optimal database performance, security, scalability, and reliability to support our organization's ever evolving, complex data needs.

Responsibilities

Database Development and Design

• Design, implement, and optimize database systems in a multi-technology environment
• Develop efficient database schemas, structures, and indexing strategies to support business applications

Performance Optimization

• Monitor and enhance database performance, scalability, and availability
• Identify bottlenecks and implement strategies for efficient query optimization and tuning

Cloud Integration

• Collaborate with DevOps and cloud infrastructure teams to deploy and manage database solutions
• Utilize cloud-native tools for monitoring, automation, and cost optimization

Data Security and Compliance

• Implement security measures to safeguard sensitive data
• Ensure databases comply with regulatory and organizational standards

Additional Responsibilities

Collaboration and Support

• Work with application developers to integrate databases with front-end and back-end applications
• Provide support for database-related issues, troubleshooting, and incident resolution
• Monitor Incident and request queue and support change management processes

Automation and CI / CD

• Build and maintain database CI / CD pipelines to streamline development and deployment processes
• Leverage Infrastructure as Code (IaC) tools like Terraform or CloudFormation for database provisioning

Documentation and Reporting

• Maintain up-to-date documentation for database structures, configurations, and processes
• Generate reports and dashboards for stakeholders as required.

Education & Experience

• Bachelor’s degree in Computer Science, Information Technology, or a related field. Equivalent experience will be considered.
• Proven experience with multi-platform database technologies (e.g., AWS Aurora Family(Postgres,MySQL), MSSQL, DynamoDB, Azure Cosmos DB, Google BigQuery)
• Hands-on experience with SQL and NoSQL database systems
• Experience with cloud platforms such as AWS, Azure, or Google Cloud

Qualifications

Technical Skills

• Proficiency in database programming languages like SQL, PL / SQL, or T-SQL.
• Familiarity with database migration tools and techniques
• Knowledge of database backup, recovery, and disaster recovery solutions
• Experience with data warehousing and ETL processes such as SSIS is a plus
• Strong Understading of lambda development lifecycle. Experience is a plus
• Strong scripting skills in Python, Bash, or similar
• Knowledge of data modeling tools and methodologies

Soft Skills

• Strong analytical and problem-solving skills
• Excellent communication and collaboration abilities
• Ability to work independently and manage multiple projects simultaneously
• Natural curiosity to learn and explore the unknown

Preferred Qualifications

• Certifications such as AWS Certified Database – Specialty, Microsoft Azure Database Administrator, or Google Professional Data Engineer
• Experience with containerization and orchestration tools like Docker and Kubernetes
• Understanding of machine learning and big data technologies

Posting Details

Location: 530 - Corporate

Working Conditions: Office Environment

Reports to : Manager Technology

Purolator is an equal opportunity employer committed to diversity and inclusion. We consider all qualified applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, Aboriginal / Indigenous status or any other factors considered discriminatory. If you require an accommodation during the recruitment process, we will work with you to meet your needs.