SQL Server Architect

  • Full-time

Company Description

 

 

Job 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:

  • Support SQL server applications
  • 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 minimal 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 with SQL server applications and supporting components, including SSIS and SSRS
  • 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 as a lead worker in a team of subject matter experts of varying capacities
  • 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 people and are committed to providing individual development opportunities to help you continue to grow and stay happy and satisfied at work.

Exciting projects:

You’ll take ownership of various projects for both public and private clients: calling for creativity and innovation, at the cutting-edge of technology.

rock solid company:

With more than 250 customers, and 25% turnover growth in FY2022, you’ll join a business with a sustainable and growth-oriented plan.

 

But let’s talk about it face to face!

 

You have the qualities as listed above? Please, apply & send us your CV, which will be processed in full confidentiality.

 

You don’t have all the above requirements but own a great part of them? You can send us your CV too because we will give you the opportunity to grow up with us.

Privacy Policy