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.
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.This posting is for an existing vacancy within our team.
Please visit our careers page to see more job opportunities.
