Database Administrator - Remote US

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, 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.