Senior SQL Developer

Summary

Join Encora as a Senior SQL Developer and design, develop, and maintain high-quality software solutions. Collaborate with cross-functional teams to translate business requirements into scalable applications. Lead technical projects, mentor junior engineers, and improve software development practices. Work remotely from Peru, Colombia, Costa Rica, or Bolivia. The role involves optimizing SQL queries, stored procedures, and database structures. You will also develop and maintain ETL processes for data extraction, transformation, and loading.

Requirements

• Bachelor’s degree in computer science, software engineering, or a related field
• Extensive experience in software development with a focus on designing and building scalable applications
• Professional/ Advanced English skills
• +5 years of experience
• Expert-level proficiency in writing and optimizing SQL queries, views, functions, and stored procedures
• Experience with major RDBMS platforms such as Microsoft SQL Server, PostgreSQL, or Oracle
• Strong understanding of relational database concepts, normalization, and indexing
• Experience with performance tuning, execution plan analysis, and troubleshooting slow-running queries
• Familiarity with ETL tools such as SSIS, Talend, or custom scripting for data migration

Responsibilities

• Design, develop, and optimize complex SQL queries, stored procedures, and database structures to support application and business requirements
• Maintain and improve existing SQL code and database performance through query tuning and indexing strategies
• Work closely with data analysts, application developers, and business teams to understand data needs and deliver efficient solutions
• Develop and maintain ETL processes for data extraction, transformation, and loading across multiple systems