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. 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 the following areas relative to PostgreSQL:
Installation
Install and configure new database servers using best practices.
Ensure all database servers are backed up.
Perform restoration testing.
Database maintenance
Define and implement maintenance plans for database systems.
Database monitoring
Proactively identify, troubleshoot, and resolve live database system issues.
Capacity planning and forecasting.
Creating and reviewing data access audits.
Performance Tuning
Identification of queries having the largest performance impact.
Documentation and training
Providing training for developers and other technical resources.
Data conversion
Assist with data migrations between DBMS platforms.
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.
Bachelor’s degree in computer science or a related field
~ A minimum of 1-2 years of database administration experience
~ A minimum of 1 year of experience performing or supporting application development
~
~ Containers or Kubernetes knowledge and experience is a plus
~ Linux OS experience
~ Programming language experience is a plus (Java, Python, shell, etc)
~ Strong understanding of database structure and design principles
~ Familiarity with database security principles
~ Familiarity with a variety of installation platforms including Linux, Cloud, and Cloud provider-managed instances
~ Ability to work remotely but within a team structure
~ Fluency in English is a requirement, ability in spanish is also preferred but not required
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.
This involves reviewing automated alerts, checking logs for unusual activity, and monitoring database performance metrics like CPU usage, memory allocation,
and disk I/O. A significant portion of time is dedicated to performance tuning. 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.
DBAs are constantly vigilant against unauthorized access and data breaches. They are the digital bouncers, ensuring only the right people get into the data club.
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.
El anuncio original lo puedes encontrar en Kit Empleo:
https://www.kitempleo.es/empleo/209277494/postgresql-remote-database-administrator-th988-principado-asturias/?utm_source=html
#J-18808-Ljbffr