About this role
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 English7+ 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 impactExposure to modern technologies and cloud-based architectureCross-border collaboration with teams in CER countriesA supportive and agile working environmentOpportunities 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