403 SQL developers in 110 agencies found

Security Engineer and Tester. Dynamic, quick learning with a strong aptitude for security...
Flexible skill-set has contributed to experience in supporting technical tools, assessing security risks for clients, and training users on the safe operation of resources: Penetration testing. Data S...
All rates are indicative
view Profile
Updated: 22 Jun 2018
Sr QA Engineer - Manual and automated testing
All rates are indicative
view Profile
Updated: 22 Jun 2018
Full cycle product development, Windows/Linux Native (C++) applications and Virtualization...
All rates are indicative
view Profile
Updated: 22 Jun 2018
YS
Software Developer- .NET, ASP.NET MVC, AZURE, C#
All rates are indicative
view Profile
Updated: 22 Jun 2018
OL
Software Engineer - JavaScript, Angular 2x, Node.JS
All rates are indicative
view Profile
Updated: 22 Jun 2018
PS
Front end developer - JavaScript, Angular, Typescipt
All rates are indicative
view Profile
Updated: 22 Jun 2018

No-one really matches your needs?

Normally we are able to pro-actively find any given talent within 72 hours.

SQL

Seven Major Skills any Dedicated SQL Developer Must Have

SQL (Structured Query Language) is a query language for relational databases. It allows to manipulate (extract, edit, delete, change the structure, etc.) the information, which is stored and systematized by specialized software – DBMS (database management system). Currently, SQL (for the most part in Oracle implementation) remains the most popular of the database manipulation languages.

The declarative nature of the language as compared to more traditional imperative ones, such as C# or JavaScript, make it hard even for the experienced Chief Technical Officer to hire a SQL programmer with required qualifications. The declarative programming paradigm defines the computing process by describing its logic as opposed to describing the logic of the controlling program, inherent to imperative programming. The former describes WHAT must be done, the latter – HOW it must be done. The specific implementation of database manipulation mechanisms is assigned to DBMS and varies between different vendors.

Thus, we strive to provide the seven major knowledge areas a professional SQL developer should have experience with.

A competent SQL programmer should have:

  1. Solid knowledge of the database design theory, in particular, normalization, data integrity, data definition, data modelling, database indexing.
  2. Knowledge of database programming technologies (writing stored procedures, functions, views).
  3. Knowledge and experience with common data exchange formats (XML, JSON).
  4. Knowledge of the principles and methods of database backup and recovery.
  5. Knowledge of the security regulations of the target DBMS, the principles of user access levels and privileges delimitation.
  6. Good knowledge of the target DBMS and its tools, knowledge of the principles and features of the installation and operation of a particular DBMS in various operating systems and environments.
  7. Knowledge of ways to assess the performance of databases and optimize it, execution plans and index maintenance routines.

Upgraded versions of the basic SQL standard that most software vendors have developed over the years include a large number of advanced features, such as window functions, common table expressions and much more. Knowledge of such subtleties makes it easy to separate real professionals from novice or non-core developers. We hope this checklist will help you to make a good hiring decision.