SQL Database Developer

Compunnel, Inc.; Halifax; On-site; CAD 70,000 - 110,000; Full time

Job summary

An established industry player is seeking a SQL Database Developer to design and optimize database solutions that enhance business processes and support data-driven decision-making. This role emphasizes collaboration and analytical thinking, requiring expertise in SQL and database architecture. The ideal candidate will work with modern data tools, including Azure SQL Server and Databricks, to improve data accessibility and quality. Join a dynamic team where your contributions will directly impact the efficiency and effectiveness of data management practices, driving innovation and success in the organization.

Qualifications

• Proficiency in SQL and relational database design.
• Experience with ETL processes and tools.

Responsibilities

• Design and structure effective database schemas.
• Write and optimize SQL queries for data operations.
• Execute and manage ETL processes for data integration.

Skills

SQL

Database Architecture

Performance Tuning

ETL Processes

Analytical Thinking

Collaboration

Tools

Azure SQL Server

Azure Data Factory

Databricks

Power Automate

Job description

The SQL Database Developer is responsible for designing, developing, and optimizing robust database solutions to support business processes and data-driven decision-making.

The ideal candidate will demonstrate expertise in SQL, database architecture, performance tuning, and ETL processes.

This role also emphasizes collaboration, analytical thinking, and the implementation of modern data tools and technologies to improve data accessibility and quality.

Key Responsibilities

1. Design and structure effective database schemas to support various applications and business needs.
2. Write and optimize SQL queries for data retrieval, insertion, updates, and deletions.
3. Execute and manage ETL processes for extracting, transforming, and loading data from multiple sources.
4. Analyze data sets to uncover actionable insights and improve decision-making capabilities.
5. Optimize database performance and ensure data integrity through monitoring and tuning.
6. Collaborate with cross-functional teams to define and implement data requirements and architecture.
7. Utilize tools like Azure SQL Server, Azure Data Factory, and Databricks for database management and processing.
8. Implement automation solutions using Power Automate and other relevant technologies.

Required Qualifications

1. Proficiency in SQL and experience with relational database design and performance tuning.
2. Familiarity with ETL processes and tools.
3. Experience with Azure SQL Server, Azure Data Factory, and Databricks.
4. Strong analytical and problem-solving abilities.
5. Ability to collaborate with cross-functional teams in a dynamic environment.

Preferred Qualifications

1. Knowledge of Python and Streamsets.
2. Strong organizational and project management skills.