Endpoint Clinical
Principal Database Developer
Endpoint Clinical, Morrisville, North Carolina, United States, 27560
Principal Database Developer
The Principal SQL Server DB Developer will serve as the strategic and technical lead responsible for the design, implementation, and ongoing management of high-performance, mission-critical SQL Server code. This role requires extensive expertise in database architecture, high-availability configurations, performance optimization, and data security, with a strong focus on ensuring data integrity and system reliability. The Principal DB Developer will lead initiatives for automation and troubleshooting, acting as the top-level escalation point for complex database issues. In addition, this role will collaborate closely with cross-functional teams, provide mentorship to the development team, and drive continuous improvement efforts across all database operations. Ideal candidates will have a deep knowledge of SQL Server technologies, scripting for automation, and a proactive approach to managing cloud-based and on-premises database solutions to meet business objectives. Responsibilities:
Database Architecture and Strategy: Develop, maintain, and enforce database standards and guidelines for DBAs and the operations development teams. Performance Tuning and Optimization: Develop, manage, and maintain monitors to identify issues in the data tier. Analyze results and provide both SQL tuning and process development to get poorly performing code fixed. Security and Compliance: Work with the systems operations team to make sure the data tier is secure to include encryption and access control as it applies to relevant regulations. Perform regular security audits and vulnerability assessments to safeguard data Troubleshooting and Incident Management: Top level escalation point for all database issues. Accountable and responsible for documenting and conducting CA/PA exercises in the event of a data tier issue. Innovation and Continuous improvement: Stay current with SQL Server advancements and trends, evaluating how emerging tools and technologies can benefit the organization. Identify areas for process improvements and implement enhancements to optimize database environments. Collaboration and Mentorship: Collaborate with cross-functional teams (Developers, Infrastructure, DevOps, etc.) to support project needs and database integration. Mentor junior DBAs and provide technical guidance, best practices, and training on SQL Server technologies. Education:
Bachelor's degree in a relevant field or equivalent work experience. Experience:
8+ years of experience in SQL Server Database Administration, with proven expertise in managing large, mission-critical databases. Strong knowledge of SQL Server high-availability solutions and clustered environments. Proficiency in T-SQL and PowerShell scripting for database automation. Extensive experience writing T-SQL stored procedures and performing query optimization and tuning. Experience with cloud-based database solutions (Azure SQL and Cosmos) is highly desirable. Experience with monitoring tools such as SQL Server Management Studio (SSMS), SQL Profiler, Extended Events, and third-party tools (e.g., SolarWinds, Redgate). Ability to interact effectively with resources from the functional and technical tracks on the project team. Ability to manage multiple tasks with shifting priorities is a necessity. Must be willing to work on-call as part of regular work schedule and when required. Process and detail-oriented with excellent analytical and problem-solving skills. Previous experience working in a fast-paced, entrepreneurial environment preferred. Skills:
Strong attention to detail Excellent organizational and time management skills Excellent communication and leadership skills, with a collaborative approach to working with various teams and mentoring junior staff. Staff management skills
The Principal SQL Server DB Developer will serve as the strategic and technical lead responsible for the design, implementation, and ongoing management of high-performance, mission-critical SQL Server code. This role requires extensive expertise in database architecture, high-availability configurations, performance optimization, and data security, with a strong focus on ensuring data integrity and system reliability. The Principal DB Developer will lead initiatives for automation and troubleshooting, acting as the top-level escalation point for complex database issues. In addition, this role will collaborate closely with cross-functional teams, provide mentorship to the development team, and drive continuous improvement efforts across all database operations. Ideal candidates will have a deep knowledge of SQL Server technologies, scripting for automation, and a proactive approach to managing cloud-based and on-premises database solutions to meet business objectives. Responsibilities:
Database Architecture and Strategy: Develop, maintain, and enforce database standards and guidelines for DBAs and the operations development teams. Performance Tuning and Optimization: Develop, manage, and maintain monitors to identify issues in the data tier. Analyze results and provide both SQL tuning and process development to get poorly performing code fixed. Security and Compliance: Work with the systems operations team to make sure the data tier is secure to include encryption and access control as it applies to relevant regulations. Perform regular security audits and vulnerability assessments to safeguard data Troubleshooting and Incident Management: Top level escalation point for all database issues. Accountable and responsible for documenting and conducting CA/PA exercises in the event of a data tier issue. Innovation and Continuous improvement: Stay current with SQL Server advancements and trends, evaluating how emerging tools and technologies can benefit the organization. Identify areas for process improvements and implement enhancements to optimize database environments. Collaboration and Mentorship: Collaborate with cross-functional teams (Developers, Infrastructure, DevOps, etc.) to support project needs and database integration. Mentor junior DBAs and provide technical guidance, best practices, and training on SQL Server technologies. Education:
Bachelor's degree in a relevant field or equivalent work experience. Experience:
8+ years of experience in SQL Server Database Administration, with proven expertise in managing large, mission-critical databases. Strong knowledge of SQL Server high-availability solutions and clustered environments. Proficiency in T-SQL and PowerShell scripting for database automation. Extensive experience writing T-SQL stored procedures and performing query optimization and tuning. Experience with cloud-based database solutions (Azure SQL and Cosmos) is highly desirable. Experience with monitoring tools such as SQL Server Management Studio (SSMS), SQL Profiler, Extended Events, and third-party tools (e.g., SolarWinds, Redgate). Ability to interact effectively with resources from the functional and technical tracks on the project team. Ability to manage multiple tasks with shifting priorities is a necessity. Must be willing to work on-call as part of regular work schedule and when required. Process and detail-oriented with excellent analytical and problem-solving skills. Previous experience working in a fast-paced, entrepreneurial environment preferred. Skills:
Strong attention to detail Excellent organizational and time management skills Excellent communication and leadership skills, with a collaborative approach to working with various teams and mentoring junior staff. Staff management skills