Senior SQL Developer

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.