Senior Database Engineer

PlanHub; Canada; Remote; CAD 140,000 - 190,000; Full time

Job summary

Join a dynamic team at a leading pre-construction SaaS platform as a Senior Database Engineer. In this exciting role, you will design and manage MySQL databases hosted on AWS, focusing on optimizing data collection systems and processing pipelines. Your expertise will help modernize the data architecture, ensuring high scalability and performance. With a culture that empowers you to make an impact and a remote-friendly environment, this is your chance to contribute to a company recognized on the Inc. 5000 list. If you're passionate about database solutions and eager to drive innovation, this opportunity is perfect for you.

Benefits

Open time-off policy

Remote friendly

Empowered culture

Learning opportunities

Qualifications

• 7+ years of experience in MySQL database management on AWS.
• Experience in troubleshooting and query tuning.
• Hands-on experience with Bash and Python scripting.

Responsibilities

• Design, configure, and manage MySQL databases on AWS.
• Optimize existing database systems and architecture.
• Collaborate with teams to maintain and modernize data architecture.

Skills

MySQL

AWS RDS

AWS Aurora

Troubleshooting

Root Cause Analysis

Bash scripting

Python scripting

Data architecture

Query optimization

Technical documentation

Education

Degree in Computer Science

Tools

AWS CLI

Informatica

SSIS

Apache NiFi

AWS Glue

Snowflake

AWS Redshift

MongoDB

ElasticSearch

Job description

Get AI-powered advice on this job and more exclusive features.

PlanHub is the leading pre-construction SaaS platform and marketplace helping general contractors, subcontractors, and suppliers connect and grow their businesses. Built with tradespeople in mind, PlanHub is designed around the user workflow to help boost productivity, maintain deadlines, increase revenue, and create relationships. Easily post projects or submit bids with anytime-anywhere collaboration for every commercial construction trade.

We’re currently seeking a Senior Database Engineer to join our team. This role will focus on building and optimizing data collection systems and processing pipelines. The primary responsibility will involve managing/supporting/improving the OLTP databases of PlanHub.

What you will be doing

• Design, configure, and manage MySQL databases hosted on AWS RDS and Aurora.
• Troubleshooting, Root Cause Analysis, Slow query log analysis and query tuning.
• Work on improving the existing database systems and architecture.
• Modernize the data tier on AWS towards a highly scalable, available and performant database architecture and data flows with the SaaS platform and external data sources.
• Perform database code deployment and tooling.
• Define, develop, and optimize queries for product.
• Assist software developers with query optimizations.
• Implement reports as needed to support internal business stakeholders.
• Collaborate with the application development and BI teams to maintain and modernize our data architecture.
• Review and troubleshoot reported issues.

What you will need to be successful

• 7+ Design, configure, and manage MySQL databases hosted on AWS RDS and Aurora.
• 5+ Years of experience with Troubleshooting, Root Cause Analysis, Slow query log analysis and query tuning.
• 5+ Utilize AWS CLI for infrastructure tasks including provisioning, monitoring and scaling of RDS/Aurora instances.
• Experienced with Modernization of software to support exponential growth and improve QOS in AWS Cloud infrastructure.
• Maintain comprehensive and clear technical documentation, including runbooks, diagrams and wikis.
• Experienced in designing and implementing OLTP database solutions.
• Degree in Computer Science or related technical discipline or equivalent experience.
• Hands-on experience with Bash / Python scripting.
• Self-motivated and willing to "do what it takes" to get the job done.
• Ability to plan, organize and work on multiple projects with minimal supervision.
• Collaborate with developers to optimize database interactions and ensure efficient data workflows.
• Support database upgrades, patching, and migrations with minimal downtime.
• Strong written and verbal communication skills and the ability to convey technical details to non-technical stakeholders.

Nice to have

• Good to have experience with GUI ETL tools: Informatica/SSIS/Apache NiFi/AWS Glue etc...
• Good to have experience with Snowflake, AWS Redshift, AWS Lake Formation, or similar Data Warehouse / Data Lake tools
• Experience working with NoSQL such as MongoDB, ElasticSearch is good to have.
• Experience in data warehousing inclusive of dimensional modeling concepts and demonstrate proficiency in Python, Perl, or similar

What's in it for you:

The opportunity to join a dynamic team that landed into the top list of Inc. 5000 in 2024 You can make an immediate impact as PlanHub moves to dominate the industry!

PlanHub offers:

• An awesome culture where you will be empowered, make an impact, and learn a ton
• Remote friendly
• Open time-off policy

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology and Engineering

• Industries

  Software Development, IT Services and IT Consulting, and Technology, Information and Media

Referrals increase your chances of interviewing at PlanHub by 2x

Get notified about new Database Engineer jobs in Canada.

Canada CA$140,000.00-CA$140,000.00 1 week ago

Canada CA$150,000.00-CA$190,000.00 1 week ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.