SQL Server Architect

**Company Description**

As a **SQL Server Architect** (_M/F_), you will help migrate to new versions of SQL Server as well as Oracle RDBMS and ensure the availability and optimization of the current databases.

**Your main responsabilities**:

- 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
- Provide technical guidance and mentoring to junior members of the team

**Your profile**:

- 5+ years of experience as a SQL Server Architect/DBA, with a strong focus on database design, implementation, and optimization
- University degree is preferred
- Proficiency in Oracle RDBMS, including database design, administration, and performance tuning
- 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
- Microsoft Certified: SQL Server certification(s) (e.g., MCSA, MCSE) or equivalent
- Oracle Certified Professional (OCP) certification or equivalent is an asset
- Fluency in English (written and spoken) is required

**Additional Information** AR**Ƞ**S?**

Arηs is a fully **independent** group of companies specialized in managing complex **IT projects and systems** for **large organisations**, focusing on state-of-the-art software development, business intelligence and infrastructure services.

We are composed of 16 entities across 8 countries that are unified by the Arηs Group, with more than 2500 consultants.

This corporate structure enables us to respond quickly to market changes and customer requests, and to communicate and make decisions without layers of bureaucracy.

Our success can be attributed to the synergy among our nine complementary entities, combined with our methodologies, which are based on the Rational Unified Process (RUP) and the Scrum agile software development framework.

**_
Our Vision and Values_**

Our vision is to be the most caring and reliable IT company on the market place for both clients and our people.

Our values are**:caring, agility, excellence, innovation, continual improvement, and reliability**.

Our values support our vision by leveraging excellence, striving for results, ensuring commitment and promoting adaptability.

**_ Our Culture_**

We work in close partnership with our customers, turning their needs into benefits; We promote a dynamic local environment where both young and experience people can realize themselves; We leverage a flexible, independent and responsive organization.

**_ Our Brand_**

The ArȠs (pronounce [aris]) name comes from Greek Mythology. ArȠs is the son of Zeus and the God of War - in our eyes, an accurate representation of the intelligence, strategy, leadership and vision that are essential in business.

**Don’t hesitate Join our team**

**_ What you’ll get:_**

An **informal hierarchy **and work environment:
Our open, flat structure supports a strong focus on communication and collaboration, enabling to respond quickly to market changes and customer requests.

An **attractive salary package**:
With an attractive salary and benefits package - including advantageous fringe benefits - you’ll be paid for what you love to do.

A strong **corporate culture**:
You’ll join a **dynamic team **of smart and ambitious people. From the way we hire, to the way we relate to our clients - our values from the foundation of the way we work.

**Learning **& development opportunities:
We constantly **invest in our peo