Smile Digital Health
Powering the next generation of connected healthcare. Health system solutions for technology, business, and people
Database Administrator
Location
United States
Posted
55 days ago
Salary
$110K - $125K / year
Bachelor Degree5 yrs expEnglishAmazon RedshiftAWSAzureCloudKafkaMongo DBOraclePostgresSQL
Job Description
• 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.
Job 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.
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