SoM Banner

Database Administrator - Part Time

49 Gervais Dr., Toronto, Ontario, Canada ● Virtual Req #165
Thursday, July 11, 2024

About Spirit of Math:
 
With over 30 years of success, Spirit of Math is an innovative leader in after-school mathematics education for high-performing students. Located at more than 40 campuses across Canada. From our after-school classes and campuses to our expanding series of math workbooks and training for educators, Spirit of Math is changing the equation for inquisitive minds around the world.

 

 

Job Description:

We are seeking a skilled and experienced Database Administrator to join our IT team. The ideal candidate will be responsible for managing and maintaining our database systems, ensuring their performance, security, and availability. This role involves working closely with developers, systems administrators, and other IT staff to support the deployment, configuration, and maintenance of databases in various environments.

Personal Qualities:

This person will be able to balance multiple processes and projects. This person is naturally proactive and goal oriented. This individual will be an independent, strategic thinker. This person values accuracy, consistency and efficiency. This person will naturally focus on being careful and precise in dealing with data and information. This individual will have a probing, factual style of communication. And above all, be fun and creative!

Work Values:

This person has the following work values:

  • Values the relationship between all departments and the needs.
  • Objective & Goals Oriented to a level that influences others.
  • Believes in informed decisions/recommendations and acting on them.

Decision-Making

Ability:

The person in this role is be able make decisions that will positively impact the Applications Users.  You will be responsible for ensuring the applications and all builds are at a 99.8% up-time, and all security and privacy polices are always adhered too. You will have decision making ability to upgrade and patch DB function to ensure up-time and security and user privacy is always the top priority

Education Requirements:

A bachelor’s degree in Computer Science desirable, with a focus on Application Management.

Skills, Knowledge, &

Experience:

  Database Proficiency in configuring and maintaining Database infrastructure for applications.

1. Database Management: Proficiency in configuring and maintaining database systems such as MySQL, PostgreSQL, Oracle, or SQL Server.

2. Performance Monitoring: Expertise in monitoring database performance and troubleshooting issues to ensure optimal functionality.

3. Security Protocols: Knowledge of implementing and managing database security measures, such as encryption, access controls, and auditing.

4. Backup and Recovery: Experience in setting up and managing database backup solutions and disaster recovery plans.

5. Data Modeling: Ability to design and optimize database schemas, tables, indexes, and relationships.

6. Query Optimization: Familiarity with optimizing SQL queries and database performance tuning techniques.

7. Cloud Databases: Understanding of cloud-based database services like Amazon RDS, Azure SQL Database, or Google Cloud SQL, including deployment and management.

8. Scripting and Automation: Proficiency in scripting languages (e.g., SQL, PL/SQL, T-SQL) for automating routine tasks and processes.

9. Technical Support: Strong troubleshooting skills and experience providing technical support to database users.

10. Communication Skills: Excellent verbal and written communication skills for documenting processes, creating reports, and interacting with team members and stakeholders.

 

 

- Experience:

  - 3-6 years of experience in Database Administration, including scripting is required

 

-  Other Requirements:

  - Ability to lift and carry equipment.

  - Willingness to work flexible hours, including evenings and weekends, as needed.

 

 

 

 

 

Key Responsibilities:   This position has the following key responsibilities:

 

 

 

1. Database Deployment: Manage the deployment, configuration, and maintenance of databases across various environments (development, testing, production).

2. System Monitoring and Performance Tuning: Continuously monitor database performance and system resources, optimizing for efficiency and troubleshooting any issues.

3. Security Management: Implement and maintain security measures to protect databases from threats, including encryption, access controls, and auditing.

4. Patch Management: Regularly apply patches and updates to database systems to ensure security and functionality.

5. Backup and Recovery: Develop and maintain backup strategies and disaster recovery plans for critical databases and data.

6. User Support: Provide technical support to database users, addressing issues and training them on new features and functionalities.

7. Incident Response: Respond to and resolve database-related incidents and outages, conducting root cause analysis to prevent future occurrences.

8. Configuration Management: Maintain and document database configurations, ensuring consistency and compliance with organizational standards.

.

     

 

 

 

 

Accountabilities:

The Database Administrator will report to the RTG Division Head and responsible for planning, executing, and delivering integrated application Database and all required development to keep the application fully functional to the market at all times.

 

You will be responsible for tactical planning and communications of changes and materials.

 

Initiatives that you might work on in this role span a variety of areas including national, regional, and local development operations and strategies and plans.

Authorities:

The Database Administrator has the following authorities:

 

1. User Account Management: Creating, modifying, and deleting database user accounts, including setting permissions and managing access controls.

2. System Monitoring and Maintenance: Regularly monitoring database performance, applying updates, and performing routine maintenance tasks.

3. Backup and Recovery Operations: Initiating and managing database backup processes, as well as performing data recovery when necessary.

4. Security Enforcement: Implementing and enforcing database security protocols, including encryption and access controls.

5. Software Installation and Updates: Installing, updating, and configuring database software and related tools.

6. Database Configuration: Managing database settings and configurations, including storage allocation, indexing, and query optimization.

7. Performance Tuning: Performing routine performance tuning and optimization tasks to ensure database efficiency.

  1. checks, replacements, and troubleshooting to ensure optimal performance.

 

Other details

  • Job Family RTG Operations
  • Pay Type Salary
Location on Google Maps
  • 49 Gervais Dr., Toronto, Ontario, Canada
  • Virtual