Vyne

GENERAL SUMMARY

Responsible for designing and implementing database solutions that are categorized as very large datasets with extreme complexity, this role encompasses maintaining, optimizing, and securing databases, implementing backup/recovery strategies, monitoring performance, troubleshooting issues, ensuring compliance with standards, collaborating on engineering solutions, maintaining documentation, and mentoring juniors.

DUTIES & RESPONSIBILITIES:

• Design and implement database solutions to meet business requirements, including data modeling and schema design
• Optimize database performance by analyzing query execution plans, indexing strategies, and resource allocation
• Develop and implement database backup and recovery strategies to ensure data availability and integrity
• Monitor database health and performance, proactively identifying and addressing issues
• Troubleshoot and resolve database-related incidents and performance problems
• Ensure data security and compliance with relevant regulations by implementing access controls, encryption, and auditing
• Collaborate with software developers to design and implement efficient and scalable database schemas
• Document database configurations, procedures, and best practices
• Stay up-to-date with emerging database technologies and industry trends to make informed recommendations for improvements
• Mentor junior database engineers in best practices
• Maintain compliance with the knowledge requirements outlined on the department intranet site
• Other duties as assigned.

EDUCATION, KNOWLEDGE AND SKILLS:

• Minimum of 10+ years of experience in a related position
• Master level technical knowledge of database management systems (DBMS) such as MySQL, PostgreSQL, SQL Server, MongoDB, etc
• Expert level knowledge of query languages like SQL for relational databases and appropriate query languages for NoSQL databases
• Expert level proficiency in database design, modeling, and optimization
• Advanced level understanding of backup and recovery strategies
• Master level familiarity with database performance tuning and optimization techniques
• Master level problem-solving and analytical skills
• Master level communication and collaboration skills to work with cross-functional teams and stakeholders
• Master level ability to troubleshoot and resolve database-related issues and optimize query performance
• High level of integrity and dependability with a strong sense of urgency and results-orientation.
• Expert level understanding of data security best practices, including encryption, access controls, and auditing
• Applicable Bachelors Degree in Engineering, or equivalent experience

#LI-Remote