Created in 2015 in a technology disruption group, Powertalent is a Portuguese company specializing in TI projects.
Our experience allows us to succeed where others fail. We offer consulting solutions tailored to your real needs, we perform cyber security assessments and diagnostics and design with you the best solution. Additionally, and taking advantage of our country's strengths, such as our climate, gastronomy, and security, we provide nearshoring services, enhancing your growth. If you prefer, we also offer the service, a turnkey project, so you don't have to worry about anything else.
We are a company of people, for people!
Created in 2015 in a technology disruption group, Powertalent is a Portuguese company specializing in TI projects.
Our experience allows us to succeed where others fail. We offer consulting solutions tailored to your real needs, we perform cyber security assessments and diagnostics and design with you the best solution. Additionally, and taking advantage of our country's strengths, such as our climate, gastronomy, and security, we provide nearshoring services, enhancing your growth. If you prefer, we also offer the service, a turnkey project, so you don't have to worry about anything else.
We are a company of people, for people!
About the Job:
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
Requirements
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, Tunig Adviser, Query Store, Profiler, and third-party tools.
The level of English should be at least B2
Benefits
Food subsidy
Health insurance
Hybrid Work
Continuing education and professional development
#J-18808-Ljbffr