Saxon Global
Postgres Database Administrator
Saxon Global, Jersey City, New Jersey, United States, 07390
Required Skills•Postgres on AWS (S3) •Aurora •Overall DBA skills
Project Scope: Going from Postgres 11 14 (Processing inbound and to the applications)
Development Methodology: Agile - 2 week
High-Level Individual Duties:
Performance Analysis - about 10 instances under a single cluster (a few outside)
Using Hibernate as an ORM, so they need someone who gets how that would impact performanceIndexing / Caching
DB Monitoring - Continuous eval (AWS tooling...they want to use some of the Postgres native tools - our person needs to show HOW)
Offer solutions for alerting as well
Scaling - want to double in size where are we running today? If we double in size in these areas, XYZ is going to be a scalability issue and we need to do ABCReplication - Change Data Capture (Debezium - not necessary)Query optimizationOthers...
PartitioningDML / DDLAdding Query HintsReading Execution PlansRebuilding IndexesBuilding Data SetsMust-Haves (Concepts & Tools):
Postgres on AWS (S3)AuroraOverall DBA skills (App vs. Server)Nice-to-Haves:
RDSHibernate
RegardsSachin972-338-9391
Project Scope: Going from Postgres 11 14 (Processing inbound and to the applications)
Development Methodology: Agile - 2 week
High-Level Individual Duties:
Performance Analysis - about 10 instances under a single cluster (a few outside)
Using Hibernate as an ORM, so they need someone who gets how that would impact performanceIndexing / Caching
DB Monitoring - Continuous eval (AWS tooling...they want to use some of the Postgres native tools - our person needs to show HOW)
Offer solutions for alerting as well
Scaling - want to double in size where are we running today? If we double in size in these areas, XYZ is going to be a scalability issue and we need to do ABCReplication - Change Data Capture (Debezium - not necessary)Query optimizationOthers...
PartitioningDML / DDLAdding Query HintsReading Execution PlansRebuilding IndexesBuilding Data SetsMust-Haves (Concepts & Tools):
Postgres on AWS (S3)AuroraOverall DBA skills (App vs. Server)Nice-to-Haves:
RDSHibernate
RegardsSachin972-338-9391