SQL Server DBA (French Speaker) | IT CIB & AWM

Natixis in Portugal is a Centre of Expertise whose mission is to transform traditional banking by developing innovative solutions for the business, operations and work culture of Groupe BPCE worldwide.

As part of Groupe BPCE’s international division, Natixis in Portugal designs and delivers solutions for its two core areas – Corporate & Investment Banking and Asset & Wealth Management – as well as transversal services that support all entities across the Group.

With more than 3,000 employees representing 46 nationalities, the teams work across Information Technology, Banking Support Activities, and Compliance, in an integrated, inclusive, and cross-functional way, supporting all business lines and platforms of the Group.

A disruptive mindset and a culture of proximity and agility identify Natixis in Portugal Team and reflect the company's mission to transform traditional banking at a global scale: a perfect match in the Portuguese dynamics and entrepreneurial ecosystem.

NATIXIS is seeking an experienced and skilled SQL Server Database Administrator (DBA) with strong knowledge of SQL Server to join our NIMOS perimeter team. In this role, you will be responsible for the administration, maintenance, and optimization of our multi-SGBD environment, with a primary focus on SQL Server versions post-2014 and Sybase ASE. You will play a crucial part in ensuring the stability, performance, and availability of our production databases, as well as contributing to strategic migration and cloud initiatives.

Key Responsibilities:

• SQL Server Administration: Manage and administer SQL Server platforms (versions > 2014).
• Platform Refresh & Migration: Oversee SQL Server platform refreshes, including infrastructure and version upgrades.
• Scripting & Development: Develop and maintain T-SQL and PowerShell scripts for automation, administration, and utility purposes.
• Performance Tuning & Optimization: Conduct performance analysis, tune SGBDs, support development teams in rewriting suboptimal code, contribute to database modeling, and proactively propose performance improvements.
• High Availability: Implement and manage high availability solutions, including AlwaysON and Transactional Replication.
• Database Auditing & Maintenance: Perform regular audits of SQL Server databases and maintain the operational readiness of SGBDs within the NIMOS perimeter.
• Production Monitoring: Supervise production SGBDs within the NIMOS perimeter (SQL Server and Sybase).
• Incident & User Support: Respond to and resolve incidents and user support requests related to databases.
• Crisis Management: Participate in crisis management "cellules" (war rooms).
• Change Management: Control and deliver database structure modifications.
• Cross-Functional Knowledge: Leverage and apply knowledge of infrastructure, networking, and SGBD architecture.
• MS BI Tools Administration: Administer and tune third-party Microsoft tools such as SSRS, PowerBI Server, SSIS, and SSAS.
• Release Management: Handle and process requests for Production deployments.
• Intervention Management: Respond to intervention requests across various SGBD technologies.
• Installation & Optimization: Install, administer, and optimize SGBD servers, including performance analysis.
• Query Optimization Assistance: Assist development teams in reviewing and optimizing SQL queries and stored procedures.
• Continuity & Availability: Participate in continuity and availability exercises and maintain associated procedures.
• Documentation: Create and maintain operational documentation for databases.
• Technology Watch & Projects: Participate in technology watch initiatives, exploring new features in SQL Server 2022-2025 and interfacing with technologies like Polybase and Hadoop.
• Cloud Database Projects: Contribute to database projects on cloud platforms such as Azure (SQL Server, Analysis Services, PowerBI), AWS, and GCP.
• Security Compliance: Apply NATIXIS's general security policy.

On-Call & Shift Work:

• This role requires on-call availability and may involve staggered working hours.

Desirable Skills:

• Experience with .NET development (C#, Angular, Rust) is a plus, particularly for evolving monitoring tools and web platforms.

Environment:

• Perimeter: NIMOS
• SGBDs: Multi-SGBD environment, predominantly SQL Server with Sybase present.

Languages:

• French (B2/C1)
• English (B2/C1)

Our workplace reflects the vibrant spirit of our locations, with initiatives such as a Green Transportation Budget, electric bikes and a flexible Hybrid Work Policy. We promote wellbeing through the Honolulu Wellness Club, a Prayer Room, a Lactation Room, and themed Villages that inspire creativity and collaboration. Through our ESG and DEI strategies, we are committed to being inclusive, caring, and fair, ensuring every voice is heard and valued.