SQL Developer

Overview :. The SQL Developer is responsible for ensuring the design, development and maintenance of the enterprise data warehouse. This includes designing integration solutions, reporting solutions and supporting .Net Developers. The SQL Developer will also be responsible for the maintenance, tuning, and backup of each database and/or server

Roles & Responsibilities :. Designs, analyzes code, optimizes and maintains Microsoft SQL Server databases, tables, stored procedures, indexes, triggers, data extraction, transformation, and validation

The ability to develop SSIS packages to address complex business needs as well as troubleshoot and maintain existing SSIS packages

Design, develop, and maintain scalable ETL/ELT processes using Azure Data Factory (ADF) to integrate data from various sources

Develop and maintain data pipelines, workflows, and transformations to support business intelligence, analytics, and reporting needs

Familiarly with other Azure services such as Azure Databricks and Azure SQL databases would be preferred

Works closely with application developers and business division to define requirements for advanced database designs

Provides advice and guidance on database good practices

Provides input on systems architecture

Follows all security practices and identifies areas and processes where performance and security can be improved

Makes and justifies recommendations for improvement

Continuously tunes and optimizes SQL Server databases. Ensures that code and other deliverables adhere to company standards

Provides all required additional support to development, quality assurance, and production support teams

On-call status is a requirement of the position

Works on special projects as needed

Qualifications : To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The qualified candidate must have:. Excellent attention to detail

Ability to multi-task and consistently meet multiple deadline. Strong verbal and written communication skill. Strong interpersonal/relationship building skill. Problem solving and decision making ability

Excellent interpersonal and listening skill. Strong analytical skills and a strategic thinking

Ability to work well independently

Strong organizational skill

Ability to work in a team environment

Strong customer-service orientation

Ability to use good judgment