PostgreSQL Database Administrator (DBA)

  • O'Fallon, MO
  • Posted 13 hours ago | Updated 13 hours ago

Overview

Hybrid
Depends on Experience
Contract - W2

Skills

Postgres DBA
on-premise

Job Details

Role: Postgres DBA

A PostgreSQL Database Administrator (DBA) plays a critical role in managing and maintaining PostgreSQL databases within an organization's infrastructure.

Work location: O'Fallon, MO - Hybrid

Need on w2 Only.

Job Responsibilities:

  • Install and configure PostgreSQL database servers on-premises.
  • Optimize database configuration settings for performance and reliability.
  • Monitor database performance and resource usage.
  • Identify bottlenecks and implement performance tuning measures.
  • Use tools and scripts to analyze query performance and recommend optimizations.
  • Develop and implement backup and recovery strategies to ensure data integrity and availability.
  • Regularly review and update security policies and protocols.
  • Plan and execute database migrations and upgrades with minimal downtime.
  • Collaborate with developers and application teams to design efficient database schemas.
  • Ensure normalization and indexing strategies are applied for optimal data retrieval.
  • Diagnose and resolve database-related issues and errors.
  • Provide support to application developers in optimizing database interactions.
  • Maintain detailed documentation of database configurations, procedures, and policies.
  • Document changes made to the database environment and maintain an inventory of databases.
  • Develop scripts for automation of routine DBA tasks (e.g., backups, monitoring).
  • Recommending hardware upgrades or changes as necessary.
  • Work closely with development, network, and security teams to ensure database systems align with overall IT strategy.
  • Communicate effectively with stakeholders regarding database status, issues, and plans.
  • Ensure databases comply with relevant regulations and standards (e.g., GDPR, HIPAA).
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.