Connect44

Our team

Data Engineer- Java/ Python

Connect44

Data Engineer- Java/ Python

Job Location

Zurich

Available Positions

1 positions

Job Type

Contract

Job Ref. Number

3347003360432

Data Engineer- Java/ Python
Zurich- Switzerland
Contract Role for 6 months

Data Engineer- Java/ Python

Zurich- Switzerland

Contract Role for 6 months

Our client, a well known Finance Company in Switzerland, is currently looking for an experienced Data Engineer , to support their projects based in Zurich - Switzerland

The Role:

  • Design, build, automate and deploy highly available, robust, resilient and secure database solutions.
  • Works in conjunction with multiple teams to make sure that the infrastructure and the applications that depend on it work harmoniously together.
  • Document all operational processes and procedures to optimize support and management of deployed systems - demonstrate proficiency in establishing repeatable processes.
  • Adopt, embrace and promote agile practices.
  • Contribute towards new and ongoing Technology projects in areas of Scalability, Performance and High Availability and Automation.
  • Collaborate with Architects, performance engineers and system administrators on database and system optimizations.
  • Investigate production issues and perform root cause analysis.
  • Work closely with developers to design, create and maintain schema objects, design and debug triggers, stored procedures and user defined functions.
  • Monitor and maintain maximum performance of databases.
  • Identify poorly performing queries and work with development teams to tune accordingly.
  • Design and implement processes and procedures to reduce and eliminate database outages and downtime.
  • Implement data backup and recovery procedures to prevent the loss of data from all types of failure.
  • Replace existing Bash and Python scripts with a fault-tolerant solution that packages and moves files between servers.

Skills and Experience required:

  • At least 7 years' experience as a Postgres DB Engineer with software development and Linux experience.
  • At least 4 years of experience in designing Database solutions/architecture.
  • Development skills in Java/Scala and python.
  • Experience or knowledge of Elasticsearch, Splunk, Kafka, Spark, Apache Arrow, Presto and Kubernetes/Openshift based cloud (Postgres) deployment is a strong plus.
  • Strong knowledge of Postgres and Linux(RHEL).
  • Experience supporting business-critical production database systems.
  • DB setup: DB installation, configuration, upgrade, maintenance, patching and security.
  • DB import: Importing data from CSV, other databases and API's.
  • DB intra-source data checks: Checking data consistencies by executing data comparisons
  • between various sources.
  • DB monitoring: monitoring the performance of a database (queries, resources, table indices)
  • Experience in implementing automated tools.
  • Good communication and documentation skills.
  • Ability to learn quickly and deliver high quality code in a fast-paced, agile team environment.
  • Ability to work effectively within a team environment and to work proactively.
  • Software engineering - source control, continuous integration, test-driven development.
  • Experience in writing unit and functional tests to build solid test coverage.
  • Agile development experience.
  • Must be able to help others on topics related to data management.
  • Must be able to create reports on databases.
  • Must be able to design and develop database data architectures.
  • High level of organization, initiative and attention to detail.
  • Ability to gather and compile information from different sources.