Database Developer - 11938

MSI -

Dania Beach, FL, United States

1 day ago

Apply on www.disabledperson.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

3 years minimum

Working hours

Regular working hours

Languages

English

Job source

www.disabledperson.com

Tech stack

Microsoft Azure Business Intelligence Development Databases Data as a Services Data Architecture Data Integration Extract Transform Load (ETL) Relational Databases Database Design Database Security Disaster Recovery Document-Oriented Databases

+20 more

Python (Programming Language) Machine Learning Microsoft SQL Server SQL Azure Performance Tuning Windows PowerShell Query Optimization Power BI SQL Stored Procedures SQL Server Reporting Services SQL Server Integration Services Data Streaming Transact-SQL Azure Data Factory Snowflake Database Performance Indexer Azure Synapse Analytics Data Pipelines Serverless Computing

Job description

Reporting to the Vice President of Data Architecture and Machine Learning, you will work inside an existing, live Azure data estate, modifying stored procedures and schemas across multiple databases and maintaining the data integration processes that support reporting, transactional systems, and downstream analytics across the organization., * Design, develop, and maintain relational databases, schemas, and objects on Microsoft SQL Server and Azure SQL Database

Write, optimize, and troubleshoot complex T-SQL queries, stored procedures, functions, views, and triggers
Build and maintain ETL/ELT processes using SQL Server Integration Services (SSIS) and/or Azure Data Factory to move and transform data across systems
Maintain and occasionally extend a small number of Azure Functions used in data movement and integration
Develop scripts and automation (PowerShell, Python) for ETL, database maintenance, deployments, and monitoring tasks
Tune, and troubleshoot database performance, including indexing strategy, query plans, and resource utilization
Support database security, backup/recovery, and disaster recovery procedures in line with enterprise policy
Build and maintain reports and dashboards using SQL Server Reporting Services (SSRS) and Power BI, including data model and DAX support for BI developers
Document database designs, data flows, and standard operating procedures
Other duties as assigned.

Requirements

3+ years of experience developing and administering Microsoft SQL Server databases in a production environment
Build ETL/ELT pipelines using SSIS and Azure Data Factory, including feeds supporting marketing, personalization, and customer analytics platforms
Experience with SSIS, SSRS, and/or Azure Data Factory for data integration and reporting
Experience automating database tasks using PowerShell and/or Python
Experience with Azure SQL Database, Azure Synapse, or other Microsoft Azure data services
Strong proficiency in T-SQL, including query optimization and performance tuning
Working familiarity with Power BI (data modeling, DAX, report/dashboard development)
Working knowledge of data modeling, normalization, and database design best practices
Snowflake experience a plus
Retail or eCommerce data experience a plus
Must be able to read, write, and speak English fluently