This position is responsible for the quality maintenance and performance of data stores across Smile Digital Health along with its clients and partners. As a Database Administrator, you will be tasked with enhancing data management practices and providing recommendations and best practices to development teams as required. Responsibilities: • Perform Database capacity planning, installation, configuration, database design, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery operations. • Act as a subject matter expert for data management and interact with internal and external teams to troubleshoot and provide best practices regarding database implementation and maintenance with our core product. • Contributes and assists with efforts/ projects in the deployment, maintenance, and support of data systems for internal and external projects. • Write and tune SQL queries and review schema designs for optimal performance. • Implement and maintain DBMS and data maintenance pipelines/processes to optimize data operations. • Plan and execute data migration plans for complex systems with large datasets. • Proactively and regularly make recommendations for data system improvements. • Collect, collate and present metrics on data systems to be used by internal and external parties. • Engage with multiple teams across the business including but not limited to the Core Development team, Managed Services team, partners and customers to provide database management best practices and enhancements. • Accountable for ensuring that all working hours are accurately reported in Netsuite on a daily or weekly basis, that the majority of (if not all) hours are tracked as billable and that the project management tool in Netsuite is properly and fully utilized. • Tracking and reporting of billable hours is a critical aspect of project management and delivery to our customers and this is a major area of accountability. • Comply with the privacy, security and confidentiality policies. Requirements: • A post-secondary degree in computer science or a related field combined with five to ten years of experience in database administration, information technology, database architecture, or a related field. • Extensive experience with Relational and Non-Relational database technologies (Oracle, MS SQL, PostgreSQL and MongoDB). • Experience with Data Warehousing technologies such as Snowflake or Redshift is nice to have. • Strong command of SQL and database server tools. • Master database tuner, can interpret and explain plans in multiple servers and understand the query optimizations required to improve them. • Advanced knowledge of database security and performance monitoring standards. • Understanding of relational modeling and strong mathematical and statistical knowledge. Experience with a few programming languages and the ability to troubleshoot connection strings and pools. • Minimum 3 years of experience with a Cloud Database Service (e.g. AWS RDS, Azure PostgreSQL).Minimum 2 years experience with PostgreSQL maintenance tasks (Backup and Restore. Multi-region replication etc.). • Experience with cloud services (AWS, Microsoft Azure, OCI) and queuing services (Kafka, Eventhubs, ActiveMQ).Working experience with Datalakes or BigData technologies is nice to have. • Excellent written and verbal communication skills and attention to detail. $110,000 - $125,000 a year Some of the benefits we offer: * Remote Work Environment * Flexible Time Away From Work Policy including PTO, Personal and Sick Days * Competitive Salary and Health/Medical Benefits * RRSP/TFSA/401K Employee Contribution * Life and Disability * Employee Assistance Program * FHIR Study Program and Skillsoft Learning * Super HAPI Fun Club