SUMMARY

• Over 13 years of experience as MS SQL Server Database Developer/Architect/DBA in production/Development/QA/Staging servers on windows Server environments.
• Extensive experience with SQL Server 2008/2005/2000.
• Expertise in designing, creating, and managing SQL database and objects with emphasis on security and data - integrity.
• Expertise in extracting, transforming and loading (ETL) of data using SSIS/DTS Packages and BCP Utility for importing and exporting data with format files.
• Expert in writing and developing SQL Queries, Stored Procedures, Views.
• Expertise in designing patterns, Data Flow Diagrams, Data Models, ER Models and architectural specifications.
• Strong experience in generating Report Models, customized Ad-Hoc, Cached, Parameterized reports using SSRS.
• Experienced in migrating databases from Old version of SQL Server to SQL Server 2005/2008.
• Good knowledge of RDBMS, Data Warehouse concepts, OLTP and OLAP.
• Backup, Restore/Recovery Models, Transactional Replication, Log Shipping and Database Mirroring.
• Disaster Recovery methodologies and high availability techniques and implementations.
• Database activities like installation, configuration, applying service packs and hot fixes.
• Excellent T-SQL Programming skills in creating, executing, debugging, problem analysis & trouble shooting stored procedures, functions, triggers, and creating solutions.
• Good experience in Remote database administration using Win VNC software, remote desktop and Citrix.
• Experienced in full SDLC - Gathering Requirements, Analysis, Architecture, Design, Building, Testing, Deployment, Production Support, Migration and end user Training.
• 24x7 Production Support, customer interactions, team-player, and ability to handle multiple tasks independently.

TECHNICAL SKILLS

• SQL Server DBMS
• T-SQL
• Stored Procedures
• Functions
• Views
• Triggers
• Performance Tuning
• Data Modeling
• SSIS
• SSRS (s)
• DBA Activities like Backup/Restore
• Replication
• Log Shipping
• Database Mirroring
• SSAS

PROFESSIONAL EXPERIENCE

Confidential

MS SQL Server Developer/Administrator

Responsibilities:

• Writing Complex T-SQL code to analyze issues reported.
• Writing Stored Procedures, Views and Functions as needed.
• Work on Development requests and also on Incidents pertaining to Data changes.
• Work on Designing data models as per the requirement.
• Do the code review of other requests, before they are deployed to other environments.

Environment: MS SQL Server 2008, MS Windows 2003/XP/7/NT, MS Visual Studio 2008/2010, Team Foundation Server, Serena Dimensions, Serena Team Track, DB Packager, BMC Service Desk Express

Confidential

MS SQL Server Developer/Administrator

Responsibilities:

• Responsible for SQL Development and DB Administration. Worked hand-in-hand on both Development and DBA roles.
• Created SSIS Packages for importing data from different sources to SQL Server.
• Created SSRS reports.
• Wrote SQL Queries, Stored Procedures, Views and Functions as needed. Work on Development DB Service requests which we get from developer to Check-in the new Schema changes into TFS.
• Work on Development DB Service requests which we get from developer to create Shelve sets.
• Monitoring the daily release build and making sure the build is generated successfully.
• Generating daily alter scripts by comparing build generated today with the yesterday’s release build for schema changes and including the Data Alter scripts if any to the daily generated alter script.
• Test the daily generated alter script against the QA restored back up database and fix if there are any errors and let developer know about the errors.
• Setting up smoke test environment by restoring the 14 QA BAK databases and applying the alter scripts generated and work on any database related tasks assigned.

Environment: MS SQL Server 2005/2008, MS Windows XP/7/NT, MS Visual Studio 2008/2010, TFS.

Confidential

Responsibilities:

• Designing of database/objects based on the requirement.
• Write SQL Queries, Stored Procedures, Views and Functions as needed.
• Involved in migrating of SQL SERVER 2000 database to SQL SERVER 2008.
• Created SSIS packages for importing data from different sources to SQL Server.
• Perform performance tuning at the query and index level.
• Monitor Data Warehouse Process and to create reports for data analysis using SSRS.
• Implement the change requests as required, done unit and integration testing.

Environment: MSSQL Server 2008/2000, SSAS, SSIS, MS Windows 2003/XP/2000/95/98/NT.

Confidential

Responsibilities:

• Responsible for database design.
• Created SSIS Packages for importing data from different sources to SQL Server.
• Wrote SQL Queries, Stored Procedures, Views and Functions as needed.
• Performed performance tuning at the query and index level.
• Responsible for taking database backup and restoring.
• Created and generated periodic reports for data analysis using SSRS.
• Implemented the change requests as required, done unit and integration testing.

Environment: MSSQL Server 2005 and MS Windows 2003/XP/2000/95/98/NT.

Confidential

Responsibilities:

• Responsible for database design.
• Created SSIS packages for importing of alliance and Muze vendors data into our databases.
• Created tab delimited files for importing our products list into Google Base, so that the products are searchable.
• Generated product feeds as XML files to be imported into MS BizTalk Sever and then onto MS Commerce server.
• Wrote SQL Queries, Stored Procedures, Views and Functions and Cursors as needed.
• Performed performance tuning at the query and index level.
• Responsible for backup complete and differential and restoring.
• Created and generated periodic reports for data analysis.
• Implemented performance tuning tips to get the best performance out of SQL Server.
• Executed the change requests as required, done unit and integration testing.

Environment: ASP.NET, HTML, JavaScript, MSSQL Server 2005, MS Visual Studio, SSIS, MS BizTalk Server, MS Commerce Server and MS Windows 2003/XP/2000/95/98/NT.

Confidential

MS SQL Server Database Developer/Administrator

Responsibilities:

• Responsible for the system design and database design.
• Interacted with Client Engagement managers.
• Created the installation scripts, including the base installation scripts to create the tables, indexes, stored procedures and initial data.
• Wrote SQL Queries, Stored Procedures, Views and Functions and Cursors as needed.
• Performed performance tuning at the query and index level.
• Responsible for Backup (Complete and Differential) and Restoring.
• Used BCP utility/DTS Tool for importing and exporting of data.
• Created and generated periodic reports.
• Implemented performance tuning tips to get the best performance out of SQL Server.
• Implemented the change requests as required, done unit and integration testing.

Environment: ASP, HTML, JavaScript, MSSQL Server 2000/2005, MS Visual Studio, Visual Basic, MS Exchange Server 2000, MS Visio, DTS, BCP Utility and MS Windows 2003/XP/2000/95/98/NT.

Confidential

MS SQL Server Database Developer

Responsibilities:

• Responsible for the system design and database design.
• Wrote SQL Queries, SQL Stored Procedures, Views, Functions and Cursors as needed.
• Used BCP utility/DTS Tool for importing and exporting of data.
• Performed daily backups and restoring of data when ever necessary.
• Implemented change requests as required and performed unit testing and integrating testing.

Environment: ASP.NET, C#, HTML, JavaScript, MS SQL Server 2000, MS Visual Studio.NET, Visual Basic, MS Exchange Server 2003, Microsoft Visio, DTS, MS SQL Server 2000 and MS Windows 2003/XP/2000/95/98/NT.

Confidential

Responsibilities:

• Responsible for the system design and database design.
• Wrote SQL Queries, SQL Stored Procedures, Views, Functions and Cursors as needed.
• Implemented the Change Requests as required.
• Performed unit testing and integration testing.

Environment: ASP.NET, C#, HTML, JavaScript, MS SQL Server 2000, MS Visual Studio.NET, DTS, SQL Profiler, Execution Plan, SQL Server Agents, MS SQL Server 2000 and MS Windows 2003/XP/2000/95/98/NT.

Confidential

Programmer Analyst

Responsibilities:

• Responsible for the database design.
• Performed coding and wrote SQL Queries, Cursors, views and SQL Stored Procedures.
• Implemented the change control requests as required.
• Performed unit testing and integration testing.

Environment: Visual Basic 6.0, Crystal Reports, MSSQL Server 2000 and Windows 2000/95/98/NT.

Confidential

Software Programmer

Responsibilities:

• Responsible for system design and database design.
• Performed database design and wrote SQL Queries and Stored Procedures.
• Developed client application using MS Visual Basic 6.0.
• Performed coding and unit testing.

Environment: ASP 2.0, Visual Basic 6.0, Crystal Reports 5.0, HTML, JavaScript, Macromedia Dreamweaver, MS Visual Studio, MS SQL Server 2000, PC/LAN and Windows 2000/95/98/NT.

Confidential

Responsibilities:

• Performed database design and wrote SQL Queries and Stored Procedures.
• Performed coding and unit testing.

Environment: VB 6, Crystal Reports 4.5, MS SQL Server 2000, PC/LAN and Windows 2000/95/98/NT

Confidential

Trainee

Responsibilities:

• Performed database design and wrote SQL Queries and Stored Procedures.
• Performed coding and unit testing.

Environment: Java, Java Servlets, Java Script, HTML and MS Visual Studio, MSSQL Server 6.5, PC/LAN and Windows 95/98/NT.