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

SynergisticIT

Entry Level Python/R Developer Job at SynergisticIT

 ...just want a degree-they're looking for job-ready developers with hands-on experience, relevant...  ...employers want now. Currently, We are looking for entry-level software programmers, Java Full stack developers, Python/Java developers, Data analysts/Data Engineers/... 

Overhaul Carriers

Truck Drivers CDL A No Experience Necessary Recent Graduates Openings Job at Overhaul Carriers

 ...career with Overhaul Carriers Ltd., new drivers receive guided training, reliable miles and...  ...paid weekly. Weekly earnings for new CDL Class A $1260 to $1500 weekly pay after...  ...into dedicated or regional positions as experience grows.Training Program: On-the-road instruction... 

GovernmentJobs.com

Construction Job at GovernmentJobs.com

 ...Construction Engineer The County of San Diego invites your interest in an excellent career opportunity! Construction Engineer Interviews will take place on an ongoing basis. Job offers will be made after successful completion of interviews. The starting salary for... 

AtWork!

Patient Care Technician / CNA - $27-$29/hr | PRN Job at AtWork!

 ...Patient Care Technician / CNA - $27-$29/hr | PRN Flagstaff, AZ We are hiring Patient Care Technicians / Certified Nursing Assistants to assist Veterans and members in a professional care environment in Flagstaff, AZ. Schedule: 12-hour shifts Day... 

PureVida Water

Outside Sales Representative B2B Job at PureVida Water

 ...simple solution they absolutely love! Flexible work schedule balanced between being out in your territory and working from home. A super effective Inside Sales engine...  ...deal! Company Description PureVida is a Christian owned company with a main priority of......