PostgreSQL Developer

PostgreSQL, PL/PGSQL, Stored procedures, Functions, Triggers, complex SQL queries, complex SQL Scripts
Contract W2, Contract Corp-To-Corp, 12 Months
Depends on Experience
Travel not required

Job Description

Technical Skills:

  • RDBMS: PostgreSQL
  • Languages: Shell scripting, PL/PGSQL
  • Operating Systems: Linux, Unix, Windows
  • Backups: Logical and Physical backups
  • High Availability: WarmStandby, Hotstandby, Streaming replication

 

Responsibilities:

  • 1. Should be able to write and understand the complex SQL Scripts, Stored procedures, Functions and triggers.

    2. Should be able to debug complex SQL queries/stored procedures.

    3. Experience in Oracle to PostgreSQL migration.

    4. Query tuning

    5. DB tuning

    6. Any other DB related task needed for project Migration project to migrate from Oracle to PostgreSQL

    7. Monitoring databases to optimize database performance and diagnosing.

    8. Monitor and manage database indexes for optimal performance.

    9. Maintaining custom vacuum strategies at table and DB levels.

Dice Id : 91118308
Position Id : 6611030
Originally Posted : 3 months ago
Have a Job? Post it

Similar Positions

Couchbase DBA
  • IT America
  • Santa Clara, CA
Senior Oracle DBA RAC
  • Trinamix
  • San Jose, CA
PostgresDBA
  • Wipro Ltd.
  • Sunnyvale, CA