MS SQL Server Developer

• 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

Remote Work :

No

Employment Type :

Full-time