Database support Engineer L2
teckinfo solution pvt ltd
مجموع سنوات الخبرة :5 years, 7 أشهر
Perform business analysis, technical analysis, systems design, application software programming.
Restructuring the stored procedure, designing, coding and developing the same using the T_SQL Programming
Transferring the data (ETL) to Data warehouse (Informatica) by SSIS.
Extensively worked on Dynamic Management Views in SQL Server 2005.
Installed, authored, and managed reports using SQL Server 2008 R2 Reporting Services.
Managed the migration of SQL Server 2005 databases to SQL Server 2008 R2.
Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
Performed daily tasks including backup and restore by using SQL Server 2008 R2 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
Prepared the project management and technical documentation.
Unit Testing the SSIS packages with respect to its flow and performance issues.
Solving the Bugs Reflected by the Testing team.
Rebuilding the indexes at regular intervals for better performance.
Monitored and modified Performance using execution plans and Index tuning.
Rebuilding the indexes at regular intervals for better performance.
Extensively worked on DBCC commands and Dynamic Management Objects.
Expertise in SQL Server Reporting Services and SQL Server Analysis Services.
Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
Complete documentation about the database. Recovering the databases from backup in disasters.
Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
analyze long running slow queries and tune the same to optimize application and system performance.
set up SQL Server configuration settings for better server management.
Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.
Rebuilding the indexes at regular intervals for better performance.
Database Administrator, Database Programming.
Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
Deploying new code base release to UAT and Production Environments.