- In depth knowledge of PostgreSQL and MSSQL Architecture.
- Willing to participate in hands on delivery of cross database migrations.
- Ability to design and architect migration strategies for Oracle to Postgres , Sybase to MSSQL migrations.
- In depth knowledge of Performance tuning in Postgres and MSSQL.
- Basic knowledge of High Availability strategies for on-prem and cloud Postgres as well as MSSQL.
Added advantage
- Well versed with cross platform migration and code conversions.
- Knowledge on Azure PaaS instances such as Azure Postgres Flexi server, Azure SQL , Azure SQL Managed Instance.
- Knowledge of automation using Shell, PowerShell etc.
- Knowledge of deployment tools such as Gitlab , ADO etc.
- Experienced in data migration using various tools such as DMS , Azure Data Factory, ora2pg etc. Knowledge of change data capture is added advantage.
- 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.
- In depth knowledge of PostgreSQL and MSSQL Architecture.
- Willing to participate in hands on delivery of cross database migrations.
- Ability to design and architect migration strategies for Oracle to Postgres , Sybase to MSSQL migrations.
- In depth knowledge of Performance tuning in Postgres and MSSQL.
- Basic knowledge of High Availability strategies for on-prem and cloud Postgres as well as MSSQL.
Desired skills*
- Well versed with cross platform migration and code conversions.
- Knowledge on Azure PaaS instances such as Azure Postgres Flexi server, Azure SQL , Azure SQL Managed Instance.
- Knowledge of automation using Shell, PowerShell etc.
- Knowledge of deployment tools such as Gitlab , ADO etc.
- Experienced in data migration using various tools such as DMS , Azure Data Factory, ora2pg etc. Knowledge of change data capture is added advantage.
- 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