SQL Developer

Published

This is a remote position.

SQL Developer - Remote Job, 1+ Year Experience****Annual Income: $58K - $68K

A valid work permit is necessary in the US/Canada****About us: Patterned Learning is a platform that aims to help developers code faster and more efficiently. It offers features such as collaborative coding, real-time multiplayer editing, and the ability to build, test, and deploy directly from the browser. The platform also provides tightly integrated code generation, editing, and output capabilities.

Description:

As an SQL Developer, you will play a crucial role in designing, implementing, and optimizing database solutions, enabling efficient data storage, retrieval, and manipulation. You will collaborate with cross-functional teams to understand data requirements and deliver effective solutions that meet our clients' needs. This is a unique opportunity to work on diverse projects, tackle complex data challenges, and make a significant impact in the world of data.

Responsibilities:
\

  • Collaborate with stakeholders to gather data requirements and translate them into efficient SQL queries, stored procedures, and functions.
  • Design, develop, and maintain database schemas, ensuring data integrity, security, and performance.
  • Write complex SQL queries for data extraction, transformation, and loading (ETL) processes.
  • Optimize SQL queries and database performance, identifying and resolving bottlenecks and inefficiencies.
  • Develop data validation and quality assurance processes to ensure accuracy and reliability.
  • Collaborate with cross-functional teams to integrate SQL code into applications and reporting systems.
  • Conduct data analysis to identify trends, patterns, and insights that drive business decisions.
  • Stay up-to-date with the latest trends and advancements in SQL and database technologies.

Requirements:
\

  • Bachelor's degree in Computer Science, Information Technology, or a related field.
  • Proven experience as an SQL Developer or Database Developer, working with complex databases.
  • Strong proficiency in SQL and experience with relational databases (e.g., MySQL, Oracle, SQL Server).
  • Solid understanding of database design principles, data modeling, and normalization.
  • Proficiency in writing complex SQL queries, stored procedures, and functions.
  • Experience with performance optimization and tuning of SQL queries and database indexing.
  • Familiarity with ETL processes and tools (e.g., SSIS, Informatica) is a plus.
  • Knowledge of data warehousing concepts and dimensional modeling is desirable.
  • Strong problem-solving skills and the ability to analyze complex data requirements.
  • Excellent attention to detail and a commitment to delivering high-quality solutions.
  • Effective communication and collaboration skills to work with cross-functional teams.