Senior SQL Database Developer *IMMEDIATE NEED*

PointClickCare - Toronto, Canada Area

Posted 791 days ago
  • Experience
  • Job function
    Information Technology
  • Employment type
  • Industry
    Computer Software
  • Job ID

This is a preview of the Senior SQL Database Developer *IMMEDIATE NEED* job at PointClickCare. To view the full job listing, join LinkedIn - its free!Join LinkedIn - its free!

About this job

Job description

A Little About Us:

PointClickCare is a North American leader in one of the hottest segments in technology today – SaaS-based Electronic Health Record (EHR) software. We’re growing at a record pace and are seeking high-energy players to join our team.  Our work environment is fast.  And we like to surround ourselves with smart, passionate, and enthusiastic people who want to be part of an entrepreneurial company that plays to win.




The Job


 Reporting to the Product Manager of Reporting and Business Intelligence, this position will be responsible to build and design a standard library of data sources for reports and data extracts for the PointClickCare solution.


Job Description

  • Develop required database objects to support data retrieval for standard reports and extracts using SQL Server 2005 for all areas of the electronic health record – billing, clinical, enterprise, etc. This includes but is not limited to tables, views, functions and a heavy emphasis on stored procedures.
  • Develop data migration and transformation scripts using DTS/SSIS.
  • Develop data warehouse and data marts to support new dashboard designs and functionality.
  • Continually expand and maintain standard Reporting and Business Intelligence object library.
  • Work with team members to refine optimal design to meet end-user requirements and performance expectations.
  • Present and articulate design decisions, code reviews, features and benefits.
  • Provide a high level of customer service.


Job Requirements

  • 5+ years experience with SQL Server 2005 and/or 2008, in particular, strong T-SQL skills (certification a plus)
  • Strong RDBMS knowledge
  • 2+ years experience with DTS/SSIS
  • Experience with various performance tuning techniques and tools such as profiler, execution plans, management views, etc.
  • Strong data analysis/troubleshooting skills
  • Experience working with large databases (300+ GB)
  • Experience working with large data warehouses a plus
  • Experience working with Jasper Reports a plus
  • Experience in health care, in particular with an electronic health record solution and/or long-term care a plus
  • Excellent verbal and written communication skills


Why Work at PointClickCare?:


Our beliefs:

  • Play To Win
  • Take Care of Our Customers
  • Work Shouldn’t (Always) Suck


We are a fun, fast-paced, competitive place to be.  You will be challenged every day in a work environment that provides professional growth and competitive rewards programs.  We also offer a unique work environment designed for people who like to work hard and play hard too!  Here are just a few examples:

  • On-site gym with personal trainers
  • On-site massage therapy
  • Free hot lunch 3 days a week
  • Performance-based incentives
  • RRSP matching
  • Comprehensive benefits
  • Quarterly employee events


So if you think you are a fit for the company and the role and are passionate about technology, believe that the number one value for any technology company should be commitment to customer success, and you want the opportunity to join a winning company on the ground floor, visit our Careers section at to apply today!


About this company


PointClickCare, helps long-term care providers, from single-home independents to national chains, manage the complete lifecycle of resident care. From pre-admission to discharge, our integrated approach to EHR streamlines and connects clinical, billing, and administration processes to maximize reimbursements, enhance quality of care, improve operational efficiencies, increase staff productivity and satisfaction, and reduce risk to your business. As the fastest growing EHR platform more than 5,000 long-term care facilities use to efficiently manage and automate their complex operations, why would you trust your business to anyone else? For more information on PointClickCare, please visit

Other jobs at PointClickCare

View more jobs at PointClickCare

Similar jobs

View all jobs like this

This is a preview of the Senior SQL Database Developer *IMMEDIATE NEED* job at PointClickCare. To view the full job listing, join LinkedIn - its free!Join LinkedIn - its free!

People also viewed