Senior Database Developer - SQL

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.

Requirements

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.