Administrateur·rice de bases de données/ Database Administrator (Oracle)

TouchTunes • Montreal, QC

6d • Hybrid

About The Position

TouchTunes is looking for a passionate technology professional with a strong focus on Oracle on-premises server management. In this role, you will be part of the Platform DBA team and will play a key role in the design, automation, operation, and optimization of cloud-native data services that power our large-scale, high-availability applications.
You will take ownership of self-managed Oracle data platforms and several AWS-hosted database platforms ensuring security, scalability, resiliency, and cost-effectiveness. This includes infrastructure automation, upgrades, performance tuning, and close collaboration with development teams to ensure optimal data usage and architecture decisions.
As part of the DBA team, you will contribute both to day-to-day operations and longer-term data platform initiatives. You will work with talented, friendly teams to support application development by providing expertise in AWS database services, data reliability, and cloud best practices. This role is integral to the evolution of TouchTunes’ next-generation application and data platforms.

Requirements

• Passion for database management and performance across multiple platforms
• Experience administering Linux-based systems
• Hands-on Oracle administration knowledge
• Oracle Upgrades & Patching: Upgrading databases from 11g/12c to 19c using DBUA or manual methods.
• Multitenant Architecture: Managing Container Databases (CDBs) and Pluggable Databases (PDBs).
• RMAN (Recovery Manager): Expertise in complex recovery scenarios (Point-in-Time Recovery, TSPITR) and integration with S3 or storage-level backups.
• SQL Tuning: Using the SQL Tuning Advisor and manually rewriting queries to optimize execution plans.
• Shell Scripting: Writing Bash or Perl scripts to automate daily health checks, monitoring, and RMAN backups.
• Experience with automation and scripting (Python, Bash, CloudFormation, Ansible, or similar)
• Solid understanding of high-load, internet-facing systems and distributed architectures

Nice To Haves

• Data Guard (asset): Setting up and managing Physical Standby databases, including Active Data Guard for offloading read-only workloads.
• AWR/ASH/ADDM: Deep ability to read Automatic Workload Repository (AWR) reports and Active Session History (ASH) to find the "needle in the haystack" during performance spikes.
• Knowledge of AWS services such as is an asset:
• EC2, Auto Scaling, CloudWatch, IAM, VPC, CloudFormation/Terraform
• Amazon RDS / Aurora (MySQL, PostgreSQL (an asset))
• Amazon DocumentDB
• Amazon MQ/SQS
• Amazon S3
• AWS Database Migration Service (DMS)
• Amazon ElastiCache (Redis)
• College/university degree in computer science, engineering, or equivalent experience
• 3+ years of experience in DB management, SRE, or cloud operations roles

Responsibilities

• Manage, operate, and optimize On-prem Oracle business-critical database and data services
• Support development teams throughout the full application lifecycle, from architecture and planning to production deployment.
• Standardize and automate database provisioning, configuration, scaling, and schema changes using Infrastructure as Code (CloudFormation / Terraform).
• Design and implement backup, restore, disaster recovery, and data retention strategies.
• Ensure high availability, fault tolerance, and performance of production data systems.
• Monitor, tune, and optimize databases and search platforms (queries, indexes, caching strategies, shard/replica design).
• Enforce data security and compliance best practices, including roles and permissions, encryption at rest and in transit, secrets management, and access controls.
• Identify operational inefficiencies and continuously improve reliability, scalability, and cost optimization.
• Maintain detailed Jira tickets associated with tasks and projects.
• Ensure availability of development, staging, and production environments, and automate deployments across them.
• Act as a key escalation and support resource for production data and platform incidents.
• Research new services and data technologies and lead proof-of-concepts to validate improvements.
• Assist in operating, maintaining and optimizing AWS managed database and data services
• Off-hours on-call rotation every 2 weeks (evenings and weekend). Rotations are compensated.

Benefits

• Hybrid Work Environment: Hybrid schedule with both work-from-home and in-office time, with the ability to work anywhere in the world for up to 2 months per year.
• Financial Wellness: Annual performance bonus, long-term company bonus, RRSP matching, life insurance.
• Comprehensive Benefits: Competitive health insurance and disability coverage, a Lifestyle Spending Account, access to telemedicine, and an unlimited sick days policy.
• Commuting Perks: 50% off OPUS cards and discounts on EXO train services.
• Professional Development: Continuous hands-on learning with access to e-learning platform, tuition reimbursement, and peer mentorship.
• Accessibility: An inclusive workplace designed to accommodate people with disabilities.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree