Job description

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… As a 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 be 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 you’re made of  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) This position requires availability to work in a specified time zone or working schedule, accommodating the business needs of our clients and team members. This position may require availability for on-call hours, including evenings, weekends, and holidays, to promptly address emergent issues or provide necessary support as dictated by operational demands (if applicable).     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. Abarca Health LLC is an equal employment opportunity employer and participates in E-Verify.  “Abarca Health LLC does not sponsor employment visas at this time”  The above description is not intended to limit the scope of the job or to exclude other duties not mentioned. It is not a final set of specifications for the position. It’s simply meant to give readers an idea of what the role entails.     #LI-MH1 #LI-HYBRID  

Requirements