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 consistency Manage conflict resolution, DDL changes, large objects, and column transformations within replication setups Execute zero-downtime database migrations using logical replication techniques Architect and optimize postgres_fdw solutions for distributed queries and data federation Troubleshoot performance and transactional issues in distributed PostgreSQL environments Design and maintain large declaratively partitioned tables with advanced partition pruning, partition-wise joins, and aggregates Migrate existing tables to partitioned models without disrupting service Develop, implement, and optimize complex indexing strategies to enhance performance and scalability You're ideal for this role if you have: 5+ years of hands-on experience with PostgreSQL databases Deep expertise with PostgreSQL versions 14 to 17 and above Strong experience with logical replication in production environments Advanced knowledge of postgres_fdw and distributed PostgreSQL architecture Proven mastery in declarative partitioning strategies Expert-level understanding of PostgreSQL indexing mechanisms Experience operating high-availability, large-scale database systems Strong troubleshooting and performance tuning skills Ability to design resilient, mission-critical solutions Experience in highly regulated or enterprise environments It is a strong plus if you have: (optional) Certifications in PostgreSQL or data management Experience with automation tools and scripting (e.g., Bash, Python) Knowledge of other data platforms or cloud databases Language 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.