Job Summary SQL and Postgre Developer
Location : Barcelona Sant Cugat
Work from Barcelona Sant Cugat office in hybrid mode. weekly 2 or 3 days
Job Description:
Technical Skills: Technical Skills:
* Though the DB is Postgre, but any resource who spend good amount of his time with Oracle or other DB and have 2 to 3 year of experience with Postgre DB should also be fine.
* Should have worked on Analytical projects. Should be able to understand the underline data, the relevance of data, use of data for a given hypothesis.
* Should write queries, proceduresetc. to achieve the hypothesis.
* Should be mindful of the 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 has experience dealing with database performance tuning, bottlenecks, and database ER modeling, databases (PostgreSQL)
* Knowledge of database design principles, query optimization, index management, integrity checks, statistics, and isolation levels.
* Experienced with PostgreSQL & 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, IO bottlenecks.
* Knowledge of JSON and PostgreSQL support for JSON
Certifications Needed:
* PostgreSQL
* Data base certification any