TouchBistro Database Administrator and Developer in Toronto, Ontario
It's an exciting time here at TouchBistro as we continue to expand our Internal Systems team. We are a bunch of social, hospitable and passionate individuals looking to continue to evolve our product into a World Class POS system and brand. With that being said, we are looking to hire for some mission critical roles to join us during this exciting period of growth at our Toronto, Ontario Headquarters.
TouchBistro is looking for an experienced Database Administrator and Developer to join our expanding Internal Systems, Development and IT teams. This individual will have experience with both SQL Server and especially PostgreSQL, along with some design and development experience. You will be working directly with our Development and IT teams, and be working alongside another Database Administrator and Developer and be responsible for over a TB of data. Projects will include: maintaining live databases, designing and development of new databases which could include: writing complex queries, writing stored procedures, optimization by designing table layouts, designing and developing tools or queries, etc. Does this sound like the right challenge for you?!
What's in it for you? We work in small agile teams and this means that you will get to work closely with your team and have your ideas heard. You?ll also have mentorship and a strong growth path, with lots of learning opportunities amongst other benefits and perks like $15 Ritual Lunch credits, Wednesday Snack Days, Friday Socials and more!
Work with software architects and developers to plan, design and optimize databases
Create performance optimizations and monitoring of queries, indexes, etc.
Monitor and Test database backups
Design and Document databases including tables, keys, stored procedures, views, indexes
Design and Plan disaster recovery plans and perform periodic testing
Create and Maintain scripts to perform bulk data updates and scrubbing
ALL ABOUT YOU
1+ years experience with PostgresSQL in a company setting is a requisite
5+ years of experience working with SQL databases in a company setting is must-have
Experience designing and developing databases from scratch
Hands-on experience with regular maintenance, query optimization, logical design, configuration and upgrading
Strong understanding of vacuum, reindexing and archiving
PostgresSQL scaling and capacity planning
Experience configuring database monitoring and alerting
Ability to Build and optimize SQL stored procedures and functions
Great communication skills
Exposure/Experience with MSSQL would be nice-to-have
Experience with AWS RDS/Aurora would be an asset
Linux experience is an added plus
Mastery of some automation language (Python, Shell, Perl etc.)
WHY CHOOSE US?
TouchBistro is an award-winning iPad Point of Sale system, built for restaurant people by restaurant people. We?re a team of thinkers, builders, doers, and innovators. While many of us have experience working at restaurants, some of us just have a true passion for the industry.
We?re venture backed by some of the best tech VCs in the world and are partnered with top innovators in the mobile, food, and payment industries.
We?re global and growing! TouchBistro is used in more than 100 countries worldwide and has offices in NYC, Austin, Chicago, London and headquarters in Toronto. We?re a fast-moving, ever-evolving company on a mission to change the way restaurateurs do business and help them succeed through our products and services, but we need talented, passionate people to help!
So, what do you say? Are you ready to become part of something awesome?
TouchBistro believes in fostering an inclusive workplace where all individuals have an opportunity to succeed. Requests for accommodation due to a disability can be made at any stage of the recruitment process.