PostgreSQL Database Admin 169505

Dice is the leading career destination for tech experts at every stage of their careers. Our client, ACCLiiVE, is seeking the following. Apply via Dice today!Job Title : PostgreSQL Database AdminLocation: O Fallon, MOLooking for 8+ Years of experinceRequires 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 EnterpriseDBObservability 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 tuningProficient with Postgresql procedural languages (PL/pgSQL, PL/Tcl, PL/Perl, PL/Python) and SQLWorking 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 tuningImplement 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.