Patterned Learning Career is Hiring a Research & Development-SQL Developer Near Anchorage, AK
This is a remote position. Research & Development-SQL Developer - Remote Job, 1 Year ExperienceAnnual Income: $58K - $68K A valid work permit is necessary in the US/CanadaAbout 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. Summary of Position: A skilled SQL Developer to join our dynamic team. The SQL Developer will play a crucial role in designing, implementing, and maintaining stored procedures and queries, ensuring efficient and reliable database DevOps process, and developing and maintaining reports using PowerBI. The ideal candidate should have a strong background in SQL development, database design, and PowerBI. Duties & Responsibilities:
Design and implement database solutions to meet business requirements
Create entity-relationship diagrams (ERDs) and data models
Normalize data and ensure data integrity
SQL Development:
Write efficient and optimized SQL queries for data retrieval, manipulation, and reporting
Develop and maintain stored procedures, triggers, and functions
Troubleshoot and optimize SQL code for performance
Maintain database schema and drive the dev ops process to reliably propagate changes to test and production
Data Integration:
Collaborate with cross-functional teams to integrate data from various sources into the database
Ensure data consistency and accuracy during the integration process
Documentation:
Maintain thorough documentation of database schemas, data dictionaries, and processes
Document changes and updates to the database environment
Troubleshooting and Support:
Respond to and resolve database-related issues and incidents promptly
Provide support and assistance to end-users and other teams as needed
Minimum Qualifications:
Bachelor's degree in Computer Science, Information Technology, or a related field or equivalent work experience
Proven experience as a SQL Developer or similar role
Proficiency in SQL programming and database management systems (e.g., Microsoft SQL Server, Oracle, MySQL)
Strong knowledge of database design principles and data modeling
Experience with performance tuning and optimization of SQL queries
Excellent problem-solving skills and attention to detail
Strong communication and collaboration skills
Ability to work independently and as part of a team
Prefer certification in database management (e.g., Microsoft Certified Database Administrator)
Experience with ETL (Extract, Transform, Load) processes and tools
Experience with business intelligence and reporting tools, PowerBI & Data Analysis Expressions (DAX)
Knowledge of HIPAA, preferred
Ability to deliver effective documentation of projects and tasks
Ability to perform comfortably in a fast-paced, high-intensity, deadline-oriented work environment