SQL To PGS Consultant @ Newt Global

Home > DBA / Data warehousing

SQL To PGS Consultant

Newt Global
0 years
Kolkata
18 days 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 (*)

500 characters remaining

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

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

Application Database Administrator-NoSQL Cloud Databases

IBM

3 - 7 years

Mumbai

11 hours ago

₹ Not Disclosed

Postgresql

Cognizant

5 - 7 years

Mumbai

1 day ago

₹ Not Disclosed

Lead Administrator - L1

Wipro

5 - 8 years

Hyderabad

2 days ago

₹ Not Disclosed

Lead Administrator - L1

Wipro

5 - 8 years

Hyderabad

2 days ago

₹ Not Disclosed

Newt Global

Newt Global India Private Limited Newt Global is a Global IT Services and Product development Company founded in 2004 and headquartered at Dallas TX, USA with over 500 employees globally. We are present in multiple locations in USA and in India we have offices in Chennai, Bangalore, Hyderabad, M...

SQL To PGS Consultant @ Newt Global

Home > DBA / Data warehousing