Division: Group Technology Services (GTS)
Short description:
As a global critical financial infrastructure, the protection of Euroclear’s information and assets is essential to our business. Security is at the core of our services and is deeply embedded in our management systems and processes.
You will join our Group Technology Services (GTS) division as a member of the Patch Orchestration Team (Vulture Team). In this role, you will play a key part in protecting our digital assets by reporting and coordinating remediation activities for identified vulnerabilities and weaknesses across a wide range of IT technologies. This proactive approach helps us stay ahead of potential cyber threats and continuously strengthen our defenses.
We are looking for a motivated Microsoft SQL Server Database Specialist to manage the Patch Orchestration Database system. This system consolidates information on detected vulnerabilities and weaknesses to support remediation efforts.
Responsibilities:
Data Logic & SQL Development:
1. Design, develop, and optimize complex SQL queries, stored procedures, and views to support security reporting and dashboards.
2. Build data models and logic that align vulnerability findings with the correct asset and owner.
3. Improve attribution accuracy by enhancing business logic and mapping tables.
SQL Server Management:
4. Maintain, monitor, and optimize SQL Server environments.
5. Apply indexing strategies, query tuning, and performance monitoring.
6. Ensure adherence to database security, backup, and recovery policies.
Reporting & Data Support:
7. Collaborate with cybersecurity analysts to understand data and reporting needs.
8. Deliver well-structured datasets for Power BI dashboards and Excel reports.
9. Support troubleshooting of data quality, report accuracy, and dashboard performance.
Version Control & Change Management:
10. Use version control tools (., Git) to manage SQL scripts, procedures, and schemas.
11. Document changes to database logic, schema updates, and data processing pipelines.
12. Follow structured change management practices for production deployments.
Collaboration & Continuous Improvement:
13. Act as a liaison between security, data, and IT infrastructure teams.
14. Participate in data validation and cross-team debugging.
15. Recommend improvements to data models, architecture, and automation processes.
Requirements:
Technical Skills:
16. Advanced proficiency in writing and optimizing complex SQL queries and stored procedures.
17. Experience managing Microsoft SQL Server, including performance tuning and job scheduling.
18. Proficiency in PowerShell scripting for SQL data normalization, joins, and transformation logic.
19. Experience using Git or similar version control systems for managing SQL code.
20. Strong focus on data integrity, completeness, and consistency.
21. Familiarity with vulnerability management data (., CVEs, CVSS, asset mapping) or experience supporting cybersecurity teams is a plus.
22. Knowledge of Power BI data modeling or support experience is a plus.
Soft Skills:
23. Strong problem-solving skills and the ability to independently resolve data issues.
24. Effective collaboration with both technical and non-technical stakeholders.
25. Ability to manage multiple priorities and deadlines in a dynamic environment.
#LI-AK2