Pular para o conteúdo principal

Sênior SQL/Python (4807)

Tecnologia
Keep Simple
Remoto, BrasilHá 1 mês
100% Remoto

Descrição da vaga

Come work for a large global financial and insurance products company! This is your chance !!

Start a successful career in a renowned company in the international market! Great opportunity!

Global insurance and asset management company seeks a responsible, organized, dynamic and team-oriented person.

Responsabilidades e atribuições

Key Responsibilities:

  • Development and support of code on SSIS and write new code on Python for Klondike teams.
Requisitos e qualificações

Required Qualifications / Skills:

  • Database: MS SQL, Azure,AWS;
  • Tools : SSIS, SSRS, AI Tools;
  • Languages: SQL, T-SQL,Python;
  • Desired Experience Range 5+ years.
Data Development (Must have) :
  • SQL Server 2017/2019/2022 DBA/Developer 5+ years;
  • Strong development background in SQLserver and some SSIS ,stored procedures, Python - this is mostly a development role;
  • AWS/Azure Cloud experience considered a plus;
  • Work with operational and data warehouse systems;
  • Strong communication skills;
  • Self-Starter and flexibility with work hours and work direction;
  • Experience with AI code generators for PowerShell and SQL ,oracle databases considered a plus.
Data Development - SQL Server Developer with extensive familiarity with data management principles including:
  • Development of high quality database solutions;
  • Develop, implement and optimize stored procedures and functions using T-SQL;
  • Understand data dimensional models;
  • Write or troubleshoot Stored Procedures, Functions, Views, Triggers etc;
  • Review and interpret ongoing business report requirements;
  • Research required data;
  • Build appropriate and useful reporting deliverables;
  • Analyze existing SQL queries for performance improvements;
  • Suggest new queries;
  • Develop procedures and scripts for data migration;
  • Provide timely scheduled management reporting;
  • Investigate exceptions with regard to asset movements.
Development and QA Support -
  • Detailed knowledge of T-SQL, SSIS packages and knowledge of SQL Server Reporting Services;
  • Experience with Python coding;
  • Develop and analyze SQL Server Code objects such as Stored Proc, View, Function , Trigger etc and identify defects and recommend for performance tuning;
  • Experience of Transactional SQL, and SSIS Package;
  • Code version management, Code deployment to various databases.
Problem-solving skills – SQL Server Developer should be skilled creative and technical problem-solvers, able to isolate and resolve database issues in real time to maintain access and data integrity.

Communication Skills:

  • Respond to issues in timely manner, clearly elaborate problem and propose solution;
  • Communicate with application teams, listen and respond to their queries and concerns.
Knowledge to additional technologies (Good to Have):
  • AWS exposure (S3, RDS, EC2);
  • Oracle PL/SQL;
  • Informatica Development;
  • Workload automation;
  • Service Now and Change Management Process.
Informações adicionais

Modelo de contratação:

  • PJ.
Forma de atuação:
  • 100% Remoto.
Somos uma empresa de consultoria em TI com mais de 10 anos no mercado e contamos com um time de especialistas em recrutamento tech. Nosso processo é 100% focado na experiência de quem tanto importa, o candidato. Optamos por fazer a diferença e temos orgulho em dizer que todos que passam pela Keep Simple se sentem especiais. Possuímos um ambiente descontraído, colaborativo, e adotamos o ágil de verdade.

Faça parte da nossa história, #vemprakeep

Keywords
sqlpythoninsurance-productsasset-managementtraining-and-developmentmicrosoft-azureamazon-web-servicesartificial-intelligencedata-warehousehours-of-workpowershelloracledata-managementdatabase-solutionstroubleshootingreporting-and-disclosureadaptive-project-management-and-reportingdatabase-migration-and-conversiondata-migrationmanagement-reporting

Tem interesse nesta vaga?