Database Administrator

OverviewJoin to apply for the Database Administrator role at BeanfieldWe 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, mentor and provide technical guidance to junior team members, and 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.About BeanfieldBeanfield is building fast and reliable fibre internet, connecting communities across Toronto, Montreal, and Vancouver. We are Challenger, United, and Care values in action, committed to our people and customers.Roles & ResponsibilitiesInstallation & 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 & Qualifications5+ 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.EducationDegree 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.EEOBeanfield is 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. If you require accommodation during the application or interview process, please contact 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. #J-18808-Ljbffr