What are the responsibilities and job description for the Database Administrator position at NLB Services?
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 .