Lead Database Engineer
Role details
Job location
Tech stack
Job description
Applicants who live within 35 miles of Durham, NC location will follow a hybrid schedule. This schedule includes a minimum of three in office days per week in Durham, supporting both collaboration and flexibility.
Work Schedule: This is a full-time, exempt (salaried) position assigned to a First Shift schedule, with standard business hours of Monday through Friday, 8:00 a.m. to 5:00 p.m. EST.
Business needs may occasionally require flexibility in work hours, including earlier, later, or additional hours, with reasonable notice provided when possible., * Lead database-focused software development initiatives, providing technical direction and oversight across projects.
- Design, develop, and maintain database solutions that support scalable, reliable, and high-performance applications.
- Create and maintain technical design documentation, testing plans, and support documentation.
- Manage multiple concurrent projects while ensuring adherence to enterprise standards and best practices.
- Provide Tier-3 production support, including root cause analysis, issue resolution, and implementation of enhancements or fixes.
- Analyze and troubleshoot SQL queries and data-related issues to resolve incidents and improve system performance.
- Conduct database performance analysis, identifying and resolving bottlenecks to improve efficiency.
- Support data engineering processes, including ETL workflows, data pipeline monitoring, and optimization initiatives.
- Collaborate with application development and data teams to ensure data quality, system reliability, and timely issue resolution.
- Train and mentor Tier-1 and Tier-2 support staff, including knowledge transfer and documentation development., The Lead Database Engineer serves as the technical lead for database-driven development initiatives, ensuring the design, performance, and reliability of critical data systems. This role partners closely with application and data teams to deliver scalable, efficient database solutions while driving continuous improvement across database operations and support functions.
Requirements
- Bachelor's degree in Computer Science, Software Engineering, Information Systems, or Engineering.
- 5 or more years of experience in database design and data modeling.
- 5 or more years of experience developing SQL queries and database solutions.
- 2 or more years of experience developing applications using Oracle databases., * 5 or more years of experience designing relational databases using normalization and indexing techniques.
- 5 or more years of experience writing and optimizing SQL and PL/SQL code.
Additional Job Standards
- Experience performing SQL performance tuning, query optimization, indexing, and partitioning.
- Experience developing database solutions using T-SQL or PL/SQL.
- Experience working with ETL processes, data pipelines, and data processing workflows.
- Strong analytical and problem-solving skills.
- Strong written and verbal communication skills.
- Ability to collaborate effectively across technical teams.
- Ability to manage multiple priorities in a fast-paced environment.
- Strong attention to detail and commitment to data quality and system reliability.