Oracle Database Administrator

Overview

Groupe Dynamite is a leading fashion digital retailer with two brands at the heart of our success, Garage and Dynamite. With over 300 stores in Canada and the U.S., and more than 4,000 people, we have been making our mark on fashion since 1975.

Our core strengths are rooted in our team, our innovation and our customers. We are proud to hire and retain aspirational leaders who are driven to achieve great things and are recognized for their entrepreneurial spirit.

Position Overview

We are seeking a versatile and highly skilled Oracle Database Administrator (DBA) to manage, maintain, and enhance our Oracle-based infrastructure. This role will focus on administering Oracle Database environments, with expertise in Oracle Cloud Infrastructure (OCI), Oracle Retail Merchandising System (RMS), and supporting tools. The candidate will also manage Linux application servers, develop automation scripts, and collaborate across teams to support business objectives.

This is a critical role requiring in-depth experience in both on-premises and cloud environments, technical development skills, and hands-on management of OCI and Exadata systems.

Key Responsibilities

1. Database Administration
   • Manage and monitor Oracle databases, including Container (CDB) and Pluggable Databases (PDB);
   • Perform database upgrades, patching, backups, disaster recovery (DR), and high availability (HA) implementations;
   • Optimize database performance through tuning, capacity planning, and SQL query optimization;
   • Automate database processes using scripts and Oracle tools for enhanced efficiency.
2. Oracle Cloud Infrastructure (OCI) Management
   • Administer OCI environments across PROD and DEV setups, ensuring stability and cost-effectiveness;
   • Manage Exadata Database Servers, including patching, upgrades, and troubleshooting;
   • Oversee OCI network configurations, security, and storage solutions (e.g., Object Storage, Archive Storage);
   • Monitor and resolve performance issues in OCI-based databases and related services.
3. Oracle Retail Merchandising System (RMS) Expertise
   • Configure and maintain Oracle RMS to align with business processes;
   • Ensure data integrity, security, and compliance within RMS modules;
   • Collaborate with retail operations and IT teams to resolve RMS-related issues promptly;
   • Perform data extraction, reporting, and integration tasks within the RMS ecosystem.
4. Linux Application Server Management
   • Manage Linux application servers, including patching and upgrades;
   • Ensure seamless interaction between Linux environments and Oracle applications.
5. Development and Automation
   • Develop and maintain automation scripts using Shell scripting, Python, AWK, and PL/SQL;
   • Ability to manage code merging and associated tools;
   • Support internal tools and environments, streamlining IT operations and reducing manual efforts.
6. Collaboration and Support
   • Provide 24/7 support for critical database and infrastructure issues, minimizing operational disruptions;
   • Work collaboratively with application developers, data architects, and business analysts;
   • Document configurations, procedures, and troubleshooting guidelines for the IT knowledge base.
7. Compliance and Security
   • Implement and enforce database security policies, user access controls, and encryption strategies;
   • Ensure adherence to corporate governance and data protection regulations;
   • Conduct regular security and performance audits of database systems.

Required Skills and Qualifications

Technical Expertise

• Strong proficiency with Oracle Database 19c or newer, including RAC and ASM;
• Hands-on experience with Oracle Cloud Infrastructure (OCI) and Exadata systems;
• Advanced knowledge of Oracle RMS, including configuration and integration;
• Expertise in database tuning, indexing strategies, and SQL optimization;
• Proficiency in PL/SQL, Python, and Shell scripting for automation;
• Familiarity with database monitoring and diagnostic tools like OEM, AWR, and ADDM;
• Experience with replication tools, such as Oracle Data Guard or GoldenGate;
• Experience with Oracle RMS cloud an asset;
• JIRA and Confluence knowledge;
• Experience in ERP implementation is a nice to have.

Soft Skills

• Exceptional problem-solving and troubleshooting capabilities;
• Strong planning and communication skills. As part of the role, it will be important to share, plan and communicate with the user community and application owners;
• Effective communication and cross-functional collaboration skills;
• Ability to work under pressure and meet tight deadlines;
• Proactive learning attitude and adaptability to evolving technologies.

Preferred Qualifications

• Experience with managing Linux application servers and environments.
• Familiarity with additional Oracle retail modules or cloud applications.
• Certifications in OCI or Oracle Database Administration are a plus.

At GDI, you will be part of a growing organization that understands the importance of investing in people and offers you:

• A comprehensive compensation package that includes performance-driven bonuses;
• A group retirement savings program with employer matching;
• Flexible group insurance with personalized coverage that meets your needs;
• An employee discount at Garage and Dynamite;
• Exclusive private sample sales;
• A flexible vacation policy;
• And more!

GDI has been repeatedly voted one of Montréal’s Top Employers and one of Canada’s Top Employers for Young People.

Our promise…No day will be like the last—we aim to be better today than we were yesterday. We are committed to employment equity.

Candidates that are retained will be called for an interview.

#LI-NM1