Middle Oracle & Postgres Database Administrator Porto

Middle Oracle & Postgres Database Administrator
Porto
Porto, Porto District, Portugal

Devexperts works with respected financial institutions, delivering products and
- made solutions for retail and brokerage houses, exchanges, and
- 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
  - 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 4 years of IT experience and at least 2 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 Postgre
  SQL databases in different environments (Production, Pre-Production).
• Experience with Oracle Enterprise Manager.
• Docker Management.
• Experience with Liquibase.
• 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, Fish
  Eye, etc. ).

Additional Information

Devexperts employees create the art of Fin
Tech in comfortable working spaces in modern business centers around the world. Join our team in Porto and enjoy:

Work Regime Flexibility benefits:

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.
• Play
  Station, 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
  - learning platforms.
• Certification opportunities.
• Parental bonus.
• Referral bonus.
• Blood donation paid leave.

Apply for Middle Oracle & Postgres Database Administrator

First name

Last name

Email

Phone

Country

City

Resume* Upload your CV

Linked
In

Website

Tell us a bit about you

I hereby agree to and accept the privacy policy and to access my personal data.

By checking this box, you will declare that you read and agree to the privacy policy of Devexperts and agree to be part of communities for future career opportunities.

I want to receive whatever materials from Devexperts you can only provide.

Life in Devexperts

We will only achieve our mission if we live our culture. We start with becoming learners in all things—having a growth mindset. Then we apply that mindset to learning about our customers, being diverse and inclusive, working together as one, and—ultimately—making a difference in the world.