SQL developer,DBA,SSIS develoepr

• Roles & Responsibilities:
o Installing and configuring SQL Server 2005/2008/2012.
o Design Data dictionary and Database.
o Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors
o Managing and Configuring SQL Servers as Linked servers as well as setting configuration options.
o Transformed data from one server to other servers using tools like SQL Server Integration Services (SSIS) (2005/2008).
o Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
o Experience in importing/exporting data between different sources like Oracle//Excel etc. using SSIS/DTS utility
o Experience in ETL processes involving migrations and in sync processes between two databases.
o Experience in maintaining one to many and many to one relationships while moving data between two databases
o Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
o Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
o Index creation and maintenance
o Creating, Scheduling and scripting Jobs
o Designing and Configuring Database Mirroring
o Monitoring SQL Server Performance and Activity
o Query Optimization and troubleshooting
o User Role Management
o Handling Production Server, Jobs, Server failure, Backup failure, Database Consistency, Synchronizing.
o Monitor and maintain health of auto processes such as windows scheduled tasks, SSIS packages, SQL Jobs
o Good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor.
o Database Security Management
o Code review of database objects