This Job Vacancy has Expired!

PostgreSql Administrator Remote 6+ Month Contract

Request Technology - Craig Johnson

Posted on Apr 4, 2021 by Request Technology - Craig Johnson

Not Specified, PR
IT
Immediate Start
Annual Salary
Contract/Project


*We are unable to sponsor for this 6+ Month contract role, no 3rd party candidates will be considered*

Prestigious Global Firm is currently seeking a PostgreSql Administrator for a remote 6+ Month Contract.

Responsibilities:

  • Administer PostgreSQL databases through all phases of their development life cycle.
  • Perform routine database maintenance tasks including vacuuming, statistics updates, re-indexing, and log file maintenance.
  • Setup monitoring using the statistics collector or third-party tools to ensure optimal query performance.
  • Configure backup and recovery plans for each PostgreSQL instance to meet or exceed service level agreements.
  • Install and configure PostgreSQL instances on multiple operating systems with consistency and in accordance with industry best practices.

  • Plan and implement high availability, load balancing, and replication.

Qualifications:

  • Minimum 5 years of experience with PostgreSQL 9.6 or greater.
  • Experience installing and administering PostgreSQL on multiple Linux distributions (eg Red Hat, Ubuntu, CentOS)
  • In depth knowledge of PostgreSQL internals.
  • Solid understanding of database design principals.
  • Familiarity using using execution plans to optimize query performance.
  • Good SQL language skills including the use of routines and PL/pgSQL.
  • Good performance tuning skills for both the instance and queries.
  • Ability to proactively identify, troubleshoot and resolve production database or instance issues.
  • Knowledge of disaster recovery principles and practices, including configuring backups and testing restores.
  • Hands-on experience with the setup and configuration of high availability environments.
  • Ability to set and meet deadlines.
  • Ability to work in high-pressure situations.
  • Excellent attention to detail.
  • Strong written and verbal communication skills, including technical writing and documentation.



Reference: 1152808704

Set up alerts to get notified of new vacancies.