Position Type : Contract (Hybrid) – 3 Days onsite / week
Location : Barcelona, Spain
Job Description :
* 10+ years of experience in software development and at least 2 to 3+ years as a Databricks, PostgreSQL developer for a large / high volume project.
* Though the DB is Postgre, any resource who has spent a good amount of time with Oracle or other DB and has 2 to 3 years of experience with Postgre DB 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 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 with experience in database performance tuning, bottlenecks, and database ER modeling (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, including IO bottlenecks.
* Knowledge of JSON and PostgreSQL support for JSON.
Process Skills :
Should know software development and Databricks migration process.
#J-18808-Ljbffr