Database Administrator II

Beanfield MetroConnect; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Benefits offered by this job

Hybrid work model

Total rewards package (TSA/HCSA)

5 personal care days

Job summary

Beanfield Technologies Inc. is seeking an experienced Database Administrator to own the full lifecycle of PostgreSQL and MySQL databases, from design to production. You will ensure data integrity and availability, mentor juniors, and drive policies for secure, scalable systems.

You will design, implement, and operate HA/DR strategies, perform performance tuning, and lead cloud migrations. This role demands reliability and proactive problem‑solving in a 24/7 production setting.

Qualifications

• 5+ years as a Database Administrator.
• 3+ years PostgreSQL and MySQL experience.
• 3+ years SQL coding and scripting.
• 2+ years cloud platforms, preferably GCP.
• Experience with highly available database systems.

Responsibilities

• Install, configure, and upgrade PostgreSQL databases and tools.
• Monitor performance, tune queries, and optimize bottlenecks.
• Develop backup and disaster recovery strategies.
• Support design, schemas, and application interactions.
• Provide on-call support and troubleshoot issues.
• Document configurations, procedures, and standards.
• Plan capacity and lead high‑level DB architecture design.
• Lead migrations from on‑premises to cloud and maintain HA/DR.

Skills

DBA

PostgreSQL

MySQL

SQL

GCP

HA/DR

Job description

Salary Range: $80,000.00 To $100,000.00 Annually

About Beanfield

We don't just build networks, we build communities. From our roots in Liberty Village to our growing footprint across Toronto, Montreal, and Vancouver, Beanfield has spent 35+ years connecting people through a robust, independently owned fibre-optic network.

With 500+ employees and an entrepreneurial mindset, we move fast, think creatively, and stay connected to the people who make Beanfield what it is. If you thrive in a collaborative, high-impact environment where your work matters, you will feel right at home.

Our headquarters is located in Toronto’s super-hip Liberty Village, surrounded by great coffee, food, energy, and creativity—making it a great place to collaborate in person.

Our Values

We lead the way. We disrupt the industry by thinking differently, moving quickly, and taking ownership. We operate with a startup mentality and believe in building and investing in our own infrastructure, and our people.

We Are United

We operate as one team. Collaboration is core to how we work, and every idea matters. We believe strong partnerships and shared ownership lead to better outcomes.

We Care

We care deeply about our employees, partners, customers, and communities. We build trust through open communication, thoughtful decisions, and a relentless focus on our brand and customer experience.

The Role

We are seeking an experienced Database Administrator (DBA) to join our dedicated team and manage the full lifecycle of our PostgreSQL and MySQL databases. 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.

What You’ll Do

• 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.
• 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.
• 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.
• Responsible for high-level design of Beanfield's database system including selection, planning, ensuring the architecture align with long-term business goals.
• Lead database migration initiatives such as moving on-premises to cloud.
• Design, implement, and maintain the entire HA/DR strategy for mission-critical systems.
• Design and deploy HA/DR solutions, such as streaming replication, Patroni, or pgpool-II, to minimize downtime.
• Define and enforce enterprise-wide database security policies.
• Manage user permissions and access controls and conduct regular security audits.
• Automate routine database tasks like maintenance and monitoring using scripting languages such as Bash or Python.
• Identify and implement tools and processes to improve performance, efficiency, and reduce the risk of human error.

What You Bring

• 5+ years of professional experience as a Database Administrator.
• 3+ years of hands‑on experience with PostgreSQL and MySQL.
• 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.
• 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.

What’s in it for you

• A united, values-driven culture that genuinely cares about people, collaboration, and community.
• Hybrid work model with purposeful, in-person collaboration from our vibrant Liberty Village / Montreal office.
• A comprehensive total rewards package, including Traditional Spending Account (TSA) and Health Care Spending Account (HCSA) coverage to support your physical, mental, and financial well-being.
• An additional five (5) personal care days, giving you extra flexibility to recharge, reset, or take care of what matters most.

At Beanfield, we're proud to be an equal-opportunity employer.

We believe that diverse teams make stronger teams. No matter your background, experience, or life story, if you meet the requirements for this role, we want to hear from you. We are committed to creating an inclusive and accessible 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 provides reasonable accommodations at all stages of the recruitment and selection process. If you need support during your application or interview, please reach out to us at [e-mail], we are happy to help.

Please note:

Actual total compensation will be determined based on factors such as knowledge, skills, performance and experience. The salary range indicated includes a Short Term Incentive Plan ("STIP") which represents a percentage of your Base Salary based on the achievement of individual and corporate objectives; The STIP payment is calculated based on a formula that takes into account several factors, including, without limitation, corporate and individual performance measures. The STIP payment is conditional upon meeting all of the STIP's eligibility requirements.

Candidates must be legally eligible to work in Canada, as we are unable to sponsor employment visas. Also, all official 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.