Smile Digital Health

Powering the next generation of connected healthcare. Health system solutions for technology, business, and people

Database Administrator

Full TimeRemoteTeam 201-500Since 2016H1B No SponsorCompany SiteLinkedIn

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

Related Categories

Related Job Pages