MS SQL Server Developer

Job 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.

Qualifications

• 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

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 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