This Job Vacancy has Expired!

Senior Postgre SQL Administrator

Posted on Mar 31, 2021 by Request Technology

Illinois, IL
IT
Immediate Start
Annual Salary
Contract/Project


*Permanent full time role*

A prestigious company is on the search for a Sr. Postgre SQL Administrator. This will be a remote 6 month or longer contract. They are only accepting W-2 candidates. They need someone with 5+ years of experience with PostgreSQL 9.6 or greater. They need experience installing and administering PostgreSQL on multiple Linux distributions (eg Red Hat, Ubuntu, CentOS).

Responsibilities:

  • Administer PostgreSQL databases through all phases of their development life cycle.
  • Perform routine database maintenance tasks including vacuuming, statistics updates, reindexing, 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.

Skills:

  • 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: 1146634621

Set up alerts to get notified of new vacancies.