Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uqrrO-00ELCF-0j for pgsql-jobs@arkaria.postgresql.org; Tue, 26 Aug 2025 11:29:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uqrrN-005A6A-Bj for pgsql-jobs@arkaria.postgresql.org; Tue, 26 Aug 2025 11:29:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uqq4u-004Bkm-65 for pgsql-jobs@lists.postgresql.org; Tue, 26 Aug 2025 09:34:57 +0000 Received: from mx0b-001e3d01.pphosted.com ([148.163.159.68]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uqq4r-001ved-1C for pgsql-jobs@postgresql.org; Tue, 26 Aug 2025 09:34:55 +0000 Received: from pps.filterd (m0422820.ppops.net [127.0.0.1]) by mx0b-001e3d01.pphosted.com (8.18.1.2/8.18.1.2) with ESMTP id 57Q8tAH1022149 for ; Tue, 26 Aug 2025 18:34:50 +0900 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= hk.yusen-logistics.com; h=cc:content-type:date:from:message-id :mime-version:subject:to; s=selector-ylhk-20240129; bh=zYeH5ybjg qmAU9ZYP+5r/TIqTcN0YBsqdF4Sm8LKde4=; b=BRowX8fFBbJwtiDydIwzKu872 KBb5WYvRFMYD4dvmEr4D6QDWL8EXg6DDJo99rNA0L+Z11AKp0BdW/ur7ZlVTaa7l TkObHHpp0fT6z8cmLSYyYq/cX5yW6p2KxCCBHCja0zZNJlD8VX/UG4hWJNstBB7L jFrOwcr4+JPR6xkD3Sbk1hdvyZX3TuKCl3yt0Qo5nw5zYlFAa2eM4FjHW6IYHPNt n3JUF2xJwxXfJCa1lH8clzjC96PBCUPxMEtoZ7QCtAyngf9ZfgcEQR8rLKAyMZdX Xf7g4g9Lk1Dt8Gskr8C79Knalbd7X+Eet24HmdzCoVOospJnhQNPq6I9MkxPA== Received: from os0p286cu011.outbound.protection.outlook.com (mail-japanwestazlp17010000.outbound.protection.outlook.com [40.93.130.0]) by mx0b-001e3d01.pphosted.com (PPS) with ESMTPS id 48s3k0jm2y-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT) for ; Tue, 26 Aug 2025 18:34:49 +0900 (JST) ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=dBjRihN4d0rnHaRayKggNJaIhzrN1g+CoqKTo0GakeikVGpH1PZsRpnfO60zWezT2RJ3ETOiW3ou2EJhpQeUMLMmiVTyClnm1cp0lvZC8c7MUldz0dGb9ACQ3vbrhgJnTDELJe95xMs7kKFBueFSkJluK6jRnOJor0VXhU24yoca8/SobvGV6LP8OMHyB36dsnBqC5lHsfRbiCCi10Iou77vz3UaP25asE/lcAxPsvphFI7ROXDvifNefc1S3EMi9gvS5ciU3ixHtN6/93ZDpoOISO4nhOKv2WuhVtmU6UtP3Uf+kDZtfGden3M3yUOjK1AG7nBC9o2jdhNZU5o4ng== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=zYeH5ybjgqmAU9ZYP+5r/TIqTcN0YBsqdF4Sm8LKde4=; b=EN9eFFwykJEs1OTdA9uwNy+P57iB0K/PVsh+Q10mbYd61x5nYA8FBu/W7tHuB7/QKHVWdStTbj5juUxHWrTo3E+g5Q78tqNSzW2ehDLa7mq9T8a0p6tZNvEwjPZTyELdNW8aTNqLkfRG8FKDUo9ISAn/B9aV+sSVf9NtiY3Kp/WEJODXFVRmKcQ/Rx6D/8GBQHVjz/Z7rBwh4XP7pkwlY29qLovp0Y79bcjnAx0l8nWgGAM9xNTFd5JDt717WSmL9UWYpnDaj0nXGeUxL1TGcl9HjeG8vquczoS0wX9QtWaLzRdl+1ONBHGGZW6863fT2OuDW0sPoMP8rVEQOS1U9w== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=hk.yusen-logistics.com; dmarc=pass action=none header.from=hk.yusen-logistics.com; dkim=pass header.d=hk.yusen-logistics.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=nykgroup.onmicrosoft.com; s=selector1-nykgroup-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=zYeH5ybjgqmAU9ZYP+5r/TIqTcN0YBsqdF4Sm8LKde4=; b=w1XjOEaExTVTtKFnL/CDHeRG+IMu+f4ylUQF2foLsm6UX8M02fJtm3YqGaSKfxJiTk+V78a9GuBYULzOaOiQOxavp9zVrhNEGIBV9WFFgKIbQfOlHzKIM0dYWHfV+M60MjLRhEL2uxPCZSZAlbcuR92dDQZsoDCX/JPtw2Kflik= Received: from TYYP301MB1354.JPNP301.PROD.OUTLOOK.COM (2603:1096:405:311::10) by TYYP301MB1144.JPNP301.PROD.OUTLOOK.COM (2603:1096:405:10d::9) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9052.21; Tue, 26 Aug 2025 09:34:46 +0000 Received: from TYYP301MB1354.JPNP301.PROD.OUTLOOK.COM ([fe80::9734:3f51:9063:c827]) by TYYP301MB1354.JPNP301.PROD.OUTLOOK.COM ([fe80::9734:3f51:9063:c827%5]) with mapi id 15.20.9052.019; Tue, 26 Aug 2025 09:34:46 +0000 From: "mrigank.ballabh@hk.yusen-logistics.com" To: "pgsql-jobs@postgresql.org" CC: "yoichi.nozoe@hk.yusen-logistics.com" , "syeda.samreen@hk.yusen-logistics.com" Subject: Senior Postgres Database Developer 8+ years Thread-Topic: Senior Postgres Database Developer 8+ years Thread-Index: AQHcFmwcgauSe0fJdEeh8OLlJEoExA== Date: Tue, 26 Aug 2025 09:34:46 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-publictraffictype: Email x-ms-traffictypediagnostic: TYYP301MB1354:EE_|TYYP301MB1144:EE_ x-ms-office365-filtering-correlation-id: f4651a21-98cd-492a-c81b-08dde483cbc6 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|366016|1800799024|376014|38070700018|8096899003; x-microsoft-antispam-message-info: =?Windows-1252?Q?SrS3fPQKdlasFkfRb24WmQf+/hnByHGhhvxmfr9aTzwcC13XE+Sw+0h0?= =?Windows-1252?Q?taZ95QItowVQ2aq2+XCWDlUybAdkGUT0AVlnAtHKLg30bsmlURh5WoPi?= =?Windows-1252?Q?XHaXF5J5srd7xcDUyWE0iOUBMSE/+2hEdrgvcmlj4l7tXnbUGynQmEHo?= =?Windows-1252?Q?bdi2+eqlOzWckvKtTQAVrYc7llN4aUMcG7Om5pYw9yKNLXSvbgreRrgz?= =?Windows-1252?Q?HD1VhCzwZ6qsBM6D1ywyAOztfgJOR2hK8Fi7sbSgoTHwQsOoErEkreBH?= =?Windows-1252?Q?Kk725InzR091XcZ1yVHlQjtpRjGoW7dfC0ez5QRjL6UO4x7VhD7CTqmN?= =?Windows-1252?Q?8BubJu9hn9duVdfxTv5niG6X3aCqQtNkyWMXcbC881Nb/kJFrnG7ujoF?= =?Windows-1252?Q?aMwo197/imgievQim/9cNzPEJ4+Wr4sJVGOlkbI5vGjEfp70w89lYHqN?= =?Windows-1252?Q?eTXDnW1HTekoGUNnutHjoeIp8uvvenvV26w4C/n0vQinPe/brhr3RA85?= =?Windows-1252?Q?UhNRaUzqKKyf4ea8xct1aE/5qn4xY0AGhspR354ojFL32hXPTpPWCKLH?= =?Windows-1252?Q?o92ZtXiXoVvi3je5pKBIZFyJeE37ya4kdQz6C5dqBmN9Hk+6P8FQ60qu?= =?Windows-1252?Q?DU3l2bWcjtTH9GqTtmn88DVsFBxQndD31EICyXUw0vWRVusfOpppmWfY?= =?Windows-1252?Q?kbiBNUOttwuIXX+vQdxMH9/CCRjGWuCWd+Ahmdcw88P2l6+Yg8wMg+rV?= =?Windows-1252?Q?j590TxZHkqYvu6PGtZiXKIaSAxgL14+045a127eQ3Mt3KCMU8cAGqAo/?= =?Windows-1252?Q?IpugG3yrnZHoa8ckALA6DqULGIwOy34H7cDJ5BiK2ak/tM5b+6U/SmHU?= =?Windows-1252?Q?gCUnBpNk0v9SpgKRvslKkM9lhsrpM0bOok4q1xDhFlG1wC5QB1R5hXSN?= =?Windows-1252?Q?4Z60wy85ad8miH5zcSbejkxMBOUsdJwzeBEP4wadhk+FLSJUmZgqjtIc?= =?Windows-1252?Q?9qGMODCIBlF5vZhokqzCw5tWE4MhePS5FuHsJQxeYzDmVqPB+PBYbk8g?= =?Windows-1252?Q?idg+k8Vs2ppYEMRuTtcpfoNeCnn6dI6O7y9g/pd+8saJBzeZeg6G9fIu?= =?Windows-1252?Q?q1wSLFlpGMVJvDtJD02egw+OL/e44Qm1Dzf7noANOjQEDvb+VU1TA2e2?= =?Windows-1252?Q?fpYvgzGI+7TVnvFAT71zVNKlAaIto3loelUHr4xA3VNFxxP+GhqYaLp1?= =?Windows-1252?Q?8qPUYAZeHcBN0usQYFrqYvcTXe0vowFNGa0RDWol72jc1QnJ/EHbHBow?= =?Windows-1252?Q?X9V+defP5JMFJaxmc0mTzUbOmIYSPZvBE9ddCBAHldSg9B64+19ROqzZ?= =?Windows-1252?Q?Uz+7e0B3rCoHbs+ALPmD7rtM3xOKvNez5OJKDpr/U9ne1vUh7iIjW/Ya?= =?Windows-1252?Q?H8k+V5BJLlrJ8TlyZ+913wHxEDra2nwiAs4zKZd18KurDLPW1opjA30R?= =?Windows-1252?Q?QOxi+iKE0EBKL9kMCCw9Lur7CGtCIXUhbDGBAYFDYVHhD+KHTvZEK7vq?= =?Windows-1252?Q?Bf/JtAbtTvYKTQod/ajFDj7FScrAa+b2sDCJxNWvhES/xhN7iUlEX3l3?= =?Windows-1252?Q?8II=3D?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TYYP301MB1354.JPNP301.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230040)(366016)(1800799024)(376014)(38070700018)(8096899003);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?Windows-1252?Q?LgUQG3bX8805TtqqfK1qPEPedxgSRESILwXt3FpraUjxGtPWbDCg55nS?= =?Windows-1252?Q?ttkF/D6nSahF9Zk6zn5FtbzMyPnkCeFB4sU6iYfy+jloASjbzYb5u9q3?= =?Windows-1252?Q?EiRaCvqfZjF0OPWpr8k9+jo+fXJWqREtZY9C+1YKtA0k0D5/mWxBMVEa?= =?Windows-1252?Q?pwp1O/Zcpy1H9DxyZMWeBBVJnib1h5JJI0XcPp86JNWvD64TWk4sKYY7?= =?Windows-1252?Q?8whhkAf9nzeVoL44wrH8qzAqKBV+Nd3vCePwvlN3DBp2wNPSdjNjK2Vb?= =?Windows-1252?Q?h6A2LToc1O5nmJrqcXkxzP9oYj+y7nGeZQbjNYX7Uy7sTBzLCLc76OnR?= =?Windows-1252?Q?O0RH37QQGusxV+yCl4E0G4pqdYxaUBUI0va6Y/7Gc0KYWTLu4XdGzusc?= =?Windows-1252?Q?akJ80tCnxUxr5wULgsY1iOZgOUorPkSEOXGH5DAaaNWLeovl14DGEGCT?= =?Windows-1252?Q?x67sbXYle2dMR0nou/iUjtDuCaJHqo47pxhoAr1wrXQPdkrIFstTYUUa?= =?Windows-1252?Q?aGerdu4TMKjFSdTCevp1lxQlr+fyctBTH4gMawfgFau3aqQ+YgVcQpVg?= =?Windows-1252?Q?SpA8Np2S4KfHCzsqnTwOLrwKvVBbDJSWRRuc8kU0Tt1cFMlYGHucz7+M?= =?Windows-1252?Q?hFhlIO++AtdPsC8zeXsaUDkRCW1wdLCggkQTlQuZkD1HuqZx3kBgqjgi?= =?Windows-1252?Q?7D+4w9p1wkASBYZe52rugL0ZzzhWo5buOaKlsN1s5WEzz/+Uz3ZGqbid?= =?Windows-1252?Q?X2epwJCFAo1eqzHgl6P2lwBzxirb39HV9OFvTjBUlOYPXRezOziMYt+G?= =?Windows-1252?Q?YAeOgMnezX060sLcpTzzZlbIwZGW0toOsLid5rgjDJ+0n1l6jN1ILQXu?= =?Windows-1252?Q?55QM021cS6MQpfxRr/h091me4JouhcfhGO+Ard2CQkC4XB9rMkhGglLH?= =?Windows-1252?Q?yvWP3s6gvbW86AXikgU1zse/PzYM1PahuDXkIAbVj6LwM7p6Gt0BlG0G?= =?Windows-1252?Q?6Rt70u/P6mRbNOSGoJWlBUBA2w1yu3tqg2/Sej0nqa66+7tkttC36hMh?= =?Windows-1252?Q?fugi+Y1J/o9GvltlgCEIjIhJkoZsD2TrJ2063bqh3Z+gxWMsAcz24cUt?= =?Windows-1252?Q?awOQa82VMKiEgqRBEafOFx/DxuT1pjlaJSwCtWq4Dwkx4v7LUX5EXJpa?= =?Windows-1252?Q?Ju6q7gWA3ArFsq0cCrMmiP7cZIHojibclNV3azG1wT4DWtLA9fkFwuS4?= =?Windows-1252?Q?+fD1JAd/MGLVf1C49fIPOKu8n/Eqv6XVXdKMnL4desw8DNrJsGJf+9fv?= =?Windows-1252?Q?90xeWGg8GyD7qDIu+gPJsGerse5PpTYbaOClhCO8rl+hzitY51/kwrvH?= =?Windows-1252?Q?TvpQOpW2zL0jxNoSCjWDybmUSvNSPjYI7N22t1iaJWEnxrnz0NGxM2a9?= =?Windows-1252?Q?aBBPUj2Jo4Yfe19qm95IfR9EF6MlBlAMZtzT0Xi8CU83iZXa0Z0a/irr?= =?Windows-1252?Q?oA6tKjoPuZVZNBpA+cmzCL+FXL7u2OrsRmuN1IDgQBzA3kAvwHQ/4ZOv?= =?Windows-1252?Q?5wrcNvHwTGrikFBcz9x0+bcqYzcQjHZqRx3cSpu5nn/6o0GQ0kfLkAai?= =?Windows-1252?Q?+1zAgvsEQlCejZLWeSLhYh8J133jjMqGMlaPZEt3hbAWKr/HaI0TPuAR?= =?Windows-1252?Q?7tRhf+GvAHa46cX4YPEeM53/Fzm5gZpySPQDv4ogSoqjmGAn8BJhHA?= =?Windows-1252?Q?=3D=3D?= Content-Type: multipart/alternative; boundary="_000_TYYP301MB135488AEFB73DD10696220F78139ATYYP301MB1354JPNP_" MIME-Version: 1.0 X-OriginatorOrg: hk.yusen-logistics.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: TYYP301MB1354.JPNP301.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: f4651a21-98cd-492a-c81b-08dde483cbc6 X-MS-Exchange-CrossTenant-originalarrivaltime: 26 Aug 2025 09:34:46.6601 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: ca2aecff-bc6d-4032-9161-fe56057fd193 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: SPEP6oBEdmYycGz2Kv9P2WeGetu2w5dKDrgxAmLV2OzZnG9Zgk8sg/lhN3nPJCoxe0IXnjY8dgJ/PTRyPWEzUec/hGOgAK7pZwQZDTHkGv4= X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYYP301MB1144 X-Proofpoint-Spam-Details-Enc: AW1haW4tMjUwODI2MDAxMyBTYWx0ZWRfX+QCzfHU267IB w9jqaZhBDvqSpyLQnpHkkZUDw7Nqgp+iZtq3z5nui2W5MrKyeDAeyhxZwd/IBvg6OgU9isljXSo 4sU08N3S31Gf4a/n4cP/syrlDVjSRpaXsw6flZdoMBS2Rgp2xdELkps3oF7a4gEV3af6nE/doAa uVhUmO3bSHLeozqPCoZfg++5UQycJ0K8jatkMtN1k+fJrF7M5dldLAN7/lrKJ/DT+v1vTcgwoYU wbMndE1vS3Tl5tjgBYWEUlpYQUovCo/ZVY5Lqq6Z6BT3mm8eIU/HwoQcxi2Yp4+t451qiuNMNz/ UeBFAizhVcynbt2c8vHi/ne1vJtdfiZsOAjIZoOrEi78Cts4IQRlIrGsEPGISb1SrTi/XauaT8Q zUEOs08m X-Authority-Analysis: v=2.4 cv=R/wDGcRX c=1 sm=1 tr=0 ts=68ad7fb9 cx=c_pps a=SqXz6srAmfI9N4VVD9X/4Q==:117 a=z/mQ4Ysz8XfWz/Q5cLBRGdckG28=:19 a=lCpzRmAYbLLaTzLvsPZ7Mbvzbb8=:19 a=wKuvFiaSGQ0qltdbU6+NXLB8nM8=:19 a=Ol13hO9ccFRV9qXi2t6ftBPywas=:19 a=xqWC_Br6kY4A:10 a=2OwXVqhp2XgA:10 a=7j0FZ4iXMVMA:10 a=QLFhjc-ydeAA:10 a=m6GteZdtepukkGG8H64A:9 a=pILNOxqGKmIA:10 a=94PoLSZE1mcds7zYdwgA:9 a=SLtSMyJXVpy8roWg:21 a=frz4AuCg-hUA:10 a=_W_S_7VecoQA:10 X-Proofpoint-GUID: wziuUeV2V_oC2JaqQFxNsYnvPzUXNpTq X-Proofpoint-ORIG-GUID: wziuUeV2V_oC2JaqQFxNsYnvPzUXNpTq X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1099,Hydra:6.1.9,FMLib:17.12.80.40 definitions=2025-08-26_02,2025-08-26_01,2025-03-28_01 X-Proofpoint-Spam-Reason: orgsafe List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_TYYP301MB135488AEFB73DD10696220F78139ATYYP301MB1354JPNP_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Senior Database Developer Experience: >8 years Work Mode: Hybrid Tech Stack: PostgreSQL, MongoDB, Cassandra Key Responsibilities * Database Architecture & Data Modeling Design and maintain scalable, normalized and denormalized schemas for micro= services and reporting use cases using PostgreSQL, MongoDB, and Cassandra (= especially for time-series or high-write workloads). * Query & Aggregation Development Write and optimize SQL queries, views, materialized views, stored procedure= s, and MongoDB aggregation pipelines. Develop efficient CQL-based queries a= nd data models for Cassandra in distributed environments. * Application Integration Work closely with Java Spring Boot teams to define efficient ORM mappings (= Hibernate, JPA) and API-facing query strategies. Participate in schema evol= ution and entity refactoring across SQL and NoSQL platforms. * Performance Optimization Analyze execution plans, tune queries, recommend indexes, and optimize join= s, batch loads, and aggregation logic for high-throughput transactional sys= tems. Use Cassandra=92s partitioning and clustering keys for performance. * Reporting Logic Develop backend logic and data layers to support BI tools and custom dashbo= ards. Collaborate with frontend and data teams to meet data presentation re= quirements. * Data Governance & Standards Define and enforce constraints, validation logic, and naming conventions ac= ross services. Work with analysts and QA to ensure data consistency across = PostgreSQL, MongoDB, and Cassandra. * Versioning & Deployment Maintain schema versioning using Flyway or Liquibase or any relevant tools.= Review and approve migration scripts as part of CI/CD workflows with DevOp= s. * Backup Knowledge (Supportive) Coordinate with infra teams for PostgreSQL PITR, MongoDB snapshot/restore, = and Cassandra backup integration. Validate restore logic periodically, with= out being the primary owner. Must-Have Skills * Proficiency in SQL query optimization, indexing, schema design, and M= ongoDB/Cassandra aggregation pipelines. * Hands-on experience collaborating with backend developers and writing= query logic that supports APIs and domain-driven models. * Comfortable with high-concurrency systems, denormalized views, partit= ioning, and materialized logic. * Deep understanding of Cassandra=92s data modeling (e.g., primary key = vs. partition key), compaction strategies, and consistency trade-offs. * Proficient in cloud-native databases (e.g., GCP/AWS PostgreSQL, Mongo= DB Atlas, Cassandra DBaaS) and Kubernetes-based DB deployments. Nice-to-Have Skills * Kafka, RabbitMQ, or event-driven persistence models. * Experience with Redis or in-memory caching strategies. * Exposure to OpenSearch / Elasticsearch for analytics or log event pip= elines. * Familiarity with RBAC, encryption, and row-level security in regulate= d environments (GDPR, SOC2). * Experience supporting reporting engines or data extraction for BI. Regards, Mrigank B Singh (MG) IT Manager (G2) Yusen Logistics Ltd. --_000_TYYP301MB135488AEFB73DD10696220F78139ATYYP301MB1354JPNP_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable
Senior Database Developer
Experience: >8 years
Work Mode: Hybrid
Tech Stack: PostgreSQL, MongoDB, Cassandra
 
Key Responsibilities
  • Database Architecture & Data Modeling
    Design and maintain scalable, normalized and denormalized schemas for micro= services and reporting use cases using PostgreSQL, MongoDB, and Cassandra (= especially for time-series or high-write workloads).
  • Query & Aggregation Development
    Write and optimize SQL queries, views, materialized views, stored procedure= s, and MongoDB aggregation pipelines. Develop efficient CQL-based queries a= nd data models for Cassandra in distributed environments.
  • Application Integration
    Work closely with Java Spring Boot teams to define efficient ORM mappings (= Hibernate, JPA) and API-facing query strategies. Participate in schema evol= ution and entity refactoring across SQL and NoSQL platforms.
  • Performance Optimization
    Analyze execution plans, tune queries, recommend indexes, and optimize join= s, batch loads, and aggregation logic for high-throughput transactional sys= tems. Use Cassandra=92s partitioning and clustering keys for performance.
  • Reporting Logic
    Develop backend logic and data layers to support BI tools and custom dashbo= ards. Collaborate with frontend and data teams to meet data presentation re= quirements.
  • Data Governance & Standards
    Define and enforce constraints, validation logic, and naming conventions ac= ross services. Work with analysts and QA to ensure data consistency across = PostgreSQL, MongoDB, and Cassandra.
  • Versioning & Deployment
    Maintain schema versioning using Flyway or Liquibase or any relevant tools.= Review and approve migration scripts as part of CI/CD workflows with DevOp= s.
  •  
    Must-Have Skills
    • Proficiency in SQL query optimization, indexing, schema design, and MongoDB= /Cassandra aggregation pipelines.
    • Hands-on experience collaborating with backend developers and writing query= logic that supports APIs and domain-driven models.
    • Comfortable with high-concurrency systems, denormalized views, partitioning= , and materialized logic.
    • Deep understanding of Cassandra=92s data modeling (e.g., primary key vs. pa= rtition key), compaction strategies, and consistency trade-offs.
    • Proficient in cloud-native databases (e.g., GCP/AWS PostgreSQL, MongoDB Atl= as, Cassandra DBaaS) and Kubernetes-based DB deployments.
     
    Nice-to-Have Skills
    • Kafka, RabbitMQ, or event-driven persistence models.
    • Experience with Redis or in-memory caching strategies.
    • Exposure to OpenSearch / Elasticsearch for analytics or log event pipelines= .
    • Familiarity with RBAC, encryption, and row-level security in regulated envi= ronments (GDPR, SOC2).
    • Experience supporting reporting engines or data extraction for BI.

    • Regards,

      Mrigank B Singh (MG)

      IT Manager (G2)

      Yusen Logistics Ltd.

       

      --_000_TYYP301MB135488AEFB73DD10696220F78139ATYYP301MB1354JPNP_--