Welcoming Data Egret – the new fresh look of PostgreSQL Consulting
You know how sometimes after a good productive day at work you feel that you’ve done it – you’ve achieved what you planned and you are just in the right place? Well, I rarely feel that way and I love it! I love the fact that every new day brings a new challenge, a new hard decision to make, a new client or a new colleague from whom I would be able to learn.
Since we started PostgreSQL-Consulting five years ago every day has been just like that – a new excitement and rush, problems and solutions, questions and answers and although it has been a while I feel that we’re just getting started.
To celebrate our five year anniversary and acknowledge this ever growing sense of excitement as of 1 March we will be changing our name to Data Egret.
This change is a result of our efforts to mirror the success of our company and promise to our clients to keep delivering personal, efficient and valuable support whenever they need it. We cherish personal approach and strong partnership that we developed with our clients and our rebranding will not change that.
PostgreSQL will remain at our core and we are grateful to be given the opportunity to contribute to its development and growth. PostgreSQL community is an amazing crowd to be a part of and I see it as my personal goal to make sure that as a company we continue to support it and share our knowledge and passion for database maintenance through our solutions and training opportunities.
So next time when you have that feeling that you already arrived, just remember that there is always another mountain ahead and a new challenge to embrace.
CEO, Data Egret aka PostgreSQL-Consulting
PS Our official address, legal name, phone numbers and skype usernames will remain the same. New email addresses will be in the format of first initial followed by last name, however, you can also keep using our old ones.
In my previous post I gave an overview of some general parameters that will work well in a standard setting. They might be aggressive, but will allow…
Senior PostgreSQL DBA
We are a consulting firm that offers remote PostgreSQL administration services. We are looking for a seasoned PostgreSQL DBA specialist for a remote full-time position.
Who will you be working with?
Some clients have their own DBA teams, with whom you will be working and some don’t – in this case you will be working with client’s developers and technical managers. In either case you will be surrounded by best in class Data Egret PostgreSQL DBA, who have many years of experience servicing our clients.
What skills will you gain?
As well as harnessing your technical skills you will grow as a technical support specialist, who is able to listen to our clients, ask questions, review possible solutions with them, and be a reliable partner, who will add value beyond customer expectations.
What will your job be?
You will be the focal point to our clients when it comes to databases – figuring out why things don’t work the way they should, providing guidance and fixes to ensure that our client’s high availability projects go like clockwork.
Here are a few examples of your day-to-day technical tasks:
Make changes in database’s schema under load
Perform slow query analysis and optimisation
Correctly create/adjust indexes for query optimisation
Set up and configure Postgres on new servers
Setup Postgres database replication
Set up backup process and perform recovery
Perform minor and major upgrades
Database health check
What do we expect from you?
You are a seasoned DBA with 2 or more years of experience in administering high availability PostgreSQL projects (including replication configuration, performance tuning, monitoring configuration etc.)
Have experience in optimising complex SQL queries
Enjoy working independently on vague client briefs
You are a confident Linux user and know how to administer it (Ubuntu/Debian/RedHat),
Have a general understanding of database theory
Have basic knowledge of shell scripting (writing a couple of screens-lengthy script that will be understandable to other admins and yourself a few month down the line)
You can write a complex (and very complex) SQL query
You are a keen learner and eager to discover new solutions to old problems
This is a client facing role and the ability to communicate your actions and be able to reason with clients is imperative.
What skills would be a plus?
Familiarity with Patroni
Familiarity with some DevOps tools such as Ansible/Docker/Kubernetes
C programming skills and experience in analysing with perf/strace/gdb
Administration experience with cloud platforms
Basic knowledge of Russian language would be a plus
Why choose Data Egret as your place of work?
You will become part of one of the leading PostgreSQL DBA teams working in a company that has been named a significant sponsor to PostgreSQL by the Postgres community.
Will be able to brush up your database administration skills on a multitude of databases in different environments and gain experience that would take you years to get working in-house.
What do we offer?
A competitive pay based on your experience and annual performance-based bonus scheme
Full-remote working, offering you the opportunity to actually have a life 🙂
Flexible working hours
An opportunity to work alongside colleagues DBA, who live and breathe Postgres and contribute to its development
Support of your participation in community conferences
Collaborative and open environment where you are supported by your colleagues and can learn and thrive
Most emergencies leading to service unavailability and loss of your data can be mitigated and detected at an early stage with minimal effort. Data Egret Health Check will ensure a smooth running of your service, give you a headstart for your launch or migration and will allow better budgetary planning.
We will provide you a tailored offering based on your system specifications, however, below rates will give you an idea of pricing for our Health Check solution.
PostgreSQL configuration analysis
from 500 €
Hardware and OS configuration analysis
from 600 €
Slow SQL queries analysis
from 500 €
Comprehensive performance Health Check*
from 3500 €
* For single PostgreSQL installation (1 master + 1 replica)
Whether you are looking for an immediate support for your system or an advice on how best to maintain it in a long run, our experts are there for you. A bundle of DBA hours that can be used for getting expert advice as well as hands-on assistance on:
Backup and recovery
With our PostgreSQL Consulting service our clients:
Improved their PostgreSQL performance
Established correct scaling strategy
Decreased response time of their services
Mitigated future emergencies
Increased uptime of their system
Have set up a reliable backup system
Established the PostgreSQL performance monitoring process
Pricing: from €350 per hour (plus VAT)*
* Consulting hours can be purchased in 10 hour-bundles that are valid for one year. Minimum billing time – 1 hour, then in 30-minute intervals.
24/7 PostgreSQL Support offers you a combination of ongoing consultancy from our experts as well as round the clock support from dedicated team. To ensure smooth running of your systems and give you peace of mind we will be providing following services:
Dedicated Data Egret team
that will be your contact in case of any questions or concerns. Team that will be aware of your system’s specifications and will work on any arising issues within 15 minutes to an hour from enquiry.
Real time counsel
on everything PostgreSQL provided by our team of experts to your company developers and operations engineers.
Ongoing monitoring of your databases
that includes query performance, issues management and recommendation on performance improvements.
of PostgreSQL and related software.
Backup and recovery
that includes regular backup of your database and recovery solution with regular test recovery.
At Data Egret we are committed to protecting your privacy.
Information we collect
You are free to explore our Websites (dataegret.com and dataegret.ru) without providing any Personal Information about yourself. When you visit our Websites we use Google Analytics tool to collect information about traffic to our websites and the website usage to be able to analyse it and provide you with a better experience in the future.
Google Analytics transmits collected website traffic data to Google servers in the United States. It doesn’t identify individual users or associate your IP address with any other data held by Google.
This refers to any information that you voluntarily submit to us and that identifies you personally, including contact information, such as your name, e-mail address, company name, address, phone number, and other information about yourself or your business.
When you contact us through “Contact us” button on our websites we will use information provided for responding to your enquiry and will save it for future reference. We will not use this information for sending you any marketing emails without receiving prior consent from you.
When we have no ongoing legitimate business need to process your Personal Information, we securely delete the information or anonymise it or, if this is not possible, then we will securely store your Personal Information and isolate it from any further processing until deletion is possible. We will delete this information from the servers at an earlier date if you request it.
Social Media Features
Data Egret GmbH (Germany) will not share information we receive from you with third parties.
We do not currently have any subscription services.
Should we launch such activity and you submitted your personal information through our online Contact form in the past we will ask for your explicit permission to receive such information from us.
If you are not sure what information and if any we hold about you or would like us to delete any of that information please feel free to contact us via [email protected]
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.