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.

#LI-MT #LI-Onsite