Database Administrator - Remote US jobs in United States
cer-icon
Apply on Employer Site
company-logo

Smile Digital Health · 1 day ago

Database Administrator - Remote US

Smile Digital Health is dedicated to improving global health through their innovative health data platform. The Database Administrator will ensure the quality maintenance and performance of data stores, enhance data management practices, and provide recommendations to development teams.

Developer APIsElectronic Health Record (EHR)Health CaremHealth
check
H1B Sponsor Likelynote

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

Qualification

Database AdministrationSQLRelational DatabasesCloud Database ServicesDatabase SecurityData WarehousingCommunication SkillsAttention to Detail

Required

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)
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.)
Excellent written and verbal communication skills and attention to detail

Preferred

Experience with Data Warehousing technologies such as Snowflake or Redshift is nice to have
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

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

Company

Smile Digital Health

twittertwittertwitter
company-logo
Smile Digital Health specializes in delivering fast, secure, compliant data infrastructures to enable for data intensive sectors.

H1B Sponsorship

Smile Digital Health has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (2)
2022 (1)

Funding

Current Stage
Growth Stage
Total Funding
$65M
Key Investors
FirePower CapitalUPMC Enterprises
2025-02-06Debt Financing· $15M
2023-01-26Series B· $30M
2021-08-06Series A· $20M

Leadership Team

leader-logo
Clement Ng
Head of Corporate Development, Co-Founder
linkedin
Company data provided by crunchbase