The Job Overview
We are seeking a dedicated SQL programmer to join our growing company. You will work as part of a broader team to design and create database structures suitable for quickly and efficiently storing and retrieving relevant data for company projects.
As an SQL programmer, you will be expected to develop fast and performant database queries, in addition to performing database maintenance tasks and ensuring an even load distribution as required. Your duties will include following best database design and development practices, as well as staying up-to-date with all relevant data security procedures and complying with all applicable data protection legislation.
Responsibilities
Below are some of the responsibilities an SQL developer or programmer is expected to assume in their position:
- Write fast and performant database queries using a flavor of SQL Server, such as MySQL, MSSQL, or PostgreSQL
- Troubleshooting and problem-solving using JavaScript and other programming languages
-
- Maintain and back up databases regularly
- Perform SQL database sharding and indexing procedures as required to handle heavy traffic loads
- Development, optimize, and implement stored procedures
- Use database analytical tools to analyze performance and generate reports
Job Qualifications and Skill Sets
Below are the qualifications expected of an SQL programmer:
-
- Bachelor's degree in software development, computer science, business intelligence, information technology, data management, or other related fields
- Advanced knowledge of database procedures and Microsoft SQL Server concepts
- Knowledge of one or more SQL variant, such as MySQL, MSSQL, and PostgreSQL
- The ability to create fast and efficient database queries, including joining and cross-referencing cells from several tables
- Familiarity with standard database management tools and software, such as Microsoft Access, Oracle Database, and phpMyAdmin
- Excellent communication skills