PROFESSIONAL SUMMARY

• Extensive experience in Performance Tuning using SQL Profiler and Query Plan
• Extensive experience with Replication.
• Extensive experience in transferring data between servers using SSIS, BCP and DTS
• Extensive experience in various High Availability technologies such as Log Shipping, Clustering and Database Mirroring
• Extensive experience with SQL database Administration that includes SQL Server Installation, Upgrades, Disaster Recovery, Capacity Planning, Backups and Recovery
• Over 8 plus years of extensive experience with Designing, Developing and Implementing applications using SQL Server 2000/2005/2008/2008R2/2012
• Extensive Experience working with OLAP and OLTP applications, cubes, star schema and crystal reports
• Developed reports using SSRS

• Experience in VB.NET, C , ASP.NET, ADO.NET and Web Services
• Good team player with excellent oral, verbal, documentation and interpersonal skills

TECHNICAL SKILLS

• RDBMS: MS SQL Server 2000/2005/2008/2008R2/2012, MySQL, Oracle 9i/10g
• Operating System Windows 2000/2003, Linux, HP-UNIX
• .NET Technologies: ASP.net, C , VB.net
• Database Tools: SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, SSRS, SSIS, SSAS, Backup Server, Replication server, OLAP Services, SQL Agents, SQL Alerts, SQL Jobs, Replication tools
• Programming Languages: C, C , Java
• Web Technologies: HTML, DHTML, CSS, Java Script, AJAX, VB Script, XML, SOAP, IIS
• Database Access Technology: ADO.NET, DTS
• Design and Development: Visual Studio 2008/2005/2003, Visual Studio 6.0
• Reports: SSRS, Crystal Reports, Cognos Reporting tool

EXPERIENCE

Confidential

SQL Server DBA

Responsibilities:

• Developed reports using SSRS
• Scheduled Backups of databases and recovered them periodically to verify integrity of Backups
• Provided support to 75 database Servers. Support included Production, QA and Development
• Upgraded databases from 2000 to SQL 2005 and SQL 2008/2008R2/2012
• Installed and Configured SQL Server 2005/2008/2008R2/2012 on Stand-Alone and Active/Passive clusters on Windows 2003.
• Provided 24x7 support
• Worked on Performance Tuning and Optimizing Queries by analyzing Execution Plans and Re-designing Indexes.
• Developed SSIS packages to transform data between various data sources
• Imported and exported data from heterogeneous sources using various techniques like BCP and DTS
• Wrote complex T-SQL queries and Stored Procedures for the reports
• Configured and administered Transactional Replication
• Involved in Capacity Planning and adding new storage space as needed
• Worked in evaluating various high availability technologies such as Log Shipping, Clustering and Database Mirroring
• Configured Linked Servers to Oracle
• Managed Security by creating login/groups and assigning appropriate permissions
• Provided Secondary Support to IIS Web Servers.
• Involved in troubleshooting front end applications designed in ASP.NET for connectivity issues and backend performance issues
• Prepared Documentation for database, procedures and views

Environment: SQL Server 2005/2008/2008R2/2012, Cognos, .NET Framework, Visual Studio 2005, ASP.NET, ADO.NET, WINDOWS 2000/2003

Confidential

SQL Server DBA/Developer

Responsibilities:

• Provided support to 50 database Servers. Support included Production, QA and Development
• Managed the complete migration of SQL Server 2000 databases to SQL Server 2005
• Managed the complete migration of SQL Server 2005 databases to SQL Server 2008
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Created SSIS Packages to import xml data daily from Web services to SQL Server and to export database updates back to Web Services in xml format
• Provided organizational reporting and timely reports utilizing SSRS SQL Server Reporting Services
• Integrated SharePoint with SSRS and managed reports subscriptions, delivery, generation, rendering, and snapshoting via SharePoint User Interface.
• Created star schema in SSAS and developed SSRS reports based on the cubes.
• Created several cubes in SSAS and build lot of MDX queries to query cubes and to access cube's data
• Developed several database structures, complex SQL queries, stored procedures, views, triggers and user-defined functions.
• Managed Query Optimization and Performance Tuning of Stored Procedures, Functions etc
• Managed production servers with multiple databases, with a couple over 3 terabytes both in clustered environment with mirroring and replication
• Wrote triggers After and Instead Of and stored procedures to capture updated and deleted data from OLTP systems.
• Responsible for performance tuning of stored procedures using SQL Profiler and Database tuning wizard.
• Implemented Log Shipping and Transactional Replications as part of disaster recovery plans.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans with SSIS for proactively monitoring the performance of SQL Server databases
• Scheduled jobs for backup, and created alerts for error reporting.

Environment:

SQL Server 2005/2008,SSRS 2008/2005,SSIS 2005,SSAS, T-SQL, ODBC, Excel, Access, Windows 2000/XP, IIS 5.0

Confidential

SQL DBA/Developer

Responsibilities:

• Scheduled Backups of databases and recovered them periodically to verify integrity of Backups
• Worked on Migration from SQL Server 2000 to 2005
• Installed SQL Server 2000/2005 on Stand Alone and Clustered Environments on Windows 2000/2003
• Wrote complex T-SQL Scripts for generating reports
• Wrote stored procedures and designed triggers
• Worked in evaluating various high availability technologies such as Log Shipping, Clustering and Database Mirroring.
• Involved in performance tuning issues by running Profiler Trace and analyzing the output
• Ensured Security by defining access control to data
• Generated reports using SSRS
• Designed and developed DTS packages for data import and export
• Configured Linked Servers
• Worked on OLAP and OLTP
• Interacted with development and testing team
• Importing and exporting of Databases using various techniques like BCP, DTS
• Analyzed and Installed Security patches as required

Environment: SQL Server 2005, .NET Framework, ASP.NET, ADO.NET, WINDOWS 2000/2003

Confidential

SQL DBA

Responsibilities:

• Provided support to 32 production database servers including active/active and active/passive clusters.
• Configured and administered Replication in SQL Server 2000
• Planned and Worked on Migrations from SQL Server 6.5/7.0 to SQL Server 2000.
• Provided 24x7 Support
• Scheduled Backups of databases and recovered them periodically to verify integrity of Backups
• Involved in Performance Tuning using performance monitor and SQL Profiler
• Designed Logical and Physical model using Erwin
• Involved in Capacity planning for Database Servers
• Tuned Queries and Stored Procedures
• Used Constraints and Triggers to enforce Business rules
• Designed and Redesigned Indexes.
• Involved in resolving Deadlocks
• Managed Security by creating login/groups and assigning appropriate permissions
• Installed and Configured MS SQL Server 2000 in Stand Alone and clustered environment

Environment: SQL Server 2000, .NET Framework, ASP.NET, ADO.NET, Erwin tools, WINDOWS 2000/2003.

Confidential

SQL Developer

Responsibilities:

• Involved in analyzing the requirements
• Involved in designing the database
• Tuned indexes for effective retrieval of data
• Involved in writing Stored Procedures and triggers for efficient retrieval of data
• Involved in writing complex T-SQL queries
• Provided the critical database stored procedures using ADO for SQL Server 2000
• Used the ODBC interface to connect with the SQL server database

Environment: SQL Server 2000, ASP and VB.