Database Developer, Senior

Acentra Health; United States; Remote; USD 79,000 - 132,000; Full time

Job summary

A healthcare technology company is seeking a Senior Database Developer to design and deploy ETL pipelines within their Unified Data Platform using AWS services. The role involves optimizing database performance and ensuring data integrity across systems. Ideal candidates will possess strong PL/SQL skills and collaborate closely with cross-functional teams to drive system enhancements. Join a mission-driven company committed to improving healthcare outcomes.

Benefits

Comprehensive health plans

Paid time off

Educational assistance

Retirement savings

Corporate wellness

Qualifications

• Minimum 7 years of experience with PL/SQL development and working with large datasets.
• Ability to write and optimize complex SQL queries efficiently.
• Solid foundation in relational schema design and indexing strategies.

Responsibilities

• Design and develop PL/SQL packages and procedures.
• Write SQL queries for data extraction and reporting.
• Design scalable ETL pipelines on AWS.

Skills

PL/SQL development

SQL query optimization

Data validation and cleansing

Interpersonal skills

Education

Bachelor’s degree in computer science or related field

Tools

AWS (DMS, Glue, Redshift, Lambda, S3, EC2)

PostgreSQL

Unix

Job description

Company Overview

Acentra Health exists to empower better health outcomes through technology, services, and clinical expertise. Our mission is to innovate health solutions that deliver maximum value and impact.

Lead the Way is our rallying cry at Acentra Health. Think of it as an open invitation to embrace the mission of the company; to actively engage in problem-solving; and to take ownership of your work every day. Acentra Health offers you unparalleled opportunities. In fact, you have all you need to take charge of your career and accelerate better outcomes – making this a great time to join our team of passionate individuals dedicated to being a vital partner for health solutions in the public sector.

Job Summary and Responsibilities

Acentra Health is looking for a Database Developer, Senior to join our growing team.

Job Summary:

We are looking for a highly motivated Database Developer, Senior to join our team in developing a cutting-edge Unified Data Platform (UDP) leveraging the power of AWS. In this role, you will design and deploy robust, scalable ETL pipelines and data workflows that enable seamless integration, transformation, and accessibility of enterprise data assets.

You’ll lead the development of cloud-native solutions using key AWS services such as DMS, Glue, Lambda, S3, Redshift, and EC2, while ensuring cost-efficiency, reliability, and optimized performance. Your expertise in PL/SQL development and relational data modeling will be essential in supporting complex transactional and analytical use cases within a large-scale data environment.

This is a highly collaborative position that will see you partnering with cross-functional teams to drive system testing, application integration, and continuous platform enhancements. As a champion of data integrity, governance, and regulatory compliance (e.g., HIPAA).

Position is remote

Job Responsibilities:

• Design, develop, and maintain PL/SQL packages, procedures, functions, triggers, and views.
• Write efficient SQL queries for data extraction, transformation, and reporting purposes.
• Ensure database performance optimization, query tuning, and troubleshooting.
• Design and deploy scalable ETL pipelines on AWS using services such as DMS, Glue, Lambda, S3, and Redshift.
• Ingest and process UDP-based data sources via EC2 instances or containerized ingestion services.
• Configure and optimize AWS infrastructure for performance, reliability, and cost-effectiveness.
• Design and optimize relational database schemas for scalability and normalization.
• Build and schedule robust ETL jobs and data workflows using cron or enterprise orchestration tools.
• Develop and support integration of disparate data sources (flat files, third-party databases).
• Conduct data validation and cleansing operations to ensure accuracy and completeness.
• Troubleshoot and resolve data quality issues across systems.
• Support SIT, UAT, and performance testing of Unified Data Platform (UDP).
• Work autonomously within well-defined system design frameworks to implement Unified Data Platform (UDP) components.
• Collaborate with development and business analysis teams to understand functional and technical design.
• Participate in code review sessions and implement feedback for quality improvements.
• Perform impact and gap analysis in response to system software changes.
• Lead Proof of Concepts (PoCs) and support new project initiatives from inception to deployment.
• Maintain technical documentation, coding standards, and system architecture artifacts.
• Ensure compliance with industry regulations and internal governance policies (e.g., HIPAA).
• Communicate technical impacts, root cause findings, and resolutions effectively to leadership.
• Read, understand, and adhere to all corporate policies including policies related to HIPAA and its Privacy and Security Rules.

Qualifications

Required Qualifications/Experience:

• Bachelor’s degree in computer science, Information Systems, or related field.
• A minimum 7 years of experience with PL/SQL development, performance tuning, troubleshooting, and working with large datasets in RDBMS.
• Ability to write and optimize complex SQL queries efficiently.
• Solid foundation in relational schema design, indexing strategies, and scalable architecture.
• Skilled in applying data validation, cleansing techniques, and quality frameworks.
• Understanding of SDLC and STLC processes for structured development and testing.
• Excellent interpersonal skills with a demonstrated ability to work effectively across technical and business teams.

Preferred Qualifications/Experience:

• Experience with AWS services such as DMS, Glue, Redshift, Lambda, S3, IAM, EC2 for data processing and pipeline development.
• Experience working with PostgreSQL for data modeling, performance tuning, and backend integration.
• Proven background designing, implementing, and scheduling ETL workflows and data integration solutions.
• Proficient in Unix environments with hands-on shell scripting experience.
• Knowledge of business intelligence and data warehouse methodologies.
• Knowledgeable of the healthcare industry, managed care, and operational systems.
• Excellent verbal and written communication skills.

Why us?

We are a team of experienced and caring leaders, clinicians, pioneering technologists, and industry professionals who come together to redefine expectations for the healthcare industry. State and federal healthcare agencies, providers, and employers turn to us as their vital partner to ensure better healthcare and improve health outcomes.

We do this through our people.

You will have meaningful work that genuinely improves people’s lives across the country. We are a company that cares about our employees, and we give you the tools and encouragement you need to achieve the finest work of your career.

Benefits

Benefits are a key component of your rewards package. Our benefits are designed to provide you with additional protection, security, and support for both your career and your life away from work. Our benefits include comprehensive health plans, paid time off, retirement savings, corporate wellness, educational assistance, corporate discounts, and more.

EEO AA M/F/Vet/Disability

Acentra Health is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, national origin, disability, status as a protected veteran or any other status protected by applicable Federal, State or Local law.

Compensation

The pay for this position is listed below.

Pay Range: USD $79,232.00 – USD $132,000.00 /Yr.