Senior DBA MSSQL

2 meses atrás

Lisbon, Portugal Landing.jobs Tempo inteiro
At Claranet (Permanent), in Lisbon, Portugal
Expires at: 2024-11-27
Remote policy: Partial remote

We're fast learners, hard workers, natural collaborators... and we Make Modern HappenOur ambition is to unlock the potential of our digital world so that organisations everywhere can innovate and thrive securely.We aim to achieve this goal by bringing together the world’s most talented people and the most powerful technologies, combining them to address our customers' challenges and to build something stronger together.If you share our vision, join us

Right now, we are looking for a Database Administrator to integrate our internal team, based in Lisbon.

Your responsibilities include:

  • Database Migration: Perform database migration to new versions of SQL Server, ensuring data integrity and minimizing downtime;
  • Problem Analysis: Diagnose and troubleshoot issues related to database performance, availability, and integrity. Performance Optimization (Tuning): Implement performance optimization techniques, including analyzing SQL queries, tuning indexes, and configuring the environment to maximize performance;
  • Good knowledge in Transact-SQL (T-SQL): To review and optimize queries and stored procedures, Function using T-SQL to respond to internal needs;
  • Always On Cluster Configuration and Management: Configure and manage high availability and critical environments using SQL Server's Always On functionality, ensuring redundancy and disaster recovery;
  • Proactive Monitoring and Maintenance: Perform continuous monitoring of the SQL Server environment, proactively identifying and resolving potential issues before they affect customers' systems;
  • Documentation: Document processes, configurations and changes made in the Database environment, ensuring identification and easy interpretation by other team members;
  • Team Collaboration: Work together with the other team members in a collaborative way, ensuring that Database needs are answered efficiently and securely:
  • Experience in migration of Integration Services Packages and Reporting Services Reports: Perform migrations of SQL Server Integration Services (SSIS) packages and SQL Server Reporting Services (SSRS) Reports, ensuring continuity of ETL processes and respective reports, ensuring compatibility and performance in new environments
Main requirements

You must have:

  • Proven experience in SQL Server technologies: Solid experience in the administration of SQL Server databases, including recent versions and new features;
  • Knowledge in Data Migration: Proven experience in migrating databases to new versions of SQL Server, with emphasis on planning, execution and validation;
  • Tuning and Performance Skills: Experience in performance tuning, including analysis and optimization of queries, indexes and infrastructure;
  • Proficiency in T-SQL: Strong knowledge and experience in writing and optimizing complex queries using Transact-SQL;
  • Experience with Always On: Experience in configuring, maintaining and troubleshooting high availability environments with Always On;
  • Problem Solving: Analytical ability to diagnose complex database problems and propose effective solutions;
  • Proactivity: Ability to identify and anticipate problems and opportunities for improvement, taking initiative to solve them independently;
  • SQL Server Certifications (Required): DP-300 and DP-900;
  • Knowledge of Monitoring Tools: Experience with monitoring and management tools for DB's, Tunnig Adviser, Query Store, Profiler, and third-party tools.
Nice to have

We value:
  • Effective Communication: Excellent communication skills to collaborate with different teams and document processes clearly and accurately;
  • Knowledge of Monitoring Tools: Experience with Database monitoring and management tools, Tunnig Adviser, Query Store, Profiler, and third-party tools;
  • Desirable Differentials: Knowledge in ServiceNow for incident and change management, Zabbix and Grafana for infrastructure monitoring, and Microsoft Azure for integration and management in Cloud environments;
  • Experience in database architecture design, transaction control, capacity planning and process automation are significant differentiators;
  • Ability to implement Microsoft-recommended best practices to ensure a secure, efficient, and compliant SQL Server environment with IT guidelines.
Benefits & Perks

We offer:
  • Regular professional development;
  • Health insurance, with family package;
  • Office facilities for meals and snacks;
  • Regular teambuilding programs;
  • Friendly workplace.

  • Senior Cloud DBA

    2 meses atrás

    Lisbon, Portugal Kinsei Talent Tempo inteiro

    Would you like to relocate to sunny Marbella/ Spain?Our client is at the forefront of developing the next generation of generative AI tools for the finance industry and beyond. With 20 years of experience as a leading big data analytics provider for financial services, we empower our clients—including some of the world's most successful hedge funds, banks,...

  • DBA MSSQL

    Há 1 mês

    Lisbon, Portugal Landing.jobs Tempo inteiro

    At IT Service Management Company (Contractor), in Lisboa, Portugal Expires at: 2025-06-19 Remote policy: Partial remoteRight now, we are looking for aDatabase Administratorto integrate our internal team, based in Lisbon. Your responsibilities include:Database Migration: Perform database migration to new versions of SQL Server, ensuring data integrity and...

  • DBA MSSQL

    2 meses atrás

    Lisbon, Portugal Landing.jobs Tempo inteiro

    At IT Service Management Company (Contractor), in Lisboa, PortugalExpires at: 2025-06-19Remote policy: Partial remoteRight now, we are looking for a Database Administrator to integrate our internal team, based in Lisbon.Your responsibilities include:Database Migration: Perform database migration to new versions of SQL Server, ensuring data integrity and...

  • Senior Backend Developer

    4 meses atrás

    Lisbon, Portugal ALTER SOLUTIONS Tempo inteiro

    Company Description Alter Solutions Portugal is an IT Consultancy Company, promoter of Digital Transformation, part of the Alter Solutions Group, created in 2006, in Paris. In 2022, Alter Solutions joined the act digital group, constituting a global community of talent in Technology, with presence in twelve countries: Germany, Belgium, Brazil, Canada,...

  • Senior PHP Laravel

    4 semanas atrás

    Lisbon, Portugal Alter Solutions Tempo inteiro

    Job DescriptionJob description:Responsibilities:Mentor and Tech coach a PHP Backend Development Team on Product Development and Maintenance activities.Design, develop, and maintain backend services and web applications using PHP, Laravel, Eloquent, GraphQL and MSSQL DB Design and Model.Implement GraphQL for efficient data querying and manipulation.Create...

  • Senior .Net Developer

    4 semanas atrás

    Lisbon, Portugal Pertemps ERP Tempo inteiro

    This is an exciting opportunity for an experienced .Net Developer to join an international company in Lisbon to work on innovative projects, using Microservice Architecture.TasksDevelop, test, and maintain high-quality software solutions using .Net technologies: .NET (C#), MSSQL, Angular/React, Postgres, and Kafka.Develop and enhance products using...

  • Senior PHP Laravel

    4 semanas atrás

    Lisbon, Portugal ALTER SOLUTIONS Tempo inteiro

    Company Description Alter Solutions Portugal is an IT Consultancy Company, promoter of Digital Transformation, part of the Alter Solutions Group, created in 2006, in Paris. In 2022, Alter Solutions joined the act digital group, constituting a global community of talent in Technology, with presence in twelve countries: Germany, Belgium, Brazil, Canada,...

  • Head of Development

    7 meses atrás

    Lisbon, Portugal Eurofins Tempo inteiro

    Job Description Eurofins endeavours to develop all of our software applications in-house to service and support our numerous laboratories globally. With hundreds of thousands of clinical diagnostic tests performed every day, the laboratories of the Eurofins clinical diagnostic services business line strive to ensure that every patient, wherever he or...