Postgre SQL DBA Job at Omni Inclusive, Saint Louis, MO

YlFHejJUU0s5S3FFY0g1V0RCaW9IcFE5
  • Omni Inclusive
  • Saint Louis, MO

Job Description

PostgreSQL Database Administrator

A PostgreSQL database administrator is responsible for managing a firm's PostgreSQL management. They ensure that the database runs smoothly and functions as expected to ensure business goals are achieved. They look for ways to optimize the performance of the database, create backups that come in handy during disaster recovery, and monitor security and access.

PostgreSQL DBA Roles and Responsibilities

A PostgreSQL DBA is an expert in managing the PostgreSQL database system. Let us take a look at their primary responsibilities.

  • 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 in case a disaster destroys the database.
  • 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.
  • Tablespace management.
  • 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.

Job Tags

Similar Jobs

Primoris

Gas Technician Job at Primoris

 ...Primoris Gas Operations, which consists of companies such as Q3 Contracting, ARB, Primoris Distribution Services , Pride and Future, has over 60 years of experience working in the natural gas distribution industry. Over this time, we have maintained numerous customer relationships... 

H&H Recruiting

Class A CDL Driver Job at H&H Recruiting

 ...OVER THE ROAD CLASS A DRIVERS WANTED CDL in Hand? Start Earning NOW! $1,400+ Weekly - No experience? No problem! We'll set you up for success. Home Time - Bi-weekly Regional OTR Routes - Steady miles without disappearing for months. No-Touch Freight - Drive... 

The Blood Connection

Hospital Services Delivery Driver Job at The Blood Connection

 ...transfusion facilities. Responsible for delivery of raw materials from satellite centers...  ...mobile collection sites. Good customer service skills are required in order to maintain...  ...Blood Connection. Essential Functions Driver Supported Tasks : Ensures that all... 

Democratic Attorneys General Association

Senior Digital Media Strategist Job at Democratic Attorneys General Association

 ...Title: Senior Digital Media Strategist Location: Washington, D.C. Pay Band: 3 Reports to: Director of Communications Position...  ...DC-based employees work in-office three days a week and work remotely from home two days a week. DAGA's office is open 9 AM - 6 PM... 

Fresenius Medical Care

Dialysis Program Manager Registered Nurse - RN Job at Fresenius Medical Care

 ...for the direct supervision of various levels of Home Therapies staff. EDUCATION : ~ Graduate of an accredited School of Nursing (R.N.) Advanced education preferred. Current appropriate state licensure. EXPERIENCE AND REQUIRED SKILLS : ~ Minimum of one...