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 isa 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 the following areas relative to PostgreSQL:
InstallationInstall and configure new database servers using best practices.Knowledge of High Availability (HA) and Disaster Recovery (DR).Upgrade minor and major versions.Backup and recoveryEnsure all database servers are backed up.Perform restoration testing.Database maintenanceDefine and implement maintenance plans for database systems.Standardize maintenance approaches across systems.Index and statistics maintenance.Database monitoringProactively identify, troubleshoot, and resolve live database system issues.Capacity planning and forecasting.Creating and reviewing data access audits.Tracking and reporting on Recovery Point Objectives (RPO) metrics.Performance TuningIdentification of queries having the largest performance impact.Improvements to indexes and execution plans.Troubleshoot transaction and concurrency issues.Assist developers with query optimization.Documentation and trainingCreate documentation on processes and procedures.Providing training for developers and other technical resources.Data conversionAssist with data migrations between DBMS platforms.Participate in the on-call support rotation
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 ExperienceBachelor’s degree in computer science or a related fieldA minimum of 2-3 years of Postgres experienceA minimum of 1-2 years of database administration experienceA minimum of 1 year of experience performing or supporting application development
Additional Qualifications:
Containers or Kubernetes knowledge and experience is a plusLinux OS experienceProgramming language experience is a plus (Java, Python, shell, etc)Ability to thrive in a fast-paced environmentStrong understanding of database structure and design principlesFamiliarity with database security principlesSolid scripting skills including pl/pgsql scripting and stored proceduresFamiliarity with a variety of installation platforms including Linux, Cloud, and Cloud provider-managed instancesEffective prioritization of tasksSuccessful time managementAbility to work remotely but within a team structureStrong communication skillsLanguage requirement:
Fluency in English is a requirement, ability in spanish is also preferred but not required
The Day to day of a DBA at OnGresA 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.