Database Platform Administrator (PostgreSQL)

Infotree Global Solutions·Remote(United States)
Other

WFA Digital Insight

As the demand for skilled database administrators continues to grow, with a 25% increase in job postings over the last year, professionals with expertise in PostgreSQL are in high demand. Infotree Global Solutions is at the forefront of this trend, seeking a Database Platform Administrator to support their critical business systems. With the shift towards remote work, this role offers the opportunity to work on stable, business-critical systems from anywhere, making it an attractive option for those looking for a long-term, fully remote setup. Before applying, candidates should be prepared to demonstrate their hands-on experience with PostgreSQL and their ability to work independently in a remote environment.

Job Description

About the Role

The Database Platform Administrator role at Infotree Global Solutions is a critical position that involves operating and developing a PostgreSQL platform to support business-critical systems. As a key member of the database platform team, you will work directly with the client's team in a long-term, fully remote setup. Your day-to-day responsibilities will include installing, configuring, and maintaining PostgreSQL servers, as well as optimizing database performance and troubleshooting issues. The team you will be working with is part of a large enterprise environment, and your contributions will have a real influence on the reliability, performance, and evolution of the PostgreSQL platform.

In this role, you will have the opportunity to work on real production systems, applying your skills and expertise to ensure the smooth operation of critical business systems. You will be working closely with the client's team, providing input and guidance on database-related matters, and contributing to the development of the PostgreSQL platform. The ideal candidate will have a solid understanding of PostgreSQL internals, replication, and backup mechanisms, as well as experience with performance tuning and troubleshooting.

Infotree Global Solutions is committed to providing a supportive and collaborative work environment, with opportunities for professional growth and development. As a remote worker, you will be part of a distributed team, working closely with colleagues from around the world to achieve common goals.

What You Will Do

  • Install, configure, and maintain PostgreSQL servers to ensure optimal performance and reliability.
  • Configure database security and server parameters to protect sensitive data and prevent unauthorized access.
  • Set up and maintain backup and restore mechanisms, including WAL and Point-in-Time Recovery (PITR), to ensure business continuity in the event of a disaster.
  • Configure and operate streaming and logical replication, failover, and high-availability solutions to ensure maximum uptime and availability.
  • Optimize database performance by tuning queries, indexing, partitioning, autovacuum, and planner analysis.
  • Monitor databases, collect metrics and logs, and troubleshoot performance or stability issues to ensure prompt resolution.
  • Perform minor and major PostgreSQL upgrades and migrations, ensuring extension compatibility and minimal downtime.
  • Use PL/pgSQL and PostgreSQL client tools (e.g. psql) in day-to-day work to streamline tasks and improve efficiency.

What We Are Looking For

  • Hands-on experience administering PostgreSQL in production environments, with a solid understanding of PostgreSQL internals, replication, and backup mechanisms.
  • Experience with performance tuning and troubleshooting, with the ability to analyze complex issues and develop effective solutions.
  • Knowledge of high-availability and disaster recovery concepts, with experience implementing and managing these solutions in a production environment.
  • Experience working as part of a client-side or in-house database team, with excellent communication and collaboration skills.
  • Communicative level of English, with the ability to work effectively in a remote team environment.
  • Strong problem-solving skills, with the ability to think critically and outside the box.
  • Experience with PostgreSQL client tools (e.g. psql) and scripting languages (e.g. Python).

Nice to Have

  • Experience with cloud-based PostgreSQL solutions, such as Amazon RDS or Google Cloud SQL.
  • Knowledge of containerization technologies, such as Docker, and experience with container orchestration tools, such as Kubernetes.
  • Experience with monitoring and logging tools, such as Prometheus and Grafana, and experience with alerting and notification systems.

Benefits and Perks

  • Fully remote work arrangement, with the flexibility to work from anywhere in the world.
  • Long-term cooperation as part of the client's internal team, with opportunities for professional growth and development.
  • Work on stable, business-critical systems in an enterprise environment, with real influence on the reliability, performance, and evolution of the PostgreSQL platform.
  • Competitive compensation package, with benefits and perks tailored to remote workers, including health insurance, retirement planning, and paid time off.

How to Stand Out

  • When applying for this role, be sure to highlight your hands-on experience with PostgreSQL, including any relevant certifications or training.
  • Make sure to include specific examples of your experience with performance tuning and troubleshooting, as well as your knowledge of high-availability and disaster recovery concepts.
  • Be prepared to discuss your experience working in a remote team environment, and how you handle communication and collaboration in a distributed team.
  • Consider including a link to your GitHub profile or a personal project that demonstrates your skills with PostgreSQL and related technologies.
  • When negotiating salary, be sure to research the market rate for similar positions and be prepared to discuss your expectations and requirements.
  • Pay attention to the company culture and values, and be prepared to ask questions about the team and the work environment during the interview process.

This is a remote position listed on WFA Digital, the platform for professionals who work from anywhere. Browse more remote jobs across all categories.