SUMMARY:

• Extensive experience developing and working with diverse collection of applications and Around 9+ years of professional experience as Microsoft SQL server database administration and developer.
• Extensive experience in maintaining Very large databases (VLDB) and highly transactive production servers in SQL Server … environments.
• Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication (Snapshot and Transactional with updatable subscriptions), Log shipping, Clustering (Active - Active and Active Passive) and Database Mirroring
• Experience working on SQL Server 2008 R2
• Handful of Experience on SQL server 2008 new features like Microsoft SQL multi server administration, resource governor, performance data collector.
• Experience in Migrating from SQL server 2000 to 2005 and … to 2008R2 by using side-by-side upgrade process, and documented the Upgrade Process.
• Extensively worked on Backup compression and data compression in SQL Server 2008.
• Experience configuring and working Microsoft SQL server 2005, Microsoft SQL Server 2008 on VMware Environment. Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Configuring more than 2GB RAM for 32-bit and 64-bit systems using AWE switches.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing, MSSQL Databases, Analysis Services (SSAS), Reporting Services (SSRS), Notification Services (SSNS) and MDX ad-hoc Reporting.
• Expertise on physical storage SAN configuration on different RAID levels.
• Excellent backend skills in creating SQL objects like tables, synonyms, stored procedures, views, Indexes, triggers, rules, defaults, user defined data types and functions.
• Hands on experience with administering large databases, managed databases of size above 2 terabytes, database design, normalization and database application development using varied development tools.
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, horizontal and vertical partitioning.
• Experience in configuring and managing Linked Servers. Data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
• Experience in trouble shooting sql server jobs, and job monitoring tool.
• Good at Data availability solutions like Online Restore, Online index Operation, Database Snapshot, and Fast Recovery.
• Auditing of database for users transaction, login and database action and removing orphan users.
• Expertise in using DBCC trace flags, handling blocking and dead lock situations.
• Intensive experience in monitoring and tuning SQL Server database performance using SQL Profiler, DMV's, Index Tuning Wizard and Windows Performance Monitor.
• Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Experience in Troubleshooting and documenting root cause analysis.
• Closely worked with development team to assist them in various problems solving and troubleshooting Web-based applications, which calls various Database objects like stored procedures, functions, and triggers.
• Explicitly used third party tools like Litespeed, Fog light and Red gate, Tivoli Storage Manager (TSM).
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Checking the threshold values and baselines and monitoring in perfmon and SCOM.
• Rebuilding indexes with different fill factors and updating statistics.
• 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS:

Databases: MS SQL Server … Oracle, MYSQLLanguages T-SQL, C, C++, C#, vb.net, JAVA, ASP.NET, Visual …

Technologies: VB.NET, .NET FRAMEWORK, ASP.NET, Microsoft Office Suite

Tools: Active X, IIS, MTS, Litespeed, Spotlight, Visual Studio … VSS, Visio 2003, Office Visio 2007, SharePoint Designer 2007, Erwin 4.0,SSIS,SSRS,SSAS,SCOM,Tivoli TSM

Operating System: Windows 2000, Windows NT, Windows Server … Windows …

Others: Microsoft office, Microsoft Project.

WORK EXPERIENCE:

Sr.SQL Server DBA

Confidential, Charlotte, NC

Responsibilities:

• Administrated and Managed SQL Server 2012/2008R 2/ 2008/2005/2000 databases in Production, Staging, QA and development environments.
• Responsibilities include the Production and Application Support for the Database and Application Servers.
• Upgraded/Migrated SQL Server 2000/2005/2008 R2 databases into SQL server 2008R2/2012 and mentored other technical staff.
• Involved in implementation of AlwaysOn Availability Group as a High Availability solution on SQLServer 2012.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Resolving performance issues using DMVs (Dynamic Management Views).
• Used native tools like SQL SENTRY Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning. Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2008/2005 and participated in Disaster Recovery Drill processes.
• Designed and developed a full-scale reporting solution for a multi-client environment using MS SQLServer 2008 and Confidential 2008/2012.
• Created a SSIS replication package from production to 12 pool servers.
• Created, implemented and maintained a reporting suite of over 72 standard reports while also customizing many reports to meet individual client needs.
• Created drill down, drill through, sub and linked reports using Confidential 2008 as well as managed the subscription of the reports.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008/2012 and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.

Sr.SQL Server DBA

Confidential, Charlotte, NC

Responsibilities:

• Installation and Maintenance of SQL Server 2012 and 2008R2 on Test, Development and Production Environments.
• Worked with SQL Server 2008 inplace and side by side upgrade from SQL server 2005.
• Strong experience in working on Very Large Databases (VLDB) over 80 GB for OLTP and 2TB for OLAP databases.
• Implemented Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts, SQLCMD and dedicated admin connection.
• Worked in Active passive cluster environment.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies.
• Successfully implemented the Capacity planning for different servers.
• Creating Logins and Roles with appropriate permissions.
• Creating and Maintaining Database Maintenance Plans.
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Tune slow running queries using SQL Server Profiler.
• Performed data partitioning for efficient management of database tables and indexes.
• Maintaining the database consistency with DBCC at regular intervals
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Managed Disk space, memory and User connections.
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Rebuilding the indexes at regular intervals for better performance.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Monitored and modified Performance using execution plans and Index tuning.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Performance testing on stored procedures, indexes, and triggers.
• Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Experience in applying Service Packs at database and OS Level.
• Technical Analysis, Code Review, Implementation, 24 x 7 production support.
• Experience in using ERWIN tool for Entity Relationship diagrams.
• Checking Database Health by using DBCC Commands and DMVS
• Did Performance Tuning of the Stored Procedures.
• Hands on experience in trouble shooting database issues.
• Update statistics, database integrity check and Backup operations
• Expertise in SQL server Reporting Services(SSRS)

Environment: SQL Server 2012/2008R2/08/05/00, Windows 2003, Windows 2008 Server, MS SQLServer 2000/2005, C#.net, VB and ASP.NET, Redgate, MS Visio, Microsoft SQL server Visual Studio 2005/2008/2010 , MS Business Intelligence Development Studio 2008, FogLite.

Confidential, Jersey City, NJ

Responsibilities:

• Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data.
• Assembled and converted user requirements from multiple clients into our standard reporting solution and customized specific client requests when necessary.
• Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS.
• Converted Confidential 2005 and Excel based reports to Confidential 2008/2012 based reports.
• Worked on TFS for project handling.

Environment: SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS), TSQL, .Net framework, XML, MS Visual, TFS

Sr.SQL Server DBA

Confidential, Boston, MA

Responsibilities:

• Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
• Developed logical design and physical design.
• Administered and maintained production/Development servers with more than 2 TB of database size with complex structures.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Fine tuning of database objects and server.
• Used DTSXchange tool for migrating DTS packages to SSIS.
• Worked with SQL Server 2005 side by side upgrade from sql server 2000.
• Installed couple of SQL Server 2005/2008 on cluster environment.
• Extensively worked on TSM litespeed backup.
• Worked with SQL server Profiler to generate traces.
• Integrated SQl server profiler traces with Performance monitor to have better graphical analysis to find system bottlenecks.
• Identified long running stored procedures and SQLs using profiler and fine tuned for maximum performance.
• Expertise in setting up and troubleshooting Database mirroring.
• Optimized working process.
• Daily routine Developer/DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Use SQL Server RML Utilities to do performance baseline analysis report between the SQL Server 2000 and SQL Server 2005.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot isolation,
• Database mirroring, database snapshot, DDL triggers, try-catch blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts, DTA, SQLCMD and dedicated admin connection.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQLserver 2005.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance
• Extensively working on IMS performance issues like update statistics, rebuilding the indexes at regular intervals for better performance.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Configured up to 32 GB of memory.
• 24/7 on call support, created various jobs to check health of the server and to troubleshoot.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Huge data of Insurance policies and customer information in XML, Flat file data transforming using SSIS Packages.
• Developed SSIS packages, stored procedures, functions, triggers.
• Tuned servers to the peak for maximum performance by configuring memory and various server level parameters.
• Hands of experience in writing batch files.
• Extensively worked on extraction, transformation and loading of data from various data sources to SQL Server.
• Productionised Code and packages per company's policies.

Environment: SQL Server 2008/05/00, Windows 2003, Windows 2008 Server, MS SQL Server 2000/2005, C#.net, VB and ASP.NET, LiteSpeed, MS Visio, Microsoft SQL server Visual Studio 2005/2008, MS Business Intelligence Development Studio 2008, FogLite.

SQL Server DBA

Confidential, Charlotte, NC

Responsibilities:

• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Used log shipping for synchronization of databases.
• Prepared Documentation for the Disaster Recovery plan
• Expertise in SQL server Reporting Services(SSRS)
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Installed couple of SQL Server 2005 on cluster environment.
• Assisted on the Adhoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.
• Extensively worked on trouble shooting and fine-tuning of databases for its performance
• Designed and implemented comprehensive Backup plan and disaster recovery
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQLserver 2005.
• Checking Database Health by using DBCC Commands and DMVS
• Implemented new topics like CLR integration on Development Server.
• Extensively worked on TSM litespeed backup.
• Solving the Bugs and issues reflected by the Testing team.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQLserver 2005.
• Daily routine Developer/DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Worked with Microsoft Visual Studio developing client web applications and windows form applications using C#.NET.
• Managing the VERITAS net backups and Litespeed.
• Monitored the performance of the server and checked the database health with Foglite.
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Working with customers on Application rollouts and server migrations.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non production database code as well as T-SQL code from developers.
• Configured up to 32 GB of memory.
• Worked on call 24/7 Support on weekly basis.

Environment: SQL Server 2000/2005 with clustering, Replication, T-SQL, Windows 2003 64-bit, DTS, SSIS, Red Gate, Profiler, MOM, SQL Sentry, Share Point, Sql Server 2008, Oracle 10g, TFS, LiteSpeed, Foglite.

SQL Server DBA/Developer

Confidential, Dallas, TX

Responsibilities:

• Installation & configuration 2005 enterprise Edition.
• Installed and administered two node cluster Active/passive Migrated DTS packages from SQL Server 2000 to SSIS SQL server 2005.
• SQL 2000, 2005 - Performed installation of SQL Enterprise 2005 64bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers. Patch applications.
• Extensively worked on SQL Server Integration Services (SSIS).
• Migrated databases easily from SQL Server 2000 to SQL Server 2005 by using REDGATE.
• Implemented in new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Managing the VERITAS net backups.
• Designed the reporting databases by using Erwin.
• Transformation of data (Millions of records) to SQL server by SSIS, DTS, BCP.
• Worked with Merge Replication Environment and handled the publication conflicts manually depending on last changed date.
• Worked with Transactional Replication to achieve Load balancing
• Played a key role in business requirements analysis, architecture designs, physical and logical Data modeling, application development by using Erwin.
• Compare and synchronize your database schemas or data by using REDGATE
• ETL experience with SSAS and SSIS.
• Upgraded Sql Server 2000 to Sql Server 2005 using In-Place method.
• Using log shipping for synchronization of database.
• Expert in Using DMV's, Performance dash board, Mirroring, database snapshot.
• Expert in implementing the snapshot isolation and DDL triggers.
• Maintaining the database consistency with DBCC at regular intervals
• Solving the Bugs Reflected by the Testing team
• Rebuilding the indexes at regular intervals for better performance
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Environment: SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003, IIS 6.0, .NET, T-SQL, Microsoft Reporting Service, Microsoft Dynamic NAV 4.0, Cognos 8.0 and ASP.NET.