Posted 07 June, 2026
Database Architect
ClifyX
Bengaluru,Karnataka,India
Full Time
Reference: 365_594563_25-05496
| Country | India |
| Number of Openings* | 2 |
| Approved ECMS RQ# | 454504Y25 |
| Duration of contract* | 12 months |
| Total Yrs. of Experience* | 10+ |
| Relevant Yrs. of experience* | 10+ |
| Role | Database Architect |
| Detailed JD *(Roles and Responsibilities) | Must Have : 1. Handson Experience in PL-SQL/PL-PGSQL/TSQL. 2. In depth knowledge of PostgreSQL and MSSQL Architecture. 3. Willing to participate in hands on delivery of cross database migrations. 4. Ability to design and architect migration strategies for Oracle to Postgres , Sybase to MSSQL migrations. 5. In depth knowledge of Performance tuning in Postgres and MSSQL. 6. Basic knowledge of High Availability strategies for on-prem and cloud Postgres as well as MSSQL. Added advantage: 1. Well versed with cross platform migration and code conversions. 2. Knowledge on Azure PaaS instances such as Azure Postgres Flexi server, Azure SQL , Azure SQL Managed Instance. 3. Knowledge of automation using Shell, PowerShell etc. 4. Knowledge of deployment tools such as Gitlab , ADO etc. 5. Experienced in data migration using various tools such as DMS , Azure Data Factory, ora2pg etc. Knowledge of change data capture is added advantage. 6. Experienced in Postgres upgrades, MSSQL to Azure SQL, on-prem to cloud Postgres migration strategies. |
| Mandatory skills* | 1. Handson Experience in PL-SQL/PL-PGSQL/TSQL. 2. In depth knowledge of PostgreSQL and MSSQL Architecture. 3. Willing to participate in hands on delivery of cross database migrations. 4. Ability to design and architect migration strategies for Oracle to Postgres , Sybase to MSSQL migrations. 5. In depth knowledge of Performance tuning in Postgres and MSSQL. 6. Basic knowledge of High Availability strategies for on-prem and cloud Postgres as well as MSSQL. |
| Desired skills* | 1. Well versed with cross platform migration and code conversions. 2. Knowledge on Azure PaaS instances such as Azure Postgres Flexi server, Azure SQL , Azure SQL Managed Instance. 3. Knowledge of automation using Shell, PowerShell etc. 4. Knowledge of deployment tools such as Gitlab , ADO etc. 5. Experienced in data migration using various tools such as DMS , Azure Data Factory, ora2pg etc. Knowledge of change data capture is added advantage. 6. Experienced in Postgres upgrades, MSSQL to Azure SQL, on-prem to cloud Postgres migration strategies. |
| Domain* | Banking |
| Client name (for internal purpose only)* | Banking |
| Approx. vendor billing rate* (INR /Day) | 12,000 INR/Day |
| Work Location* | Pune |
| Background check process to be followed: * | Yes |
| Before onboarding / After onboarding: * | Before Onboarding |
| BGV Agency: * | as agreed with Subcon_BGV team |
| Mode of Interview: Telephonic/Face to Face/Skype Interview* | Teams - Video |
| WFO / WFH / Hybrid | WFO |
| Any Certification (Mandatory) | As per JD |
| Shift Time | - |
| Business travel required (Yes / No) | No |
| Client BTP / SHTP | Pune(Hinjewadi or Kharadi) |
