PostgreSQL Database Engineer - Remote / Telecommute

$104,000 - $114,400/Yr

Cynet Systems - New York, NY

Full-time - Mid Level

Remote - New York, NY

Professional, Scientific, and Technical Services

About the position

The PostgreSQL Database Engineer will be responsible for managing PostgreSQL database servers throughout various product lifecycle environments, ensuring high performance, availability, and security. This role involves configuring and maintaining database servers, assisting developers with query tuning, and providing technical mentorship to peers.

Responsibilities

• Manage PostgreSQL databases servers during multiple product lifecycle environments, from design to production systems.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Assist developers with complex query tuning and reference refinement.
• Research, Test and Recommend database structural and performance enhancements.
• Share technical expertise, providing technical mentorship and cross-training to other peers and team members.

Requirements

• 5+ years PostgreSQL, Oracle, or similar RDBMS products Administration experience.
• 5+ years of experience with SQL and CLI interfaces such as PSQL and SQL*Plus.
• 5+ years of experience with Linux or UNIX operation systems.
• Experience with Performance Tuning and Optimization, using native monitoring and troubleshooting tools.
• Experience with backups, restores and recovery models.
• Experience with range type table/index partitioning.
• Experience with automatic queuing such as PGQ.
• Experience with database stored procedure scripting languages such as PG/PLSQL or PLSQL.
• Knowledge of Physical High Availability (HA) and Disaster Recovery (DR) methods.
• Excellent written and verbal communication.
• Ability to organize and plan work independently.
• Ability to work in a rapidly changing environment.