Migration Expert (SQL Server to PostgreSQL)

The Migration Expert role involves leading database migration projects from SQL Server to PostgreSQL. The company focuses on strategic migration planning, coding, and optimizing complex database procedures. The role requires a deep understanding of T-SQL internals and proficiency in IT Service Management (ITSM) concepts, with advanced skills in JIRA. The main day-to-day responsibilities include leading end-to-end migration projects, analyzing and optimizing T-SQL code, and developing migration tools. The role also involves documenting migration processes, mentoring junior DBAs and developers, and supporting IT development workflows. The expert will work with Atlassian workflow and documentation systems, including Jira, Confluence, GitHub, and GitLab. The must-have requirements include at least 10 years of experience with Microsoft SQL Server, expert-level T-SQL knowledge, and a deep understanding of T-SQL internals. The candidate must have a proven track record of migrating large and complex databases from SQL Server to PostgreSQL. Strong experience with PostgreSQL features, PL/pgSQL, and performance tuning in PostgreSQL environments is also required. Additionally, the role demands hands-on experience writing complex SQL scripts, stored procedures, functions, and triggers, as well as strong analytical, problem-solving, and communication skills. Nice-to-have skills include experience with cloud platforms like Azure, AWS, or GCP for database hosting and migration. Knowledge of scripting languages such as Python or Bash for automation is also beneficial. Familiarity with SQL Server Integration Services (SSIS) or equivalent ETL frameworks for complex data migration pipelines is an added advantage. The team works with Atlassian tools and documentation systems, and the role offers opportunities for mentoring and professional growth. What the role asks for: - 10 years' experience working with Microsoft SQL Server - Expert-level T-SQL knowledge - Deep understanding of T-SQL internals - Proven track record of migrating large and complex databases from SQL Server to PostgreSQL - Strong experience with PostgreSQL features, PL/pgSQL, and performance tuning in PostgreSQL environments - Hands-on experience writing complex SQL scripts, stored procedures, functions, and triggers - Strong analytical, problem-solving, and communication skills - Nice-to-have: Experience with cloud platforms (Azure, AWS, GCP) for database hosting and migration