{"id":"6f6df8c4-ad56-4e00-beee-ec08abac1a6b","title":"Middle Oracle \u0026 Postgres Database Administrator","location":{"country":"Portugal","city":"Porto"},"descriptions":{"company":"\u003Cp\u003EDevexperts\u0026#xa0;works\u0026#xa0;with 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.\u003C\/p\u003E","job":"\u003Cp\u003E\u003Cstrong\u003EWe expect the Database Administrator to:\u0026#xa0;\u003C\/strong\u003E\u003C\/p\u003E\u003Cul\u003E\u003Cli\u003EManage, monitor, and optimise Oracle and Postgres database systems, ensuring high performance, availability, and security,\u003C\/li\u003E\u003Cli\u003EDesign and implement Oracle and Postgres database structures based on business requirements,\u003C\/li\u003E\u003Cli\u003EIdentify and resolve performance issues, optimise queries, and proactively monitor database performance,\u003C\/li\u003E\u003Cli\u003EDevelop and implement backup and recovery strategies to ensure data protection and disaster recovery capabilities,\u003C\/li\u003E\u003Cli\u003EImplement and maintain database security measures to safeguard sensitive data,\u003C\/li\u003E\u003Cli\u003EInvestigate and resolve database-related issues, provide technical support to users, and collaborate with developers and other IT staff,\u003C\/li\u003E\u003Cli\u003ECreate and maintain comprehensive database documentation, including configurations, processes, and procedures,\u003C\/li\u003E\u003Cli\u003EPlan and execute database upgrades and apply patches to ensure the latest features, security enhancements, and bug fixes.\u003C\/li\u003E\u003C\/ul\u003E","qualification":"\u003Cp\u003E\u003Cstrong\u003EMust-have skills:\u0026#xa0;\u003C\/strong\u003E\u003C\/p\u003E\u003Cul\u003E\u003Cli\u003EAt least 4\u0026#xa0;years of IT experience and least\u0026#xa0;2 years in a similar role,\u003C\/li\u003E\u003Cli\u003EInstallation and administration of Oracle Database 19c and Postgres 13 and forward,\u003C\/li\u003E\u003Cli\u003EHigh availability environments (Failover or RAC),\u003C\/li\u003E\u003Cli\u003EDisaster Recovery Environments (Data Guard),\u003C\/li\u003E\u003Cli\u003EBackup and restore using RMAN,\u003C\/li\u003E\u003Cli\u003EHands-on experience with table spaces, indexes, partitions, and query performance tuning,\u003C\/li\u003E\u003Cli\u003ECreation, migration, maintenance and administration of Oracle and PostgreSQL databases in different environments (Production, Pre-Production),\u003C\/li\u003E\u003Cli\u003EExperience with Oracle Enterprise Manager,\u003C\/li\u003E\u003Cli\u003EDocker Management,\u003C\/li\u003E\u003Cli\u003EExperience with Liquidbase,\u003C\/li\u003E\u003Cli\u003EExperience in tasks automation,\u003C\/li\u003E\u003Cli\u003EAdvanced 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).\u003C\/li\u003E\u003C\/ul\u003E\u003Cp\u003E\u003Cstrong\u003ENice-to-have skills:\u003C\/strong\u003E\u003C\/p\u003E\u003Cul\u003E\u003Cli\u003EExperience with Foglight,\u003C\/li\u003E\u003Cli\u003EExperience with Ansible (AWX),\u003C\/li\u003E\u003Cli\u003EKnowledge of Java programming language,\u003C\/li\u003E\u003Cli\u003EExperience with trading\/exchange\/risk management software usage,\u003C\/li\u003E\u003Cli\u003EExperience with Atlassian software (JIRA, Confluence, FishEye, etc.).\u003C\/li\u003E\u003C\/ul\u003E"},"additionalInformation":{"title":"Additional Information","text":"\u003Cp\u003ECare for the employees is one of Devexperts\u0027 core values. For the suggested position, we offer a benefits package that will guarantee the comfort of our new teammate.\u003Cbr\u003E\n\u0026#xa0;\u003C\/p\u003E\u003Cp\u003E\u003Cstrong\u003EWork Regime Flexibility benefits:\u0026#xa0;\u003C\/strong\u003E\u003Cbr\u003E\n\u0026#xa0;\u003C\/p\u003E\u003Cul\u003E\u003Cli\u003EPossibility of hybrid\u0026#xa0;work mode,\u003C\/li\u003E\u003Cli\u003EFlexible working hours.\u003Cbr\u003E\n\u0026#xa0;\u003C\/li\u003E\u003C\/ul\u003E\u003Cp\u003E\u003Cstrong\u003EHealth and recreation benefits:\u0026#xa0;\u003C\/strong\u003E\u003Cbr\u003E\n\u0026#xa0;\u003C\/p\u003E\u003Cul\u003E\u003Cli\u003EFully paid additional wellness days (3 unwell days per year),\u003C\/li\u003E\u003Cli\u003EMedical insurance for the employees and children,\u003C\/li\u003E\u003Cli\u003EReimbursement of fitness \/ Urban Sports Club Membership,\u003C\/li\u003E\u003Cli\u003EMeal allowance (Coverflex Card),\u003C\/li\u003E\u003Cli\u003EFlexpay system (Coverflex).\u003Cbr\u003E\n\u0026#xa0;\u003C\/li\u003E\u003C\/ul\u003E\u003Cp\u003E\u003Cstrong\u003EFacility benefits:\u0026#xa0;\u003C\/strong\u003E\u003Cbr\u003E\n\u0026#xa0;\u003C\/p\u003E\u003Cul\u003E\u003Cli\u003EModern office with new equipment,\u003C\/li\u003E\u003Cli\u003EPlayStation, table football, and musical instruments in the office,\u003C\/li\u003E\u003Cli\u003EParking spaces,\u003C\/li\u003E\u003Cli\u003EFree drinks and snacks.\u003Cbr\u003E\n\u0026#xa0;\u003C\/li\u003E\u003C\/ul\u003E\u003Cp\u003E\u003Cstrong\u003ECommunity benefits:\u003C\/strong\u003E\u0026#xa0;\u003Cbr\u003E\n\u0026#xa0;\u003C\/p\u003E\u003Cul\u003E\u003Cli\u003ETeambuilding activities,\u003C\/li\u003E\u003Cli\u003ECorporate parties,\u003C\/li\u003E\u003Cli\u003EFootball Club,\u003C\/li\u003E\u003Cli\u003EMusic club,\u003C\/li\u003E\u003Cli\u003ESpeakers\u0027 club,\u003C\/li\u003E\u003Cli\u003EFree admission to corporate external events,\u003C\/li\u003E\u003Cli\u003EPossibility of joining conferences and professional fairs,\u003C\/li\u003E\u003Cli\u003EPersonal branding development support.\u003Cbr\u003E\n\u0026#xa0;\u003C\/li\u003E\u003C\/ul\u003E\u003Cp\u003E\u003Cstrong\u003EProfessional training benefits:\u003C\/strong\u003E\u0026#xa0;\u003Cbr\u003E\n\u0026#xa0;\u003C\/p\u003E\u003Cul\u003E\u003Cli\u003ELocal language courses for foreign employees,\u003C\/li\u003E\u003Cli\u003EUnlimited access to self-learning platforms,\u003C\/li\u003E\u003Cli\u003ECertification opportunities,\u003C\/li\u003E\u003Cli\u003EMentorship Program.\u003Cbr\u003E\n\u0026#xa0;\u003C\/li\u003E\u003C\/ul\u003E\u003Cp\u003E\u003Cstrong\u003ESocial benefits:\u0026#xa0;\u003C\/strong\u003E\u003Cbr\u003E\n\u0026#xa0;\u003C\/p\u003E\u003Cul\u003E\u003Cli\u003EParental bonus,\u003C\/li\u003E\u003Cli\u003EPension plan (Coverflex),\u003C\/li\u003E\u003Cli\u003EReferral bonus,\u003C\/li\u003E\u003Cli\u003EBlood donation paid leave.\u003C\/li\u003E\u003C\/ul\u003E"}}