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
