Database Engineer

Rakuten Kobo Inc.•Toronto, ON

8d•Hybrid

About The Position

Rakuten Kobo Inc. offers a casual working start-up environment with a commitment to work/life balance, valuing innovation, creativity, and passion in its employees. The company provides competitive salaries, performance-based annual bonuses, stock options, and training opportunities. The role is for a talented and motivated Database Engineer to join the database engineering team, focusing on ensuring the performance, reliability, and scalability of core ecommerce systems. This position involves tackling challenges related to high-volume transactions, performance, analytics, and process automation, contributing to Rakuten Kobo's mission of enhancing reading lives.

Requirements

Bachelor's degree in Computer Science, Information Technology, or a related field or equivalent practical experience
6+ years of hands-on experience as a Sr Database Engineer, SRE, Sr DBA, Systems Architect or a mix of these roles, preferably within a high-transaction environment with a focus on automation.
Experience with Infrastructure as Code (IaC) principles and tools, specifically for database systems
Experience with Database Platform migrations( Eg: Relational <--> DocumentDB, Oracle <--> postgres, On-Prem <--> Cloud )
Proficiency in writing and optimizing complex queries, stored procedures, and functions.
Writing tools and utilities in Python, bash, powershell.
Solid understanding of database design principles and data modeling for relational and document/NoSQL database systems.
Experience with database performance tuning and optimization techniques, including indexing strategies and query plan analysis
Familiarity with data governance concepts / data security best practices / data privacy regulations(GDPR, CCPA, etc)
Strong expertise with relational database system (PostgreSQL, SQL Server, MySQL, Oracle)
Working knowledge of NoSQL, Document Database systems (MongoDB, Redis, RavenDB, Memcache)
Windows and Linux Systems
Core networking and storage concepts
Development experience with Python, cli/web/data frameworks
Infrastructure (as code concepts, CI/CD pipelines with Gitlab/Github, Provisioning with Terraform/Ansible, Containers, Docker, Helm Charts, kubernetes)
Familiarity with Systems architecture, Distributed computing architecture, BigData systems, Processes and toolsets

Nice To Haves

Analytical mind with the ability to diagnose complex issues and propose effective, sustainable solutions.
Excellent verbal and written communication skills, with the ability to explain technical concepts clearly to both technical and non-technical audiences.
A team player who thrives in a collaborative environment, enjoys sharing knowledge, and works effectively across departments.
Ability to quickly learn new technologies and adapt to evolving business needs and technology landscape.
A self-starter who takes initiative, anticipates potential issues, and proposes improvements

Responsibilities

Contribute to the design, development, and implementation of robust, scalable, and high-performance database solutions tailored for ecommerce needs.
Proactively monitor, analyze, and optimize database queries, stored procedures, and schema designs to ensure optimal transaction processing and data retrieval.
Implement and maintain robust backup, recovery, and disaster recovery strategies to guarantee continuous availability of our ecommerce platform.
Manage database security, user access, roles, and data encryption to protect sensitive customer and business information
Work closely with software engineers, data engineers, data scientists, product managers, and other stakeholders to understand business requirements and come up with effective, datadriven solutions.
Develop and maintain tools to automate routine database administrative tasks, improving efficiency and reducing manual effort.
Diagnose and resolve complex database issues in production and lower environments with a focus on minimizing downtime.
Participate in knowledge sharing, provide technical guidance to junior team members, and actively seek opportunities to learn new technologies and best practices
Participate in on-call rotations to provide critical support for our 24/7 e-commerce operations.
Create and maintain clear, concise documentation for database designs, configurations, operational procedures and tools.