Expertise ETL, Data warehouse development. Please find my skill set below..
➢ Over 6 Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2014/2012/2008R2 in Production, QA and Development Environments.
➢ Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2014/2012/2008R2.
➢ Experience in Managing Security of SQL Server 2014/2012/2008R2 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
➢ Strong experience with T-SQL (DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, Transactions, Sequence, User Defined Functions, Indexes, Error Handling, Paging, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
➢ Hands on experience in writing IBM DB2 database query. Ability to access and pull data from DB2 database.
➢ Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Ignite-8, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance. Experience of In-Memory functionality of SQL 2014 to improve performance of large tables. Hands on experience in Column stored indexes.
➢ Expertise in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and in SQL Se