Empower large-scale data transformation — engineer the future of high-availability, zero-downtime PostgreSQL platforms!Warszawa-based opportunity with a remote work model (5 days per week).As a Senior PostgreSQL Database Engineer, you will be working for our client, a prominent, highly regulated financial organization operating globally. You will contribute to a complex modernization program focused on building scalable, resilient PostgreSQL infrastructures that support distributed systems and ensure seamless, zero-downtime operations. This role offers the chance to shape mission-critical data platforms, drive innovation, and accelerate your career growth.Your main responsibilities:Design and implement logical replication solutions including publications and subscriptions to ensure data consistencyManage conflict resolution, DDL changes, large objects, and column transformations within replication setupsExecute zero-downtime database migrations using logical replication techniquesArchitect and optimize postgres_fdw solutions for distributed queries and data federationTroubleshoot performance and transactional issues in distributed PostgreSQL environmentsDesign and maintain large declaratively partitioned tables with advanced partition pruning, partition-wise joins, and aggregatesMigrate existing tables to partitioned models without disrupting serviceDevelop, implement, and optimize complex indexing strategies to enhance performance and scalabilityYou're ideal for this role if you have:5+ years of hands-on experience with PostgreSQL databasesDeep expertise with PostgreSQL versions 14 to 17 and aboveStrong experience with logical replication in production environmentsAdvanced knowledge of postgres_fdw and distributed PostgreSQL architectureProven mastery in declarative partitioning strategiesExpert-level understanding of PostgreSQL indexing mechanismsExperience operating high-availability, large-scale database systemsStrong troubleshooting and performance tuning skillsAbility to design resilient, mission-critical solutionsExperience in highly regulated or enterprise environmentsIt is a strong plus if you have: (optional)Certifications in PostgreSQL or data managementExperience with automation tools and scripting (e.g., Bash, Python)Knowledge of other data platforms or cloud databasesLanguage required for the role:Polish (good command)Eligibility for the role:Only candidates with an existing legal right to work in the European Union will be considered for this role.We offer you: ITDS Business Consultants is involved in many various, innovative and professional IT projects for international companies in the financial industry in Europe. We offer an environment for professional, ambitious, and driven people. The offer includes: Stable and long-term cooperation with very good conditions Enhance your skills and develop your expertise in the financial industry Work on the most strategic projects available in the market Define your career roadmap and develop yourself in the best and fastest possible way by delivering strategic projects for different clients of ITDS over several years Participate in Social Events, training, and work in an international environment Access to attractive Medical Package Access to Multisport Program Access to Pluralsight Flexible hours & remote work Internal job number #8368You can report violations in accordance with ITDS’s Whistleblower Procedure available here.