Database analyst Jobs in Windsor, ON

The Rock Family of Companies is made up of nearly 100 separate businesses spanning fintech, sports, entertainment, real estate, startups and more. We’re united by our culture – a drive to find a better way that fuels our commitment to our clients, our community and our team members. We believe in and build inclusive workplaces, where every voice is heard and diverse perspectives are welcomed. Working for a company in the Family is about more than just a job – it’s about having the opportunity to become the best version of yourself.

As a Senior Database Administrator, you’ll ensure the databases that support our technology systems are designed and performing as needed and provides the necessary data to the appropriate team members.

About the role

Work with our developers and business analysts to create and modify our database structure

Proactively monitor and optimize the performance of the database servers

Perform database maintenance tasks, including backups / restores, updating statistics, rebuilding indexes, etc.

Work with our data engineers to help map data in our production databases to our data warehouse

Maintain system security and data integrity

Work with our systems engineers to ensure optimal hardware and storage subsystems

Develop, manage and maintain a strong disaster recovery and high availability plan

Install, upgrade and patch the database servers

Participate in code and design reviews

Participate in production code

Mentor and coach other team members

About you

Minimum Qualifications

Bachelor’s degree in computer science or a related field or equivalent work experience

Preferred Qualifications

Designing data models for both DynamoDB and Aurora based on application requirements, considering data access patterns and scalability need

Implementing efficient partitioning strategies for large datasets in DynamoDB.

Selecting appropriate database configurations for Aurora depending on workload (e.g., MySQL, PostgreSQL).

Monitoring database performance metrics for both DynamoDB and Aurora, identifying bottlenecks and implementing tuning strategies.

Optimizing query performance by analyzing access patterns and adjusting indexes in DynamoDB.

Tuning database parameters in Aurora to improve query execution and throughput.

Implementing robust backup and recovery strategies for both DynamoDB and Aurora, including point-in-time restores.

Managing data replication across availability zones for high availability.

Performing data migrations between different cloud DB technologies.

Enforcing strict security policies on both DynamoDB and Aurora, managing user permissions and access controls.

Implementing data encryption at rest and in transit for sensitive data.

Developing automation scripts using AWS tools to streamline database management tasks like provisioning, patching, and backups.

Leveraging Terraform to manage database infrastructure.

Troubleshooting database issues and providing technical support to application teams.

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.

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.

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 [email protected] .

The Company is an Equal Employment Opportunity employer, and does not discriminate in any hiring or employment practices. The Company provides reasonable accommodations to qualified individuals with disabilities in accordance with state and federal law. Applicants requiring reasonable accommodation in completing the application and / or participating in the employment application process should notify a representative of the Human Resources Team, The Pulse, at [email protected].

J-18808-Ljbffr