Senior Postgre SQL Administrator

*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.