$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Contract PostgreSQL database consultant
Piotr Adamiak
,
Musselburgh, United Kingdom
Experience
Other titles
Skills
I'm offering
"I can teach your PostgreSQL databases new tricks."
Bilingual customer-focused and enthusiastic Linux professional with expert knowledge of the PostgreSQL relational database management system.
Specialities: PostgreSQL, EnterpriseDB Postgres Plus Advanced Server, Postgres Plus Cloud Database, PostgreSQL High Availability, Load Balancing and Replication on Red Hat Cluster Suite (RHCS), on-prem, hybrid and cloud-based Postgres server/query tuning/optimisation, database monitoring, PostgreSQL workshops and training courses.
Bilingual customer-focused and enthusiastic Linux professional with expert knowledge of the PostgreSQL relational database management system.
Specialities: PostgreSQL, EnterpriseDB Postgres Plus Advanced Server, Postgres Plus Cloud Database, PostgreSQL High Availability, Load Balancing and Replication on Red Hat Cluster Suite (RHCS), on-prem, hybrid and cloud-based Postgres server/query tuning/optimisation, database monitoring, PostgreSQL workshops and training courses.
Markets
United Kingdom
Language
English
Fluently
Polish
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2018 - ?
freelance
CEO / Principal Consultant
Oliphant Consulting Ltd.
Multiple clients including the Registers of Scotland, EOH Europe Ltd, Seeburger AG and Tatras Data,
all requiring hands on assistance and knowledge transfer to help them integrate their existing local and cloud based PostgreSQL databases with modern Open Source tools including TICK / EFK stacks
with Grafana / Kibana dashboards, Ansible and Jenkins CI/CD automation. Tasks included among
others optimising the performance of local and cloud based database instances by tuning both hosts and queries, resolving potential streaming and logical replication issues, implementing site wide
database upodates via Ansible, Jenkins and Git with live monitoring dashboards, migrating out
PostgreSQL commited data via logical decoding into Apache Kafka topics as well as creating database
reporting scripts for Jira / Conflunece or Barman centralised backups using Bash or Python.
all requiring hands on assistance and knowledge transfer to help them integrate their existing local and cloud based PostgreSQL databases with modern Open Source tools including TICK / EFK stacks
with Grafana / Kibana dashboards, Ansible and Jenkins CI/CD automation. Tasks included among
others optimising the performance of local and cloud based database instances by tuning both hosts and queries, resolving potential streaming and logical replication issues, implementing site wide
database upodates via Ansible, Jenkins and Git with live monitoring dashboards, migrating out
PostgreSQL commited data via logical decoding into Apache Kafka topics as well as creating database
reporting scripts for Jira / Conflunece or Barman centralised backups using Bash or Python.
Apache, Tuning, Streaming, Kibana, Ceo, Monitoring, Kafka, Open source, Bash, Python, Cloud, Database, Automation, Jenkins, PostgreSQL, Jira, Git
2015 - 2018
job
Senior Consultant
EnterpriseDB.
Responsibe for the review, design, implementation and support of Postgres solutions for EnterpriseDB
clients [on-site and remote]. Tuned and optimized Postgres database clusters, Linux servers and
attached storage soutions. Ran knowledge transfer and training sssions on PostgreSQL and EnterpriseDB software. Implemented PostgreSQL automation using Jenkins and Ansible, monitoring
using EDB PEM and the Influx TICK stack as well as cloud solutions using EDB Ark, AWS and Openshift
solutions.
clients [on-site and remote]. Tuned and optimized Postgres database clusters, Linux servers and
attached storage soutions. Ran knowledge transfer and training sssions on PostgreSQL and EnterpriseDB software. Implemented PostgreSQL automation using Jenkins and Ansible, monitoring
using EDB PEM and the Influx TICK stack as well as cloud solutions using EDB Ark, AWS and Openshift
solutions.
Design, Linux, AWS, PostgreSQL, Training, Jenkins, Automation, Database, Cloud, Support, Implementation, Postgres, Monitoring, Software, OpenShift, Storage
2012 - 2015
job
Database Administrator
William Hill.
Organised the daily database Business-As-Usual desk support including typical DBA/system
administrator chores like daily / weekly system checks, database backups, server/process monitoring
via Nimsoft with custom scripts, server software upgrades, patching and scripted PCI compliance
verification. Additionaly designed and implemented PostgreSQL based internal solutions as wel as
trained both William Hill and external third parties on PostgreSQL technoogies.
administrator chores like daily / weekly system checks, database backups, server/process monitoring
via Nimsoft with custom scripts, server software upgrades, patching and scripted PCI compliance
verification. Additionaly designed and implemented PostgreSQL based internal solutions as wel as
trained both William Hill and external third parties on PostgreSQL technoogies.
PostgreSQL, Database, Compliance, Support, Monitoring, Software, Server, Administrator
2007 - 2012
freelance
Head Administrator
Polish Transplant Coordinating Centre.
Supported existing Linux and PostgreSQL servers as well as reimplemented better data backup and security strategies company-wide. Successfully migrated an internal MS-Windows closed-source data
input appication with floppy disk based data transfers, to a multi-user web based countrywide
alternative using Open Source tools like PHP and PostgreSQL.
input appication with floppy disk based data transfers, to a multi-user web based countrywide
alternative using Open Source tools like PHP and PostgreSQL.
Php, Linux, PostgreSQL, Windows, Open source, Security, Backup, Web, Administrator
2005 - 2009
job
Senior support specialist
Softbank S.A.
Supported the COBOL based, "Zorba 3000" integrated banking application implemented nationwide at PKO BP bank, by assisting and solving bank branch administrators / operators with their Zorba 3000,
Oracle / DB2, and HP-UX / AIX problems and issues. Installed and supported internal Unix / Linux
software and packages at client locations.
Oracle / DB2, and HP-UX / AIX problems and issues. Installed and supported internal Unix / Linux
software and packages at client locations.
Linux, UX, Oracle, Unix, DB2, Hp-ux, Cobol, Banking, Support, Software, Aix
2001 - 2005
job
CEO
Faerie IT solutions.
Created specialized websites and applications to meet customer project needs.
Projects included among others on-demand media streaming for a local music company, multi user HR
database applications, multiple internet shops, and CD/DVD multimedia autostart PC application.
Projects included among others on-demand media streaming for a local music company, multi user HR
database applications, multiple internet shops, and CD/DVD multimedia autostart PC application.
Websites, Database, Ceo, Music, Streaming, Internet, PC
1999 - 2001
job
Eastern Europe Region Product Support Specialist
Creative Labs (Irl.) Ltd.
Researched competitor products as well as presented current and future technologies to IT journalists.
Trained and supported distributor support personnel on upcoming technologies and support
methodology. Acted as liaison between regional journalists / distributors and rest of company.
Internally promoted better support of Creative equipment under Linux.
Trained and supported distributor support personnel on upcoming technologies and support
methodology. Acted as liaison between regional journalists / distributors and rest of company.
Internally promoted better support of Creative equipment under Linux.
Linux, REST, It, Support
2000 - 2000
job
compliance country coordinator
Lucent Technologies Poland S.A..
located, verified and upgraded all old "Definity PBX" switches
with Y2K incompatible software. Recipient of Director's financial award for work achievements.
with Y2K incompatible software. Recipient of Director's financial award for work achievements.
Compliance, Coordinator, Software
1998 - 1999
job
IP/Telecomm support engineer
Lucent Technologies Poland S.A.
Designed, implemented and supported advanced call centre solutions utilizing "Computer Telephony Integration" using external software and Lucent Technology equipment. Supported and administered
all Linux and Unix [Unixware, AIX and Solaris] based equipment and software sold to clients. Year
all Linux and Unix [Unixware, AIX and Solaris] based equipment and software sold to clients. Year
Linux, Unix, Integration, Technology, Support, Software, Aix
1996 - 1998
freelance
Co-owner / Administrator
VR.pl S.C.
Administered Red Hat Linux / PostgreSQL and MySQL database servers at ISP start-up. Designed and implemented new services and functionality based on Open Source software.
Mysql, Linux, PostgreSQL, Database, Open source, Software, Administrator, UP
1995 - 1996
job
Head administrator
Obsługa Funduszy Inwestycyjnych.
Administered local Novell / Windows NT servers and supported users with any IT issues.
Localized and modified internal Fox Pro application to better support Polish market during stay at Forum Financial US headquarters.
Localized and modified internal Fox Pro application to better support Polish market during stay at Forum Financial US headquarters.
Windows, It, Support, Administrator
1994 - 1995
job
Specialist
Foundation for Privatization in the Republic of Poland.
Co-created documentation required for EC PHARE assistance programme tenders in Poland.
Developed and implemented a secure internal database application, decreasing retrieval speed of tender details from paper files in storage.
Developed and implemented a secure internal database application, decreasing retrieval speed of tender details from paper files in storage.
Database, Storage
1992 - 1994
job
Specialist
Warsaw Stock Exchange S.A.
Presented and explained Warsaw Stock Exchange trading mechanisms to groups of foreign visitors.
Monitored and reviewed software developed for brokerage houses by commercial software houses.
Verified correctness of accounting procedure implementations in brokerage / external software.
Monitored and reviewed software developed for brokerage houses by commercial software houses.
Verified correctness of accounting procedure implementations in brokerage / external software.
Exchange, Software
My education
1991
-
1995
Warsaw School of Economics
N/a, Internal Commerce
N/a, Internal Commerce
Piotr's reviews
Piotr has not received any reviews on Worksome.
Contact Piotr Adamiak
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Piotr directly in Worksome.
38000+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark