Database Administrator

Payworks-Inc.; Calgary; Hybrid; CAD 85,000 - 120,000; Full time

Benefits offered by this job

Health Spending Account

Pension plan with employer contributed

Professional development opportunities

Volunteer days

Hybrid work model

3 weeks vacation

Lifestyle Spending Account

Job summary

Payworks, a Calgary-based payroll and HR SaaS provider, seeks a Database Administrator to support SQL Server databases, ensuring availability, performance, and security. Reporting to the Manager and Senior DBA, you will contribute to the operation of our data platforms while growing your expertise.

This role offers a hybrid work model with three days in the office and opportunities for professional development, collaboration with developers, and a focus on secure, scalable data solutions.

Qualifications

• Bachelor's degree in Computer Science, IT, or related field.
• 3–5 years of database administration experience.
• Proficient in SQL for querying and management tasks.
• Hands-on experience with backup and recovery tools.
• Experience with database migration and upgrades.

Responsibilities

• Maintain and optimize SQL Server databases, backups, restores, and performance tuning.
• Provide timely support for database issues and collaborate with developers.
• Implement and enforce database security measures.
• Document configurations and generate performance reports.
• Stay current with database technologies and participate in training.

Skills

Analytical skills

Communication

Problem solving

Independent work

Adaptability

Education

Bachelor's degree in Computer Science/IT

Tools

SQL Server

Backup/Recovery tools

Migration tools

Job description

Doing business to business, person to person.Payworks is a leading workforce management solutions provider and multi-year winner of the Canada's Best Managed Companies program. We are proudly Canadian as well as committed to developing world-class products and providing a progressive workplace culture where Doing Right by Peopleis our purpose.

With clients of all sizes from coast to coast and more than 600 employees, we currently have an exciting opportunity on our Platform Technology team for the right candidate. Because when it comes to great people, there's always room for one more.

DOING RIGHT BY PEOPLE – IT'S WHAT WE DO

Payworks develops proprietary, integrated SaaS-based products in the payroll, human resources and time and attendance space. We create, deploy and maintain our own solutions; this requires the support of a talented but growing and increasingly more complex team. Reporting to the Manager, the Database Administrator (DBA) is responsible for supporting the SQL Server database systems of the organization to ensure their availability, performance, and security. Working under the guidance of a Manager and Senior DBA, you will contribute to the effective and efficient operation of our database systems while building your expertise in a collaborative, supportive environment.

WHY YOU SHOULD CHOOSE PAYWORKS

• Comprehensive employer paid benefits, including a Health Spending Account, for you and your family and excellent pension plan with employer contributions.
  
• Plenty of professional development opportunities.
• Community-minded culture – Receive two paid days per year to volunteer and lots of opportunity to "Pay it Forward".
• Time and flexibility to meet your needs –Hybrid work model with flexible work options, plus 3 weeks vacation to start, flex time and parental leave benefits.
• Cool perks – Annual Lifestyle Spending Account, fun office environment and events, and more!

ADMINISTER & OPTIMIZE – IT'S WHAT YOU'LL DO

• Maintain and optimize – Perform routine database maintenance tasks including backups, restores, query execution and performance tuning. Monitor database performance and tune databases to optimize efficiency. Support Infrastructure in routine maintenance and upgrading of database systems.
• Support and troubleshoot – Provide timely support for database-related issues. Diagnose and resolve database errors and performance problems, and collaborate with developers to ensure database designs meet performance and security requirements.
• Secure and protect – Help implement and enforce database security measures to protect sensitive data. Assist in ensuring databases comply with organizational policies and industry standards. Support the development and deployment of database changes and new applications.
• Document and collaborate – Maintain detailed documentation related to database configurations, procedures, and operations. Generate reports on database performance, usage, and other metrics. Work closely with Database Administrators, Software Developers, IT Operations, and IT Security to support database-related initiatives.
• Learn and grow – Stay updated with the latest database technologies, tools, and best practices. Participate in training and professional development opportunities to enhance your skills and knowledge.

WHAT YOU'LL NEED TO SUCCEED

• Bachelor's Degree in Computer Science, Information Technology, or a related field.
• 3-5 years of experience in database administration, support, and maintenance.
• Proficient understanding of database management systems and SQL for database querying, optimization, and management tasks.
• Hands-on experience with backup and recovery tools and techniques.
• Ability to write and maintain scripts for automation tasks.
• Experience with database migration and upgrade projects.
• Strong analytical and problem-solving skills with the ability to manage multiple priorities effectively.
• Effective communication skills with the ability to work collaboratively across technical and non-technical teams.
• Ability to work independently, adapt to changing priorities, and thrive in a collaborative, fast-paced environment.

We are proud to support a Flexible Work Plan that recognizes the diverse needs and lifestyles of our people. The Database Administrator has the option to work fully out of the Payworks office in Calgary or on a hybrid work model, working in the office at least three (3) days a week.

Payworks is committed to providing an inclusive, accessible environment, and collaborating with employees, clients and guests to identify and effectively remove barriers, in a manner that respects the principles of independence, dignity, integration, reasonable accommodation and equal opportunity. Payworks welcomes and encourages applications from all persons. Individuals applying for employment with Payworks may request accommodations at all stages of recruitment and employment from Human Resources.

Employees at Payworks come from different backgrounds, and we celebrate those differences. We are looking for the best candidate for this opportunity, but do not expect applicants to meet every qualification in order to be considered.

Payworks does not use artificial intelligence (AI) technologies in the screening, assessment, or selection of applicants at any stage of the hiring process.

This posting is for an existing vacancy within our team.