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!The Database Administration team consists of operational Database Administrators and Database Developers. While the line between the two areas of functionality is blurry, we are looking for a Senior Microsoft SQL Database Developer who will work closely with Application Development teams to architect, develop, and tune database code and structures.
Collaborating with the development team members and internal stakeholders to develop a robust and effective strategy to improve the performance of existing database code and future new releases. The focus will be on the technical side of the database application and 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 such as 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.
- Work closely 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 in Computer Science, Engineering, or related fields. (In lieu of a degree, equivalent relevant work experience may be considered.)
- 6+ years of experience with microsoft sql server development.
- Experience administering on-prem / 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 and the ability to build quick alignment, drive to decisions, influence without positional power, and collaborate to produce improved outcomes.
- 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.
- Experience ascertaining the technical status of issues raised, using limited information, and formulating the best possible issue-resolution plan.
- Excellent oral and written communication skills.
- We are proud to offer a flexible hybrid work model which will require certain on-site work days (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.
Abarca Health LLC is an equal employment opportunity employer and participates in E-Verify. “Applicant must be a United States’ citizen. 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-AMBT #LI-REMOTE
