Job description 1Good understanding of sql server architecture, memory handling, and db indexes2Strong knowledge and hands on expertise in sql server stored procedures, functions, triggers, indexes, jobs, and performance tuningWriting and reviewing t-sql code3Day-to-day production db support and maintenance of ms sql server 2016 4Hands on experience on table partitioning for performance 5Perform database system optimization and improvement and query optimization6Hands on experience on database mirroring, log shipping, replication and always-on in all sql versions7Plan and maintain database archiving 8Assisting application team in detecting performance problems.
Microsoft certified database administrator (mcdba) certification would be an added advantage.
Experience working with large enterprise databases is a must
Experience in working with billing and invoicing is a plus.
Cogniter Technologies is an established web development company delivering the best quality web design and internet development services of any complexity to clients worldwide. Being in IT business for over 9 years now, Cogniter Technologies has a strong team of 100 skilled experienced IT experts. Our clientele starts from small business companies to large enterprises who realize that they need a professional internet solution to generate revenue streams, establish communication channels or streamline business operations. Cogniter has never limited its vision. It has expanded its horizons throughout USA with its major clients spread all over USA. Known for the quality work, within five years of its establishment, Cogniter has become one of the hot favorites for anybody and everybody looking for web Internet Business.