Database Administrator, Remote US

Salary Range: 110000 to 125000 (Currency: USD) (Pay period: per-year-salary) 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 everyday! Apply today and find plenty of reasons to SMILE! This position is responsible for the quality maintenance and performance of data stores across Smile Digital Health along with its clients and partners. As a Database Administrator, you will be tasked with enhancing data management practices and providing recommendations and best practices to development teams as required. 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, arenaflex 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. Additional Information • Smile discloses that artificial intelligence (AI) may be used in portions of the recruitment and selection process, such as resume screening or application assessment. All hiring decisions are ultimately made by qualified human decision-makers, and AI tools are used to support — not replace — fair and equitable hiring practices. • This position is a replacement role, created to support Smile’s continued growth and commitment to operational excellence. Some of the benefits we offer: • 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 Smile's core values include respect, inclusion, embracing our differences, and celebrating shared values because our people are the foundation of our success. We are big on creating a sense of belonging and empowering each other to bring our authentic selves to work. We are dedicated to fostering a workplace that values diversity, equity, and inclusion. We welcome and encourage candidates of all backgrounds to apply. Candidates are encouraged to inform us if they wish to discuss or require accommodations during interviews or while working at Smile. Apply tot his job

Back to blog
Ads

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...