02 Aug
|
Beanfield
|
Toronto
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 design, installation, monitoring, maintenance, and performance tuning of our databases 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, and mentor junior team members. You will also develop, implement, and oversee policies and procedures that govern our databases and associated software. This is a critical position that requires commitment to excellence and reliability. The role may require work after hours or on weekends as needed by project and business needs.
What You’ll Do
- Install, configure, and upgrade PostgreSQL databases and associated tools.
- Monitor database performance, identify and resolve bottlenecks, and optimise SQL queries.
- Develop and implement comprehensive backup and recovery strategies, including disaster recovery plans.
- Collaborate with development teams to support database design, create schemas, and optimise application‑to‑database interactions.
- Diagnose and resolve database issues promptly, including providing rotational on‑call support for critical systems.
- Maintain thorough and current documentation for all database configurations, procedures, and standards.
- Analyse database storage and performance metrics to forecast and plan for future capacity needs.
- Responsible for high‑level design of Beanfield’s database system, ensuring the architecture aligns 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 minimise 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.
- Robust ability in performance tuning and capacity planning.
- Proven ability to prioritise 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.
- Additional five (5) personal care days for extra flexibility.
Equal Opportunity Employment
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
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. 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.
#J-18808-Ljbffr
📌 Database Administrator II (Toronto)
🏢 Beanfield
📍 Toronto