MS SQL Server Developer

Description

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.

Requirements

• 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 Services
• Key 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.
• Additional Information

Benefits

• 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 area
• What 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
• Company Description
• 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!