Must Have Skills:
- Designing Database Schema and making changes to existing tables functions
- Experience in implementing Table partitioning and advanced working knowledge of different index types and how they are used column store, fulltext, filtered, indexes with include columns
- Experience in creating TSQL (DML, DDL, DCL and TCL), Temporary Tables, Table Variables, Stored Procedures, System and User Defined Functions
- Experience with SSIS in implementing ETL Tasks, data integration with other systems.
Detailed Job Description:
- At-least 5+ years of experience in SQL Server Development and Administration including Analysis, Design, Capacity planning, up-gradation, configuration, performance analysis, security, development, maintenance of database on production, development, and test environments under Windows platforms
- Experience with Migrating SQL databases and data sources to Relational cloud-based Azure platform (PAAS)
- Good knowledge on Setting up High availability DR solutions and over Azure
- Experience with SQL Database Development tasks like Create database and Database objects like creating tables, indexes, stored procedures, Triggers using SSM...
