Lorven Technologies
Senior SQL Developer
Lorven Technologies, New York, New York, us, 10261
Job Description:
Responsibilities:
Design and develop large-scale applicationsCollaborate to refine user requirements through test-driven development (TDD)Working on creating end-to-end pipeline to load data by reading from multiple sources and load to landing layer or SQL tablesAnalyze root causes of incidents and provide the solutionSQL Programming and DB administrationWorking on performance running in MSSQL \ Azure SQLMandatory Skills Description:
8+ years of experience in SQL programmingStrong experience in performance tuning and DBA activitiesExcellent understanding of relation transactional databases like MSSQL, Azure SQL and cloud-based frameworks like MS AzureExperience with Cloud platforms\tools (Azure is preferable)Nice-to-Have Skills Description:
Experience in TSQL (MSSQL/SYBASE) code development, performance tuning, query optimization and extensive batch or ETL creation experience with better error handling.Strong knowledge of Extraction Transformation and Loading (ETL) processes using frameworks like Azure Data Factory or Synapse or Databricks.
Responsibilities:
Design and develop large-scale applicationsCollaborate to refine user requirements through test-driven development (TDD)Working on creating end-to-end pipeline to load data by reading from multiple sources and load to landing layer or SQL tablesAnalyze root causes of incidents and provide the solutionSQL Programming and DB administrationWorking on performance running in MSSQL \ Azure SQLMandatory Skills Description:
8+ years of experience in SQL programmingStrong experience in performance tuning and DBA activitiesExcellent understanding of relation transactional databases like MSSQL, Azure SQL and cloud-based frameworks like MS AzureExperience with Cloud platforms\tools (Azure is preferable)Nice-to-Have Skills Description:
Experience in TSQL (MSSQL/SYBASE) code development, performance tuning, query optimization and extensive batch or ETL creation experience with better error handling.Strong knowledge of Extraction Transformation and Loading (ETL) processes using frameworks like Azure Data Factory or Synapse or Databricks.