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.