astra-north

Database Administrator - DB2, MS SQL

astra-north

Toronto, Ontario, CanadaFull timePosted May 27, 2026

Job description

Role Description: We are seeking a highly skilled Senior Database Administrator with extensive experience in database management, administration, and optimization. The ideal candidate will have a strong background in DB2 and MySQL, expertise in writing complex queries, and a deep understanding of database integration with Java/Python.

This role requires advanced knowledge of indexing strategies and query optimization to ensure high-performance and scalable database solutions. Top 3 Required Skills:

  • DB2
  • MSSQL
  • Database Management Preferred Skills:
  • Experience with cloud-based database solutions:
  • AWS RDS
  • Azure SQL
  • Knowledge of NoSQL databases:
  • MongoDB
  • Cassandra Key Responsibilities:
  • Design, implement, and maintain database systems (DB2, MySQL) to ensure high availability, reliability, and security.
  • Develop and optimize complex SQL queries to improve performance and efficiency. Implement and manage indexing strategies to enhance query execution speed.
  • Collaborate with development teams to integrate databases with Java/Python applications.
  • Monitor database performance, troubleshoot issues, and implement proactive solutions.
  • Ensure data integrity, backup, recovery, and disaster recovery procedures Provide technical leadership and mentorship to junior database administrators.
  • Stay updated on emerging database technologies and best practices.

Qualifications

& Requirements:

  • Minimum 12 years of hands-on experience in database management and administration.
  • Proven expertise in DB2 and MySQL database systems Strong proficiency in writing and optimizing complex SQL queries.
  • Experience with database integration in Java/Python environments.
  • Deep understanding of indexing strategies and query optimization techniques.
  • Familiarity with database security, backup, and recovery processes.
  • Excellent problem-solving, communication, and teamwork skills Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience)