Firefly Software Hiring for Database Administrator at Vancouver, BC Full Time

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 Database Administrator you’ll be responsible for configuring, monitoring and improving PostgreSQL databases; query analysis to understand how teams are using the data; allocation of system storage and planning storage requirements; planning backup and recovery of database information and managing data replication.

Duties and Responsibilities

Manage all database services

Develop, implement and document best practices for DR, backup and recovery, database security

Database system software installations and upgrades

Deploy database schema changes to various enterprise environments

Participate in on-call production support rotation

Coordinate database system upgrades with IT staff, end users and vendors

Performance monitoring and reporting

Performance tuning

Capacity planning

Automate database administration functions

Execute diagnostics on operational (i.e. production) databases, analyse the results and articulate recommendations

Required Education & Skills

Bachelor’s degree in Computer Science or equivalent experience with demonstrated progressive responsibilities

5+ years of IT experience with a minimum of 3 years’ experience implementing and operating significant Oracle or PostgreSQL databases in Unix-based commercial environments

Solid understanding of database design principles

Ability to proactively identify, troubleshoot and resolve live database systems issues

Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore

Good SQL knowledge including PL/SQL or PL/pgSQL scripting

Proficient in Unix shell scripting

Experience working in a DevOps focused environment employing related technologies like GitLab (GitHub) or similar source control with continuous integration using Ansible and Docker (or Kubernetes etc.) for orchestration preferred

Current on technical advancements in the field and in related fields

Excellent ability to learn new technologies quickly

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.