MS SQL Server Developer

At Coface, we make trade happen everyday. Our 5,200 experts representing 80+ nationalities in 58 countries are united by a shared purpose: helping companies navigate through uncertainty by empowering them to make the right decisions and trade smarter in a complex world. With nearly 80 years of global experience, we offer companies a full range of solutions: Trade Credit Insurance, Business Information, Debt Collection, SingleRisk insurance, Surety Bonds, Factoring — all driven by a unique data patrimony, cutting-edge technology, innovation and a deep understanding of the global economy. Joining Coface means being part of a close-knit international organization, where your ideas matter.  We foster a culture of learning, collaboration and inclusion where you are given responsibilities and can see the impact of your actions. Shape the future of trade with us. Join our Happeners! - Design, develop, maintain, and optimize Microsoft SQL Server data warehouses and data marts. - Proactively monitor Microsoft SQL Server workloads, query performance, blocking, resource utilization and database health. - Analyze complex SQL queries, execution plans, indexing strategies, partitioning schemes and workload patterns to identify optimization opportunities. - Review existing data processing, integration and operational flows to identify inefficiencies and propose technical and operational improvements. Design and implement database refactoring initiatives to improve scalability, maintainability, and performance. - Develop and maintain ETL processes and data integration solutions. - Implement and support Change Data Capture (CDC) and other data synchronization mechanisms. - Create and maintain technical documentation, data models and database standards. - Collaborate with business analysts, developers and infrastructure teams to design effective data solutions. - Provide production support and root cause analysis for database-related incidents and performance issues. - Proactively review Microsoft SQL Server workloads, execution plans, wait statistics and performance metrics, providing recommendations and implementing improvements to enhance overall platform efficiency.  - BS/MS degree in Computer Science or related discipline. - Strong Oral and Written Communication in English - 7+ years of experience with Microsoft SQL Server. - Strong expertise in SQL development and performance tuning. - Proven experience analyzing query execution plans and optimizing SQL workloads. - Strong knowledge of Microsoft SQL Server internals, indexing, statistics management, locking, blocking and transaction management. - Strong understanding of data warehouse concepts, dimensional modeling and data architecture. - Experience designing and refactoring database models to improve performance and maintainability. - Hands-on experience with SQL Server Integration Services (SSIS). - Experience working with Power BI. - Strong analytical and problem-solving skills. - Familiarity with Jira and Agile delivery methodologies. - Nice to know : SSAS  - SQL Server Analysis ServicesKey Competencies - Strong analytical and troubleshooting skills. - Ability to investigate complex data flows and identify optimization opportunities. - Proactive mindset with a focus on continuous improvement. - Ability to estimate effort, prioritize tasks and deliver high-quality solutions. - Ability to challenge existing technical designs and propose practical improvements. - Strong performance-oriented mindset with a focus on scalability, reliability and maintainability. What We Offer - Involvement in a strategic, innovation-focused project with strong business impact - Exposure to modern technologies and cloud-based architecture - Cross-border collaboration with teams in CER countries - A supportive and agile working environment - Opportunities for growth and development in a fast-paced, high-impact areaWhat is it like to work at Coface?  This is a hybrid role based in our Bucharest office. We encourage our employees to take care of themselves with things like short Fridays, private healthcare, vouchers – meal, vacation, gift, and more