Database Administrator

About Us:

At Beanfield, we’re not just building networks, we’re building communities. We’re dedicated to investing in our 100% Canadian-based employees, 100% Canadian-driven investments, and our 100% Canadian operations. We’ve 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 everyone's 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 team. In 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.

What's 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 recruitment@beanfield.com.

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 @beanfield.com. We urge candidates to be cautious of any unsolicited messages or offers and to remain vigilant against phishing attempts.