SQL Developer

RCGT Consulting; Ottawa; On-site; CAD 70,000 - 100,000; Full time

Job summary

A leading company is seeking an SQL Developer to join their team. This role involves designing, developing, and maintaining database systems to ensure data integrity and retrieval efficiency. The ideal candidate will work on database architecture, query optimization, and provide technical support in troubleshooting. Candidates should have strong SQL skills and an understanding of database operations, with opportunities for ongoing engagements offered.

Benefits

Opportunities for ongoing work

Professional collaboration and support

Timely payments and clear expectations

Qualifications

• Strong understanding of SQL syntax, data types, and database operations.
• Ability to design and implement relational database schemas.

Responsibilities

• Create and maintain database structures like tables and procedures.
• Write and optimize SQL queries to improve data retrieval.

Skills

SQL Fundamentals

Database Modeling

Programming Languages

Database Optimization

Data Management

Software Engineering

Job description

We are currently building our roster of experienced and reliable subcontractors to support upcoming projects. If you take pride in your work, deliver on time, and value professionalism, we'd love to hear from you.

Position: SQL Developer

An SQL Developer designs, develops, implements, and maintains database systems, ensuring data integrity and efficient retrieval. They use SQL to create and modify tables, write queries, and optimize system performance. Responsibilities include creating database schemas, writing and testing SQL code, and troubleshooting database issues.

Key Responsibilities :

1. Database Design and Development : Create and maintain database structures, including tables, stored procedures, views, and functions.
2. SQL Querying and Optimization : Write, analyze, and optimize SQL queries to retrieve data and enhance system performance.
3. Data Integrity and Security : Ensure data accuracy, consistency, and security within the database system.
4. Troubleshooting and Maintenance : Diagnose and resolve database issues, including performance bottlenecks and security vulnerabilities.
5. Work with other developers, project managers, and stakeholders to understand requirements and implement solutions.
6. Documentation : Document database schemas, procedures, and queries for future reference.

Skills and Knowledge :

• SQL Fundamentals: Strong understanding of SQL syntax, data types, and database operations.
• Database Modeling: Ability to design and implement relational database schemas.
• Programming Languages: Familiarity with programming languages used for database interaction (e.g., T-SQL).
• Database Optimization: Knowledge of indexing, querying techniques, and other performance optimization strategies.
• Data Management: Understanding of data warehousing, data modeling, and data integrity.
• Software Engineering: Familiarity with software development methodologies and best practices.

What We Offer :

• Opportunities for ongoing work
• Professional collaboration and support
• Timely payments and clear expectations

Note :

This is a proactive posting to identify and connect with top talent ahead of scheduled projects.

Only qualified candidates will be contacted.

Thanks for your interest to partner with our organization.