Postgresql Database Engineer Apply
Hi ,
Our client is looking PostgreSQL Database Engineer for Long Term Contract project in Berkeley Heights, NJ or Alpharetta, GA below is the detailed requirements.
Job Title : PostgreSQL Database Engineer
Location : Berkeley Heights, NJ or Alpharetta, GA
Duration : Long Term Contract
Exp: 12+ Years
Job Description:
- 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.