Support the company's mandate for #BetterGlobalHealth by maintaining and enhancing data management practices as a Database Administrator. This role involves ensuring the quality and performance of data stores across the company and its clients, and providing recommendations and best practices to development teams.
Requirements
- Post-secondary degree in computer science or a related field
- 5-10 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
Benefits
- 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