Database Administrator

13 hours ago

Toronto, Ontario, Canada Smile Digital Health Full time US$110,000 - US$125,000 per year
Working for a company like Smile Digital Health means supporting our mandate for #BetterGlobalHealth. We strive towards this goal every day, and the results can be seen in the impact of our innovative health data platform and data management solutions, which are used in over 20 countries. We were #19 on Deloitte's Technology Fast 50 Ranking for Smile Digital Health makes it easy for healthcare stakeholders to collect and exchange data with our leading FHIR-based data liberation platform.   At its heart, the Smile platform enables people and organizations to better manage healthcare data. We help generate and liberate structured healthcare data to ensure effective delivery across care teams and health systems bringing  #BetterGlobalHealth to patients everyday
Apply today and find plenty of reasons to SMILE
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
Smile's core values include respect, inclusion, embracing our differences, and celebrating shared values because our people are the foundation of our success. We are big on creating a sense of belonging and empowering each other to bring our authentic selves to work.  We are dedicated to fostering a workplace that values diversity, equity, and inclusion.   We welcome and encourage candidates of all backgrounds to apply. Candidates are encouraged to inform us if they wish to discuss or require accommodations during interviews or while working at Smile. We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.

  • Database Administrator

    2 weeks ago

    Toronto, Ontario, Canada Arthur Grand Full time $80,000 - $120,000 per year

    Position : Database Administrator - IntermediateLocation: 222 Jarvis ,Toronto, Ontario M3M 0B4(Hybrid - Candidate MUST work 3 days onsite and 2 days remote)Must Have:More than 10 yrs Oracle DBA experienceApproved experience of Oracle 19c using multi-tenant architectureRMAN backup and RestoreData Encryption using ASO/TDEOracle Dataguard Physical/Logical...

  • Database Administrator

    12 hours ago

    Toronto, Ontario, Canada Maven Workforce Inc. Full time

    Position Requirements:• 5+ years of DB2 or PostgreSQL database administration experience• 2+ years of Snowflake data warehouse administration and development experience• Experience working with cloud PaaS database services.• Jenkins, gitlab/bgit-bucket• Linux/Unix experience• Experience supporting highly available and fault tolerant systems.•...

  • Database Administrator

    6 days ago

    Toronto, Ontario, Canada BGIS Full time $90,000 - $120,000 per year

    Who We AreBGIS is a leading provider of customized facility management and real estate services. With our combined team of over 6,500 globally, we relentlessly focus on enabling innovation through the services we deliver, while actively looking for new opportunities that will enable innovation for our clients' businesses. Globally, we manage over 320 million...

  • Database Administrator

    4 days ago

    Toronto, Ontario, Canada BGIS Full time $90,000 - $120,000 per year

    Description Who We Are  BGIS is a leading provider of customized facility management and real estate services. With our combined team of over 6,500 globally, we relentlessly focus on enabling innovation through the services we deliver, while actively looking for new opportunities that will enable innovation for our clients' businesses. Globally, we manage...

  • Database Administrator

    1 week ago

    Toronto, Ontario, Canada Bridgenext Full time $80,000 - $120,000 per year

    Bridgenext is a digital consulting services leader that helps clients innovate with intention and realize their digital aspirations by creating digital products, experiences, and solutions around what real people need. Our global consulting and delivery teams facilitate highly strategic digital initiatives through digital product engineering, automation,...

  • Database Administrator

    2 days ago

    Toronto, Ontario, Canada Smile Digital Health Full time $110,000 - $125,000

    Working for a company like Smile Digital Health means supporting our mandate for #BetterGlobalHealth. We strive towards this goal every day, and the results can be seen in the impact of our innovative health data platform and data management solutions, which are used in over 20 countries. We were #19 on Deloitte's Technology Fast 50 Ranking for 2024 Smile...

  • Database Administrator

    5 hours ago

    Toronto, Ontario, Canada Smile Digital Health Full time US$80,000 - US$120,000 per year

    Working for a company like Smile Digital Health means supporting our mandate for #BetterGlobalHealth. We strive towards this goal every day, and the results can be seen in the impact of our innovative health data platform and data management solutions, which are used in over 20 countries. We were #19 on Deloitte's Technology Fast 50 Ranking for 2024Smile...

  • Oracle Database Administrator

    11 hours ago

    Toronto, Ontario, Canada Tekgence Inc Full time $800,000 - $1,300,000 per year

    Database Administrator/ PostgreSQL DBALocation: TORONTODuration: 6 monthsSkills Required:Job Description: 5 years of experience as a Database Administrator or Database Reliability Engineer, or a similar role with a strong focus on automation and DevOps principles. Deep expertise in at least one, and preferably multiple, database systems Relational IBM...

  • Database Administrator – Oracle

    7 hours ago

    Toronto, Ontario, Canada n2psystems Full time $80,000 - $100,800 per year

    Job SummaryWe are seeking an experienced Database Administrator with 6–10 years of expertise in Oracle technologies to manage and maintain Oracle databases and the Zero Data Loss Recovery Appliance (ZDLRA). The role involves configuring and troubleshooting ZDLRA, implementing protection policies, performing disaster recovery operations, and ensuring...

  • Intermediate Database Administrator

    1 week ago

    Toronto, Ontario, Canada The Code Crackers Full time $80,000 - $120,000 per year

    Position OverviewThe Senior Oracle Database Administrator (DBA) is responsible for designing, implementing, and managing complex Oracle database environments to ensure optimal performance, reliability, and data integrity. The successful candidate will administer databases across multiple environments, perform migrations, monitor performance, and support...