SUMMARY

• Around 8+ years of IT experience in SQL Server Administration with 32bit, 64 - bit Microsoft SQL SERVER in Production, Development and Testing in Clustered and Stand alone Server Environment.
• Experience installing MS SQL SERVER 2000, 2005, 2008, 2008R2, 2012, 2014; updating with hot fix and service packs.
• Strong understanding of RDBMS, Normalization/De-normalization as well as Data Modeling Concepts.
• Solid experience and outstanding knowledge on High availability (HA) &Disaster recovery solutions (DR) - log shipping (With Monitor Server Instance), Mirroring (High safety and High performance), Replication (Snapshot & Transactional) and Clustering (Active-Passive and Active - Active).
• Well Experience in file and file group’s management and Supported for very Large databases (VLDB) up to4TB and Complex Databases.
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.
• Implemented In-place and Side by Side Migration of MS SQL SERVER 2000/20 and 2014.
• Experience in implementing T-SQL (DDL, DML), stored procedures, triggers and user defined functions (UDF).
• Experience on Always on availability groups in SQL 2012.
• Upgraded databases from MS SQL Server 2008 to MS SQL Server 2012/2014, MS SQL Server 2005 to MS SQL Server 2008 and MS SQL Server 2000 to MS SQL Server 2005.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Good at SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Experience in Change Data Capture (CDC) to track important tables for clients.
• Experience in Index Maintenance, Index tuning, Rebuild & Reorganizing according to Indexfragmentation, running DBCCchecks, Update Statistics to checkData Integrity.
• Expert level skills in Objects creation such as Table, Views and Stored Procedures,Normalization, Indexes, Cursors, Triggers and other SQL joins and query writing.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in Data partitioning for large tables to increase performance by paralyzing the I/O.
• Experience in performing database regular Backups (Full/Differential/Transaction Log Backups into Disk and striping for large Databases) and Restoring on requirement.
• Experience in SQL Upgrades SQL 20 /2014 and Building SQL Clustering.
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis.
• Experience in comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
• Experience in importing the SQLPS module and also in running windows Power-Shell from SSMS. Used the database engine cmdlets.
• Experience in Backing up, restoring the data base manually and automation of administrative tasks like creating Maintenance plans, creating Jobs, Alerts using SQL Server agent and monitoring and troubleshooting the jobs.
• Expert in analyzing the execution plan and index management for better Query Optimization.
• Extensively worked on Backups, Managing server and client Connections.
• Explicitly used third party tools like Lite Speed, and Red gate.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Experience in using DMV and dynamic management functions (DMF) Of Tables, Triggers, Store Procedure etc for finding out long running queries.
• Experience in moving system databases and user databases when needed.
• Auditing of database for users transaction, login and database action and removing orphan users.
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers.
• Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases and security principals.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files and loading into SQL server.
• Experience in creating deployment utility to deploy SSIS packages over Production, QA and Local System.
• Expert in creating SQL Server Reports using SSRS 2012.
• Extensive experience in the development of Reports using SQLServer 2000/2005/2008/2012 Reporting Services (SSRS) and Microsoft Access and developed Custom Report and different types of Tabular Reports, Matrix Reports, and drilldown reports in multiple formats using multi - dimensional objects.
• Strong ability in Scheduling and deploying reports on Report manger.
• Experience working with change control process.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning, ability to easily and effectively interact with technical, non-technical, and business staff at all levels.

TECHNICAL SKILLS

Project Domain: Application Development, Systems Integration and Database,Administration of MS SQL Server 2014/2 /2000/7.0

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

ETL Tools: Data transformation services (DTS), SQL Server bulk insert and BCP utilities.

Tools: DTS, Lite-Speed, Spotlight, Visual Studio 2003/2005/2008/2010/2012/2013 , Team Foundation Server (TFS), Enterprise manager, Performance counters, SQL Profiler and Red gate.

Databases: SQL Server 2014/2012/2008 R 2/2008/2005/2000/7.0 , MS Access.

Skills: Designing and developing Databases in MS SQL Server 2000, 2005, 2008 R2,2012

Business Intelligence: SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).

Languages: T-SQL, PL/SQL, C, C++, HTML, XML.

Packages: Microsoft Office 2013/2010/2007/2003/2000

Operating Systems: Windows NT/2000/XP/VISTA/ 2003/2008/2011/2012 , Unix

PROFESSIONAL EXPERIENCE

Confidential, ATLANTA, GA

Senior Ms SQL Server DBA

Responsibilities:

• Installed and administrated SSRS 2008/2008r2/2012/2014on Windows Server 2008 r2 64 bit SSRS 2008/2008r2/2012 on Windows Server 2008 r2 64 bit.
• Performed migration from SQL Server 2000 databases to SQL Server 2008 R2 on Windows 2003.
• Configured the Transactional and Merge replication in SQL Server 2008 R2 instances.
• Performed the data compression and databases backupcompression in SQL Server 2008 R2.
• Database Administrator, Database Programming.
• Relocation of Databases from one server to another server using attach and detach databases.
• 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.
• Upgrading SQL server versions and applying patches and hot fixes.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Migrated DTS packages from Legacy system to SQL SERVER 2008.
• Using the Lite speed to take backups.
• Implemented log shipping between two instances of servers using Database Maintenance Plan.
• Configured and Maintained High Availability and disaster recovery Setups (Always On, Transactional Replication, 2 nodes and 3 node clustering, Mirroringand Log Shipping).
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Recovering the databases from backup in disasters.
• Maintaining the database consistency with DBCC at regular intervals.
• Used DTS packages to move logins and jobs from one server to another server.
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flowand Data Flow Tasks with ETL Tool.
• Transferred data (ETL) to Data ware house Environment using SSIS.
• Monitoring SQL server performance using profiler to find performance and Dead locks.
• Maximum performance and uptime in production environment.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings to resolve various resource allocation&memory issues for SQL Server databases .
• To perform installations &performance tuning, manage capacity planning& user accounts, and implement database security for multiple instances of development,, QA, and production SQL Servers databases.
• Planned and implemented Data Compression, Transparent Data Encryption (TDE), Resource Governor, Policy Based Management, Backup Compression and Change data capture(CDC).
• Provided on-call 24/7 support regarding production-related database problems.

Environment: SQL Server 2008/2012 with clustering, Replication, T-SQL, Windows bit, Profiler, Visual Studio Management, ETL tools, Red gate .

Confidential, SANTANA, CA

SQL Server DBA

Responsibilities:

• Installed and administrated SSRS 2008/2008r2/2012 on Windows Server 2008 r2 64 bit SSRS 2008/2008r2/2012 on Windows Server 2008 r2 64 bit.
• Installed Service packs and hot fixes on to cluster and standalone environment.
• Installed SQL SERVER 2008/2008r2 FAILOVER Cluster and standalone installation on Windows Server 2008 r2 64 bit system and Hyper - V in PROD/TEST/DEV fromscratch.
• Migrated SQL Server /2008 databases to SQL Server 2012.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent and Database Engine Tuning Advisor
• Configured Linked servers between different servers.
• Implemented T-SQL features like Data Partitioning, Error handling and Snapshot Isolation.
• Created complex Stored Procedures, Triggers, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.
• Managed database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications.
• Involvedinup gradation of Touch works Database.
• Implemented SQL Logins, Roles and Authentication modes as a part of Security in SQL Server and SSRS.
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Tuning the SSRS and long running ETL queries.
• Resolved bottlenecks and provided Root Cause Analysis for DB related issues.
• Supported Windows Team SAN Migration by moving the User Databases.
• Developed stored procedures and triggers for data porting for very large databases.
• Used DMV’s and DMF’s for the performance of data collection and monitoring.
• Configured and Maintained High Availability and disaster recovery Setups (Always On, Transactional Replication, 2 node and 3 node clustering, Mirroring, Log Shipping)
• Worked with SQL Server 2012 in place and side by side upgrade from SQL server 2008.
• Worked on Project for setting up DB mirroring and troubleshooting.
• Successfully implemented the Capacity planning for different servers.
• Creating and Maintaining Database Maintenance Plans.
• Installed and configured SQL Server clustered databases.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Modifying Stored Procedures and complex T-SQL Queries to improve query execution process.
• Installed and Configured SSRS and Deploying SSIS packages.
• Performed BCP failover exercises for Log shipping and mirroring.
• Maintaining the database consistency with DBCC at regular intervals.
• Used 3rd party tools like Lite Speed, and Spot light.
• Monitoring servers by checking Error Logs and Windows Logs.
• Managing schema objects, such as tables, indexes, and views.
• Performed data base Backups (Full/Differential/TransactionLog Backups into Disk) and restoring on requirement.
• Resolving performance issues using DMVs (Dynamic Management View).
• Performed Query optimization and achieved Performance by tuning SQL queries using Profiler and Execution Plans.
• Provided on-call 24/7 support regarding production-related database problems.

Environment: MS SQL Server 2008 MS Access, DTS, SQL Query Analyzer.

Confidential, SAINT LOUIS, MO

SQL Server DBA

Responsibilities:

• Supporting Microsoft approved SQL technologies like SQL Server 2005, SQL 2008, 2008
• Design, implement and maintain 100 database servers.
• Prepared and planned index optimization jobs on non-production and production environments.
• Defined and developed strategies for patch upgrades, rolling patches and rolling upgrades in Clustered Environments.
• Planned and configured Disaster Recovery between data centers in various locations by Clustering, Log-shipping, Mirroring and Replication.
• Continuous check of databases health and taken necessary steps to fix consistency errors.
• Prepared backup and restore backup processes using Lite Speed and scheduled automated jobs.
• Recovered data for objects using object level recovery of Lite Speed.
• Used index tuning wizard and profiler extensively to fix performance issues.
• Trouble shooter job failures and provided permanent fix.
• Prepared root cause analysis for issues and documented.
• Generate daily database reports and provide builds status to counties.
• Implemented Backup, Restore, Recovery, Update statistics, Rebuilding, Reorganizing indexes, and defragging strategies.
• Used dynamic management views to find and solve Performance Issues of databases.
• Documented processes and procedures.
• Successfully implemented the Capacity planning for different servers.
• Creating and Maintaining Database Maintenance Plans.
• Installed and configured SQL Server clustered databases.
• Modifying Stored Procedures and complex T-SQL Queries to improve query execution process.
• Created Linked servers between non-production to production and vice versa.
• Maintained database User Permissions, server Logins and Security standards across all databases.
• Monitored Event Viewer, SQL Error logs and Log Files Viewer for errors and provided fix.
• Worked in 24/7 environment to maintain and administer databases also to fulfill user requirements.

Environment: SQL Server 2005/2008, Visual Studio Management, Transact-SQL, Enterprise Manager, Query Analyzer, MS-ACCESS and Windows 2003.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Performed backup/restore, created database objects such as tables, procedures, constraints, indexes and views, user security management.
• Designed database tables and relations between them through Normalization. Involved in project planning, scheduling for database module with project managers.
• Responsible for developing processes, automation of maintenancejobs, tuning SQL Server, indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification.
• Wrote complex SQL queries using joins, subqueries and correlated sub queries to retrieve data from the database.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency.
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimizeperformance.
• Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning and optimizing indexes using Performance Monitor, Profile and Index Tuning wizard.
• Experience on Import / Export using DTS and BCP utility.
• Worked as a developer in creating complex Stored Procedures, Functions, Triggers, and Views.
• Involved in Database designing, Logical and Physical Data modeling.
• Transformed logical model into Physical SQL Server Database.
• BCP, Bulk-Copy, Select into are used to move data between data files and databases.
• Monitoring/troubleshooting the existing DTS packages.

Environment: SQL Server 2005, Visual Studio Management, Transact-SQL, Enterprise Manager, Query Analyzer, MS-ACCESS and Windows 2003.