Database Administrator

Toronto - Canada

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

About Us:

At Beanfield were not just building networks were building communities. Were dedicated to investing in our 100% Canadian-based employees 100% Canadian-driven investments and our 100% Canadian operations. Weve spent over 35 years growing a fibre-optic network that connects people and businesses across Toronto Montreal and Vancouver. Beanfield has always challenged the status quo believing that everyone deserves fast and reliable fibre internet.

We are Challengers leading the way disrupting the industry with a startup mentality and a focus on building our own infrastructure.

We are United operating as one team where everyones ideas are valued.

We Care prioritizing the well-being of our employees partners customers and communities. We foster trust communicate openly and focus on our brand and customers.

Come join our team as we continue to connect communities and foster choice by providing fast and reliable fibre Internet to Canadians.

Position Summary

We are seeking a Database Administrator (DBA) to join our dedicated this role you will be responsible for the full lifecycle of our databases including design installation monitoring maintenance and performance tuning. Your primary goal will be to ensure high levels of data and system availability while maintaining the integrity of our database infrastructure.

You will independently manage and deliver end-to-end projects taking full ownership from concept to completion. You will mentor and provide technical guidance to junior team members. You will also develop implement and oversee policies and procedures that govern our databases and their associated software.

This is a critical position that requires a commitment to excellence and reliability. Please note that this role includes special working conditions such as the need to work after-hours or on weekends as required by project and business needs.

Roles & Responsibilities

Installation & Configuration: Install configure and upgrade PostgreSQL databases and associated tools.
Performance Tuning: Monitor database performance identify and resolve bottlenecks and optimize SQL queries to ensure maximum efficiency.
Backup & Recovery: Develop and implement comprehensive backup and recovery strategies including disaster recovery plans to guarantee data integrity and availability.
Security Management: Implement and enforce security policies manage user permissions and ensure data encryption and compliance.
High Availability & Disaster Recovery (HA/DR): Design and deploy HA/DR solutions such as streaming replication Patroni or pgpool-II to minimize downtime.
Development Support: Collaborate with development teams to support database design create schemas and optimize application-to-database interactions.
Troubleshooting & Support: Diagnose and resolve database issues promptly including providing rotational on-call support for critical systems.
Automation & Scripting: Automate routine database tasks like maintenance and monitoring using scripting languages such as Bash or Python.
Documentation: Maintain thorough and current documentation for all database configurations procedures and standards.
Capacity Planning: Analyze database storage and performance metrics to forecast and plan for future capacity needs.

Skills & Qualifications

5 years of professional experience as a Database Administrator.
3 years of hands-on experience with PostgreSQL and MySQL. (NoSQL is a plus.)
3 years of experience in SQL coding and scripting.
2 years of experience with cloud platforms preferably Google Cloud Platform (GCP).
Proven expertise in designing deploying and administering highly available database systems.
Experience with on-premise cloud and hybrid database environments in a 24/7 production setting.
Demonstrated experience in migrating SQL databases from on-premise to cloud platforms.
Expertise in designing building installing configuring and providing support for database servers.
Strong ability in performance tuning and capacity planning.
Proven ability to effectively prioritize and execute tasks independently in a 24/7 production environment.
Excellent problem-solving skills and the ability to conduct research on database issues standards and products as needed.
Nice to have: PostgreSQL Professional and/or Google Cloud Platform (GCP) certifications.

University/College Degree Required

Degree in Computer Science Information Systems or a related area.

Whats in it for you

Competitive base salary plus annual bonus based on company and individual performance.
Permanent full-time position.
A comprehensive group insurance plan - medical dental vision care with health and lifestyle spending accounts.
A fantastic parental leave top-up program.

At Beanfield we are proud to be an equal-opportunity employer.

We are committed to fostering a diverse and inclusive workplace where all qualified applicants are considered for employment without regard to race colour religion gender gender identity or expression sexual orientation national origin genetics disability age or any other protected status.

Beanfield is dedicated to providing access equal opportunity and reasonable accommodation for individuals with disabilities in all aspects of employment as well as in our services programs and activities. If you require accommodation during the application or interview process please contact us at.

Please note that candidates must be legally eligible to work in Canada at this time. We regret that Beanfield is unable to sponsor employment Visas.

Please note that all communication regarding recruitment and hiring at Beanfield will come exclusively from email addresses ending in@. We urge candidates to be cautious of any unsolicited messages or offers and to remain vigilant against phishing attempts.

Required Experience:

Unclear Seniority

About Us:At Beanfield were not just building networks were building communities. Were dedicated to investing in our 100% Canadian-based employees 100% Canadian-driven investments and our 100% Canadian operations. Weve spent over 35 years growing a fibre-optic network that connects people and busines...