Migration Expert (SQL Server to PostgreSQL)

pstrongJob Summary: /strong /p pstrongSeeking a highly experienced Migration Expert with at least 10 years of hands-on /strong /p pstrongexperience in SQL Server T-SQL development and database migration to PostgreSQL. The ideal candidate must have deep knowledge of T-SQL internals and be proficient in IT Service Management (ITSM) concepts with advanced skills in JIRA (minimum 10 years). This role requires strategic migration planning, coding, and optimizing complex database procedures, with strong expertise in JIRA workflows and ITSM automation. /strong /p h2Tasks /h2 pstrongKey Responsibilities: /strong /p ul listrongLead end-to-end migration projects from SQL Server (T-SQL) to PostgreSQL, including schema conversion, stored procedures, functions, and data migration. /strong /li listrongAnalyze and optimize T-SQL code, leveraging deep understanding of T-SQL internals to ensure efficient cross-platform compatibility. /strong /li listrongDevelop and maintain migration tools, scripts, and utilities to automate and streamline migration processes. /strong /li listrongStrong expertise in the Atlassian workflow and documentation systems (Jira Confluence, but also GitHub/GitLab), with hands-on experience supporting IT development workflows or executing database migrations. /strong /li listrongDocument migration architecture, processes, challenges, and lessons learned. /strong /li listrongMentor junior DBAs and developers on T-SQL internals, cross-platform compatibility, and performance tuning. /strong /li /ul h2Requirements /h2 pstrongRequired Skills Experience: /strong /p ul listrongMinimum 10 years’ experience working with Microsoft SQL Server, with expert- /strong /li /ul pstronglevel T-SQL knowledge and deep understanding of T-SQL internals (query optimizer, execution plans, indexing strategy). /strong /p ul listrongProven track record of migrating large and complex databases from SQL Server to PostgreSQL. /strong /li listrongStrong experience with PostgreSQL features, PL/pgSQL, and performance tuning in PostgreSQL environments. /strong /li listrongHands-on experience writing complex SQL scripts, stored procedures, functions, and triggers. /strong /li listrongStrong analytical, problem-solving, and communication skills. /strong /li /ul pstrongSQL Server Expertise (for Migration Auditing): /strong /p ul listrongExpert-level understanding of SQL Server internals, including query execution engine, transaction log architecture, buffer manager, and tempdb behavior. /strong /li listrongProven experience performing schema and data mapping between SQL Server and PostgreSQL (handling data types, collation, constraints, identity/sequence translation, etc.). /strong /li listrongDeep understanding of T-SQL procedural logic and its translation to PL/pgSQL, /strong /li /ul pstrongincluding handling of cursors, dynamic SQL, exception handling, and temporary tables. /strong /p ul listrongStrong knowledge of SQL Server performance tuning — indexing strategy, query plan optimization, statistics management, and partitioning. /strong /li listrongExperience with SQL Server Profiler, Extended Events, and Dynamic Management /strong /li listrongViews (DMVs) for performance analysis and auditing. /strong /li listrongExpertise in SQL Server auditing and compliance, including setup and interpretation of SQL Server Audit, Change Data Capture (CDC), Transaction Log Analysis, and row-level security. /strong /li listrongExperience identifying and resolving cross-platform migration issues such as collation mismatches, differences in transaction isolation levels, or behavior of stored procedure logic. /strong /li listrongAbility to script and automate administrative tasks using PowerShell or SQLCMD, particularly for schema extraction, data export/import, and validation before migration. /strong /li /ul pstrongPreferred Qualifications: /strong /p ul listrongExperience with cloud platforms (Azure, AWS, GCP) for database hosting and migration. /strong /li listrongKnowledge of scripting languages such as Python or Bash for automation. /strong /li listrongFamiliarity with SQL Server Integration Services (SSIS) or equivalent ETL frameworks for complex data migration pipelines will be an added advantage. /strong /li /ulbrpCYBERTEC ist eines der ersten Unternehmen weltweit, das sich auf das OpenSource Datenbankmanagementsystem PostgreSQL im Support- und Consulting- Bereich spezialisiert hat. Neben Hochverfügbarkeit, Skalierung und Consulting bietet CYBERTEC auch Kubernetes / OpenShift basierte Automatisierungen, sowie volle Migrationstoolchains zur raschen Portierung von Oracle nach PostgreSQL. /p pSeit über 20 Jahren ist das Team von CYBERTEC bestrebt, immer einen Schritt voraus zu sein, um sicherzustellen, dass die Kunden Zugang zu den innovativsten und effektivsten Lösungen auf dem Markt haben. CYBERTEC verfügt über das Fachwissen und die Ressourcen, um Unternehmen und Organisationen bei der Erreichung ihrer Ziele zu unterstützen. /p