What are the responsibilities and job description for the Staff Database Engineer (35389) position at Vyne Dental?
GENERAL SUMMARY
Responsible for designing and implementing database solutions that are categorized as 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
• Leverage AI tooling to accelerate development activities (e.g., code generation, testing, documentation)
• Other duties as assigned.
Qualifications:
EDUCATION, KNOWLEDGE AND SKILLS:
• Bachelors Degree in Engineering, or equivalent experience
• Minimum of 8 years of experience in a related position
• Master level knowledge of AI-enhanced development tools (e.g., Cursor, GitHub Copilot, Claude Code, Chat2DB, AI2SQL, SQLAI.ai)
• Expert 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
• Expert level familiarity with database performance tuning and optimization techniques
• Master level problem-solving and analytical skills
• Expert level communication and collaboration skills to work with cross-functional teams and stakeholders
• Expert 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.
• Advanced level understanding of data security best practices, including encryption, access controls, and auditing