Adrien Nayrat
DBA PostgreSQL Freelance
Salaire / Taux journalier
26000 Valence, France
Freelance
À distance uniquement
Expertises
Langues
Expérience de travail
DBA PostgreSQL Freelance
Europ Assistance
oct. 2022 - Présent
4 ans 1 mois
Remote, Oregon 97458, États-Unis
Consulting on Postgres : tuning, cost reduction on AWS, Postgres upgrade with minimal downtime
PostgreSQL DBA
Alma
mai 2022 - Présent
4 ans 6 mois
Remote, Oregon 97458, États-Unis
Support to Alma on the usage of PostgreSQL (cloudSQL): monitoring (Datadog), query optimization, schema advice.
PostgreSQL Expert DBA
Adrien Nayrat - Expert PostgreSQL Freelance
janv. 2021 - Présent
5 ans 10 mois
Remote, Oregon 97458, États-Unis
Available for expertise freelance missions for PostgreSQL (on-premise, AWS RDS, Google GCP, Heroku, Clever cloud...) : - Audit/consulting and architecture consulting - Tuning (on-premise, AWS RDS, Heroku, Clever cloud...) - Remote DBA - Query optimization - Database Design - Monitoring (Nagios like, Icinga, Datadog) - Backup - Replication physical and logical - Training - Cost reduction with cloud providers, Database FinOps They trusted me: Alma, Hopitaux de Paris (APHP), DGFIP, Mirakl, Welcome to the Jungle, Elevo, Frisquet, Acoss, Plum Energie, Major Corp, Foodles, Julaya, Europ assistance...
Contributor
Opensource
janv. 2015 - Présent
11 ans 10 mois
Contributions to opensource projects, such as : * PostgreSQL : patch, review, bugs reports * Powa : tests, hosting demo and dev website : https://demo-powa.anayrat.info & https://dev-powa.anayrat.info * check_pgactivity : tests, patchs * netdata : tests, patchs * pg_sampletolog : author * pgcheetah : author
Senior PostgreSQL DBA
PeopleDoc France
sept. 2019 - juin 2021
1 an 10 mois
Remote · Remote
Production DBA, tuning, full text search, partitioning, blue-green migrations, automation with ansible, on call and technical watch
PostgreSQL Expert
Doctolib
juin 2018 - mai 2019
1 an
Région de Valence, France (Remote) · Remote
Keeps the database in good operational condition under PostgreSQL 9.6 (3.5To - 40K-50K TPS): - Operating system and PostgreSQL tuning - Load testing - Monitoring and metrology - Query optimization - Sharing of knowledge with developers and DEVOPS team in order to use postgres to the best advantage - Technical watch on PostgreSQL, Linux and hardware (CPU, storage, memory)
Dalibo
juil. 2015 - juil. 2018
3 ans 1 mois
Associate
mai 2017 - juil. 2018
1 an 3 mois
Associate of the SCOP
Postgres Expert
juil. 2015 - mai 2018
2 ans 11 mois
Valence (remote) · Remote
PostgreSQL Expert: - Production DBA - Support - Consulting : Configuration, replication, monitoring - High Availability - Optimization / tuning : SQL, PostgreSQL, Linux, storage - Contributions in PostgreSQL : bugs reports, patch review - Trainings - Conferences : Speaker for pgday France - Technical watch : PostgreSQL, Linux, visualization, storage SAN
Formation Parcours des Associés de Scop et Scic
avr. 2018 - avr. 2018
1 mois
Formation Parcours des Associés de Scop et Scic avec l'URSCOP Ile de France : http://www.les-scop.coop/sites/fr/le-reseau/accompagnement/Formation/Parcours/ Les thèmes abordés L’entreprise L’exploitation, le marché, les fonctions de l’entreprise, bilan, compte de résultat, indicateurs-clé, tableau de bord, indicateurs de performance Spécificités Scop Capital social et réserves impartageables, engagement au capital, modalités et enjeux, répartition des résultats Rôle d’associé et vie coopérative Participer à une assemblée générale, rôle des associés, coopérer au travail Démarche personnelle Partage des pratiques, recherche d’information dans la coopérative en intersession, restitution au groupe
System administrator
Axess Groupe
juil. 2013 - juin 2015
2 ans
Valence Area, France
Operational maintenance and platform engineering of "la-vie-scolaire.fr" (Digital workspace for Colleges and High Schools). - Postgresql DBA (optimization, replication) - Virtualization vSphere 5.1/5.5 - Tomcat 7 - Metrology (Collectd, ELK, Grafana) - Dedicated/mutualized hosting - Network engineering as the company is also an internet provider xDSL,fiber
NEO-SOFT Services
juin 2012 - juil. 2013
1 an 2 mois
Rennes, France
Project management
déc. 2012 - juil. 2013
8 mois
Rennes, France
Extension of the RAEI network (backbone network offering services to companies in France). Management of router deployment (Juniper). Management of the implementation of transmission links
Network engineer
juin 2012 - déc. 2012
7 mois
Rennes Area, France
Mission to the National Center for Automatic Radar Processing. Administration switch, VPN concentrator and routers (cisco, H3C) Administration firewall (cisco ASA, BSD) Failover, VRRP, CARP Scripting bash
Groupe SII
oct. 2009 - mai 2012
2 ans 8 mois
Rennes Area, France
Network engineer
janv. 2012 - mai 2012
5 mois
Rennes Area, France
Network Engineer at Orange Buisness Services Technical stream leader, participates in international VPN business projects, engineering and network architecture study design of offers (VPN and VoIP). Coordination with voice and network engineering teams. Orientation on technical choices (Networks, Voice)
Security engineer
mars 2011 - déc. 2011
10 mois
Rennes Area, France
At Orange Buisness Services, Strong authentication with RSA Securid and Active Identity. Virtualization of an existing security solution under Vmware 4.1. Support N3
System Engineer
oct. 2009 - mars 2011
1 an 6 mois
Rennes, France
System Engineer at Orange (DEPFS). Operation of servers for VoIP (SIP). Operating systems: Linux/solaris Network traffic analysis: Wireshark SIP protocol. Ericsson SIP production platform to support several million clients. Server installation, Incident resolutions (level 2 support) + DNS/DHCP expertise on-call
Apprentice Engineer
Brest Métropole Océane
sept. 2006 - août 2009
3 ans
End of study project on IPv6 deployment. SAN configuration (LUN, Zoning on Brocade switch...). Monitoring with NAGIOS /Centreon Installation and configuration of a mail firewall in Cluster (Borderware Security Platform 8.1)
Formation
Telecom Bretagne
Engineer specialized in networks and telecommunications, Networks and Telecomunications
2006 - 2010
4 ans
Skills: PostgreSQL · SQL · Linux · Bases de données · C · IPv6
IMT Atlantique
Engineer specialized in networks and telecommunications, Networks and Telecomunications
2006 - 2010
4 ans
Skills: PostgreSQL · SQL · Linux · Bases de données · C · IPv6
Licences et certifications
Certification IPv6 "Guru"
Délivré le : déc. 2012
TOEIC 835
Délivré le : nov. 2008