Description

You will design, develop, and maintain database processes and data pipelines to support functional requirements and application performance.

Responsibilities

• Design and develop database objects, functions, procedures, triggers, and views to meet software requirements.
• Perform process analysis and recommend structural changes to optimize database query performance and tuning.
• Implement data provisioning strategies, including masking and anonymization for non-production environments.
• Manage production data modification requests and maintain up-to-date documentation for all data management processes.
• Participate in code reviews, technical design documentation using UML, and after-hours on-call support rotations.

Required Skills

• 6+ years of experience in database design, data mapping, and data pipeline best practices.
• Extensive experience developing database processes using Oracle, MSSQL, and PostgreSQL.
• Proficiency in PL/SQL and writing complex SQL queries.
• Strong experience with Unix shell scripting.
• Expertise in ETL processes and relational data modeling.
• Proven ability in designing database objects using partitioning and sharding.
• Deep understanding of software methodologies, distributed networking, and multiprocessing applications.
• Experience maintaining data in accordance with data retention policies.
• Ability to translate technical designs into working software and technical design documents.

Preferred Skills

• Prior experience in the healthcare or PBM industry.

Key Skills

Education

Any Gradute