Summary

• Almost 8 years of IT experience in SQL SERVER Database Development, System Analysis, Design, and Administration Support in Production, QA, Replication and Cluster Server Environments.
• Experience in installation and configuration of MS SQL Server 2012/2008 R2/2005 versions.
• Experience in Migration from SQL Server 2000 to SQL Server 2005/2008 R2 as well as DTS Exchange tool for migrating DTS packages to SSIS packages.
• Experience in up gradation/Migration of MS SQL Server 6.5/7.0 to MS SQL Server 2000 and now 2000 to 2005 and 2008 by in place upgrade process and Side by Side process
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS utility. Extracting, Transforming and loading of data using SQL Server DTS.
• Experience in IIS, MTS, and Windows NT administration.
• Experience with upgrades and service pack installations Tuning and normalization.
• Expertise in planning and implementing MS SQL server security and database permissions
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Extensive experience with Storage Capacity planning, including system storage allocation, on-going capacity analysis and planning future storage requirements.
• Hands on experience and outstanding knowledge in high availability solutions, including SQL Server Always on, Clustering, Replication and Log shipping.
• Managed the multiple databases DB under clustered active/active, active/passive and implementing RAID technology.
• High level proficiency with various types of Replication Models such as Snapshot, Transactional and Merge Replication Planning, Replication Tools, Implementing Replication .
• Experience in Extraction Transformations and Loading ETL tools like Data Transformation Services DTS , Bulk Insert, and BCP for OLTP and DSS Data Mart/Data Warehouse environment.
• Extensive knowledge of Relational Database Management Systems.
• Proficient in monitoring SQL Server Performance using SQL Profiler Dead Locks/Long running queries , Query Analyzer, Index Tuning Wizard, Database Engine Tuning Wizard and Windows Performance Monitor.
• Good experience in monitoring Windows and SQL Server error logs.
• Experiences in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC, resolve Dead Locks/Long running queries.
• Design entity relationship diagrams and dimensional data models.
• Proficiency in web-tier development using HTML -proficiency in middle-tier and back-end programming using SQL.
• In depth knowledge of developing complex stored procedures, views, efficient triggers, required functions, and creating indexes and indexed views using SSMS and SQLCMD.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures and triggers through query analyzer

• Experience in implementing business logic using Triggers, Views and Stored procedures.
• Managed day-to-day User activities like creating logins, granting permissions, applying security for new users and creating user Roles and Role Members to ensure Security.
• Supported the deployment of SQL Server 2005/2008 and SSIS Integration Service for ETL activities .
• Expert in Data Extraction, Transforming and Loading ETL using various tools such as SQL Server Integration Services SSIS , Log Shipping, DTS, Bulk Insert and BCP.
• Created DTS and SSIS Package designs for Import/Export from accesses, oracle to SQL Server.
• Self-motivated and Flexible to adapt to any new environment and work on any project.
• Worked as a team member to provide 24x7 on-call production database support.

Skill Set

PROFESSIONAL EXPERIENCE:

Confidential

• Managed and Administrated the SQL Server 2008 and 2012 production and Non-production servers.
• Installation of SQL Server 2012 on Windows Server Clustered environment.
• Prepared maintained and modified SQL server installation and configuration documents.
• Migrating SQL Server 2008 databases to SQL server 2012 databases
• Maintenance of database security by creating groups and logins and providing the necessary permission to the end users.
• Monitored DB Mirroring/ Transactional Replication and trouble shooting of errors.
• Subscribe SQL Server Azure Cloud Services.
• Create Database s on SQL AZURE.
• Create, manage SQL Server AZURE Databases
• Performing Database backups using PowerShell.
• Checking the status of the services on remote server using PowerShell.
• Finding out the list of DB's using PowerShell.
• Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Performed backups and restoration when necessary. Testing the backup and restoration plans.
• Performed backup using backup compression and Data compression in SQL Server 2008 on clustered environment.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• To set up SQL Server configuration settings to resolve various resource allocation memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Handled numerous change management requests on production servers
• Supported 24 X 7 Production environment

Confidential

SQL Server DBA

• Installation of SQL Server 2012/08 on Standalone and Windows Server Clustered environment.
• Prepared, maintained and modified SQL server installation and configuration documents.
• Upgraded/Migrated SQL Server 2005/2000 databases to SQL Server 2008 databases.
• Perform capacity planning and/or management on system and database resources based on current applications and utilization rate.
• Provide Support to DR setup and testing.
• Experience in setting up the SQL Server Always on for high availability for Lab systems.
• Setting up and Monitored transactional replication, Database mirroring on Production, QA and Dev servers.
• Created SSIS packages to load robust data from different Heterogeneous data sources like Access, Excel to SQL server.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• Used SQL Server profiler to troubleshoot the performance issue or monitoring a server in real time.
• Managed Security using SQL Logins, Roles and Security Modes for various users.
• 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.
• Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Performed backups and restoration when necessary. Testing the backup and restoration plans.
• Performed backup using backup compression and Data compression in SQL Server 2008 on clustered environment.
• Involved in implementing the security patches to the database servers in order to main the appropriate security measures.
• Handled numerous change management requests on production servers.
• Provided 24/7 support in weekdays and weekends.

Confidential

SQL Server DBA

Responsibilities:

• Administered the SQL server 2012 by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Involved in the Backup of the databases.
• Development of automated daily, weekly and monthly system maintenance tasks such as database upgrading and indexing updates and apply in development and Testing Environment.
• Involved in SQL server Cluster and Database Mirroring implementation.
• Involved in general Database administration, query performance tuning and validated some of the existing schemas.
• Deployed and monitored the snapshot and transactional replication on the testing and development servers.
• Refresh the database from production to development and staging environment on daily basis.
• Created permanent tables, temporary tables and table variables.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services SSRS .
• Using Activity Monitor to identify and resolve Blocking and Deadlock issues.
• Worked on SSRS to generate drill-down, drill-through and ad-hoc reports.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Experience with dropping and recreate the tables for the damaged databases to avoid data loss.
• Conducted design reviews with users/team for development and production strategies.

Environment: MS SQL Server 2008/20012, T-SQL, SQL Profiler, DTS, XML, MS Office, Windows 2000/2003 and SSRS.

Confidential

SQL Server DBA Developer

Responsibilities:

• Migrated Databases, DTS packages, from MS Access to SQL Server 2008.
• Involved in creating Schemas, Logins, Tables, Views, Functions and Stored Procedures.
• Involved in general Database administration, query performance tuning and validated some of the existing schemas
• Administered databases in Prod, Qual, Test and Development regions.
• Administered the SQL server 2000/2005/2008/2012 by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• User management by assigning appropriate permissions to the database users.
• Monitored, Scheduled jobs and alerts and did troubleshooting when failed on daily basis.
• Expertise in Setting up database backup and recovery procedures for production, QA and development servers
• Implemented different types of Replication Models such as Transaction, Snapshot and Merge replication in SQL Server 2000 and SQL Server 2005 in OLTP Environments.
• Involved in setting up, managing and maintaining Log shipping and Database Mirroring.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification and indexing updates and apply in development and Testing Environment.
• Experience with Dropping and recreate the tables for the damaged databases to avoid data loss.
• Refresh the database from production to development and staging environment on daily basis.
• Developed physical data models for database schema and objects.
• Responsible for developing, monitoring and deploying SSIS packages.
• Loaded data from various sources like excel files, to SQL Server database Using SSIS Package.
• Created permanent tables, temporary tables and table variables.
• Conducted design reviews with users/team for development and production strategies.
• Working with the Access database users in fixing the issues for day to day operations.
• Prepared the Flow diagrams by using MS Visio to indicate the dataflow between the tables in MS Access and SQL server databases.

Environment: MS SQL Server 2005/2008, SSIS, Active / Passive, T-SQL, DTS, XML, MS Office and Crystal Reports 9.0.

Confidential

SQL Server DBA

Responsibilities:

• Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
• Installation of SQL Server 2008/05 on Windows Server Clustered environment.
• Prepared maintained and modified SQL server installation and configuration documents
• Upgraded/Migrated SQL Server 2005/2000 databases to SQL Server 2008 databases and mentored Jr.DBAs and other technical staff.
• Migrated SQL Server 2000 databases to SQL Server 2005 databases including DTS to SSIS packages.
• Performed backup using backup compression and Data compression in SQL Server 2008 on clustered environment
• Handled up to 2.5 TB Size databases with clustered environment.
• Application support for front end feeds.
• Good knowledge in developing and designing reports through SSRS and Excel.
• Setting up and Monitored transactional replication, Database mirroring on Production, QA and Dev servers.
• Monitored DB Mirroring/ Transactional Replication and trouble shooting of errors.
• Involved in developing Cubes in Business Intelligence Development Studio using SSAS.
• Managed Security using SQL Logins, Roles and Security Modes for various users.
• Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Analyze execution plans and generate suggestions for improvement.
• To set up SQL Server configuration settings to resolve various resource allocation memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.
• Monitoring SQL Server logs to ensure whether the backup operations, batch commands, scripts have completed successfully.
• Handled numerous change management requests on production servers
• Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.
• Created SSIS packages to load robust data from different Heterogeneous data sources like Oracle, DB2 to SQL server.
• Created, scheduled database maintenance plan using SSIS Maintenance plan task.
• Configured and deployed SSIS Packages from Test to Production Environments.
• Created, deployed and managed reports using SQL Server Reporting Services SSRS
• Used Online Indexing and online Restoring in SQL 2005.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas
• Supported 24 X 7 Production environment

Environment: SQL Server 2000/2005/2008 Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services DTS , MSSQL Server2000 Analysis Server

Confidential

SQL Server DBA Developer

Responsibilities:

• Prepared maintained and modified SQL server installation and configuration documents.
• Installation of SQL Server 2008 on Windows Server Clustered environment.
• Managed and Administrated the SQL Server 2008/2005 production servers.
• Handled up to 2.2 TB Size databases with clustered environment.
• Data Migration from Legacy system to SQL Server 2008 using SSIS packages
• Upgraded/Migrated SQL Server 2005 databases to SQL Server 2008 databases and mentored other technical staff.
• Performed backup using backup compression and Data compression in SQL Server 2008 on clustered environment.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Monitored transactional replication on Production, UAT, QA and Dev servers.
• Used SQL Server 2008 Activity Monitor When troubleshooting a performance issue or monitoring a server in real time.
• Implemented new features in SQL 2008 like Policy based Management, Table Compression backup compression, SQL Server Auditing, Resource Governor and MERGE statement in T-SQL.
• Created SQL Server Audits in developing a risk mitigation plan to keep the environment secure.
• Designed a centralized data repository for storing performance data called management data warehouse and used the fully extensible performance data collection and warehouse tool the 'data collector'.
• 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.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• Managed Security using SQL Logins, Roles and Security Modes for various users.
• Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Handled numerous change management requests on production and UAT servers
• Maintaining the database consistency with DBCC utility at regular intervals.
• Provided documentation for SQL configuration, and Performance measures.
• Designed Daily , Weekly and Monthly checklists for the database and server
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas
• Involved in Source Data Analysis, analysis and designing mappings for data extraction
• Created, deployed and managed reports using SQL Server Reporting Services SSRS
• Created and managed financial reports using SSRS
• Evaluated data storage considerations to store databases and transaction logs.
• Review of Technical and Functional High Level Documents HLDs .
• Developing Test cases for the Interfaces.
• Involved in Batch Processes

Environment: SQL Server 2008/2005 SSMS, SQL Profiler, Index Tuning Wizard, Data Transformation Services DTS , SSRS, SSIS , Snap Manager for SQL

Confidential

SQL Server DBA Developer

Responsibilities:

• Installation and Configuring the MS SQL Server 2005.
• Involved in designing the data model for a normalized database.
• Designed database for implementing Notification Services in SQL Server 2005.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and scripting/data Migration with SQL server Export Utility.
• Involved in performing Extraction, Transformation and Loading using DTS.
• Developed all the required stored procedures, user defined functions, triggers using T-SQL.
• Involved in creating normalized Databases, creating objects, sizing temp databases.
• Designing, programming and managing data interfaces, data validation and providing with data modeling.
• Experience in performance tuning, backup and disaster recovery processes and tools.
• Performance and tuning of SQL servers and application issues related to migration.
• Testing of applications for performance, data integrity and validation issues.
• Data Transfers between various servers using BCP.
• Assisting developers with code enhancements, indexing the tables properly.
• Writing the stored procedures, checking the code for efficiency.
• Database monitoring using system tools.
• Administrative and Production support for various applications in all environments.
• Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures, and Contingency plans. Testing and implementing these procedures.
• Routine backups and restoration when necessary. Testing the backup and restoration plans.

Environment: MS SQL Server 2000, Windows 95/98, Windows N.T 4.0.