Database Administrator II

Beanfield Technologies Inc. • Toronto, ON

81d • Hybrid

About The Position

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.

Requirements

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

Responsibilities

• Install, configure, and upgrade PostgreSQL databases and associated tools.
• Monitor database performance, identify and resolve bottlenecks, and optimize SQL queries to ensure maximum efficiency.
• Develop and implement comprehensive backup and recovery strategies, including disaster recovery plans, to guarantee data integrity and availability.
• Collaborate with development teams to support database design, create schemas, and optimize 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.
• 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.

Benefits

• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed