Your browser does not support javascript! Please enable it, otherwise web will not work for you.

SQL To PGS Consultant @ Newt Global

Home > DBA / Data warehousing

 SQL To PGS Consultant

Job Description

Job Description:
We are seeking an experienced SQL to PostgreSQL (PGS) Consultant to support the migration of existing SQL Server workloads to PostgreSQL. The ideal candidate will have a strong background in database development, performance tuning, and hands-on experience in large-scale database migration projects.
Key Responsibilities:
  • Analyze and assess existing SQL Server database schemas, stored procedures, functions, and jobs.
  • Design and implement equivalent PostgreSQL database structures and logic.
  • Migrate data, views, triggers, and other database objects from SQL Server to PostgreSQL.
  • Optimize PostgreSQL queries, indexing, and performance tuning post-migration.
  • Develop and maintain ETL processes as required during the migration.
  • Conduct thorough testing and validation of data and functionality after migration.
  • Collaborate with application teams to ensure seamless database integration and minimal downtime.
  • Document migration procedures, technical approaches, and troubleshooting steps.
Required Skills:
  • Strong hands-on experience with SQL Server (T-SQL) and PostgreSQL (PL/pgSQL) .
  • Proven experience in SQL to PostgreSQL migration projects .
  • Deep understanding of database performance tuning and optimization techniques .
  • Experience working with data migration tools and ETL processes .
  • Familiarity with schema comparison , data validation , and replication techniques .
  • Knowledge of PostgreSQL-specific features such as JSONB, partitioning, and indexing.
  • Strong problem-solving and debugging skills.
Preferred Qualifications:
  • Experience with cloud-managed PostgreSQL databases (e.g., Amazon RDS , Google Cloud SQL , Azure Database for PostgreSQL ).
  • Understanding of DevOps practices related to database deployment and migration.
  • Exposure to data modeling tools and migration utilities (e.g., AWS DMS, ora2pg, pgloader).
  • Knowledge of Python or scripting languages for automation.

Job Classification

Industry: IT Services & Consulting
Functional Area / Department: Engineering - Software & QA
Role Category: DBA / Data warehousing
Role: Database Administrator
Employement Type: Full time

Contact Details:

Company: Newt Global
Location(s): Kolkata

+ View Contactajax loader


Keyskills:   Performance tuning Automation Data migration Data modeling Postgresql Debugging Stored procedures Troubleshooting SQL Python

 Job seems aged, it may have been expired!
 Fraud Alert to job seekers!

₹ Not Disclosed

Similar positions

Custom Software Engineer

  • Accenture
  • 2 - 5 years
  • Mumbai
  • 4 days ago
₹ Not Disclosed

Custom Software Engineer

  • Accenture
  • 3 - 8 years
  • Mumbai
  • 4 days ago
₹ Not Disclosed

MarTech Consultant

  • Capgemini
  • 8 - 13 years
  • Noida, Gurugram
  • 4 days ago
₹ Not Disclosed

Custom Software Engineer

  • Accenture
  • 3 - 8 years
  • Hyderabad
  • 4 days ago
₹ Not Disclosed

Newt Global

Newt'snewt'sNewt Global is a unique company in Cloud Technology solutions enabling clients to fast-track application/data modernization and migration initiatives through Platform Led Factory Model thus saving 50%+ in costs and time over people-led factory model. Newt Global is a leading technology s...