Pradeep Negi

Microsoft SQL Server Certified Profession having 10+ years of experience in SQL Server.

- Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, functions, Partition, constraint etc.
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues etc.
- Experience in Performance Tuning Optimization (PTO), using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
- Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
- Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Transaction Replication.
- Strong knowledge of how indexes manage. How statistics work, how indexes are stored, how they can be created and managed effectively.
- Knowledge of SQL Server tools (Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, and system procs).
- Involved in Data Modelling (Conceptual/Logical/ Physical Database Designing).
- Used features of SQL Server 2005 - TRY/CATCH Block, PIVOT/ UNPIVOT, Windowing Functions, Common Table Expressions (CTE), Table Partitions, OUTPUT Clause.
- Develop and implement code review and improvement practices.
- Exposure to Agile Development /Involved in Daily/Weekly and Monthly Status Meeting.
- Worked with new features of SQL Server 2012 - Sequence objects and Pagination.
- Used features of SQL Server 2008 - Passing Table value parameter to Stored Procedures, and MERGE Statement.
- Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, Fact and dimension tables.
- Create and deploy various packages using variety of transformations for example Look up, Derived Column, Conditional Split, Fuzzy Lookup, and Data Conversion etc.
- Used Configuration Files for Package Portability across environments (SQL 2005/2008)
- Used Parallel Processing Techniques to Read and load the table fast where ever hardware supported.
- Created a Best Practice documents for ETL Load using SSIS
- Experience in Installation, Configuration, and Creating and Deployment of SSRS reports.
- Created and deployed various types of report utilizing SSRS, like sub report, drill down report, matrix report, parameterise report etc.
- Knowledge of SQL Server Internals (e.g. Pages, Page Types , Extents, Extent allocation, Transaction Log, Index fragmentation, DBCC checks, statistics, Logical/Physical Read, Read Ahead Read, cardinality, Selectivity, Histogram, Lazy Writer, Latch).
- Experience in Data Modelling (Logical and Physical Design of Databases).
Designed and deployed ETL solutions in SSIS. Imported data from OLTP, flat files, or other data sources and created data flow solutions and validate imported data.