This Job Vacancy has Expired!

CRM Database Expert - Postgre SQL DBA - Remote

Empiric Solutions

Posted on Nov 4, 2020 by Empiric Solutions

Barcelona, Spain
IT
1 Nov 2020
Annual Salary
Contract/Project


CRM Database Expert - Postgre SQL DBA - Remote


We have received instructions from one of the world's most innovative Consultancies for a CRM Database Expert. This exciting and challenging project is happening in the beautiful and vibrant city of Barcelona, however has been confirmed for remote work due to Covid 19 situation and will provide long term (12months +) job continuity and lots of job satisfaction.


POSTGRES EXPERIENCE IS MANDATORY



  • Working with Data Architect (Recommendation on new data structure coming in/Data processes) and SQL Programmer (Guidance and optimization on SQL)

  • Managed service, so no Platform (HW) tuning is required


Area of expertise required:


APPLICATION:



  • Focus is on Application Tuning - Schema & SQL

  • Experience of high volumes management & Monitoring performances


    • Proactive performance tuning

    • Recommendations for large data schema (1Billion rows/600GB and growing)

    • Partitioning experience

    • Index usage & optimizations


  • Contributing to schema design, access patterns, locking strategy, SQL development, and tuning

  • Modifying the database structure

  • Optimizing application and end-user queries (reactive tuning)

  • Documentation


ACCESS:



  • User/Schema management (permissions)

  • Management of ITG and Prod environment and replications.


DATABASE:



  • Version migration experience within AWS (V10 to 11 has to be carried out)

  • Parameter configuration and tuning

  • Cache management

  • Job scheduling - Sanity maintenance and optimizations

  • Management of ITG and Prod environment and replications.

  • Knowledge of AWS RDS options and possible recommendations on other service options.


This is a critical position, interviews are taking place this week so contact me if you would like to be submitted or even a for a confidential chat.


Empiric is one of the fastest-growing technology and transformation recruitment agency's specialising in data, digital, cloud and security. We supply technology and change recruitment services to businesses looking for both contract and permanent professionals. We are committed to delivering more female candidates and those from minority backgrounds and be instrumental in changing the gender and diversity imbalance within the tech sector.




Reference: 994458848

Set up alerts to get notified of new vacancies.