Source description
About the role
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 410 years of experience in Database Administration and Migration.Strong expertise in Microsoft SQL Server:T-SQLSSISIndexingQuery OptimizationPerformance TuningHands-on experience with PostgreSQL:PL/pgSQLDatabase AdministrationPerformance OptimizationProven experience in MSSQL to PostgreSQL Migration projects.Strong knowledge of:Schema ConversionData Type MappingStored Procedure Conversion (T-SQL to PL/pgSQL)SQL Query OptimizationExperience in Data Modeling and Database Design. Good To Have Skills Experience with migration and ETL tools:SSISTalendInformaticaAWS Database Migration Service (DMS)Azure Data Factory (ADF)Experience with:AWS RDS PostgreSQLAzure Database for PostgreSQLKnowledge of:Change Data Capture (CDC)Replication-based MigrationDevOps & CI/CDPython 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 MigrationPhased MigrationReplication-Based Migration Schema & Code Conversion Convert database objects:TablesViewsIndexesConstraintsFunctionsTriggersStored ProceduresRewrite 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 IntegrityData ConsistencyMinimal 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 ValidationReconciliationFunctional TestingPerformance TestingResolve 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 AdministrationPostgreSQL AdministrationDatabase Migration StrategySchema ConversionPL/pgSQL DevelopmentT-SQL ProgrammingSQL Performance TuningETL & Data IntegrationData ModelingBackup & RecoveryHigh Availability & Disaster RecoveryAWS DMS / Azure Data FactoryCloud Database PlatformsDevOps & 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. Skills: postgresql,mssql,schema,migration 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 410 years of experience in Database Administration and Migration.Strong expertise in Microsoft SQL Server:T-SQLSSISIndexingQuery OptimizationPerformance TuningHands-on experience with PostgreSQL:PL/pgSQLDatabase AdministrationPerformance OptimizationProven experience in MSSQL to PostgreSQL Migration projects.Strong knowledge of:Schema ConversionData Type MappingStored Procedure Conversion (T-SQL to PL/pgSQL)SQL Query OptimizationExperience in Data Modeling and Database Design. Good To Have Skills Experience with migration and ETL tools:SSISTalendInformaticaAWS Database Migration Service (DMS)Azure Data Factory (ADF)Experience with:AWS RDS PostgreSQLAzure Database for PostgreSQLKnowledge of:Change Data Capture (CDC)Replication-based MigrationDevOps & CI/CDPython or Shell Scripting experience.Knowledge of Backup, Recovery, HA & DR concepts. Roles & Responsibilities Migration Planning & A
More at Zorba AI