A SQL developer is a software developer oriented to database development. With Transact SQLexperience working with 3rd form of normalization data models; creating, refactoring andmodifying stored procedures; query tunning and analyzing existing queries; indexes and queryhints; data movement using different tools for ELT/ETL processes and good level knowledgeusing the SQL Language. With a strong sense of task ownership.
What you’ll do at Blueriver:
Perform migration tasks from an Oracle database to Azure SQL database, performing tasks migrating and refactoring Database objects such as tables, stored procedures, views, functions, and translating Oracle packages into the corresponding stored procedures for Transact SQL.Work with the Principal Data Architect to perform and monitor all data movement processing.Analyze existing queries and refactor when is needed to warranty good query performance.
What we’re looking for:
5+ years of experience with:Microsoft SQL ServerAzure SQL ServerAzure Data Factory or similar toolsTransact SQL:-creating and modifying tables, stored procedures, functions, views, triggers and indexes.-Query tunning and performance enhancementsETL/ELT:-Working with any type of ETL tools, we are looking for ETL mentality process, data movement, data transformation and data quality assurance from source to target.-CTE and query performance tuning.Good communication skills.Analytical thinkingProblem solving skills.Attention to detail.
Nice to have:
Oracle 11g database server.PL/SQL: Understanding and experience using PL/SQL to develop tables, stored procedures, functions, views and packages.
Why join Blueriver?We try to make the process as easy as possible for any candidate interested in working in this amazing company.
Remote work: We’re an IT company with physical offices in Puebla and Merida in Mexico, but you can work remotely from anywhere within Mexico and Colombia.Tools: We provide you a laptop and headset, ready to add value with us!Work from Mon through Fri. WE LEAVE EARLY ON FRIDAYS!Be Rich Program: We live our mission by adding value to the communities.Professional Development: We offer regular in-house Centers of Excellence (CoE) and Learning Sessions for professional growth.Collaborative Environment: We foster a culture of trust, collaboration, and innovation!Healthy Work Culture: We believe in putting people first.Internal Referral Program: Refer a friend and if hired, participate in a raffle to win amazing prizes!
Our core values:
Do What You Say: Always more, never less.Be Passionate: About work, life, and goals.Help Others First: Teach and grow those around you.Do The Right Thing: Honestly is the best policy.Sí Se Puede: Be the best of the best.Make It Easy: Design and deliver great experiences.
External Referral ProgramIf this position is not the right fit for you, refer someone and if hired, receive a $100 USD AMAZON gift card per hire.
Send your referral via email to careers@blueriver.comWe will send a confirmation email.Receive your Amazon gift card if your referral is hired.
For more information: http://www.blueriver.com