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.