Database Administrator III, Policy Reporter (Remote, Canada)

Job Locations CA-Vancouver
Posted Date 4 days ago(3/17/2023 12:51 PM)
# of Openings


Policy Reporter is committed to Employment Equity. Accommodations during the recruitment process are available upon request for candidates with disabilities. 


Company overview:

Policy Reporter offers a suite of insights products and consulting services to enhance market access strategies and patient support initiatives. By tracking payer policies in near real time, we ensure that the largest pharmaceutical, medical device and diagnostics manufacturers, leading academic institutions and organized provider groups have the most up-to-date data and evidence-based guidance to help patients access the therapies they need. For more information, please visit

About the Team:

We’re a team of engaged developers who love building reliable, scalable systems that solve direct customer problems. We’re an easy-going team and have found value in being open to learning new technologies and we're eager to dive into our applications to tackle a wide variety of technical issues.

As a team we are making significant investments into our tech stack by improving our data structures, increasing automation, scalability, and software quality. We have a challenging problem of building a comprehensive database of payer policy data and keeping it up to date.

Our technology stack is JavaScript, PHP, Python and Go, with PostgreSQL as our primary data store. Our single page application is written in React with D3. Many of us are full stack developers and we care deeply about building quality products.

Our Culture:

At Policy Reporter, people are the heart of our company. We foster an environment that promotes diversity and inclusion, and believe in a culture that supports open communication, continuous learning, innovation, and team collaboration. We create opportunities for employees to thrive both personally and professionally and work together with them to carve out their career path and future with the Company. Our employees work hard and are empowered to take on challenges head-on by being flexible and ready for change. We’re focused on delivering great work with great people. At Policy Reporter, you will be able to do what you love, be yourself, and impact the lives of millions of patients.

Policy Reporter’s Core Values: 


Value & Respect

Continuous Learning

Ownership & Accountability



  • Provide technical leadership to the team. Including, but not limited to:

    • Query performance tuning assistance

    • Database handling best practices and explanation of advanced features

    • Guidance and recommendations to the management team

  • Work with Engineering and management to identify and resolve database performance issues as they arise, and make recommendations for improvements

  • Proactively identify database performance impediments and resolve them by proposing and delivering changes to the codebase

  • Contribute to projects to achieve project goals and consult with other project teams and departments to share best practices and other knowledge

  • Work towards departmental goals and objectives like improving accuracy of technical project estimates, improving database resiliency, reliability, scalability and performance

  • As a project's technical lead, collaborate with teams outside of Engineering to ensure that all stakeholders understand project goals, requirements and realistic timelines


  • 5+ years experience supporting, tuning and administering PostgreSQL databases

  • Expert level knowledge of PostgreSQL, its query planner, query profiling, benchmarking and performance tuning, connection pooling/pgpool

  • Experience with distributed systems, database partitioning, replication and sharding

  • Experience with building and maintaining high availability architecture

  • Experience with AWS Aurora and RDS for PostgreSQL

  • Experience in various data systems (relational databases, Elasticsearch/OpenSearch, BI systems) and migrating data across multiple systems

  • Experience working with large datasets — tens or hundreds of millions of rows

  • Bachelor’s degree in Computer Science/Engineering discipline or equivalent experience.

  • Excellent debugging, troubleshooting, and problem solving skills.

  • Great communication skills (written and verbal)

  • Ability to learn quickly using both internal and external resources

Good to have:

  • Experience with different database technologies such as NoSQL and OLAP, TimescaleDB or other TSDBs

  • Experience with other AWS services such as S3/Glacier, Athena, RedShift

  • Experience with building data ETL pipelines

  • Experience with Splunk and SPL

  • Experience with load testing, stress/fatigue testing

What we offer...

  • Healthy work/life balance

  • Competitive compensation package including company-paid extended health benefits and Employee Assistance Program, paid-time off, paid volunteer leave

  • Employer-matching Group RRSP

  • Excellent opportunities for personal and career development

  • Tuition Assistance

  • Collaborative and supportive Company culture with fun team-building activities

Policy Reporter’s Core Values:

  • Excellence

  • Value & Respect

  • Continuous Learning

  • Ownership & Accountability

  • Teamwork


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed