Middle Oracle & Postgres Database Administrator

Devexperts; Porto; Presencial; EUR 42 000 - 65 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Health insurance

Meal allowance

Hybrid work mode

Medical insurance for employees and家庭

Parking

Wellness days

Resumo da oferta

Devexperts, Porto, Portugal, seeks a skilled Database Administrator to manage Oracle and PostgreSQL environments, ensuring high availability and security. You design structures, optimize queries, implement backups, and work with developers and IT staff to maintain documentation and upgrades.

The role requires hands-on experience with Oracle 19c, PostgreSQL 13+, RMAN, Data Guard, and Enterprise Manager, plus a proactive approach to performance tuning and automation. Hybrid work is available.

Qualificações

• At least 4 years IT experience and 2+ years in a similar role.
• Installation and administration of Oracle DB 19c and PostgreSQL 13+.
• High availability environments (Failover or RAC).
• Disaster Recovery environments (Data Guard).
• Backup and restore using RMAN.
• Hands-on experience with tablespaces, indexes, partitions, and query performance tuning.
• Oracle Enterprise Manager experience.
• Docker management experience.
• Liquibase for DB schema changes.
• Automation tasks experience.
• Unix/Windows administration and basic networking knowledge.

Responsabilidades

• Manage, monitor, and optimise Oracle and PostgreSQL databases for performance, availability, and security.
• Design and implement database structures based on business requirements.
• Identify and resolve performance issues and optimise queries.
• Develop backup and recovery strategies to protect data and support DR capabilities.
• Implement and maintain database security measures.
• Collaborate with developers and IT staff and provide user support.
• Create and maintain documentation of configurations, processes, and procedures.
• Plan and execute database upgrades and apply patches.

Conhecimentos

Oracle 19c

PostgreSQL 13+

High availability (Failover/RAC)

Disaster Recovery (Data Guard)

RMAN backups

Performance tuning

Oracle Enterprise Manager

Unix/Windows administration

Automation and scripting

Java knowledge (nice-to-have)

Networking basics

Ferramentas

Docker Management

Liquibase

Ansible AWX

Foglight

JIRA/Confluence

Descrição da oferta de emprego

• Full-time

Company Description

Devexpertsworkswith respected financial institutions, delivering products and tailor-made solutions for retail and brokerage houses, exchanges, and buy-side firms. The company focuses on trading platforms and brokerage automation, complex software development projects, market data products, and IT consulting services.

Job Description

We expect the Database Administrator to:

• Manage, monitor, and optimise Oracle and Postgres database systems, ensuring high performance, availability, and security,
• Design and implement Oracle and Postgres database structures based on business requirements,
• Identify and resolve performance issues, optimise queries, and proactively monitor database performance,
• Develop and implement backup and recovery strategies to ensure data protection and disaster recovery capabilities,
• Implement and maintain database security measures to safeguard sensitive data,
• Investigate and resolve database-related issues, provide technical support to users, and collaborate with developers and other IT staff,
• Create and maintain comprehensive database documentation, including configurations, processes, and procedures,
• Plan and execute database upgrades and apply patches to ensure the latest features, security enhancements, and bug fixes.

Qualifications

Must-have skills:

• At least 4years of IT experience and least2 years in a similar role,
• Installation and administration of Oracle Database 19c and Postgres 13 and forward,
• High availability environments (Failover or RAC),
• Disaster Recovery Environments (Data Guard),
• Backup and restore using RMAN,
• Hands-on experience with table spaces, indexes, partitions, and query performance tuning,
• Creation, migration, maintenance and administration of Oracle and PostgreSQL databases in different environments (Production, Pre-Production),
• Experience with Oracle Enterprise Manager,
• Docker Management,
• Experience with Liquidbase,
• Experience in tasks automation,
• Advanced knowledge of information technology necessary for performing work duties (including database skills at the administrator level, having domain of Unix and Windows environments at the user level, networking knowledge).

Nice-to-have skills:

• Experience with Foglight,
• Experience with Ansible (AWX),
• Knowledge of Java programming language,
• Experience with trading/exchange/risk management software usage,
• Experience with Atlassian software (JIRA, Confluence, FishEye, etc.).

Additional Information

Care for the employees is one of Devexperts' core values. For the suggested position, we offer a benefits package that will guarantee the comfort of our new teammate.

Work Regime Flexibility benefits:

• Possibility of hybridwork mode,

Health and recreation benefits:

• Fully paid additional wellness days (3 unwell days per year),
• Medical insurance for the employees and children,
• Reimbursement of fitness / Urban Sports Club Membership,
• Meal allowance (Coverflex Card),
• Flexpay system (Coverflex).
  

Facility benefits:

• Modern office with new equipment,
• PlayStation, table football, and musical instruments in the office,
• Parking spaces,
• Free drinks and snacks.
  

Community benefits:

• Teambuilding activities,
• Corporate parties,
• Football Club,
• Music club,
• Speakers' club,
• Free admission to corporate external events,
• Possibility of joining conferences and professional fairs,
• Local language courses for foreign employees,
• Unlimited access to self-learning platforms,
• Certification opportunities,
• Parental bonus,
• Referral bonus,
• Blood donation paid leave.