Tagcor

Stored Procedures Triggers Tables Views Index User Defined

Design, define and maintain databases.
Understand Database table partitioning procedures.
Create and maintain stored procedures for data transfer between apps and databases.
Create complex SQL queries for different ad-hoc reporting and for integration with reporting tools.
Extensively use SSIS transformations such as Lookup, Derived column, conversion, task, etc.
have Hands on experience in developing and deploying SSIS and SSRS in different environment.
Should have experience in data warehousing including business intelligence tools-SQL, SSIS and SSRS.
Should have used T-SQL objects like Stored Procedures, Triggers, Tables, Views, Index, User Defined
Functions, Data integrity, variables, cursor, CTE, joins etc.
Experience in Performance tuning of Queries and indexing to improve Performance.
Ensure policies for handling sensitive date (PCI, PII) ethically within the application.
Should have used T-SQL objects like Stored Procedures, Triggers, Tables, Views, Index, User Defined
Functions, Data integrity, variables, cursor, CTE, joins etc.
Experience in Performance tuning of Queries and indexing to improve Performance.
Experience on Table Partitioning, Backup and Recovery.
Proficiency in creating a database from the group up for a brand-new application.
Ability to design tables and organize data in a manner that maximizes performance, incorporating use of
suitable indexes and partitions.