T
Destaque

Database developer (Remote)/12 Months

Tricehealthcarevia Lensa
RemotoSan Diego, California, UsPlenoCLT2 dias atrás

Salário Estimado

R$ 7.128,00 - R$ 10.692,00

Tecnologias

0de 100

Excelente

Score da Vaga

Descrição da Vaga

Title: Database developer Duration: 12 Months Location: San Diego,CA, 92121 (Remote) Job Description The Software Technology Solutions department is responsible for developing and maintaining on-premise and hosted software solutions that provide integration, reporting, and analytics capabilities for the company's portfolio of products.


Using industry best practices, the department is responsible for delivering high-quality, robust software applications that meet present and future requirements.


Database developer • The database developer is responsible for the design and development of database objects and procedural code to support various products for the organization.


The database developer also creates programs to populate and maintain the data in the department's transaction processing and data warehousing systems.


This involves the creation of ETL programs along with the supporting stored procedures, functions, triggers, and constraints.


The position requires extensive hands-on experience developing database queries, ETL, and associated code in a Microsoft SQL Server environment.


III.


Specific Duties, Activities, and Responsibilities • Understand and apply database design and development principles for both transactional and dimensional schemas to support application requirements.

Design, plan, and develop programs to optimally extract, transform, and load data from data sources to the target systems. • Maintain source code for database and ETL projects.

Ensure that projects build successfully in a continuous integration environment. • Diagnose and resolve database performance issues.

Follow and improve development processes including but not limited to conducting peer/code reviews, complying with organizational standards, ensuring code maintainability, following build processes, implementing unit tests, and following other industry standards best practices. • Experience with automatic code deployment (Octopus) tool is a plus Education or Equivalent
BS in Computer Science or Information Systems Experience or Equivalent • 9+ years of experience working with Microsoft SQL Server with emphasis on database code development.
V.

Knowledge, Skills, and Abilities Requirements • Data modeling tools such as ER/Studio or ERWin

Database design skills including normalization and data warehouse design • T-SQL development skills including stored procedure, function, and trigger creation
Excellent query optimization and performance tuning skills • Strong SSIS skills
Detailed analytical skills • Structured troubleshooting skills
Experience in the healthcare industry is a plus VI.

Toolset • Microsoft SQL Server 2014 and above

Microsoft SQL Server Integration Services (SSIS) • Microsoft Visual Studio 2014 and above
Microsoft SQL Server 2014 to 2019 migration experience is a plus • Embarcadero ER/Studio is a plus
Microsoft SQL Server Reporting Services (SSRS) is a plus • Experience with automatic code deployment tools (Octopus) is a plus VII.

Physical/Mental Requirements • Ability to communicate clearly both verbally and in writing.

Ability to analyze complex application and business operational issues.

VIII.


Any Additional/Important Information • The database developer will be additionally be responsible for the following tasks:

Analyzing requirements to create software designs • Estimation and timely completion of tasks
Documenting developed modules • Supporting application developers and software testers
Creating and executing unit tests for developed code • Following quality assurance processes

Requisitos

  • The position requires extensive hands-on experience developing database queries, ETL, and associated code in a Microsoft SQL Server environment
  • Education or Equivalent
  • BS in Computer Science or Information Systems
  • Experience or Equivalent
  • 9+ years of experience working with Microsoft SQL Server with emphasis on database code development
  • Data modeling tools such as ER/Studio or ERWin
  • Database design skills including normalization and data warehouse design
  • T-SQL development skills including stored procedure, function, and trigger creation
  • Excellent query optimization and performance tuning skills
  • Strong SSIS skills
  • Detailed analytical skills
  • Structured troubleshooting skills
  • Microsoft SQL Server 2014 and above
  • Microsoft SQL Server Integration Services (SSIS)
  • Microsoft Visual Studio 2014 and above
  • Ability to communicate clearly both verbally and in writing
  • Ability to analyze complex application and business operational issues

Responsabilidades

  • The database developer is responsible for the design and development of database objects and procedural code to support various products for the organization
  • The database developer also creates programs to populate and maintain the data in the department's transaction processing and data warehousing systems
  • This involves the creation of ETL programs along with the supporting stored procedures, functions, triggers, and constraints
  • Understand and apply database design and development principles for both transactional and dimensional schemas to support application requirements
  • Design, plan, and develop programs to optimally extract, transform, and load data from data sources to the target systems
  • Maintain source code for database and ETL projects
  • Ensure that projects build successfully in a continuous integration environment
  • Diagnose and resolve database performance issues
  • Follow and improve development processes including but not limited to conducting peer/code reviews, complying with organizational standards, ensuring code maintainability, following build processes, implementing unit tests, and following other industry standards best practices
  • Analyzing requirements to create software designs
  • Estimation and timely completion of tasks
  • Documenting developed modules
  • Supporting application developers and software testers
  • Creating and executing unit tests for developed code

Vagas Semelhantes

R$ 7k - 11k/mês

PlenoCLT

• *Sobre Nós** O Estúdio Oggi é uma agência de marketing 360 que desenvolve soluções integrando Inteligência Artificial, automação, branding e performance. Estamos em busca de um estagiário interessado em atuar com projetos de IA aplicados a marketing e negócios. Procuramos alguém com perfil analíti...

Logo Instituto Nacional de Telecomunicações - Inatel

PDI SW - Pessoa Líder Técnica III (Inteligência Artificial)

Instituto Nacional de Telecomunicações - InatelGupy
RemotoBrHoje

R$ 8k - 12k/mês

PlenoCLT

Descrição da vaga O Inatel está recrutando Especialista para atuar na liderança técnica de projetos de Inteligência Artificial, Machine Learning e Data Science no Inatel Competence Center - PDI SW. Responsabilidades e atribuições • Definir a estratégia técnica do projeto, desenvolver e comunicando u...

RemotoBrHoje

R$ 7k - 11k/mês

PlenoCLT

This a Full Remote job, the offer is available from: Brazil The role: We are looking for highly talented and driven software engineers who take pride in their work, to expand our Engineering team in Brazil. Successful candidates will join a cross functional team including product managers and design...

RemotoBrHoje

R$ 7k - 11k/mês

PlenoCLT

Nossa missão aqui na Mundiale é simplificar a relação entre marcas e seus consumidores, proporcionando interações mais humanas, assertivas e fluidas, por meio de tecnologia de ponta e uma metodologia própria. E para isso, buscamos muita gente fera para se juntar ao nosso time de Munders e viver, a c...

Interessado nesta vaga?

Candidatar-se

Você será redirecionado para o site original

Informações

NívelPleno
ContratoCLT
LocalSan Diego, California, Us
RemotoSim
MoedaBRL
Publicada2 dias atrás
FonteLensa

Análise de Vaga com IA

Estimativa salarial, match de tecnologias e análise de requisitos feitos com Inteligência Artificial

Powered by CodeCortex
← Voltar às Vagas