Senior Database Administrator- Dynamo/MySQL

Rock Central LLC; Windsor; On-site; CAD 70,000 - 110,000; Full time

Job summary

Join a dynamic team as a Senior Database Administrator, where you will play a vital role in ensuring the performance and security of our databases. This position involves collaborating with developers and analysts to optimize database structures, perform maintenance tasks, and implement disaster recovery plans. You'll have the opportunity to work with cutting-edge technologies like DynamoDB and Aurora, while also mentoring team members. This innovative firm is dedicated to fostering growth and providing exceptional benefits, ensuring that you and your family have the support you need to thrive. Apply today to be part of a team that is shaping the future of the fintech industry in Canada.

Benefits

Health Benefits

Career Growth Opportunities

Family Support Programs

Flexible Work Environment

Qualifications

• Bachelor's degree in computer science or equivalent work experience.
• Experience with database performance tuning and optimization.

Responsibilities

• Monitor and optimize database performance and security.
• Perform maintenance tasks including backups and updates.
• Collaborate with teams to design and implement database structures.

Skills

Database Performance Monitoring

Database Maintenance

Data Security

Disaster Recovery Planning

Data Modeling

AWS Tools

Automation Scripting

DynamoDB

Aurora

Education

Bachelor's Degree in Computer Science

Tools

Terraform

AWS

Job description

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 [e-mail].