Senior Database Developer

About Us:

Endpoint is an interactive response technology (IRT®) systems and solutions provider that supports the life sciences industry. Since 2009, we have been working with a single vision in mind, to help sponsors and pharmaceutical companies achieve clinical trial success. Our solutions, realized through the proprietary PULSE® platform, have proven to maximize the supply chain, minimize operational costs, and ensure timely and accurate patient dosing. Endpoint is headquartered in Raleigh-Durham, North Carolina with offices across the United States, Europe, and Asia.

Position Overview:

The Senior SQL Server Database Developer will be the strategic and technical lead responsible for designing, implementing, and maintaining 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 Senior Database 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. The 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:

• Develop, maintain, and enforce database standards and guidelines for DBAs and the operations development teams. 
• 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. 
• Work with the systems operations team to make sure the data tier is secure – including encryption and access control as it applies to relevant regulations. 
• Perform regular security audits and vulnerability assessments to safeguard data. 
• Top-level escalation point of contact for all database issues. 
• Responsible for documenting and conducting CA/PA exercises in a data tier issue.
• 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.
• 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. 
• The 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.
• Prior experience with staff management.

Endpoint Clinical does not accept unsolicited resumes from search firms or any other third parties. Any unsolicited resume sent to Endpoint Clinical will be considered Endpoint Clinical property, and Endpoint Clinical will not pay a fee should it hire the subject of any unsolicited resume.

Endpoint Clinical is an equal opportunities employer AA/M/F/Veteran/Disability.

Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment, qualified applicants with arrest and conviction records.

#LI-MT