Database Engineer

The Role

We are looking for a talented and motivated Database Engineer to join our database engineering team. In this role, you will be instrumental in ensuring the performance, reliability, and scalability of our core ecommerce systems. You'll work on exciting challenges related to high-volume transactions, performance, analytics and process automation.

Duties:

• Design & Development Contribute to the design, development, and implementation of robust, scalable, and high-performance database solutions tailored for ecommerce needs.
• Performance Optimization Proactively monitor, analyze, and optimize database queries, stored procedures, and schema designs to ensure optimal transaction processing and data retrieval.
• Reliability & Availability Implement and maintain robust backup, recovery, and disaster recovery strategies to guarantee continuous availability of our ecommerce platform.
• Data Integrity & Security Manage database security, user access, roles, and data encryption to protect sensitive customer and business information
• Collaboration 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.
• Automation Develop and maintain tools to automate routine database administrative tasks, improving efficiency and reducing manual effort.
• Troubleshooting Diagnose and resolve complex database issues in production and lower environments with a focus on minimizing downtime.
• Mentorship & Learning Participate in knowledge sharing, provide technical guidance to junior team members, and actively seek opportunities to learn new technologies and best practices
• On-Call Support Participate in on-call rotations to provide critical support for our 24/7 e-commerce operations.
• Documentation Create and maintain clear, concise documentation for database designs, configurations, operational procedures and tools.

Experience and Education:

• 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
• Must have 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)

Tech & Architecture Skills

• 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

Soft Skills We Value:

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

The Perks:

• Flexible hours and hybrid remote working environment
• Subsidized in-office lunches
• Full benefits starting from your first day
• Paid Volunteer days, unlimited sick days, and 3% RRSP matching
• Lifestyle spending account
• Talent and development training budget
• Free Kobo device + free weekly e-book or audiobook
• Weekly Kobo Spark sessions
• Maternity/paternity leave top up
• Dog friendly office