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 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: 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.

• Monitor and maintain Microsoft SQL Server environments (primary platform) across Production, UAT, and Dev. • Support one Oracle database environment (OCI) in coordination with senior DBA resources. • Execute database maintenance tasks including backups, restores, index maintenance, patching support, and integrity checks. • Assist in troubleshooting database incidents and participate in root cause analysis (RCA). • Respond to database-related alerts and escalations in accordance with defined SLAs and call trees. • Manage and update work items through Jira in alignment with formal change and incident management processes. • Follow established Agile-like workflows for ticket intake, assignment, and resolution. • Ensure proper documentation of changes and operational procedures in Confluence. • Participate in post-incident reviews and documentation updates. • Support query performance tuning efforts under the guidance of senior DBAs. • Assist developers in identifying poorly performing queries and recommending indexing improvements. • Monitor database growth, capacity, and performance metrics. • Support Azure-hosted SQL databases. • Assist in operational tasks related to hybrid cloud environments. • Contribute to migration readiness activities for on-prem Data Warehouse and risk database workloads. • Operate within financial services regulatory and audit frameworks. • Ensure adherence to security, access control, and data governance standards. • Support audit requests and evidence gathering.

• Lead administration of Microsoft SQL Server environments across Production, UAT, and Dev. • Provide architectural oversight for hybrid database deployments (On-Prem + Azure + OCI). • Serve as Tier 3 escalation point for high-severity incidents. • Lead root cause analysis (RCA) and corrective action planning. • Collaborate with business leaders to help deliver technical (database) roadmaps to support overall business goals. • Proactively analyze and optimize database performance. • Partner with development teams to tune complex queries and improve application efficiency. • Design and maintain HA/DR solutions (AlwaysOn, clustering, replication). • Ensure 24/7 operational readiness and SLA compliance. • Support migration of on-prem EDW and risk database to Azure. • Mentor junior DBAs and validate their work output.

• Responsible for z/OS DB2 system, application object and program product installation and management • Conduct disaster recovery for the DB2 system and application objects • Maintain and create processes and procedures for tasks and duties • Provide DB2 Database design and Implementation, configuration, and planning • Perform SQL coding & tuning • Identify problem determination & diagnosis • Provide Level 2 /3 support for all DB2 for zOS issues • Provide off-hour support, 7x24 coverage