Senior Database Administrator- Dynamo/MySQL

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.