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! After successful growth in a hybrid work environment, we have move 100% remote. 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 Development Team, you will be responsible for the design, development and maintenance of database procedures and tables of the organization’s transactional and data warehouse database that is central to our software applications. As a technical expert with a strong delivery focus, you will collaborate with all levels of the organization including database and Java software developers, architects and quality assurance engineers all while being involved in sprints to help deliver software that is highly available and scalable.

Duties & Responsibilities:

• 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 data sets
• 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
• Work with data architect on data model changes and table design
• Help and support Java developers in the design, development, and deployment of databases components

Required Education & Skills:

• A College diploma or University degree in Computer Science or equivalent experience with demonstrated progressive responsibilities
• 7+ years of experience with developing, implementing and operating PostgreSQL or Oracle databases
• 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
• Desired experience with Linux/Unix operating systems (including shell scripting)
• A software development background in Java is a desired asset
• Experience using source control software like Git and Liquibase
• Experience with a containerized environment is preferred
• Experience with agile methodologies is preferred
• Strong analytical, problem resolution skills
• 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

Love what you do. Apply at Firefly Software today.