Senior Database Administrator (Oracle)

Job Summary

Reporting to the IT Infrastructure Manager, the Senior Database Administrator (Sr. DBA) will serve as the technical authority responsible for the architecture, performance, availability, security, and lifecycle management of Gildan’s global database environment. The role covers Oracle, SQL Server, Azure, and Snowflake platforms and involves supporting global operations through a rotational on-call schedule, including evenings and weekends.

Key Responsibilities

Database Administration & Lifecycle Management

• Architect, configure, and lead the lifecycle management of enterprise Oracle, SQL Server, and cloud database environments across Azure and Snowflake.

• Manage upgrades, migrations, decommissioning, and deployment standards across global database platforms.

Performance Engineering

• Act as a Tier-3 escalation point for complex database performance issues.

• Diagnose and resolve system bottlenecks through advanced analysis of indexing, memory, CPU, storage, and database resources.

Architecture & Development Support

• Advise BI and Development teams on database architecture and optimal data design.

• Review complex SQL scripts and optimize mission-critical stored procedures.

Change Management

• Participate in change governance and validate high-risk database modifications to minimize downtime and disruption to integrated global systems and clients.

Security & Compliance

• Establish and enforce database security policies covering physical, network, and identity management.

• Maintain SOX security compliance documentation and ensure audit readiness.

Business Continuity

• Own, test, and continuously improve enterprise Disaster Recovery (DR) plans.

• Strengthen business resilience by optimizing Recovery Time Objective (RTO) and Recovery Point Objective (RPO) requirements.

Documentation & Asset Management

• Ensure database architecture documentation, SOPs, and technical records remain accurate and up to date.

• Maintain long-term software license and database asset inventories.

Senior Technical Support

• Provide high-level technical support and consultation to internal business units.

• Resolve critical database issues and support strategic enhancement initiatives.

Innovation & Technology Research

• Research emerging technologies and evaluate alternative solutions for database modernization.

• Provide data-driven recommendations for technology acquisitions and cloud infrastructure improvements.

Operational Communication

• Lead proactive and timely communication regarding critical planned and unplanned system changes.

• Coordinate change-related communications with global users and executive stakeholders.