Has 7 years of experience in the analysis, design, development, implementation, testing, and maintenance of application systems in the Internet/Intranet, Client Server environments; with 4+ years of experience as a SQL Server DBA/ETL developer.
• Very good experience in Installation, configuration and maintenance of SQL Server.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
•Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands
• Experience in Database backup and disaster recovery procedures.
• Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
• Created complex DTS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2008/2005/2000.
• Experience in MS SQL Server upgrades from MS SQL Server 2000 to2005 and from 2005 to MS SQL server 2008.
•Worked in OLTP & OLAP and development databases in SQL Server.
• Has Knowledge of Analysis Services & Reporting Services, SQL Server Clustering and Log Shipping
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Has the ability to work in a fast paced environment, Good team player and can work independently. Helped the database developers on technical issues.