{"jobAd":{"id":"18868","type":"job_ad","attributes":{"title":"Senior Database Administrator MSSQL (SQL Server)","state":10,"state_name":"published","office_cities":["Lisbon"],"location":"Lisbon, Portugal","closed_at":null,"created_at":"2024-10-23T14:12:59.449Z","company_id":120,"updated_at":"2025-01-21T09:53:08.570Z","last_published_at":"2024-10-23T14:13:06.852Z","office_country_codes":["PT"],"relocation_paid":false,"visa_support":false,"citizenship":true,"remote_details":"Our team works at the office 2 days/week","slug":"senior-database-administrator-mssql-sql-server","project_duration":null,"location_icon":"hybridRemote","office_locations":[{"city":"Lisbon","country_code":"PT","google_place_id":"ChIJO_PkYRozGQ0R0DaQ5L3rAAQ","label":"Lisbon, Portugal"}],"timezone_label":null,"status_label":"Published","expires_days":null,"urls":null,"share_urls":null,"job_has_ats_offer":null,"company_has_ats":null,"country":"Portugal","waiting_counter":null,"inbox_counter":null,"review_counter":null,"waiting_new_counter":null,"inbox_new_counter":null,"review_new_counter":null,"status_color_class":"ld-status-color u-fill--puertoRico ","valid":null,"job_type":"Permanent","contractor":false,"permanent":true,"allows_remote":false,"rate":null,"salary":null,"experience_label":"Senior","experience_min":5,"experience_max":null,"preferred_language_label":"Portuguese","nice_to_have_language_label":"English","category":"Maintenance & Support","remote_working_label":"Hybrid","is_global_remote":false,"role_description":"

We're fast learners, hard workers, natural collaborators... and we Make Modern Happen!

Our 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.

","perks":"

We offer:

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

","must_have_skills":[{"id":62467,"name":"MSSQL"},{"id":766,"name":"T-SQL"},{"id":480,"name":"SQL Server"}],"other_required_skills":[{"id":2542,"name":"DBA"}],"nice_to_have_skills":[{"id":62777,"name":"IT Infrastructure"}],"referral_value":300,"referral_string":"€300","top_related_offers":[{"id":18867,"title":"DBA MSSQL (SQL Server)","company_name":"IT Service Management Company"},{"id":18970,"title":"Sage X3 ERP Consultant","company_name":"Distribuition Company"},{"id":18552,"title":"Technical Consultant (Mid/Senior Level)","company_name":"IT Service Management Company"},{"id":18911,"title":"Application Manager","company_name":"Decskill"}],"min_timezone":null,"max_timezone":null,"hiring_bonus":null,"company_name":"Claranet"}},"bookmark":null,"handshake":null,"jobSuggestion":null,"referralId":null,"cancelReasons":["I got a more interesting proposal.","I got second feelings and I'm backing down","I just felt that Claranet and I didn't connect.","I was never contacted.","Got tired of waiting for a final decision.","Claranet conditions weren't good enough.","Other"],"jobSearchFiltersAb":null}

Senior Database Administrator MSSQL (SQL Server) at Claranet

MSSQL

T-SQL

SQL Server

Job at Claranet in ["Lisbon"]