cloud developer
Title posted on indeed.com -
TSQL Developer
Posted on
December 10, 2024
by
Employer details
CAA North & East Ontario
Job details
*Job Title: TSQL Developer*
*Term: Full-Time, Permanent*
*Location: HYBRID: Work-From-Home / 1031 Bank St. Ottawa, ON *
*Job Summary:*
Under the direction of the Data Solutions Lead, the T-SQL Developer plays a critical role in designing, developing, and optimizing the company's database systems, ensuring the efficiency, reliability, and scalability of their data infrastructure. The T-SQL Developer contributes to the development and execution of data migration and integration processes between systems, and creates comprehensive documentation to support database designs and development processes.
Leveraging their expertise in Transact-SQL (T-SQL) programming and hands-on experience with SQL Server, SSIS, SSRS, and SSAS, the T-SQL Developer collaborates with cross-functional teams to translate business requirements into efficient database designs and structures.
The T-SQL Developer conducts performance tuning and optimization of database queries, troubleshooting and resolving database-related issues, and implementing ETL/ELT processes for seamless data integration. Additionally, their proficiency in Azure data technologies, such as Azure Data Factory, Azure Databricks, Azure SQL Data Warehouse, and Azure Analysis Services, is vital in deploying innovative data solutions.
The T-SQL Developer possesses a deep understanding of data modeling, multi-dimensional, and tabular database design and architecture. Moreover, their strong problem-solving skills, attention to detail, and adherence to data governance and security principles ensure the accuracy, privacy, and compliance of the company's data.
*Responsibilities*
Database Development and Optimization:
* Design, develop, and maintain complex T-SQL queries, stored procedures, functions, triggers, and other database objects to support application development and data manipulation needs.
* Conduct performance tuning and optimization of database queries to enhance system responsiveness and minimize downtime.
* Troubleshoot and resolve database-related issues, ensuring data integrity and accuracy.
* Implement ETL/ELT processes for seamless data integration and transformation.
* Demonstrate proficiency in data modeling for efficient data storage and retrieval.
Collaboration and Data Solutions:
* Collaborate with software developers and other stakeholders to understand and translate business requirements into efficient database designs and structures.
* Utilize expertise in Azure data technologies, including Azure Data Factory, Azure Databricks, Azure SQL Data Warehouse, and Azure Analysis Services, to deploy innovative data solutions.
* Ensure compliance with data governance and data security principles to protect data privacy and maintain regulatory compliance.
* Assist in the development and execution of data migration and integration processes between systems.
* Create and maintain comprehensive documentation for database designs, data models, and development processes.
*Requirements: *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.
Education and Experience:
* Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).
* Proven work experience of a minimum of 5 Years as a T-SQL Developer or similar role with hands-on experience with SQL Server, SSIS, SSRS, and SSAS.
* Minimum 1 year experience with Azure SQL Server, ADF
* Minimum 1 year experience creating data pipelines using Python and Spark
* Familiarity with Azure Databricks is an asset
Technical Skills:
* Strong proficiency in Transact-SQL (T-SQL) programming and a deep understanding of relational database concepts.
* Familiarity with multi-dimensional and tabular database design and architecture.
* Demonstrated experience in performance and query optimization techniques.
* Experience in enterprise informat
-
LocationOttawa, ON
-
Workplace information
On site
-
Salary$75,000 to $85,000YEAR annually
-
Terms of employment
Permanent employmentFull time
-
Starts as soon as possible
- vacancies
1 vacancy
- Source
indeed.com
#9560099823
Important notice: This job posting has been provided by a partner site. Job Bank is not responsible for this content.
Report a problem with this job posting
Thank you for your help!
You will not receive a reply. For enquiries, please contact us.