Database Administrator (Oracle)

Who we are

Gildan is a leading apparel manufacturing company, with a strong portfolio of brands, including Gildan®, American Apparel®, Comfort Colors®, GOLDTOE®, Peds®, and under the Under Armour® brand through a sock licensing agreement. With close to four decades of developing global manufacturing expertise, Gildan is one of the world’s most efficient, ethical, and sustainable apparel manufacturers. Founded in Canada, Gildan operates out of roughly 30 locations worldwide and sells its products in 60+ markets globally. Together with its 50,000+ employees, Gildan operates with a proven commitment to industry-leading Environmental, Social, and Governance (ESG) practices throughout its supply chain in accordance with its comprehensive ESG program embedded in the Company's long-term business strategy. More about the company at gildancorp.com

The opportunity

Reports to the IT infrastructure Manager, this position is focused on ensuring that all areas of Database operation function smoothly. This position includes rotational weekend support and after/before standard office hours to ensure department coverage (7am/7pm).

The role

• To provide support of Oracle/ SQL server/Cloud DB(Snowflake/Azure) management technology and its deployment/usage standards.
• To support and maintain SQL scripts for Store Procedure and Database maintenance tasks.
• To assist BI and development team database design, and SQL script creation/tuning.
• To ensure that all Database environmental changes are appropriately tested and implemented in such a manner that there is no impact to integrated systems and clients.
• To provide and maintain all Database documentation
• Maintain Disaster Recovery Plan.
• Maintain new and existing user profiles.
• Maintain SOX Security Documentation.
• Setup and configure all new Database.
• Maintain, install, and upgrade Database patches.
• Provide client services resolving issues and enhancement requests as they arise.
• Performance tuning and troubleshoot database system including index/memory/cpu/space analysing.
• Document all procedures in the operations folders. Include screen prints where applicable. Ensure that when a procedure changes that the documentation is updated in a reasonable fashion.
• Organize and maintain software license inventories.
• Enforce physical and network security policy.
• Assist in maintenance and client setup of remote Database access connections.
• Research projects as requested by the Infrastructure manager of IT.
• Make recommendations, based on research and solution comparison for new technology acquisitions and enhancements.
• Assist in the effective communication of upcoming planned and unplanned systems changes to users.
• Can also be broken down into areas if the role requires it as follows.

The requirement

Knowledge & Professional

Experience

• At least Bachelor’s degree from a recognized public or private university with a minimum of 5 years of experience in similar role.

Attributes

• Good crisis management, self-control, and stress management skills.
• Capacity to understand and evaluate priorities and urgencies.
• Good interpersonal and customer service skills with a desire to collaborate with others.
• An open-minded professional with a positive attitude, manner, and behavior.
• Have the ability to adapt to a changing environment in a professional and impactful way.
• Work under pressure and potentially to take on the challenge of performing the job.
• Excellent written and spoken communication skills in English.
• In depth knowledge on Oracle and SQL servers.
• Strong knowledge on Database Cloud solution.
• Azure cloud solution will be an asset.

What's in it for you?

• Join a publicly traded company dual-listed on NYSE and TSX with great potential
• Be part of a workplace where meaningful connections and teamwork are celebrated
• From local to international, be ready to work alongside a diverse group of colleagues
• Benefit from mentorship and continuous development opportunities
• Take advantage of our attractive benefits packages

You don't meet all criteria outlined above? Include your transferrable skills and unique experience in your application!

We thank all applicants for their interest, however only those selected for interviews will be contacted.

Come as you are:

Join a company that recognizes the importance of diversity, equity, and inclusion to create a successful and collaborative work environment. As an equal-opportunity employer, we value and embrace all the characteristics that make you uniquely you and seek to provide everyone with an equal chance to succeed. Because equity and inclusion matter at Gildan.