Senior Cloud Database Platform Engineer

Quality Control Specialist - Pest Control; Windsor; On-site; CAD 90,000 - 130,000; Full time

Job summary

A leading technology company in Windsor seeks a Senior Cloud Database Platform Engineer to manage and optimize database solutions. The ideal candidate will possess extensive experience in database development, AWS technologies, and implementation of best practices in cloud environments. The role includes mentoring and collaboration within a team-oriented environment, along with a commitment to ensuring data security and compliance.

Benefits

Health benefits

Career growth opportunities

Support for work-life balance

Qualifications

• 6+ years of experience developing database solutions.
• Expertise in Relational data modeling and database optimization.
• Strong knowledge of database internal engines.

Responsibilities

• Designing, implementing, and maintaining database systems.
• Creating technical documents and database scripts.
• Mentoring junior developers and coaching best practices.

Skills

Database development

Performance tuning

Cloud platforms

Automation

C#

Python

SQL Server

PostgreSQL

MySQL

Terraform

AWS Technologies

Education

Bachelor's degree in related field

Job description

We are seeking a skilled and experienced Senior Cloud Database Platform Engineer (Senior DBE) to join our team. As a Senior DBE, you'll be responsible for designing, implementing, and maintaining our database systems to ensure optimal performance, security, and reliability. The ideal candidate will have a strong background in database development, performance tuning, cloud platforms, and automation. This role involves developing technical documents, coaching developers, assisting application teams, and creating functional and non-functional requirements. The Senior DBE will build scalable database solutions using AWS services, develop Infrastructure as Code (IAC) modules using Terraform, and create database CI/CD pipelines. As a Senior DBE, mentoring junior members of the team is expected. On-call availability is required.

With the backing of Rocket, RIS is able to capitalize on the creativity and growth of a startup environment with the stability and enterprise experience of a mature company. At RIS, Canadian talent is able to collaborate, design, build, test and return a full range of custom IT solutions. RIS is leading the charge to make Windsor Canada's tech hub. Apply today to join a team that offers career growth, amazing benefits and the chance to work with leading industry professionals.

About the role

• Develop technical documents for database structures, designs, configurations, and best practices.
• Coach developers on best practices for database development.
• Assist application teams with on-premises and cloud database solutions.
• Create functional and non-functional requirements for database development.
• Build highly scalable database solutions using AWS services.
• Develop Infrastructure as Code (IAC) Modules using terraform.
• Create database CI/CD pipelines.
• Manage changes in GIT for source control.
• Create database scripts, stored procedures, and functions.
• Create rollback scripts for deployments.
• Deploy database code.
• Implement performance enhancements, including query optimization and indexing.
• Create reports, analytics and data models.
• Ensure quality data creation, presentation, and data flow across systems.
• Monitor, maintain and enhance the performance of existing database solutions.
• Work closely with the database administrators with forecasting storage, disaster recovery, and archiving needs.
• Ensure data security and compliance, safeguarding sensitive information.
• Build automation tools (CI/CD, Unit Testing, IAC, etc.) to streamline database processes.
• Migrate large datastores from on-prem to cloud and from on database engine to another.
• Be self-sufficient in daily activities and project role outs.
• Communicate with Senior Leadership and peer engineers on product rollouts, project milestones & future feature capabilities
• On-call availability.

About you

• Bachelor's degree in a related field.
• 6+ years of experience developing database solutions.
• Expertise with database development.
• Expertise in Relational data modeling.
• Expertise in SQL Server, MySQL, and PostgreSQL with strong database internal engine knowledge.
• Expertise in Terraform.
• Expertise with AWS database technologies.
• Expertise in C# and Python.
• Proficient in DynamoDB or MongoDB.
• Proficient in Non-Relational data modeling
• Experience with multi-terabyte databases.
• Experience with data integrations.
• Knowledge of ERMs.
• Passion for learning.

What you'll get

Our team members fuel our strategy, innovation and growth, so we ensure the health and well-being of not just you, but your family, too! We go above and beyond to give you the support you need on an individual level and offer all sorts of ways to help you live your best life. We are proud to offer eligible team members perks and health benefits that will help you have peace of mind. Simply put: We've got your back. Check out our full list of Benefits and Perks.

About us

Rocket Innovation Studio (RIS) launched in 2019 and has gone on to make its mark in the Canadian fintech industry. Headquartered at 156 Chatham Street in Windsor, Ontario, the company renovated the historic building which began as an auto showroom and garage before becoming a furniture store, the Old Fish Market, the Coach and Horses Pub, and the Loop. In 2020, RIS was joined by Rocket Mortgage with the mission to improve the mortgage process and deliver an excellent client experience for Canadians.

This job description is an outline of the primary responsibilities of this position and may be modified at the discretion of the company at any time. Decisions related to employment are not based on race, color, religion, national origin, sex, physical or mental disability, sexual orientation, gender identity or expression, age, military or veteran status or any other characteristic protected by state or federal law. The company provides reasonable accommodations to qualified individuals with disabilities in accordance with applicable state and federal laws. Applicants requiring reasonable accommodations in completing the application and/or participating in the application process should contact a member of the Human Resources team at [e-mail] .