1 month ago
Barcelona, SpainSenior
Responsibilities
- Deploy databases as code using Terraform, Ansible, Liquibase, Flyway, and DACPAC through CI/CD pipelines from development to production.
- Design, operate, and regularly test high-availability and disaster-recovery solutions using Always On availability groups, Oracle Data Guard, PostgreSQL replication, and cloud-native failover.
- Provide L2/L3 operational support and participate in an on-call rotation for replication, performance, backup, and corruption incidents.
- Optimize database performance and capacity using execution plans, wait statistics, Query Store, AWR, pg_stat_statements, indexing, and query tuning.
- Execute patching, upgrades, lifecycle management, and end-of-life remediation while meeting compliance SLAs.
- Implement database encryption, auditing, privileged access control, data masking, and validation documentation for GxP-regulated systems.
- Automate operational tasks with PowerShell, Python, and platform APIs.
- Onboard databases into Datadog and Splunk monitoring and observability platforms and define alerts and dashboards.
Requirements
- Proven experience deploying and supporting enterprise databases in large-scale global environments, including SQL Server, Oracle, PostgreSQL, or MySQL.
- Hands-on expertise in database deployment, high availability, backup and recovery, performance tuning, and security.
- Proficiency with infrastructure-as-code, preferably Terraform, schema migration tools, and scripting with PowerShell, Python, T-SQL, or PL/SQL.
- Working knowledge of Azure, AWS, GCP, and managed database services.
- Strong working knowledge of ServiceNow, including Incident, Change, and CMDB processes, and ITIL practices.
- Experience with Datadog, Splunk, monitoring platforms, and alert design.
- Fluent written and verbal English.
- Regulated-industry experience is a plus.
- Strong ownership, incident-management, documentation, communication, collaboration, and continuous-improvement skills.
Benefits
- Hybrid work arrangement in Barcelona, indicated by the #LI-Hybrid and #BarcelonaHub tags.
- Eligibility to participate in company employee benefit programs.
- Continuous learning and exposure to cloud-native platforms, AIOps, and intelligent operations.
- Opportunity to support life-changing medicines and vaccines in a global, purpose-driven organization.
Tech Stack
AnsibleAWSAzureDatadogFlywayGoogle Cloud PlatformMicrosoft SQL ServerMySQLPostgreSQLPowerShellPythonSplunkTerraform
Categories
Data Engineering
About Sanofi
Sanofi is a global biopharmaceutical manufacturer that discovers, develops, and commercializes prescription medicines, vaccines, and consumer healthcare products for patients and healthcare systems worldwide. Its portfolio and pipeline span immunology, oncology, rare diseases and blood disorders, neurology, diabetes, cardiovascular conditions, and vaccines. The company is publicly traded and headquartered in Paris, France, with large-scale R&D and manufacturing operations across Europe, the Americas, and Asia.