Database Administrator

About Smile Digital Health

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 every day!

Apply today and find plenty of reasons to SMILE!

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.
• Contribute and assist 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 the Core Development team, Managed Services team, partners, and customers to provide database management best practices and enhancements.
• Ensure accurate reporting of working hours in Netsuite and proper utilization of the project management tool.
• Tracking and reporting of billable hours is a critical aspect of project management and delivery to our customers.
• Comply with 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 (e.g., Oracle, MS SQL, PostgreSQL, MongoDB).
• Experience with Data Warehousing technologies such as Snowflake or Redshift is a plus.
• Strong command of SQL and database server tools.
• Master database tuning, able to 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 troubleshooting 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).
• Experience with cloud services (AWS, Microsoft Azure, OCI) and queuing services (Kafka, Eventhubs, ActiveMQ). Working experience with Datalakes or BigData technologies is a plus.
• Excellent written and verbal communication skills and attention to detail.