
Database Platform Administrator, PostgreSQL
Infotree Global Solutions
full-time
Posted on:
Location Type: Remote
Location: Poland
Visit company websiteExplore more
Tech Stack
About the role
- Install, configure, and maintain PostgreSQL servers.
- Configure database security and server parameters.
- Set up and maintain backup and restore mechanisms, including WAL and Point-in-Time Recovery (PITR).
- Configure and operate streaming and logical replication, failover, and high-availability solutions.
- Optimize database performance (query tuning, indexing, partitioning, autovacuum, planner analysis).
- Monitor databases, collect metrics and logs, and troubleshoot performance or stability issues.
- Perform minor and major PostgreSQL upgrades and migrations, ensuring extension compatibility.
- Use PL/pgSQL and PostgreSQL client tools (e.g. psql) in day-to-day work.
Requirements
- Hands-on experience administering PostgreSQL in production environments.
- Solid understanding of PostgreSQL internals, replication, and backup mechanisms.
- Experience with performance tuning and troubleshooting.
- Knowledge of high-availability and disaster recovery concepts.
- Experience working as part of a client-side or in-house database team.
- Communicative level of English.
Benefits
- Fully remote work.
- Long-term cooperation as part of the client’s internal team.
- Work on stable, business-critical systems in an enterprise environment.
- Real influence on the reliability, performance, and evolution of the PostgreSQL platform.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
PostgreSQLPL/pgSQLquery tuningindexingpartitioningautovacuumbackup and restore mechanismsstreaming replicationlogical replicationhigh-availability solutions
Soft Skills
communication