Middle Oracle Postgres Database Administrator

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 databaserelated 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 :

Musthave skills: 

• At least 4 years of IT experience and 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
• Handson experience with table spaces indexes partitions and query performance tuning
• Creation migration maintenance and administration of Oracle and PostgreSQL databases in different environments (Production PreProduction)
• 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).

Nicetohave 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 :

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

Work Regime Flexibility benefits:

• Flexible working hours

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
• Personal branding development support

Professional training benefits:

• English language courses
• Local language courses for foreign employees
• Unlimited access to selflearning platforms
• Certification opportunities
• Mentorship Program

Social benefits:

• Parental bonus
• Pension plan (Coverflex)
• Referral bonus
• Blood donation paid leave

Remote Work :

No

Employment Type :

Fulltime