Senior Database Developer
FLEXITI
Rosario, Santa Fe, Argentina
hace 11 horas

Senior Database Developer

Flexiti is looking for a resourceful person who will be responsible for end-to-end database design, development, testing, review, and implementation of code into existing databases for all levels of the Software Development Lifecycle.

Responsibilities

  • Analyze business, IT and data requirements, design the best possible data model and ETL processes, and implement data solutions (OLTP & OLAP) accordingly.
  • Develop and maintain extract, transform and load (ETL) jobs within an evolving enterprise data warehouse
  • Develop Advanced T-SQL such as temporal tables, PIVOTs, recursive table expressions, dynamic SQL as well as high complexity, fast performing SELECT queries, T-SQL procedures, functions, triggers, views, jobs, scripts to support data operations and DW users.
  • Optimize SQL statements executed by end users / ETL code as required; Test and troubleshoot ETL job functionality, validate database objects and structures through use of SQL and other means
  • Collaborates with analytics and business teams to improve data models that feed business intelligence tools
  • Assist DBAs in managing indexes, statistics, query plans, alerts, database activity and overall performance activity
  • Create and monitor fault tolerant database jobs across hundreds of integration points
  • Identify root causes of data integrity issues and ability to eliminate them
  • Qualifications

  • 4 years of experience in Database developer
  • Knowledge of MSSQL, MongoDB, SOAP / XML, REST / JSON
  • Expert understanding of ETL and ETL and hands on experience with SSIS, SSRS (development and some admin experience)
  • Hands on Experience with data modeling (OLTP and OLAP) using Erwin, Visio or similar tools
  • Experience in all aspects of SDLC
  • Experience with version control software (ideally bitbucket)
  • Working knowledge of AWS Cloud (RDS)
  • Java and python experience are an asset
  • Familiarity with ad-hoc file transfer solution / s, such as FTP, HTTP
  • Experience with modeling Power BI data modeling, designing dashboards is desirable
  • Financial services experience is an asset
  • Benefits at the company

  • Competitive salary in CAD (Canadian dollars)
  • Health plan for all the family (OSDE)
  • Gym allowance
  • Join the team!

    Reportar esta oferta
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Inscribirse
    Mi Correo Electrónico
    Al hacer clic en la opción "Continuar", doy mi consentimiento para que neuvoo procese mis datos de conformidad con lo establecido en su Política de privacidad . Puedo darme de baja o retirar mi autorización en cualquier momento.
    Continuar
    Formulario de postulación