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.

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.