{"id":"54856c31-e476-41c9-a37e-37b850ae7681","title":"Senior Database Administrator","location":{"country":"Portugal","city":"Porto"},"descriptions":{"company":"\u003Cp\u003E\u003Cstrong\u003EDevexperts \u003C\/strong\u003Eworks 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.\u0026#xa0;\u003C\/p\u003E","job":"\u003Cp\u003EWe are looking for a \u003Cstrong\u003ESenior Database Administrator\u003C\/strong\u003E who will\u0026#xa0;be responsible for on-premises and Cloud database infrastructure administration.\u003C\/p\u003E\u003Cp\u003E\u003Cstrong\u003EWe expect the Senior Database Administrator to:\u0026#xa0;\u003C\/strong\u003E\u003C\/p\u003E\u003Cul\u003E\u003Cli\u003EEnsure database services meet agreed service levels for availability, recoverability, performance, and scalability,\u003C\/li\u003E\u003Cli\u003EDesign and manage database subsystems, including clustering, replication, etc,\u003C\/li\u003E\u003Cli\u003EDefine and execute backup, disaster recovery, and business continuity procedures,\u003C\/li\u003E\u003Cli\u003EHandle database compliance with industry standards, regulations, and best practices,\u003C\/li\u003E\u003Cli\u003EEstablish monitoring standards, capacity planning practices, and operational metrics to proactively identify risks and trends before they impact the business,\u003C\/li\u003E\u003Cli\u003EInvestigate production incidents, coordinate resolution efforts, perform root cause analysis, and drive remediation initiatives to prevent recurrence,\u003C\/li\u003E\u003Cli\u003EWork\u0026#xa0;closely with Developers, Quality Assurance, and Support departments on a regular basis, assisting with Database-related requests,\u003C\/li\u003E\u003Cli\u003EParticipate in an on-call rotation and serve as an escalation point for complex production issues affecting critical systems,\u003C\/li\u003E\u003Cli\u003EApply\u0026#xa0;cost reduction practices for Cloud database\u0026#xa0;Infrastructure based on the resources usage and databases\u0026#xa0;load profile,\u003C\/li\u003E\u003Cli\u003EConduct deep analysis of database performance issues, implementing solutions,\u003C\/li\u003E\u003Cli\u003EOversee data migration projects and perform risk analysis,\u003C\/li\u003E\u003Cli\u003EDrive innovation in database technologies within the project or business unit.\u003C\/li\u003E\u003C\/ul\u003E","qualification":"\u003Cp\u003E\u003Cstrong\u003EMust-have skills:\u003C\/strong\u003E\u003C\/p\u003E\u003Cul\u003E\u003Cli\u003E5+ years of hands-on experience administering PostgreSQL in production environments within mission-critical systems,\u003C\/li\u003E\u003Cli\u003EProven experience designing, implementing, and operating \u003Cstrong\u003Ehigh-availability PostgreSQL architectures using Patroni,\u003C\/strong\u003E\u003C\/li\u003E\u003Cli\u003EHands-on experience managing \u003Cstrong\u003EAmazon RDS for PostgreSQL\u003C\/strong\u003E and \u003Cstrong\u003EAmazon Aurora PostgreSQL,\u003C\/strong\u003E\u003C\/li\u003E\u003Cli\u003EStrong expertise in \u003Cstrong\u003Ebackup and recovery strategies\u003C\/strong\u003E, including planning and executing \u003Cstrong\u003EPoint-in-Time Recovery (PITR)\u003C\/strong\u003E using tools such as \u003Cstrong\u003EpgBackRest\u003C\/strong\u003E and \u003Cstrong\u003EBarman,\u003C\/strong\u003E\u003C\/li\u003E\u003Cli\u003ESolid understanding of \u003Cstrong\u003EPostgreSQL internals (\u003C\/strong\u003EMVCC, vacuuming, query planning, replication concepts, etc),\u003C\/li\u003E\u003Cli\u003EExtensive experience with \u003Cstrong\u003Eperformance monitoring, SQL workload analysis, and database tuning\u003C\/strong\u003E, with the ability to identify bottlenecks and optimize database performance,\u003C\/li\u003E\u003Cli\u003EExperience automating database deployment, configuration management, and operational processes using \u003Cstrong\u003EAnsible,\u003C\/strong\u003E\u003C\/li\u003E\u003Cli\u003EPractical experience implementing and maintaining \u003Cstrong\u003EPostgreSQL partitioning strategies\u003C\/strong\u003E, including both \u003Cstrong\u003Enative partitioning\u003C\/strong\u003E and \u003Cstrong\u003ETimescaleDB\u003C\/strong\u003E for time-series workloads,\u003C\/li\u003E\u003Cli\u003EStrong working knowledge of \u003Cstrong\u003ELinux operating systems\u003C\/strong\u003E, including system performance analysis, process management, networking fundamentals, and storage concepts relevant to database operations,\u003C\/li\u003E\u003Cli\u003EFamiliarity with database monitoring and observability tools such as \u003Cstrong\u003EZabbix\u003C\/strong\u003E, including metrics collection, alerting, and log analysis,\u003C\/li\u003E\u003Cli\u003EExposure to \u003Cstrong\u003Ecolumn-oriented database technologies such as ClickHouse\u003C\/strong\u003E, with an understanding of their core concepts, architecture, and performance characteristics, would be a plus.\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. \u0026#xa0;\u003C\/p\u003E\u003Cp\u003E\u003Cstrong\u003EWork Regime Flexibility benefits:\u0026#xa0;\u003C\/strong\u003E\u003C\/p\u003E\u003Cul\u003E\u003Cli\u003EPossibility of hybrid\/remote work mode\u003C\/li\u003E\u003Cli\u003EFlexible working hours\u003C\/li\u003E\u003C\/ul\u003E\u003Cp\u003E\u003Cstrong\u003EHealth and recreation benefits:\u0026#xa0;\u003C\/strong\u003E\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\u003C\/li\u003E\u003Cli\u003EMeal allowance\u003C\/li\u003E\u003Cli\u003EFlexpay system\u003C\/li\u003E\u003Cli\u003E\u003Cp\u003E\u003Cstrong\u003EFacility benefits:\u0026#xa0;\u003C\/strong\u003E\u003C\/p\u003E\u003C\/li\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\/transport reimbursement\u003C\/li\u003E\u003Cli\u003EMeals in the office\u003C\/li\u003E\u003Cli\u003EFree drinks and snacks\u003C\/li\u003E\u003Cli\u003E\u003Cp\u003E\u003Cstrong\u003ECommunity benefits:\u003C\/strong\u003E\u0026#xa0;\u003C\/p\u003E\u003C\/li\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\u003C\/li\u003E\u003Cli\u003E\u003Cp\u003E\u003Cstrong\u003EProfessional training benefits:\u003C\/strong\u003E\u0026#xa0;\u003C\/p\u003E\u003C\/li\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\u003C\/li\u003E\u003Cli\u003E\u003Cp\u003E\u003Cstrong\u003ESocial benefits:\u0026#xa0;\u003C\/strong\u003E\u003C\/p\u003E\u003C\/li\u003E\u003Cli\u003EParental bonus\u003C\/li\u003E\u003Cli\u003EPension plan\u003C\/li\u003E\u003Cli\u003EReferral bonus\u003C\/li\u003E\u003Cli\u003EBlood donation paid leave\u003C\/li\u003E\u003C\/ul\u003E"}}