Senior SQL Developer

Remote: 
Full Remote
Contract: 
Work from: 

Offer summary

Qualifications:

4+ years of experience in MS SQL Database administration., Proficient in T-SQL for developing procedures and functions., Knowledge of performance tuning, optimization, and backup strategies., Familiarity with NOSQL databases and Windows server environments..

Key responsibilities:

  • Set up and maintain databases across different environments.
  • Collaborate with analysts and developers to build scalable software solutions.
  • Analyze and optimize SQL queries for performance improvements.
  • Prepare documentation and specifications for database procedures.

Idea Elan logo
Idea Elan

Job description

We are seeking a highly motivated and skilled SQL Developer to build and maintain highly scalable databases. Ideal candidates are developers who "code to live and live to code"; they must be passionate about software development. As an SQL Developer, you will develop MS-SQL queries and procedures. You will also be responsible for designing databases and ensuring their stability, reliability, and performance.

Key responsibilities
- Setup & Maintain the databases at all different environments.
- This person will work with a team of experienced analysts, developers and business resources to build highly-scalable software.
- Discuss and understand the business needs and architect the database according to it without effecting the performance.

Desired Skills and Responsibilities
- Use T-SQL to develop and implement procedures and functions.
- Maintain and back up databases regularly.
- Perform SQL database sharding and indexing procedures as required to handle heavy traffic loads.
- Use database analytical tools to analyze performance and generate reports.
- Analyze existing SQL queries for performance improvements.
- Skilled at optimizing large complicated SQL statements.
- Develop procedures and scripts for data migration.
- Knowledge of best practices when dealing with relational databases.
- Capable of troubleshooting common database issues.
-  Familiar with tools that can aid with profiling server resource usage and optimizing it.
- Proficient understanding of code versioning tools such as Git / SVN.
- Prepare documentations and specifications.
- A high degree of integrity and responsibility is a MUST!

Required Experience
- 4+ year experience in MS SQL Database administration.
- Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
- Experience with backups, restores and recovery models.
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
- Knowledge of NOSQL databases like Cosmos, Mongo DB.
- Experience working with Windows server, including Active Directory.
- Ability to organize and plan work independently.
- Ability to work in a rapidly changing environment.

Required profile

Experience

Spoken language(s):
English
Check out the description to know which languages are mandatory.

Other Skills

  • Teamwork
  • Accountability
  • Problem Solving
  • Personal Integrity

Related jobs