Senior SQL Server Developer

What you’ll do

In a few words…

Abarca is igniting a revolution in healthcare.  We built our company on the belief that with smarter technology we are redefining pharmacy benefits, but this is just the beginning…

Our Infrastructure Operations team is critical for success at Abarca Health. They handle the days in and days out of the entire architecture of our systems from data processing to server updates and stability. Our data lifecycle is secure under the watch of the Database Administration team. They focus on our portfolio of data products through areas such as cloud storage, retrieval, archiving, governance, policies, and other areas!

As Senior Database Developer we’ll need your skills to collaborate closely with the Application Development teams to architect, develop, and fine-tune database code and structures. This team-up will help the development team members and internal stakeholders develop a robust and effective strategy to improve the performance of existing database code and future new releases. So, make sure to note that the focus will be on the technical side of the database application. You’ll making sure that all processes are optimized for performance!

The fundamentals for the job…

• Provide technical expertise and support in the use of the Database Management System.
• Evaluate and recommend available Database Management System products to support validated user requirements.
• Define file organization, indexing methods, and security procedures for specific user applications.
• Create and maintain database objects (tables, views, index, constraints, etc.) for data platform and custom applications.
• Drive end-to-end availability, performance monitoring, and capacity planning for Microsoft SQL (using native and 3rd party tools).
• Evaluate, design, code, optimize, and modify databases and database applications.
• Model databases and develop tables, stored procedures, views, triggers, and other database objects.
• Tune databases for optimum performance.
• Collaborate with other developers to integrate databases with other applications.
• Perform other duties and special projects as assigned.

What we expect of you

The bold requirements…

• Bachelor’s Degree or Master’s Degree of Computer Science, Engineering, Information Technology or related fields. (In lieu of a degree, equivalent relevant work experience may be considered.)
• 6+ years of experience in administering on-prem and/or Azure based multi-user SQL Server environment with expertise in planning, designing, building, and implementing complex database systems.
• Experience with optimizing database performance through exhaustive pro-active testing and ongoing real-time monitoring, programming, and design.
• Experience with driving end-to-end availability, performance monitoring, and capacity planning for Microsoft SQL, using native and 3rd party tools.
• Experience with implementing automated methods and industry best practices for consistent installation and configuration of EDB Microsoft SQL for production, pre-production, and non-production environments.
• Experience with administrating Microsoft SQL databases throughout the non-production (Sandbox, development, test, UAT, Training), pre-production (Staging) and production lifecycles in an Azure environment.
• Experience managing cloud Database software projects utilizing agile methodologies in a mission-critical environment.
• Experience with building detailed technical artifacts to document software deployment processes.
• Availability to work rotating or irregular shifts, including weekends and certain holidays, per business or operational needs.
• Excellent oral and written communication skills.
• We are proud to offer a flexible hybrid work model which will require certain on-site workdays (Puerto Rico Location Only)

Physical requirements…

• Must be able to access and navigate each department at the organization’s facilities.
• Sedentary work that primarily involves sitting/standing.

At Abarca we value and celebrate diversity. Diversity, equity, inclusion, and belonging are guiding principles of Abarca and ensure Abarca’s workforce reflects the communities it serves.  We are proud to provide equal employment opportunities to all employees and applicants for employment and prohibit discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, medical condition, genetic information, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.

 Abarc