Sql And Postgre Developer

Job Description Years of experience needed – 10+ years of experience in software development and at least 2 to 3+ years as a PostgreSQL developer for a large/high volume project.
Technical Skills: Though the DB is PostgreSQL, any resource who has spent a good amount of time with Oracle or other databases and has 2 to 3 years of experience with PostgreSQL should also be fine.
Should have worked on analytical projects and be able to understand the underlying data, the relevance of data, and the use of data for a given hypothesis.
Should write queries, procedures, etc.
to achieve the hypothesis.
Should be mindful of performance and other aspects of the solution presented to the team.
Any experience working on CRM-related projects would be preferred.
Strong database fundamentals and experience dealing with database performance tuning, bottlenecks, and database ER modeling.
Knowledge of database design principles, query optimization, index management, integrity checks, statistics, and isolation levels.
Experienced with PostgreSQL and PostgreSQL architecture.
Implement and maintain database code in the form of tables, stored procedures, scripts, queries, views, triggers, etc.
Measure database performance and troubleshoot complex database issues, including IO bottlenecks.
Knowledge of JSON and PostgreSQL support for JSON.
Certifications Needed: PostgreSQL Any database certification #J-18808-Ljbffr