Looking for PostgreSQL Database Admin
Sarathy
We are looking for LEAD ADMINISTRATOR L1 / PostgreSQL Database Admin at O Fallon, MO
Onsite role from day 1
H1B/H4 EAD/L2S/USC Only
Mandatory Skills:
• PostgreSQL Database Admin
Job Description:
Looking for 8+ Years of experience
• 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.
|
Partha Sarathy
|
E: sar...@rdsolutionsinc.com |
|||
|
|
||||
