What are the responsibilities and job description for the PostgreSQL Database Engineer position at New York Technology Partners?
Title: PostgreSQL Database Engineer
Location: Berkeley Heights, NJ or Alpharetta, GA
Position: Contract
Description:
The PostgreSQL Database Engineer will be part of a team of DBAs supporting other teams consisting of application developers, organizational Production and Dev Ops resources.
The engineer will be responsible for maintenance, implementation and performance of critical PostgreSQL RDBMSes hosted on local and remote Linux based servers.
The successful candidate will be responsible for database and code analysis, performance tuning, SQL and stored procedure development and testing.
As with any engineering position, creating and maintaining technical documentation will be performed.
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.
Qualifications:
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.
