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.
Skills Required
- Post-secondary degree in computer science or a related field
- Five to ten years of experience in database administration, information technology, database architecture, or a related field
- Extensive experience with relational and non-relational databases, including Oracle, Microsoft SQL Server, PostgreSQL, and MongoDB
- Strong command of SQL and database server tools
- Advanced database tuning experience, including interpreting execution plans and optimizing queries
- Advanced knowledge of database security and performance monitoring standards
- Understanding of relational modeling and strong mathematical and statistical knowledge
- Experience with multiple programming languages and troubleshooting connection strings and pools
- At least three years of experience with a cloud database service, such as AWS RDS or Azure PostgreSQL
- At least two years of PostgreSQL maintenance experience, including backup, restore, and multi-region replication
- Experience with cloud services such as AWS, Microsoft Azure, or OCI
- Experience with queuing services such as Kafka, Event Hubs, or ActiveMQ
- Excellent written and verbal communication skills and attention to detail
- Experience with data warehousing technologies such as Snowflake or Redshift
- Experience working with data lakes or Big Data technologies
What We Do
Smile Digital Health (doing business as Smile CDR Inc.) specializes in delivering fast, secure, compliant data infrastructures as a service to enable and empower interconnectivity for data-intensive sectors such as healthcare. We are a solutions platform helping organizations like governments, researchers, health systems, healthcare providers, and app developers build connected health solutions and products by leveraging our core expertise in health data and HL7 FHIR. Our flagship product, Smile CDR, is the world’s first FHIR-based clinical data repository (CDR) as a service. Smile CDR is a high performance and secure solution built on the principles of Privacy by Design. Flexibility is a hallmark of the service as it can be hosted in the cloud or on-premises depending on your needs. The design was strongly influenced by real-world experience in both the jurisdictional and organizational setting. Smile CDR provides a rich set of features and capabilities including: -Multiple FHIR versions -FHIR Profiles -Full text indexing of clinical records -Type ahead search functionality -FHIR, HL7v2 and custom ETL for data input -Federated identity and identity provider functionality -International character locale support -Terminology services -Auditing -Smart on FHIR support -Rapid deployment -Extensive administrative tooling Leveraging more than 40 years of experience in building enterprise-class systems, our team includes experts in building integrated healthcare systems including FHIR-based solutions such as HAPI, e-prescriptions and other e-health solutions. We were motivated by the need to improve upon existing options for sharing health data within and across organizations. Smile CDR is the maintainer of HAPI FHIR, the prevailing open source reference implementation of FHIR worldwide
