OnGres - Senior Postgres DBA

OnGres (ON PostGRES) is a global reference in corporate level services and products for the Postgres ecosystem. It is a company deeply committed to the PostgreSQL ecosystem, carving out a niche as specialists in everything related to this powerful open-source database. Ongres developed StackGres, which is a powerful, open-source platform designed to make running enterprise-grade PostgreSQL on Kubernetes incredibly easy and efficient.

We are looking for a talented and experienced PostgreSQL Database Administrator (DBA) to manage, optimize, and maintain our PostgreSQL databases in a high-performance and mission-critical environment. You will work closely with teams across the organization to ensure database availability, performance, security, and scalability. The ideal candidate will have strong knowledge in database tuning, backups, high availability, monitoring systems, and automation (especially with tools like Ansible). Familiarity with containerization technologies such as Kubernetes will be considered a valuable asset to this role.

You will manage PostgreSQL databases across multiple product lifecycle environments—from development to mission-critical production systems—while configuring and maintaining database servers and processes. This position is to work completely remote.

Key responsibilities of this position include following areas relative to PostgreSQL :

Installation

• Install and configure new database servers using best practices.
• Knowledge of High Availability (HA) and Disaster Recovery (DR).
• Upgrade minor and major versions.

Backup and recovery

Database maintenance

Database monitoring

Performance Tuning

Documentation and training

Data conversion

Qualifications

The ideal candidate should be enthusiastic about database administration, proactive, a quick learner and a self-starter. Always focusing on the importance of protecting the customer data and environment.

Required Experience

Additional Qualifications :

The Day to day of a DBA at OnGres

A DBA in OnGres is like the guardian of an organization's most valuable digital asset : its data. Their day-to-day is a dynamic blend of proactive maintenance, reactive problem-solving, and strategic planning, ensuring that information flows smoothly and securely.

The morning often begins with a systematic health check. This involves reviewing automated alerts, checking logs for unusual activity, and monitoring database performance metrics like CPU usage, memory allocation, and disk I / O. Are there any slow-running queries? Is storage reaching critical levels? These early observations guide the day's priorities.

A significant portion of time is dedicated to performance tuning. This is a continuous quest for efficiency. They might analyze complex SQL queries to identify bottlenecks, create or modify indexes to speed up data retrieval, or adjust database configurations to optimize resource utilization. It's a bit like being a meticulous mechanic, always looking for ways to make the engine run smoother and faster.

Security is paramount. DBAs are constantly vigilant against unauthorized access and data breaches. This involves managing user permissions, implementing robust authentication mechanisms, applying security patches, and regularly auditing access logs. They are the digital bouncers, ensuring only the right people get into the data club.

Then there's the essential work of backup and recovery. A DBA ensures that comprehensive backup strategies are in place and regularly tested. If a disaster strikes – be it hardware failure, human error, or a cyberattack – they are the first responders, tasked with restoring the database to its last known good state, minimizing downtime and data loss.

Throughout the day, the DBAs are also involved in problem-solving. This can range from troubleshooting application connectivity issues to diagnosing database crashes or resolving data integrity problems. They often collaborate closely with developers, system administrators, and business users to understand and address issues promptly.