Senior Database Administrator

At CAA Club Group, we are passionate about keeping our Members safe - whether they are on the road, at home, or travelling abroad. As a trusted Member-based organization, we provide products and services that are essential to Members' safety and peace of mind. With over 2.6 million Members across Ontario and Manitoba, we advocate on issues such road safety and infrastructure, the environment, seniors' mobility, and consumer protection. Associates share in each other's successes, drive change and support each other while cultivating a great working environment to deliver on what is best for our Members. CAA SCO Systems & Services Inc. is a member of the CAA Club Group of Companies.

Are you ready to join an award-winning, purpose-driven culture? Welcome to the CAA Club Group of Companies (CCG), where purpose leads to passion

• At CCG, we are committed to delivering an exceptional Associate experience. We offer:
• Work-life harmony with access to an award-winning holistic wellness program,
• Continuous learning through our robust corporate curriculum and education reimbursement program,
• Incredible rewards, travel incentives, and product and service discounts,
• Pay-for-performance and best-in-class recognition programs, and
• Competitive benefits that include a defined contribution plan, personal spending account, and so much more.

Join our growing team where everyone belongs

What You Will Do

• Ensure the proper design, implementation and deployment of databases in conjunction with the relevant cross functional teams
• Conduct research and make recommendations on database products, services, protocols, and standards
• Work with the application development team to develop database architectures, coding standards, and quality assurance policies and procedures
• Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of databases
• Document and review database design to ensure optimal database performance, providing analysis and recommended improvement opportunities to management
• Establish appropriate end-user database access control levels
• Configuration planning and installation of mostly MS-SQL databases
• Performance and general health / capacity monitoring and day-to-day database administration duties
• Assist with routine maintenance including database rebuilds/re-indexing/expansion and archiving as needed
• Troubleshoot SQL database/server issues and assist in the resolution of application-related problems
• Provide day-to-day support to production systems as assigned or required
• Administer database security, establish effective security controls, and be primary point of contact for audits
• Other duties as assigned

Please note, salary range is not inclusive of total compensation. The expected salary range for this position will be impacted by factors such as the successful candidate's skills, experience and working location, as well as the specific position's business line, scope and level. Candidates with salary expectations outside of the range are encouraged to apply.

Who You Are

• College Diploma or University Degree in the field of computer science
• Minimum 10 years of practical DBA experience with sound working knowledge of database structure, theories, principals and practices
• Advanced knowledge and experience with various MSSQL software installations and database configuration is required and including: Always On Availability Groups, Database Mirroring, Log Shipping and failovers.
• Experience with MSSQL 2019/2022 is a must
• Understanding of and experience with client-server computing and relational database environments
• Experience with Data Management and Data Processing flowcharting techniques
• Knowledge of reporting and query tools and practices
• Scripting skills Windows server environments
• Strong understanding of all database structures, theories, principles, and practices
• Working technical experience with designing, building, installing, configuring and supporting databases on both Windows and Unix servers
• Hands-on database Tuning and Troubleshooting experience
• Availability to work weekends and after hours on a rotating basis

Please note that internal applicants are asked to formally express their interest by applying online no later than 10 business days of the position being posted.

Please note that we may use AI tools to help us through the recruitment process.

We are an equal opportunity employer and are committed to providing employment accommodation in accordance with all applicable Provincial Human Rights and Accessibility Legislation. CCG will provide accommodations to job applicants with disabilities throughout the recruitment process. If you require an accommodation, please notify us and we will work with you to meet your needs.