Database Migration Specialist – MSSQL to PostgreSQL

Job Summary

We are looking for an experienced Database Migration Specialist with expertise in migrating databases from Microsoft SQL Server (MSSQL) to PostgreSQL. The ideal candidate will be responsible for planning, executing, validating, and optimizing end-to-end database migration activities while ensuring minimal downtime, high data integrity, and optimal database performance.

The role requires strong expertise in schema conversion, stored procedure migration, performance tuning, ETL processes, and application compatibility during database migration projects.

Required Skills

• 4–10 years of experience in Database Administration and Migration.
• Strong expertise in Microsoft SQL Server:
  • T-SQL
  • SSIS
  • Indexing
  • Query Optimization
  • Performance Tuning
• Hands-on experience with PostgreSQL:
  • PL/pgSQL
  • Database Administration
  • Performance Optimization
• Proven experience in MSSQL to PostgreSQL Migration projects.
• Strong knowledge of:
  • Schema Conversion
  • Data Type Mapping
  • Stored Procedure Conversion (T-SQL to PL/pgSQL)
  • SQL Query Optimization
• Experience in Data Modeling and Database Design.

Good to Have Skills

• Experience with migration and ETL tools:
  • SSIS
  • Talend
  • Informatica
  • AWS Database Migration Service (DMS)
  • Azure Data Factory (ADF)
• Experience with:
  • AWS RDS PostgreSQL
  • Azure Database for PostgreSQL
• Knowledge of:
  • Change Data Capture (CDC)
  • Replication-based Migration
  • DevOps & CI/CD
• Python or Shell Scripting experience.
• Knowledge of Backup, Recovery, HA & DR concepts.

Roles & Responsibilities Migration Planning & Analysis

• Analyze existing MSSQL databases, schemas, dependencies, and workloads.
• Perform migration readiness assessment.
• Design migration strategies including:
  • Full Migration
  • Phased Migration
  • Replication-Based Migration

Schema & Code Conversion

• Convert database objects:
  • Tables
  • Views
  • Indexes
  • Constraints
  • Functions
  • Triggers
  • Stored Procedures
• Rewrite T-SQL code into PostgreSQL PL/pgSQL.
• Handle data type mapping, sequences, identity columns, and constraints.

Data Migration

• Design and implement ETL pipelines.
• Execute bulk and incremental data migration.
• Ensure:
  • Data Integrity
  • Data Consistency
  • Minimal Downtime

Application Remediation

• Modify SQL queries for PostgreSQL compatibility.
• Work closely with application development teams.
• Support application integration and deployment activities.

Testing & Validation

• Perform:
  • Data Validation
  • Reconciliation
  • Functional Testing
  • Performance Testing
• Resolve migration defects and optimize migration processes.

Performance Optimization

• Tune PostgreSQL queries and execution plans.
• Optimize indexes and database performance.
• Resolve scalability and performance bottlenecks.

Documentation & Support

• Prepare migration documents and runbooks.
• Develop rollback and recovery strategies.
• Provide post-migration production support.
• Ensure governance, compliance, and knowledge transfer.

Technical Competencies

• MSSQL Database Administration
• PostgreSQL Administration
• Database Migration Strategy
• Schema Conversion
• PL/pgSQL Development
• T-SQL Programming
• SQL Performance Tuning
• ETL & Data Integration
• Data Modeling
• Backup & Recovery
• High Availability & Disaster Recovery
• AWS DMS / Azure Data Factory
• Cloud Database Platforms
• DevOps & CI/CD

Soft Skills

• Excellent analytical and troubleshooting skills.
• Strong communication and stakeholder management.
• Ability to work in Agile environments.
• Good documentation and presentation skills.
• Strong collaboration and teamwork.

Education

• Bachelor's Degree in Computer Science, Information Technology, or a related discipline.