SQL To PGS Consultant @ Newt Global

Home > DBA / Data warehousing

SQL To PGS Consultant

Newt Global
0 years
Kolkata
7 months ago
Email to a friend
Report this job

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 Contact

Login

Candidates can login here to view contacts and apply.

Sign In Sign Up

Email:

Password:

Password too short

To create your profile, apply for a job or make a registration

Your name (*)

Email (*)

Mobile (*)

Preferred City (* max. 2 w/comma)

Designation / Expected Role

Current / Recent Company (*)

Experience (*)

Expected Salary (*)

Desired Industry (*):

Functional area / Department (*):

Enter Skills (key skills, subjects, technologies & roles to use in search)

Write briefly about yourself, your experience and education (*)

Attach Resume Max 2.38 MB (RTF, PDF, DOC, DOCX formats only parsed)

Please, check the file size and type.

Add social media [ + ]

Create password

I agree with website service terms and conditions

Candidates are expected to provide most recent and accurate profile information, inappropriate content is strictly prohibited!

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

Job application

We will notify the employer with your details. You can also attach a resume or a cover letter.

Sign In Sign Up

Email:

Password:

Password too short

To create your profile, apply for a job or make a registration

Your name (*)

Email (*)

Mobile (*)

Preferred City (* max. 2 w/comma)

Designation / Expected Role

Current / Recent Company (*)

Experience (*)

Expected Salary (*)

Desired Industry (*):

Functional area / Department (*):

Enter Skills (key skills, subjects, technologies & roles to use in search)

Write briefly about yourself, your experience and education (*)

Attach ResumeMax 2.38 MB (RTF, PDF, DOC, DOCX formats only parsed)

Please, check the file size and type.

Add social media [ + ]

Create password

I agree with website service terms and conditions

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...

SQL To PGS Consultant @ Newt Global

Home > DBA / Data warehousing