Application Engineer - Database

About DrFirst

For 25 years, DrFirst has empowered providers and patients to achieve better health through intelligent medication management. We improve healthcare workflows and help patients start and stay on therapy with end-to-end solutions that enhance prescription access, affordability, and adherence. Our solutions help 100 million patients a year and are used by more than 420,000 prescribers, 71,000 pharmacies, 270 EHRs and health information systems, and over 2,000 hospitals in the U.S. This is a great opportunity to be a part of a successful Healthcare IT company experiencing significant growth. Here you'll get to work with some of the smartest and most interesting people around; solving unique and complex challenges in healthcare on a scale matched by a few companies. If you get excited about stretching yourself in new ways, developing yourself to your fullest potential, care about working with smart colleagues; we want to talk to you!

Position Overview

The Application Engineer - Database provides advanced technical support for DrFirst applications by diagnosing, reproducing, and resolving complex issues escalated by internal teams. Using deep technical expertise, sound judgment, and established procedures, this role researches and validates technical problems, identifies recurring incidents, and partners with Development and Product teams to address root causes. As the primary escalation point for Tier 2, the Tier 3 Technical Lead protects production data integrity and drives automation and process improvements using Python and other scripting tools.

What you will work on

• Triage cases escalated from Tier 2 and interdepartmental teams to determine root cause of client-reported issues.
• Manage all assigned cases in accordance with documented service level agreements established for each customer's support plan.
• Resolve issues of varying complexity by querying production and CERT databases, performing in-depth troubleshooting and analysis of escalated cases through remote sessions, reproducing issues in appropriate environments, and partnering with technical departments to achieve resolution.
• Contribute to ongoing process improvement within the Operations Team to reduce the volume of tickets escalated to Customer Support.
• Drive automation and process-improvement initiatives through the development of Python scripts and related tooling
• Identify application enhancements and incidents within DrFirst products, communicating progress and findings to appropriate stakeholders.
• Collaborate with Development and Product teams to recreate issues in test/beta environments, providing the details and environment configurations needed to reproduce global incidents.
• Monitor and maintain database applications responsible for ingesting data from multiple sources, troubleshooting data-loading issues to ensure accuracy and availability.
• Lead special projects to implement new processes and applications across core business teams.
• Prioritize and manage multiple concurrent tasks to deliver optimal solutions for customers.
• Maintain production data integrity and data quality across transactional and historical DrFirst databases, liaising with cross-functional teams to resolve data issues.
• Partner with the Database Persistence Team on database cleanup initiatives using PL/SQL, Python, and related tools to ensure high-quality customer experience.
• Collaborate with the EDW team to build BI analytics dashboards and implement custom data solutions that enhance customer relationship management.
• Work closely with DevOps to troubleshoot and resolve system-critical issues requiring immediate defect resolution.
• Serve as the Tier 2 escalation point for advanced, critical customer issues and own Tier 3 ticket queue management and resolution.

Qualifications

• Bachelor's degree required, Master’s degree preferred.
• Expert knowledge of relational databases (Oracle/PostgreSQL), using PL/SQL and ability to write complex SQL queries in DBeaver, pgAdmin etc.
• Proficiency in Python and scripting for automation, data analysis, and process improvement.
• Familiarity with DevOps practices, monitoring tools, and incident management workflows.
• 2+ years of professional Tier 1/Tier 2 experience.
• Desire to provide extraordinary customer support for internal and external clients.
• Excellent analytical, technical, and interpersonal skills.
• MAC OS, Database or Windows OS certifications desired (optional)
• Ability to work independently and in a dynamic/up-tempo environment.
• Healthcare IT experience desired.

Physical Requirements

- 90% Desk work- 10% Remote meetings with internal teams and occasional customer calls

#LI-GF1 #LI-Remote 

Benefits

- Competitive compensation, with a base salary of $115,000-125,000 (Exact compensation may vary based on skills and experience)- Eligible for a Discretionary Performance-based bonus- Medical, dental, and vision insurance- 401K eligible after 3 months of employment, with 50% company match up to first 5% of salary contributed to the plan with a 3-year vesting schedule- HSA for eligible employees enrolled in the HDHP, with a generous company contribution up to $500 for individual coverage and $1000 for family coverage per year- 100% company paid short and long-term disability, AD&D, and group life insurance- Accrued annual paid time off (PTO) of 18 days for the first 3 years of service, increasing thereafter and 7 paid holiday days- Employee Assistance Program- Continuing Education funds up to $1500 annually for eligible programs after 1 year of service- Voluntary benefits including FSA, Hospital indemnity, Accident and Critical Illness insurancesDrFirst is committed to being a Remote-First company, creating a dynamic and flexible workplace where everyone can thrive, no matter where they log in from. Check out our approach to remote work https://drfirst.com/company/about-us/careers/. Our recruitment process at DrFirst is straightforward and secure. You will only be contacted by our recruitment team through an official @drfirst.com email address. We will never ask you for payment or sensitive personal information, such as your social security number or banking details, at any stage of the hiring process. Additionally, we will not request that you purchase equipment or accept e-checks or checks for deposit. If you encounter any communications claiming to be from DrFirst that seem suspicious, please contact our recruitment team directly at [email protected] to verify the message's authenticity. Your security is important to us!  Learn more about our benefits and professional development opportunities https://drfirst.com/company/about-us/careers/the-perks/.