Database Administrator II

Database Administrator II

Database Administrator II

Beanfield Technologies Inc.

7 hours ago

No application

About

  • 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 Are Challengers
  • 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. 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.
  • 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.
  • * (FOR HYBRID) 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 recruitment@beanfield.com, 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 [https://beanfield.com/]. We urge candidates to be cautious of any unsolicited messages or offers and to remain vigilant against phishing attempts.