Microsoft SQL developer who will be responsible for designing databases and ensuring their stability, reliability, and performance.
Collaborate with developers optimizing in-application SQL statements as necessary, and establishing best practices.
Will help solve all database usage issues and come up with ideas and advice that can help avoid such problems in the future.
Help write and optimize in-application SQL statements
Ensure performance, security, and availability of databases
Prepare documentations and specifications
Handle common database procedures such as upgrade, backup, recovery, migration, etc.
Profile server resource usage and optimize and tweak as necessary
Must be thorough with the handling of complete Microsoft SQL including Setting up & management of Clustering, Redundancy, Disaster Recovery etc.
Required Candidate profile
Strong proficiency with Microsoft SQL and its variation among popular databases ( Express, Standard & Enterprise Edition )
Knowledge of best practices & Experience with some of the modern relational databases
Skilled at optimizing large complicated SQL statements
Capable of configuring popular database engines and orchestrating clusters as necessary
Ability to plan resource requirements from high-level specifications
Capable of troubleshooting common database issues
Familiar with tools that can aid with profiling server resource usage and optimizing it
Must be trained & have a valid certification in Microsoft SQL Server
Candidates with knowledge of Microsoft Windows server configs/hardware & networking will be given additional preference.