Find More Than 10K+
United Kingdom Jobs

Job description

SQL Developer

Job Summary:

We are seeking a talented SQL Developer to join our dynamic team. The SQL Developer will play a crucial role in the design, development, and maintenance of our organization's databases, ensuring the efficient and secure storage, retrieval, and manipulation of data. The ideal candidate will have a strong understanding of SQL and database management concepts, along with excellent problem-solving skills and attention to detail. This role offers an exciting opportunity to contribute to the development of data-driven solutions and enhance our organization's overall efficiency.

Highlights of the role:

• Contract to Hire
• Data Department
• Richmond Hill (On-Site) – reliably commute or relocate
• 10 days’ vacation
• Bonus Pay
• 9:00 – 5:30 pm (Monday – Friday)
• Benefits – extended health care, on-site parking, store discounts

Role Responsibilities:

• Responsible for designing, developing, and maintaining databases. Create and modify database schemas, tables, views, and indexes to ensure efficient data storage and retrieval.
• Implement and maintain database security measures to protect sensitive data. Manage user access, permissions, and privileges, and ensure compliance with data privacy regulations.
• Perform regular database maintenance tasks such as backups, data archiving, and database tuning. Monitor database activity, identify and resolve data integrity issues, and ensure data consistency.
• Collaborate with other developers, data analysts, and stakeholders to understand data requirements and provide technical support. Assist in troubleshooting database-related issues and contribute to cross-functional projects.
• Document database structures, data models, and procedures to maintain an up-to-date knowledge base. Create documentation for database designs, data dictionaries, and best practices to facilitate knowledge sharing.

Ideal Candidate Profile

Our company operates based on five core values: Accountability, Innovation, Passion, Efficiency, and Shared Success. We believe these values drive us towards achieving our goals and delivering exceptional client results. Accountability means taking ownership and being responsible for our decisions. Innovation is critical to our success, and we encourage out-of-the-box thinking. Passion is the fuel that drives us forward, and we embrace new challenges. Efficiency is about doing more with less, and we optimize our operations to deliver value. Finally, Shared Success is about working collaboratively towards a common goal. We celebrate each other's successes and support each other through challenges.

Key Competencies

• Expertise in writing complex queries, understanding database management systems, and utilizing SQL functions, operators, and clauses effectively.
• Ability to design efficient and scalable database structures, understand normalization principles, and create appropriate indexes and constraints.
• Optimize queries, analyze query execution plans, and implement performance-enhancing techniques such as indexing, partitioning, and caching.
• Knowledge of database security principles and practices, including user access control, encryption, and data privacy regulations.
• Familiarity with data modeling tools and data visualization platforms
• Accuracy and precision are crucial to ensure data integrity.

Qualifications:

• Proven work experience as an SQL Developer or similar role.
• Strong proficiency in SQL and database management systems (e.g., MySQL, PostgreSQL, Oracle, SQL Server).
• Familiarity with ETL processes and tools for data extraction, transformation, and loading.
• Experience in database design, normalization, and optimization techniques.
• Solid understanding of relational database concepts and SQL best practices.
• Proficient in writing complex SQL queries, stored procedures, and functions.
• Knowledge of indexing, query optimization, and performance tuning.
• Familiarity with data modeling and data visualization tools (e.g., ER/Studio, Tableau).
• Strong analytical and problem-solving skills with great attention to detail.
• Excellent communication and collaboration skills to work effectively with cross-functional teams.
• Ability to manage multiple tasks and prioritize effectively in a fast-paced environment.

Company Profile

Proudly Canadian!

Canadian owned and operated since 2012, Parts Engine is a leading-edge, aftermarket online retailer revolutionizing the way Canadians accessorize their trucks, SUVs Jeeps, and cars. At Parts Engine, you’ll find a huge selection of the best brand-name automotive accessories that money can buy. We feel it’s our duty to help you experience the treasured Canadian lifestyle of exploring the great outdoors.

Our goal is to be the biggest and best in the industry, and from day one, we’ve diligently put the tools in place to make this goal a reality, beginning with our team of dedicated, highly trained customer service representatives. We’ve authorized each one of them to source the highest quality products at the absolute best prices. We are Canada’s truck experts.

Interview Process

We thank all applicants for their interest. Parts Engine will only contact candidates proceeding to the next interview stage.

Equal Opportunity Employer

Parts Engine is an equal opportunity employer and employs personnel without regard to race, ancestry, place of origin, colour, ethnic origin, language, citizenship, creed, religion, gender, sexual orientation, age, marital status, physical and/or mental handicap or financial ability. While remaining alert and sensitive to the issue of fair and equitable treatment for all, Parts Engine has a special concern with the participation and advancement of members of four designated groups that have traditionally been disadvantaged in employment: women, visible minorities, aboriginal peoples and persons with disabilities.

Job Type: Fixed term contract
Contract length: 3 months

Salary: $60,000.00-$100,000.00 per year

Benefits:

• Casual dress
• Company events
• Dental care
• On-site parking
• Store discount

Flexible Language Requirement:

• French not required

Schedule:

• 8 hour shift
• Monday to Friday

Supplemental pay types:

• Bonus pay
• Overtime pay

Ability to commute/relocate:

• Richmond Hill, ON L4S 0J5: reliably commute or plan to relocate before starting work (required)

Application question(s):

• What is your favourite car and why?

Experience:

• E-commerce: 3 years (preferred)

Work Location: In person

Expected start date: 2023-06-30