PostgreSQL Database Admin 169505

Job Title :

PostgreSQL Database Admin Location:

O Fallon, MO Looking for 8+ Years of experince Requires related experience in the design, maintenance, and administration of Postgres (Open Source, EDB and AWS Aurora). Highly knowledgeable of Postgres architecture and Internals for all Postgres flavours (EBD and AWS Auroara). Proficient with Postgresql installation and configuration, particularly Postgresql Plus Advanced Server from EnterpriseDB Observability and Monitoring - Proficient with Postgresql monitoring and alerting tools/processes specifically PEM from EnterpriseDB. Knowledge of Splunk, Dynatrace and similar tools. Experience in Postgres replication technologies. Proficient in setup, configuration and monitoring of Postgresql binary and logical data replication solutions (Binary Streaming, XDB and Bi-Directional Replication BDR,..) Proficient with collecting diagnostics and tuning Postgresql as well as SQL tuning Proficient with Postgresql procedural languages (PL/pgSQL, PL/Tcl, PL/Perl, PL/Python) and SQL Working knowledge of AWS Aurora. Install and configure Amazon Aurora instances. Perform debugging, tuning and performance enhancement as well as automation of operational and continuous integration aspect of the Postgres platforms. Can run EXPLAIN and do access path optimization. Proficient with collecting diagnostics and tuning Postgres as well as SQL tuning Implement and manage database version control using tools like Flyway. Use AWS services like CloudFormation, Lambda, and CloudWatch for orchestration.

Mandatory Skills:

PostgreSQL Database Admin .

Mandatory Skills:

Agentic AI . Accliive, is an IT Consulting Company working with Fortune 500 clients and is based out of Boston, MA. Accliive works extensively in all the major industries like BFSI, Oil and Gas, Utilities, Healthcare and many more. Acclive is focused on providing customer centric solutions and career centric solutions.