About UsAs 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 areAre 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 DetailsWhat 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 CommitmentWe 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.
