PostgreSQL DBA

Job Description:

Manage, support, and maintain database technologies (PostgreSQL and Microsoft SQL) and infrastructure, adhering to the architectural guidelines and policies.

Maintain organization database diagram up to date with current implementation.

Implementation/Support of databases, storage structures, replication, Hyperscale, Clusters, logical partitioning, and disaster recovery solutions.

Provide DBA support for enterprise monitoring, backup, alerting, and security compliance solutions for database servers.

Perform data analysis to uncover issues and solve complicated problems that typically span multiple systems.

Auditing and maintaining database infrastructure configuration

Tune databases and applications: rewriting SQL, adding indexes, tuning of views, interpreting explains plans, performing reorgs (or vacuum activities) in PostgreSQL

Oversee and provide technical direction in design, install, configure, maintain, troubleshoot, test, monitor, and analyze the performance of the Cloud and on-prem Databases.

Design database solutions - gathering server requirements, installing, and creating databases, performance tuning, monitoring for new and existing functionalities

Check DB health, validate background process and memory utilization, and performance tuning.

Develop processes for optimizing database governance & security, costs, backup and recovery, and performance monitoring standards.

Write documentation exhaustively, especially where no documentation currently exists

Leverage strong command of AWS SQL (PostgreSQL) and SQL Server tools.

Demonstrate knowledge of cloud database architectures.