Database Administrator

YM Inc; Toronto; On-site; CAD 70,000 - 110,000; Full time

Job summary

An established industry player is seeking a skilled Database Administrator to enhance their e-commerce systems. In this pivotal role, you will manage SQL Server and MySQL databases, ensuring data integrity and optimal performance. Your expertise in AWS and Shopify integrations will be crucial as you support a range of applications interfacing with e-commerce platforms. Join a collaborative team that values your contributions and offers opportunities for career advancement and continuous learning. If you're ready to make a significant impact in a dynamic environment, this is the perfect opportunity for you.

Benefits

Competitive Compensation Package

Health and Dental Benefits Plan

Paid Sick Days

Employee Discount

Tuition Reimbursement

Ongoing Training and Development

Career Advancement Opportunities

Supportive and collaborative team environment

Qualifications

• 8+ years of DBA experience on SQL Server platforms.
• Strong knowledge of MySQL scripting and Web API tools.

Responsibilities

• Manage installation, configuration, and performance of database frameworks.
• Support e-commerce systems and assist with non-ecomm platforms.

Skills

SQL Server

MySQL

AWS

Shopify

Web API tools

Database management

Education

BA or BS in Computer Science

Mathematics or Statistics

Tools

Shopify

SQL Server Management Studio

AWS Management Console

Job description

YM Inc. was founded on the strength of a single retail store in the heart of downtown Toronto in 1975, under the name Stitches. Today we are one of North America’s leading apparel retailers operating over 700 stores across Canada and the United States under the following banners: Stitches, Urban Planet, Urban Behavior, Sirens, Forever 21, Urban Kids, Suzy Shier, Bluenotes, West 49, Mandee and Charlotte Russe.

Our goal is to sustain performance that exceeds expectations. We are committed to creating a culture where people feel valued and inspired to achieve results. We give our people the appropriate tools, freedom and authority to make decisions. They are accountable for their actions and we recognize their efforts and reward their results. We attract and nurture the best people by providing leadership opportunities, career development and continuous learning. We are committed to leading by example and with integrity. We treat people with respect and dignity, promote the benefits of diversity and address challenges in a direct and compassionate manner. We engage people in our goals and objectives; we listen and act on new ideas where possible. That is our Philosophy.

How you will make a difference:

The Database Administrator (DBA) is responsible for supporting the system management of Windows/SQL, AWS, and Ecommerce platforms. This job is responsible for system maintenance, data integrity, and configuration of SQL servers and cloud platforms. The primary focus for this role is supporting e-commerce systems and other systems interfacing with the e-commerce platforms. The position may also be assigned to work on non-ecomm platforms to assist the other DBAs.

What You’ll Do:

1. Support and manage the installation, configuration, monitoring, and improving performance of database framework.
2. Provide technical assistance to developers, business analysts, and technical support team in troubleshooting application issues and completing users’ requests.
3. Assist in the system and database management of E-commerce platforms, including:
1. Management of Shopify eCommerce integrations and other technical related tasks.
2. MySQL DB management, including reporting function.
3. Maintenance of API setups and configurations.
4. Integrations to Shopify and other applications related to E-comm systems.
4. Document support interactions with and provide recommendations for improvement of the processes.
5. Support other related duties.

What You’ll Need:

1. BA or BS Degree in Computer Science or related filed such as Mathematics, Statistics or equivalent experience.
2. 8+ years DBA experience on SQL Server platforms.
3. Knowledge of MySql scripting and Web Api tools.
4. Experience with Shopify and understanding of integrations related to E-comm.
5. Experience in AWS platform.
6. Knowledge of retail systems is a plus.

What we offer:

1. Competitive Compensation Package.
2. Health and Dental Benefits Plan.
3. Paid Sick Days.
4. Employee Discount.
5. Tuition Reimbursement.
6. Ongoing Training and Development.
7. Career Advancement Opportunities.
8. Being part of an amazing, supportive and collaborative team.

YM Inc. is an equal opportunity employer. If chosen to participate in the selection process, accommodations are available upon request. We will consult with the applicant to provide or arrange suitable accommodation in a manner that takes into account the applicant’s accessibility needs.

This posting is for an open vacancy.

Job Types: Full-time, Permanent

Schedule:

• Monday to Friday
• Weekends as needed

Ability to commute/relocate:

• North York, ON M6A 2W1: reliably commute or plan to relocate before starting work (required)

Experience:

• DBA on SQL Server platform: 8 years (required)
• Integrations to Shopify/Ecomm: 3 years (required)

Work Location: In person