Share this Job

Database Administrator

Date: Jun 23, 2022

Location: Thornhill, ON, CA, L3T 0A1

Company: CAA Club Group

About Us

We are currently seeking an Database Administrator with SQL experience to join our Information Technology Department. The successful incumbent will be providing day-to-day maintenance, troubleshooting and monitoring performance of the database. 

Who we are

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 two-million Members requires high performing, forward thinking, and innovative people who work collaboratively to keep propelling our business forward. Life at CAA Club Group is fast paced, performance-driven and rewarding. We value our Associates' career growth and ongoing professional development-- and we regularly recognize their achievements and outstanding results. CAA Club Group (CCG) is known for providing stellar emergency roadside assistance to our motoring Members and non-Members. We work hard and play hard. We're about doing what's right and feeling good about it.

Position Details

Reporting to the Manager, Infrastructure and Applications, the Database Administrator will be responsible for the following:

  • Interact with Infrastructure Team to design, implement and deploy databases.
  • Assess and develop long-term strategic goals for production databases with stakeholders and department managers.
  • Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development.
  • Work with application development team 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 database design through data modeling, review design to ensure optimized data environments.
  • Assist in promotions, data conversions.
  • Establish appropriate end-user database access control evels.
  • Configuration planning and installation of mostly MS-SQL and Oracle databases.
  • Performance and general health / capacity monitoring and daily database admin
  • Tuning and load balancing of servers.
  • Routine maintenance - database rebuilds/re-indexing/expansion and archiving.
  • Troubleshoot SQL/Oracle database/server problems, and assist in the resolution
  • Server upgrades and conversions.
  • Apply database patches as required to both Production and Test databases.
  • Provide enterprise-wide support for storage and backup administration.
  • Provide daily support to production systems as assigned; involves week end and after hours support on a rotating basis.
  • Provide DBA support to development/implementation projects as assigned, doing installations, database loading, conversions, testing etc.
  • Prepare change control documentation.
  • Administer database security, establish effective security controls, and conduct audits.
  • Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of databases.
  • General Database Administration, Performance and Health / capacity monitoring.
  • Backup and recovery of local and remote replicated databases.

Who You Are:

  • Minimum 5 years’ experience in IT operations with strong understanding of database structures, theories, principles, and practices
  • 3-5 years MS-SQL Server 2012 and 2016 knowledge and experience is required
  • College Diploma or University Degree in the field of computer science
  • Technical experience with designing, building, installing, configuring and supporting databases on both Windows and Unix servers.
  • Hands-on database Tuning and Troubleshooting experience.
  • Experience with Data Management and Data Processing flowcharting techniques
  • Ability to present ideas in user-friendly manner and language
  • 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
  • Unix Bourne and or Korn shell script writing.
  • Rocket/IBM universe DB experience would be an asset.
  • Microsoft SQL Certification is preferred
  • Oracle Certification (OCP) would be 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.