SQL To PGS Consultant

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.