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

Natixis in Portugal; Lisboa; Hybrid; EUR 45,000 - 75,000; Full time

Benefits offered by this job

Green Transportation Budget

Hybrid Work Policy

Job summary

Natixis in Portugal, a Centre of Expertise of Groupe BPCE, seeks an experienced SQL Server Database Administrator (DBA) to join the NIMOS perimeter. You will manage production databases on SQL Server post-2014 and Sybase ASE, ensuring performance, security, and high availability.

You will automate tasks with T-SQL and PowerShell, assist with migrations and cloud initiatives, and collaborate with infra, development, and BI teams. On-call and hybrid work are required.

Qualifications

• Experience with SQL Server post-2014 and Sybase ASE.
• Strong SQL, T-SQL, and scripting skills (PowerShell).
• On-call and incident handling experience preferred.

Responsibilities

• Administer SQL Server and Sybase databases in production.
• Plan and implement migrations, refreshes, and upgrades.
• Develop automation scripts in T-SQL and PowerShell.
• Monitor performance, optimize queries, and ensure HA (AlwaysOn, replications).
• Contribute to cloud projects (Azure/AWS) and BI tooling.
• Create and maintain operational documentation.

Skills

SQL Server

Sybase ASE

PowerShell

T-SQL

Performance tuning

Cloud databases

Tools

SSRS

SSIS

SSAS

PowerBI Server

Azure SQL Database

Polybase

Hadoop

Job description

Company Description

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.

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.

Job Description

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.

Qualifications

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)

Additional Information

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.