Database Administrator (DBA) – PostgreSQL / AWS
وصف الوظيفة
Join HPS: We’re Hiring!
Are you passionate about technology and innovation? Are you ready to shape the future of electronic payments? If so, we invite you to join our dynamic team at HPS!
Who are we?
HPS is a constantly evolving multinational company and a global leader in electronic payments. Driven by excellence and innovation, we design and deliver high-performance solutions that power payment exosystems worldwide. Our diverse teams work on exciting, groundbreaking projects that are transforming the way we create, live, and share.
Creating a global impact is what makes us unique:
With offices around the world, we benefit from diversity and expertise in our daily operations. Present in 11 offices across all continents, we also offer attractive mobility opportunities across multiple business units.
What we are looking for:
We are looking for bright minds, technology pioneers, and passionate innovators who are ready to push boundaries and create a positive impact. Our career opportunities cover a wide range of fields, including:
Database Administrator (DBA) – PostgreSQL / AWS
Job Mission
We are looking for a DBA with solid PostgreSQL fundamentals, a curious and analytical mindset, and a strong willingness to develop their expertise alongside an experienced DBA. The candidate will be responsible for administering, monitoring, and optimizing our databases, particularly in mission-critical, high-volume transactional production environments.
The candidate will work closely with development, architecture, and production teams, as well as an experienced DBA who will provide guidance and mentorship on advanced PostgreSQL and AWS topics.
Key Responsibilities
- Administer and maintain PostgreSQL databases (configuration, backups, recovery, monitoring).
- Monitor database performance and participate in investigating and resolving production incidents.
- Analyze and optimize SQL queries, indexes, and execution plans (EXPLAIN / ANALYZE).
- Identify connection issues, long-running transactions, locks, and resource consumption bottlenecks.
- Participate in database maintenance and optimization activities (VACUUM, AUTOVACUUM, PostgreSQL statistics).
- Work with AWS database services and monitoring tools, including RDS / Aurora PostgreSQL, CloudWatch, and Performance Insights / Database Insights.
- Contribute to technical improvements, including partitioning, data volume management, migrations, and performance optimization.
- Participate in advanced investigations (XID wraparound, idle in transaction, bloat, contention), with guidance from experienced technical team members.
- Document incidents, technical analyses, and operational procedures.
Candidate Profile
Degree in Computer Science, IT, or a related field, with at least 5 years of experience in database administration.
Required Skills
- Good hands-on knowledge of PostgreSQL, preferably in production environments.
- Strong SQL skills and a good understanding of query optimization and indexing.
- Understanding of transactions, locking mechanisms, and PostgreSQL maintenance processes.
- Experience in database monitoring, troubleshooting, and incident resolution.
- Good knowledge of Linux/Unix environments.
Preferred Skills
- Experience with AWS RDS / Aurora PostgreSQL, CloudWatch, Performance Insights, and RDS Proxy.
- Familiarity with partitioning, VACUUM / AUTOVACUUM, and large database management.
- Basic understanding of replication, high availability, and disaster recovery.
- Knowledge of Oracle Database (a plus, not mandatory).
- Experience in banking or high-volume transactional environments.
Personal Attributes
- Strong analytical and problem-solving skills, with a structured approach to technical investigations.
- Self-motivated, curious, and eager to learn.
- Ability to collaborate effectively with development and production teams.
- Fluency in English (written and spoken) is mandatory, with the ability to communicate effectively in technical discussions and collaborate with international teams.
We value candidates with strong PostgreSQL fundamentals and a genuine willingness to learn and grow, rather than those who already master every advanced technical topic listed above.
هل أنت مهتم بهذه الوظيفة؟