» 2020 » November

I am looking for a maintenance product for my databaseI need assistance with migration of my databaseI have an issue with my database and need assistanceI am an existing customer and require assistanceOther

Go ahead

Contact

Please fill in the form below and we will get back to you shortly. If the matter is urgent please indicate in the Comments field.

Please note that the information you provide will be used by Data Egret for handling your request. For more information see our Privacy Policy.

Thank you for your message

We will contact you soon.

Your details will be used by Data Egret solely for the purposes of reviewing your job application. If needed you can familiarise with our Privacy policy here.

Thank you for your application!

We will get in touch with you regarding next steps!

We don’t want to sound like your mother, but ~~brushing your teeth~~ having your databases checked regularly is really important for your ~~health~~ application performance.

Our two-phase Premium cover is performed by DBA with 10+ years PostgreSQL experience who live and breathe Postgres.
They will ensure that your databases have the security and high availability your application needs.

– PHASE 1 –

Audit and optimisation

This is an induction phase, during which your databases will undergo a thorough review by our DBA, who will:

analyse load tune DB configuration
review your database monitoring data
review and optimise top query
assist in monitoring tool installation
set up auto-healthchecks

During this phase our DBA will be answering any questions regarding:

architecture
database configuration
OS configuration
high availability set up and replication
backup and recovery
upgrades (major and minor)
partitioning
scaling out and sharding practices
access privileges
support during migration to PostgreSQL
consult on hardware selection
locking and concurrency issues

Training

Your developers will also have an online training session run by our experts to make sure that they can tackle key PostgreSQL issues on an industry standard level.

– PHASE 2 –

Ongoing support

Once your databases have been audited and your team trained you will be moved to a subscription-based support. During this phase our DBA will be around to answer any questions and support in the following:

Questions related to database and OS configuration
Basic query optimisation
Questions that do not require an in-depth investigation
Post factum analysis of database outages (during working hours)
Autohealthcheck reports review (we notify you of any abnormalities)
Monitoring trigger review (we notify you of any abnormalities)

Price: from 11000€/year (for 2 PostgreSQL instances), Premium PostgreSQL cover is a one-year contract.

Price includes:

up to 10 hours DBA time monthly for the duration of Phase 1 (2 months) and
up to 2 hours monthly for Phase 2 (10 months).

Overtime is billed at the end of each month at 250€/hour rate.

Subject to client’s installation specifications and databases access Phase 1 may take longer and require additional fee that will be pre-agreed with client in advance.

SLA: Response time is provided as follows:

During Audit and optimisation (Phase 1) Data Egret provides support with up to 3h response during working hours.
During the Ongoing support (Phase 2) we answer any questions via email with up to 24 hours response time.

If you are interested in shorter response times we suggest our 24/7 PostgreSQL Support services.

Database Access: Data Egret PostgreSQL cover can be provided with or without access to databases, however without database access addressing any issues requires more time and therefore is less cost-effective process.

Interested in learning more? Give us a nudge via email or click the button below.

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
Perform failover/switchover
Set up backup process and perform recovery
Perform minor and major upgrades
Architectural consulting
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

Think you qualify?

Apply

Have questions about this opportunity?
Contact us! [email protected]

Want to be part of our team? Our current vacancies are listed below, but we always welcome applications from specialists who are eager to learn and grow.

01
Senior DBA (PostgreSQL)

Questions?

Get in touch

Training program is developed based on our client’s specific requirements and is run by our highly skilled DBA.

tailored program, developed specifically to address your company’s business needs;
the knowledge and hands-on experience acquired during the training can be used by your team straight away;
training by one of the leading PostgreSQL DBA in the industry.

Workshops usually have hands-on elements, we therefore suggest limiting the number of attendees to a maximum of 15.

Looking to upscale your team with PostgreSQL know-how? Contact us now.

Health Check

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.

Package	Price*
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)

PostgreSQL Consulting

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:

Query optimisation
Architectural improvements
Performance tuning
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

For price calculation please contact us.

Time is billed in 15-minute increments.

24/7 PostgreSQL Support

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.

Regular upgrades

of PostgreSQL and related software.

Backup and recovery

that includes regular backup of your database and recovery solution with regular test recovery.

Basic	Premium	VIP
Incl. up to 5h/month DBA time	Incl. up to 15h/month DBA time	Incl. up to 30h/month DBA time
Slack, Mattermost, Telegram	Slack, Mattermost, Telegram	Slack, Mattermost, Telegram
Response time — 1 Hour	Response time — 1 Hour	Response time — 30 minutes
Up to 2 PostgreSQL instances	Up to 5 PostgreSQL instances	Up to 10 PostgreSQL instances

This Privacy Policy governs our data collection, processing and usage practices. It also describes your choices regarding collection and use of your personal information. If you do not agree with data practices described in this Privacy Policy, you should not use our website. If you have any questions or concerns with regard to use of data that we collect through contact form submission please get in touch with us via [email protected] before submitting the form through our website.

We periodically update our Privacy Policy to comply with most recent regulations and to encompass our marketing activities. We therefore encourage you to review this Privacy Policy periodically. Current Policy has been updated on 29 August 2022.

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.

Google Analytics uses ‘cookies’ to collect information about website traffic and site usage. Cookies are industry standard and majority of the websites using them. A ‘cookie’ is a small text file that our site may place on your computer as a tool to remember your preferences. You may refuse the use of cookies by selecting the appropriate settings on your browser, however, please note that if you do that you may not be able to use full functionality of our websites.

Personal Information

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.

The information you provide through Contact form is saved using variety of security technologies and procedures through our European data processor service – Pipedrive. You can read more about it here https://support.pipedrive.com/hc/en-us/articles/360000335129-Pipedrive-and-GDPR

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

Our Websites (dataegret.com and dataegret.de) include Social Media Features, such as the Facebook Like button and Widgets, such as the Share This button. These features may collect your IP address, which page you are visiting on our sites, and may set a cookie to enable the feature to function properly. Social Media Features and Widgets are either hosted by a third party or hosted directly on our Websites. This Privacy Policy does not apply to these features. Your interactions with these features are governed by the privacy policy and other policies of the companies providing them.

Information sharing

Data Egret GmbH (Germany) will not share information we receive from you with third parties.

Subscription Services

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]

Month: November 2020

Interactive new look for PostgreSQL Observability

pg_utils: Low_used_indexes.sql, how it works and why it should be lower than 0.01?