RTRC Colombia, based in Bogotá, Colombia seeks to employ a Software Developer with strong SQL Database knowledge for challenging software products for the Energy industry.
The main responsibilities of a Software Developer are :
Design and implementation of software solutions.
Integration of software solution into the source code repository (TFS, GIT).
Commitment for solutions quality standards.
Contribute in the software solutions documentation.
Promote and contribute in the realization of software architecture goals.
Maintenance of the software solutions.
Conception and creation of highly scalable and highly available databases.
Design of business process logic.
Develop with your agile team.
Database analysis, testing, development and refactoring.
Optimization of database access, procedures, triggers, and functions.
Engineer or related bachelor degree.
2+ Years of advanced database development experience on SQL Server using T-SQL.
Proficiency in software design techniques, including object-oriented analysis and design techniques.
A customer oriented individual with skills in problem solving.
Proficiency in database design techniques, including conceptual, logical and physical models.
Experience analyzing and improving database queries and execution plans.
Abilities for profiling, debugging and code comprehension in complex stored procedures, triggers, views.
Good command of English (written and verbal).
Preferred but not required
Unit testing development experience with T-SQL framework.
Experience working with agile methodologies, like SCRUM, XP, TDD.
Skills in MS-SQL Server Administration and Monitoring tasks using AlwaysOn and Availability Groups, Encryption, Replication, etc.
Understanding of common architecture patterns (SOLID principles, IOC, provider, factory ).
Proficiency in C# Component Based Development and .NET Frameworks.
It is also desirable but not required to have experience in the following technologies : SQL SentryOne, SQL Clone, and SQL Prompt.
Experience working with Xml, Json and Geographic datatypes and their related specialized operations and functions.
Experience working with SQL Server Broker, tuning and troubleshooting.
Experience working with system stored procedures, advanced functions and DMVs.