Logo
Spottal

PostgreSQL Database Administrator

Spottal, San Jose, California, United States, 95199

Save Job

We are looking for a skilled

PostgreSQL DBA

to install, configure, monitor, and maintain PostgreSQL databases. You will be responsible for ensuring optimal performance, data integrity, backup/recovery, security, and high availability of PostgreSQL infrastructure in development, staging, and production environments.

Key Responsibilities:

Install, configure, upgrade, and patch PostgreSQL database systems.

Monitor database performance and proactively address performance bottlenecks.

Design and implement database security strategies, access controls, and data encryption.

Set up and maintain high availability and disaster recovery strategies (e.g., streaming replication, failover, backups).

Perform capacity planning and storage management.

Write and optimize SQL queries and stored procedures.

Develop and maintain database automation scripts using Bash, Python, or similar tools.

Implement and manage monitoring solutions (e.g., Prometheus, pg_stat_statements, Nagios).

Support database changes through schema management and versioning tools.

Perform root cause analysis of database-related incidents and outages.

Work closely with developers, DevOps, and infrastructure teams to support deployments and troubleshoot issues.

#J-18808-Ljbffr