PostgreSQL DBA

Overview

Remote
On Site
Contract - W2

Skills

PostgreSQL
Oracle
psql
pg_ctl
DBMS

Job Details


This is a remote position.

Please Note:

  • This is a 100% Remote Position.
  • Candidate should willing to work in the PST time zone

Position Description
  • Installation and set
  • Migration exp from Oracle to PostgreSQL with tools like ora2pg
  • Create the objects in the database, such as triggers, indexes, etc.
  • Monitor the performance of the database and ensure optimum performance.
  • Identify potential issues in the database to solve them early.
  • Maintain backups and perform disaster recovery.
  • Monitor security and prevent any unauthorized access to the database.
  • Schedule consistent maintenance on the server
  • Maintain database schema.
  • Manage database availability.
  • Give best practice guidance to the development team.
  • Resolve any production data issues.
  • Taplespace management



Requirements

  • Bachelor's degree or Higher education
  • Migration experience from Oracle to PostgreSQL with tools like ora2pg
  • Role management
  • Develop automation technologies to accelerate the process of data loading.
  • Develop relational databases.
  • Ensure data integrity.
  • Manage user access and permissions by adding and removing users as required.
  • Maintain the database using different utilities. This includes using like pg_ctl and psql
  • Proficiency in managing databases using DBMS tools like Backup/Restore, Performance Tuning, Security Management etc.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.