Migration Expert (SQL Server to PostgreSQL)

Added
12 days ago
Type
Full time
Salary
Salary not provided

Related skills

powershell postgresql sql jira performance tuning

๐Ÿ“‹ Description

  • Lead migrations from SQL Server to PostgreSQL, covering schema conversion, stored procedures
  • Analyze, troubleshoot, and optimize complex T-SQL code using an in-depth understanding of SQL
  • Translate T-SQL procedural logic into PL/pgSQL, addressing differences in data types, collations
  • Develop and maintain migration scripts, tools, and utilities to automate schema extraction, data
  • Assess database performance and auditing requirements using SQL Server Profiler, Extended Events
  • Identify and resolve cross-platform compatibility issues, including transaction isolation

๐ŸŽฏ Requirements

  • At least 10 years of experience working with Microsoft SQL Server and expert-level proficiency in
  • Deep understanding of SQL Server internals, including the query execution engine, transaction log
  • Demonstrated experience migrating large, complex databases from SQL Server to PostgreSQL.
  • Strong knowledge of PostgreSQL, PL/pgSQL, database architecture, and performance tuning.
  • Proven ability to write, analyze, and optimize complex SQL scripts, stored procedures, functions
  • Expertise in schema and data mapping, including data types, collations, constraints

๐ŸŽ Benefits

  • Remote work: Work from anywhere worldwide.
  • Employment type: Permanent employment.
  • Start date: As soon as possible.
  • Technical impact: Lead challenging database modernization projects and improve migration
  • Professional development: Share knowledge with other technical professionals while deepening
Get alerts for new remote engineering jobs
A weekly email with new matches. Unsubscribe anytime.
Share job

Meet JobCopilot: Your Personal AI Job Hunter

Automatically Apply to Engineering Jobs. Just set your preferences and Job Copilot will do the rest โ€” finding, filtering, and applying while you focus on what matters.

Related Engineering Jobs

See more Engineering jobs โ†’