Database Administrator

About Us

As Canada's largest automobile association, we are passionate about keeping our Members safe - whether they are on the road, at home, or travelling abroad. Meeting the diverse needs of our 2.5M+ Members requires high performing, forward thinking, and innovative people who work collaboratively to keep propelling our business forward.

Who we are

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!

Position Details

What you will do -

• Design, configure and deploy MSSQL Servers and databases (versionsSQL2016/17/19/2022) on premises and public clouds
• Assess and develop long-term strategic goals for production and non-production database environments with stakeholders and department managers
• Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development
• Collaborate with application development teams to develop database architectures, coding standards, and quality assurance policies/procedures
• Participate in IT development projects through data modeling, developing logical and physical database designs
• Document and review database design to ensure optimized data environments
• Participate in the Change Management activities and assist in code deployments and data conversions
• Establish appropriate end-user database access control levels
• Performance and general health / capacity Database Systems monitoring and daily database administration operations and tasks
• Capacity planning, tuning and load balancing of Database servers
• Routine Database maintenance - database rebuilds/re-indexing/expansion and archiving.
• Troubleshooting database/server problems and assisting in various problem resolution as it related to Database Systems
• Database systems upgrades, conversions and patching
• Providing enterprise-wide support for storage and Database backups administration
•  Providing daily support for Database production systems including rotational 24/7 coverage and after hours support
• Providing daily support for NonProduction environments; assisting development teams as required
•  Administering Database security and establishing effective security controls, participating in Compliance and Audit initiatives
• Design and implement Highly Available systems ensuring Business Continuity, placing necessary Disaster recovery, Data Loss prevention, Data archiving mechanisms to ensure effective protection and integrity of Database systems

Who You Are -

• Minimum 5 years of Microsoft SQL Server (primary/mandatory) and Oracle (secondary/asset) Database platforms knowledge and hands-on experience
• Solid practical knowledge and hands-on experience of deploying Microsoft DB HighAvailability solutions: Always On Availability Groups, Clustering and Mirroring
• College Diploma or University Degree in the field of computer science
• Experience with designing, installing, configuring and supporting databases on both on-premises and public cloud platforms in both Production and NonProduction environments
• Hands-on Database Tuning and Troubleshooting experience
• Strong communication skills
• Able to prioritize and execute tasks in a high-pressure environment
• Experience working in a collaborative team-oriented environment
• Knowledge of reporting and query tools and practices
• PowerShell, Python and Unix scripting skills
• Microsoft SQL Certification is preferred
• Oracle Certification (OCP) is an asset

Our Commitment

We are an equal opportunity employer and are committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act, 2005 (AODA). CAA 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.

As an organization we are focused on safety, which includes the safety and well-being of our Associates. Therefore, you must be and remain fully vaccinated as a condition of employment.