Database Administrator (DBA) - PostgreSQL / AWS
HPS · Casablanca-Settat
Job description
About the role
HPS, a multinational company and global leader in electronic payments, is hiring a Database Administrator (DBA) with solid PostgreSQL fundamentals. The role involves administering, monitoring and optimizing databases in mission-critical, high-volume transactional production environments, working closely with development, architecture and production teams and an experienced DBA who provides guidance and mentorship.
Key responsibilities
- Administer and maintain PostgreSQL databases (configuration, backups, recovery, monitoring)
- Monitor performance and help investigate and resolve production incidents
- Analyze and optimize SQL queries, indexes and execution plans (EXPLAIN / ANALYZE)
- Identify connection issues, long-running transactions, locks and resource bottlenecks
- Run maintenance and optimization tasks such as VACUUM, AUTOVACUUM and statistics updates
- Use AWS services and monitoring tools including RDS / Aurora PostgreSQL, CloudWatch and Performance Insights / Database Insights
- Contribute to partitioning, data volume management, migrations and performance optimization
- Investigate advanced issues such as XID wraparound, idle-in-transaction, bloat and contention
- Document incidents, technical analyses and operational procedures
Required profile
- Degree in Computer Science, IT or a related field
- At least 5 years of experience in database administration
- Fluency in written and spoken English, with the ability to collaborate with international teams
- Strong analytical and problem-solving skills, self-motivated and eager to learn
Required skills
- Hands-on PostgreSQL, preferably in production environments
- Strong SQL and query optimization and indexing
- Understanding of transactions, locking and PostgreSQL maintenance
- Database monitoring, troubleshooting and incident resolution
- Linux/Unix environment
- Preferred: AWS RDS / Aurora PostgreSQL, CloudWatch, Performance Insights, RDS Proxy, partitioning, replication, high availability and disaster recovery; Oracle (a plus); banking or high-volume transactional experience
Questions fréquentes
Why are you reporting this job?
Explore further
Salaries, guides and searches in Morocco.
Salaries by job title
Popular searches
Apply in 30 seconds
Enter your email to apply. An account will be created automatically.
By continuing, you accept our terms of use.
Already have an account? Login
A question about this job?
Ask it here: you will get the full job summary by e-mail, right away.
Published 10 hours ago
Expires 1 month from now
13 views · 0 interested
Boost your chances
Upload your CV — we will match you with relevant openings.
Analyzing your CV...
HPS
Casablanca-Settat
Related job offers
-
Chef de projet Data Governance (F/H)
Sofrecom Maroc Casablanca-Settat -
Product Owner – Marché des Particuliers & Professionnels
Banque Centrale Populaire - BCP Casablanca-Settat -
Stage développeur Odoo / Python (H/F)
BWI TECHNOLOGIES Casablanca-Settat -
Senior Consultant AMOA Bancaire H/F
Devoteam Casablanca -
Cloud Engineering Landing Zone Network Expérimenté (Cloud Ops)
Devoteam Rabat