Senior Database Administrator- Dynamo / MySQL

Rock Central LLC; Windsor; On-site; CAD 80,000 - 120,000; Full time

Job summary

Join Rock Central LLC as a Senior Database Administrator, where you will ensure database integrity, performance, and security for innovative fintech solutions. Collaborate with developers and analysts while enjoying competitive benefits and opportunities for career growth in Windsor's tech hub.

Benefits

Health benefits

Career growth opportunities

Supportive work environment

Qualifications

• Minimum qualification includes a Bachelor's in Computer Science or related.
• Experience in designing data models for DynamoDB and Aurora.
• Strong understanding of security policies and database performance metrics.

Responsibilities

• Monitor and optimize database server performance.
• Perform database maintenance tasks like backups and updates.
• Develop disaster recovery and high availability plans.

Skills

Database Maintenance

Performance Optimization

Security Management

Data Modeling

AWS Tools

Terraform

Education

Bachelor’s degree in computer science or a related field

Tools

DynamoDB

Aurora

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.

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 [emailprotected] .

J-18808-Ljbffr

Create a job alert for this search