Database Administrator (PostgreSQL)
Vertex Solutions
Lisbon, Portugal
há 4 dias
source : Just Join IT

Python (regular)

PostgreSQL (advanced)

Vertex Solutions has been providing an excellent service to our clients in Enterprise Software, FinTech, Insurance, Mobile, R&D, Finance and IT since 1997.

We work for some of the most innovative names in their respective markets.

About client

We are at a transformational moment in our company journey - and we’re so excited about it. Each day, we are finding new ways to strengthen our award-winning culture, and to accelerate creativity, innovation and growth.

Our purpose is to help customers improve business performance Data Cloud and Live Business Identity, and we’re wildly passionate and committed to this purpose.

So, if you’re looking to make an immediate impact at a company that welcomes bold and diverse thinking, come join us!

Team Overview :

This person will report to Dev-Ops Lead and work with IT Infrastructure and Development Teams to administer the Databases.

You will be a port of the larger engineering team and become a valued member of the global engineering group and offices around the world.

The Role :

The Senior DBA will help to administer, support, design, optimize, fine tune, and provide technical direction for Hoover’s and Datavision’s databases in line with industry best practices.

As an engineer you are responsible for creating and maintaining cutting edge database architectures and work with the product team, and a world-class team of engineers.

Responsibilities :

  • Fixing any issues, proactively monitor and tune for performance, perform releases, database installation, configurations, backup and recovery, and daily DBA BAU activities.
  • Plan future product direction including upgrades, migrations and DR testing.
  • Develop, manage, and test database backup & recovery strategies, verifying data integrity.
  • Responsible for capacity planning and recommending paths for growth in line with industry best practices.
  • Present designs to team members, larger audiences, and key executives.
  • Contribute scripts, automation, designs to all projects as needed and necessary for the team’s success.
  • Requirements :

  • 5+ years’ in PostgreSQL in Linux environment or RDS in the Cloud.
  • In-depth understanding of relational and dimensional database theory and concepts
  • Strong exsperience working with relational SQL (Postgres, SQL Server, Oracle, Snowflake etc..), NoSQL (MongoDB, DynamoDB, Cassandra, Elasticsearch etc..)
  • Significant practical hands-on experience with database administration, backup and recovery, database replication, hot stand-by, clustering and table partitioning, performance tuning and high-availability solutions.
  • Detailed understanding of Postgres database server architecture, concepts, features, and high availability technologies
  • Understanding of security SAML, OAUTH, JWT Token, SSO, Kerberos
  • Expert knowledge of PL / PgSQL, triggers, and stored procedural development and optimization in PostGresSQL
  • Strong written and communications skills a must. Must be able to document, present and articulate designs and technical decisions in front of teams and key business design makers.
  • Nice to have :

  • Working knowledge of Configuration Management systems such as Chef or Ansible
  • Actively promote designs and potentially in outside conferences and meetups.
  • Knowledge of Timeseries (Druid, Influx etc..)
  • Experience with Postgres RDS in the Cloud
  • Shell scripting, Python and other programming languages
  • Benefits :
  • UoP or B2B
  • Luxmed,
  • Additional days off
  • Internal training database access,
  • Reportar esta oferta de trabalho
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Candidatar
    Meu email
    Ao clicar em "Continuar", autorizo a neuvoo a processar os meus dados e a enviar-me alertas de e-mail, conforme detalhado na Política de Privacidade da neuvoo . Posso retirar o meu consentimento ou cancelar a subscrição a qualquer momento.
    Continuar
    Formulário de candidatura