- Company Name
- SMCP – Sandro, Maje, Claudie Pierlot, Fursac
- Job Title
- Ingénieur Data PostgreSQL H/F
- Job Description
-
**Job Title**
Data Engineer – PostgreSQL
**Role Summary**
Maintain, optimise, and evolve PostgreSQL databases across CRM, e‑commerce, operational, and analytical flows. Design and implement data structures, manage access controls, and develop APIs and pipelines. Ensure high performance, reliability, and security while supporting data movement to Snowflake and aligning with data‑mesh principles.
**Expectations**
- Minimum 5 years of PostgreSQL data engineering/DBA experience.
- Proven expertise in Heroku PostgreSQL and Aurora PostgreSQL.
- Advanced SQL skills for transactionally‑optimised workloads.
- Python development for API creation and automation.
- Experience with AWS and other cloud data services (S3, SNS, SQS, Lambda, Firehose).
- Familiarity with Snowflake, ELT/ETL concepts, and data‑architecture best practices.
- Understanding of data‑quality, governance, and RGPD compliance (collaboration with tools such as Collibra, Informatica MDM).
- Operational English and strong communication for cross‑functional collaboration.
- Analytical mindset, autonomy, curiosity, and a cost‑aware, solution‑driven attitude.
**Key Responsibilities**
- Ensure operational uptime and performance tuning of PostgreSQL databases.
- Manage database access rights and enforce security policies.
- Model and evolve data structures to meet evolving business needs.
- Design, develop, and maintain APIs and data pipelines (Python, ETL/ELT).
- Implement monitoring, alerting, and automation for database reliability.
- Contribute to data‑architecture improvements for integration with Snowflake.
- Advocate and document best practices for data governance, quality, and compliance.
- Propose and evaluate new tools, methods, and enhancements for PostgreSQL environments.
- Perform technology scouting and keep abreast of PostgreSQL and related cloud advancements.
**Required Skills**
- PostgreSQL DBA: performance, security, replication, backup, and recovery.
- Advanced SQL (transactional tuning and query optimisation).
- Python programming for API and automation tasks.
- Cloud experience (AWS, GCP) – data‑storage, messaging, compute services.
- Snowflake analytic platform – data loading, querying, schema design.
- ELT/ETL design and data‑pipeline architecture.
- Data‑governance frameworks, tools (Collibra, Informatica MDM, etc.).
- Strong written and oral communication in English.
- Self‑starter with analytical and problem‑solving abilities.
**Required Education & Certifications**
- Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field.
- PostgreSQL or related DBA certifications (e.g., PostgreSQL Certified DBA).
- Cloud certifications (AWS Certified Database – Specialty, or equivalent) are a plus.