Log In
Sign Up
Why Work With Us?
Are you looking for a fun, flexible work environment where the number one concern is your personal happiness? Firefly Software fosters a great cultural environment where personal and career growth go hand in hand. While finding people with the technical aptitude is not all that difficult, we strive to foster an environment where personality, culture and experience are all equally weighed. We’re also always looking for like-minded people, so if you’re a big sports fan, we should talk!
Many companies talk about helping their employees achieve a healthy work life balance, but Firefly Software actually does it. We work mostly remote, but we also have an awesome office in Vancouver with a games room full of fun stuff including the latest edition of FIFA and all of your favourite classic arcade games. We offer extended benefits from day 1 because dentist visits are important. We have strengthened our mental health support offerings to meet the needs of everyone and their families. Firefly will help you save for your future with 100% RRSP matching.
We have flexible working schedules and employees get family days because you shouldn’t have to use a vacation day to care for your child when they catch a cold or if your dog has an upset stomach. (Yikes!) Plus, you never have to work on your birthday! Being virtual has not slowed us down either. We continue to build on our already strong culture and have bi-weekly games days, all hands meetings and incredible team building events.
Company Overview
Firefly Software is an Agile software development shop with a number of cross functional teams focusing on the design, development, testing and implementation of our expansive software product suite.
As a thriving member of the Vancouver high tech community, Firefly Software knows what it takes to remain competitive in the ever-changing online marketplace. Innovative contributions and a strong team of talented and creative individuals have made Firefly Software what it is today.
Our Software
Firefly software has developed and maintained a very successful Java based multi-application software stack over the past 20 years. Our team is currently in the process of containerizing and modernizing our stack and we are looking for individuals that thrive on the challenges of maintaining and architecting an existing application.
Job Summary
As a member of the Database Team, you will be responsible for the design, development and maintenance of the organization’s PostgreSQL database platform that is central to our Java software multi-application environment. As a technical expert with a strong delivery focus, you will collaborate with all levels of the organization including software engineers, architects and quality assurance engineers.
Duties & Responsibilities:
Identify, analyze and translate business requirements into conceptual, logical and physical data models in complex, multi-application environments
Create and maintain schema objects, including complex functions, scripts and triggers
Engage in all aspects of the software development lifecycle including coding of database functions/procedures, SQL scripting, creating thorough and demonstrable unit testing specifications, test data sets and load testing to ensure all specifications are met
Provide development estimates from high-level functional requirements (i.e., user stories) in an Agile framework
Analyze code for problem resolution and performance optimizations
Analyze large, complex amounts of data
Deploy applications in different databases for development, testing, staging, and other non-production environments
Performance tuning including indexing strategies, tuning complex SQL queries and database stored procedures
Provide ad-hoc reports for project and business stakeholders
Collaborate with DBAs to analyze performance testing; identify and implement corresponding required changes in database and applications
Some shared-on call work, a week every 5th week. Low call rate
Help train and mentor
Required Education & Skills:
A College diploma or University degree in Computer Science or equivalent experience with demonstrated progressive responsibilities
5+ years of experience with developing, implementing and operating PostgreSQL
Solid experience in database design methodologies and relational database architecture
Advanced level of SQL; capable of developing and performance tuning of complex SQL queries and efficient data queries with large data sets
ETL and dimensional modelling experience is desired
Experience with Linux/Unix operating systems (including shell scripting)
Knowledge of database disaster recovery principles and practices
A strong software development background in Java is a desired asset
Experience using source control software like Git and Liquibase
Experience working in a DevOps focused environment employing related technologies like GitLab (GitHub) or similar
Experience with Continuous Integration / Continuous Deployment
Experience with a containerized environment is preferred
Experience with agile methodologies is preferred
Excellent ability to learn new technologies quickly
Current knowledge of technical advancements in the related fields
Commitment to delivering high quality solutions in an agile, team-focused environment
Must work collaboratively with other departments and all levels within the organization
Excellent verbal and written communication skills
Creative/innovative thinker
Strong analytical, problem resolution and decision-making skills
Love what you do. Apply at Firefly Software today.
