Job Description:
-
Will be in-charge for Design, development, optimize, performance tuning of custom applications.
-
Responsibility includes Troubleshooting and problem solving of MS-SQL server and databases.
-
Will be responsible for writing, reviewing and recommend optimization techniques for SQL queries and stored procedures.
-
You will be responsible for Installation, configuration and upgrading MS-SQL server, SSRS, SSIS and IIS, Web services and related products.
-
Will be in-charge of Troubleshooting and problem solving of MS-SQL server and databases.
-
Will be in-charge of Periodic monitoring of the databases.
-
Doing performance improvements on the databases.
-
Improvements and maintenance of databases to include rollout and updates.
-
Data driven Web Services for IIS, WCF and MS-SQL.
-
Work closely with management, engineering and support to provide direction in identifying and resolving database related problems.
-
Requirements collection from internal, external clients and documentation.
-
Unit testing and debugging of applications in various stages of development life cycle.
-
Work collaboratively with peers in all the stages of development life cycle.
-
Write complex MS-SQL scripts for database merge or fixes.
-
Write efficient procedures for search routines and complex business logic.
-
Develop Business Intelligence package using SQL SSIS by collecting requirements from the customer.