DESCRIPTION

Purolator is seeking a skilled and detail-oriented database technology developer. 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.

EDUCATION AND 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

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

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.