IT Solution Architect

Quick Facts

• Focus: CRM databases on MS SQL Server
• Emphasis: performance, architecture optimization, safe production changes

Description

You will help develop, optimize, and organize key CRM databases built on MS SQL Server. The role involves analyzing complex systems, improving database performance and logic, reverse-engineering MS Access application interfaces into the data layer, and documenting business logic and data flows. You will also deploy changes in production with minimal disruption and assess impacts on integrations, while supporting the evolution of a new web CRM version.

Responsibilities

• Analyze and optimize CRM database performance
• Identify bottlenecks and propose architectural and database-logic improvements
• Develop and optimize queries, stored procedures, functions, and indexes
• Reverse-engineer MS Access applications and map interfaces to the data layer
• Document business logic and data flows
• Implement changes in a live system while maintaining user continuity
• Analyze the impact of changes on integrations with other systems
• Collaborate on development of a new web-based CRM version

Requirements

• At least 5 years of experience working with MS SQL Server databases in production environments across diverse projects/systems
• Very good knowledge of MS SQL Server and T-SQL, including stored procedures, functions, triggers, and indexes
• Practical experience optimizing queries, analyzing execution plans, and diagnosing performance issues (e.g., DMV, SQL Profiler, Extended Events)
• Ability to identify and solve database issues related to blocking, deadlocks, and performance
• Experience analyzing existing systems, their logic, and dependencies between database and other components
• Knowledge of integration and data flow topics (ETL, API, SSIS, CDC or similar)
• Independence, good organization, communication skills, and English knowledge enabling work with technical documentation (B2)

Benefits

• Full-time contract of employment
• Annual bonus tied to goals
• Flexible working hours
• Hybrid work (mostly remote) with occasional office presence in Katowice
• Real impact on the development and architecture of a key CRM system
• Work with experienced specialists and knowledge sharing
• Interesting technical challenges related to performance, integrations, and data architecture
• Benefits package: medical care, sports card, language learning support, paid leave co-funding, periodic team integrations, and free parking