Nsi - SQL Server Architect / Dba - En

**Job description**:
To reinforce our teams, we are looking for a **SQL Server Architect/DBA** with a deep understanding of Oracle RDBMS speaking **English.**

**Your main responsibilities**:

- Supporting SQL Server components, including SSIS and SSRS
- Design, implement, and maintain SQL Server databases, ensuring optimal performance, reliability, and security.
- Maintaining and troubleshooting ETL (Extract, Transform and Load) processes.
- Design and implement migration to Amazon RDS for Microsoft SQL Server
- Develop and enforce database standards and best practices to ensure consistency across environments.
- Collaborate with software developers and system administrators to optimize database schema, queries, and performance.
- Troubleshoot and resolve database issues, including performance bottlenecks, connectivity problems, and data integrity issues.
- Perform database migrations, upgrades, and patches as needed, ensuring mínimal downtime and maximum data integrity.
- Design, implement and maintain database backup and recovery strategies to safeguard against data loss and minimize downtime in the event of system failures.
- Monitor database performance and resource utilization, proactively identifying and addressing potential issues before they impact users.
- Develop and maintain documentation for database configurations, procedures, and troubleshooting guides.
- Provide technical guidance and mentoring to junior members of the team.

**Job requirements**:
**Your profile**:

- 5+ years of experience as a SQL Server Architect/DBA, with a strong focus on database design, implementation, and optimization
- Proficiency in Oracle RDBMS, including database design, administration, and performance tuning
- In-depth understanding of SQL architecture; expert knowledge in SQL clustering and availability groups; good experience implementing operational automation through SQL tools and PowerShell
- Prior experience with replication topologies and components; experience in both OLTP and Data warehousing environments; proficient in using T-SQL, troubleshooting queries and stored procedures
- Previous experience with TDE encryption of databases as well as troubleshooting Kerberos issues; strong experience with Amazon SQL Server RDS (migration tasks is preferred); ability to provide coaching to developers
- Experience with cloud-based database solutions, such as Microsoft Azure SQL Database, Amazon SQL Server RDS, or Oracle Cloud
- In-depth knowledge of SQL Server features and capabilities, including stored procedures, triggers, indexes, and query optimization techniques
- Experience with database migration, replication, and high availability solutions such as clustering and AlwaysOn Availability Groups
- Familiarity with database security best practices, including role-based access control, encryption, and auditing
- Experience maintaining and troubleshooting ETL (Extract, Transform and Load) processes
- Experience in mentor IT staff and database design
- Experience in assessing and introducing new technologies to improve operation of database infrastructure
- Experience Amazon RDS for Microsoft SQL Server
- Experience as an Oracle RDBMS DBA on large deployments
- Microsoft Certified: SQL Server certification(s) (e.g., MCSA, MCSE) or equivalent
- EU citizenship
- Fluency in English (written and spoken) is required; proficiency in any other European language is a plus
- Strong problem-solving skills and the ability to troubleshoot complex database issues in a timely and efficient manner
- Excellent communication and collaboration skills, with the ability to work effectively in a team environment and interact with stakeholders at all levels of the organization

**_

**What is offered**:

- Take the opportunity to join our "NSI family", where human values remain at the heart of our priorities
- Permanent contract
- Training courses
- Dynamic and innovative environment
- Be in the position to open your career perspectives
- Competitive salary package

**_