Database Administrator - Part Time

Database Administrator - Part Time

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, 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. They will be proactive and goal-oriented, an independent strategic thinker who values accuracy, consistency, and efficiency. This individual will focus on being careful and precise in dealing with data and information and will have a probing, factual style of communication.

Work Values:

This person has the following work values:

- Values the relationship between all departments and their 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 will be able to 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% uptime, and all security and privacy policies are always adhered to.





You will have decision-making authority to upgrade and patch DB functions to ensure uptime and security, with user privacy as a top priority.

Education Requirements:

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

Skills, Knowledge, & Experience:

1. Database Proficiency in configuring and maintaining Database infrastructure for applications.
2. Database Management: Proficiency in configuring and maintaining database systems such as MySQL, PostgreSQL, Oracle, or SQL Server.
3. Performance Monitoring: Expertise in monitoring database performance and troubleshooting issues to ensure optimal functionality.
4. Security Protocols: Knowledge of implementing and managing database security measures, such as encryption, access controls, and auditing.
5. Backup and Recovery:





Experience in setting up and managing database backup solutions and disaster recovery plans.
6. Data Modeling: Ability to design and optimize database schemas, tables, indexes, and relationships.
7. Query Optimization: Familiarity with optimizing SQL queries and database performance tuning techniques.
8. Cloud Databases: Understanding of cloud-based database services like Amazon RDS, Azure SQL Database, or Google Cloud SQL, including deployment and management.
9. Scripting and Automation: Proficiency in scripting languages (e.g., SQL, PL/SQL, T-SQL) for automating routine tasks and processes.
10. Technical Support: Strong troubleshooting skills and experience providing technical support to database users.
11. 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 be 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.

#J-18808-Ljbffr

▶️ Database Administrator - Part Time
🖊️ Spirit of Math Schools
📍 Toronto