Senior PostgreSQL DBA
Relocation | full time
Data Egret
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
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
Contact info:
grebenniki@dataegret.com
