Senior Data Engineer

Contract Senior Data Engineer

Salary: Up to 550 a day depending on experience

Location: 2/3 days in the head office (Edinburgh)

Duration: 6-month contract (Outside IR35)

Project Partners is dedicated to help clients achieve their strategic goals and educate, inspire employees to be amazing.

Our Mission is to build a curated community of project professionals with the individual and collective expertise to deliver great projects for our clients.

Our Just Cause is to empower people everywhere to deliver excellent change for any organisation.

Project overview

The client is migrating to POSTGRESQL from their current oracle database -Strata in support of one of their key product lines.

Main accountabilities

• Focussed on delivering scalable database platforms that underpins the clients customer data services in a dynamic and fast-moving agile engineering environment
  
• Post Production support of a PostgreSQL implementation, working with existing team members to provide support following the implementation of new System within the bank
  
• Managing incidents, problems and change in line with best practice
  
• Expected to lead and inspire others in your team and department, drive engineering best practice and compliance, strategic direction, encourage collaboration and transparency
  
• Provide guidance and training on PostgreSQL management and utilisation to other team members
  
• Being the PostgreSQL Subject Matter Expert
  
• Capable of building a team or Centre of Excellence
  
  

Requirements

Essential skills and experience

• Experience with different types of enterprise application databases(PostgreSQL is a MUST)
  
• Proficient using SQL to interrogate, analyse and report on customer data and interactions on live systems and in testing environments
  
• Proficient using Oracle PL/SQL or PostgreSQL PL/pgSQL
  
• Experienced delivering deployments and infrastructure as code with automation tools such as Jenkins, Terraform, Ansible, etc
  
• Comfortable using code hosting platforms for version control and collaboration. (git, github, etc)
  
• Exposed to automation and have utilised some or all of technologies and tools like Oracle, PostgreSQL, AWS, Terraform, GitHub, Nexus, Jenkins, Packer, Bash Scripting, Python, Groovy and Ansible
  
• Comfortable leading complex investigations into service failures and data abnormalities that touch your applications
  
• Experience with Batch and ETL methodologies
  
• Confident making technical decisions and acting on them (within reason) when under pressure.
  
• Calm dealing with stakeholders and easily be able to translate complex technical scenarios to non-technical individuals
  
• Ability to hit the ground running.
  
  

Desirable / additional skills

• Familiar with developing in a Cloud environment (AWS RDS, DMS & DevOps highly desirable)
  
• Team Leader
  
• Coaching.