PostgreSQL DBA

Experience Range: 5-10years

Location: Noida, Chennai

Notice: Immediate & currently serving notice period

Note: #Other Notice period candidates are not considerable

PostgreSQL DBA

Job Responsibilities:

Manage PostgreSQL databases and collaborate with our customers on their in-house projects.

Perform Architectural health checks and suggest optimizations and design changes through a detailed summary.

Optimize the performance of PostgreSQL databases using your knowledge in PostgreSQL Internals.

Tune SQLs and write complex scripts for day-to-day administrative tasks.

Flexible in managing PostgreSQL databases on Cloud such as AWS RDS and Azure Flexible server, etc.

Publish blog posts and write knowledge base articles used by our customers.

Upgrade and Migrate PostgreSQL databases to Cloud and between Cloud platforms.

. Proficient in Architect, implement, and routinely test high availability and disaster recoveryincluding streaming replication, failover, connection pooling

. Enforce role/privilege models, rowlevel security, auditing, and encryption (at rest and in transit); conduct periodic security reviews and ensure adherence to customer and regulatory requirements (e.g., GDPR/PII handling) across onprem and cloud deployments

Technical Skills required:

Must have the mindset of helping customers to implement Community PostgreSQL and Open-Source solutions for regular activities.

Must have expertise on managing PostgreSQL for at least 5 years.

. You must have a good understanding of MySQL and either MSSQL or Oracle.

Must have a deeper understanding of the PostgreSQL architecture and internals.

Should understand the limitations and the workarounds for managing PostgreSQL deployed on PAAS platforms.

Must have knowledge on implementing Automatic failover, Parallel backups and Connection Pooling using Open-Source tools.

Must be able to handle Catalog Corruptions, Database Corruptions and Point in time recovery.

Must be able to analyze the logs and optimize the time-consuming SQLs.

Must have knowledge on the most widely used extensions in PostgreSQL for monitoring, analyzing, and maintaining the databases.

Must be able to perform PostgreSQL Upgrades from legacy to latest versions with least possible downtime.

Good to have skills:

Skills in scripting using Python or Golang.

Migrating schema and data from any other database to PostgreSQL.