SUMMARY

• Around 8+ Years of experience in SQL Server Administration, Development, and Database Design in Production, Test and Development environments withMS SQL Server 2014, 2012, 2008R2, 2008, 2005, 2000 environments.
• Experience in installing MS SQL SERVER 2000, 2005, 2008, 2008R2, 2012, 2014 and updating with hot fix and service packs.
• Experience in Performance Analysis and Production Support for very large (VLDB) and Complex Database.
• ImplementedSQL server 2012 technique ALWAYSON for High Availability.
• Extensive experience in implementingHigh Availability & Disaster Recovery Solutions - Log Shipping, Mirroring (High safety and High performance), Replication (Snapshot & Transactional) and Clustering (Active-Passive and Active - Active).
• Expertise in setting up Active/Passive and Active/Active Clusters, Load balancing and Failover for High availability.
• Implemented Inplace and Side by Side Migration of MS SQL SERVER 2000/2005/2008 to 2012 and 2014.
• Expert in developing T-SQL (DDL,DML,DCL) statements.
• Expert in Creating & Debugging Views, Functions, Stored Procedures, Triggers, Optimizing Code, and improving Efficiency.
• Configured teh AWE and /3 GB switch for teh 32 bit 2000/2005 server.
• Good Experience and knowledge in creating and managing User permissions, Logins and setting up security according to business standards.
• Experience in implementing and maintaining SOX controls and best practices for database security under SOX compliance.
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, Index rebuild, reorg, horizontal and vertical partitioning.
• Expertise in analyzing teh execution plan and index management for better query optimization.
• Expertise in using DBCC trace flags handling blocking and dead lock situations and handling teh Isolation Levels and Concurrency TEMPEffects, detect CPU, me/O, Memory bottlenecks.
• Extensively used repositories like Team Foundation Server (TFS), Visual source safe and Clear case for Data Archival.
• Experience in configuring Data Quality Services (DQS), Master Data Services (MDS) and IIS.
• Experience in Scheduling teh jobs and Maintenance plans.
• Extensively worked on Hot, Warm and ColdBackups, Security Management, Managing server and Client connections.
• Very Extensively used teh native tools like SQL Server Profiler, Performance Monitor, Activity Monitor, Index tuning wizard, Database tuning advisor for performance analysis
• Expertise in Data/Table partitioning, Online Indexing, Rebuild/reorg indexes and Update statistics at regular intervals for better performance.
• Implemented Change data capture(CDC)
• Handled Large Databases in Clustered environment using Physical StorageConfiguration and SANOptimization with different RAID Levels.
• Experience onData Transfer from and to SQL Server Databases using utilities/tools likeSSIS, DTS, BCP, BULK INSERTetc.
• Good knowledge of Dimensional Modeling using Star Schema and Snow Flake Schema for faster, TEMPeffective querying and Business Analysis Requirements.
• Good at SQL Server 2008 new concepts like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Good knowledge of Data modelingincluding Physical and logical data modeling using ERWIN, VISIO.
• Experience in using Dynamic Management Views (DMV) and Dynamic Management Functions (DMF) for finding out long running queries and troubleshooting OS and DB level issues
• Configured SMTP Server for Database Mail Setup and received Alerts for teh Threshold values.
• Experience on Migrating DTS packages to SSIS packages; worked on building and deploying SSIS packages and extracting data from various flat files, excel files, legacy systems.
• Good knowledge on developing and deploying OLAP cubes through SSAS.
• Extensive experience in development of reports using SSRS and Microsoft access and developed Custom reports and different types of Tabular Reports, Matrix Reports and Drilldown reports in multiple formats using multi-dimensional objects.
• Hands on experience in working with System Center Operations Manager (SCOM) and Ignite Used third party tools like Lite speed, Red gate, Idera diagnostic manager, Veritas net backup, Fog light, used pragmatic workbench.
• Flexible, Enthusiastic and project oriented team player with excellent communication skills and analytical skills to develop creative solution for challenging client needs.
• Experience in production support, 24 X 7 on call.

TECHNICAL SKILLS

Operating Systems: Windows 2000/2003/2008/2012/2012R2/XP/VISTA/7, UNIX (Sun Solar), LINUX

Databases: MS SQL Server 2012/2008R2/2008/2005/2000/7.0, MYSQL, Oracle, MS Office Access 97/2000/2003/2007.

ETL TOOLS: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)

Data Modeling/Third party tools: Erwin, Red gate, Lite Speed, fog light, Spotlight.

Languages: T-SQL, My SQL, C/C++, javascript, Visual Studio2005/2003, ASP.NET, VB.NET, Shell scripting.

Applications: Microsoft Office Suite, Visual Studio 2005/2008/2010, Visual Source Safe, TFS.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. 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 clustered and stand alone environment.
• Installed SQL SERVER 2008/2008r2/2012 FAILOVER Cluster and standalone installation on Windows Server 2008 r2 64 bit system and Hyper - V in PROD/TEST/DEV fromscratch.
• Migrated SQL Server 2000 /2005/2008 databases to SQL Server 2012, 2014.
• 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.
• Used native tools Profiler, Perfmon and Activity Monitor.
• 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.
• Setup and configures alerts using teh IDERA SQL Diagnostic Manager and IDERA Defragmenter for Index maintenance.
• Developed and deployed OLAP cubes for reporting purposes using SSAS.
• Met SLA’s, fine tuning teh SSRS and long running ETL queries.
• Resolved bottlenecks and provided Root Cause Analysis for DB related issues.
• Supported Windows Team SAN Migration by moving teh User Databases.
• Developed stored procedures and triggers for data porting for very large databases.
• Used 3rd party tools like LiteSpeed, Fog light and DB comparer.
• Monitoring servers by checking Error Logs and Windows Logs.
• Managing schema objects, such as tables, indexes, and views.
• Implemented AWE /PAE switches for SQL Server to grab more than 4 GB RAM
• Performed data base Backups (Full/Differential/TransactionLog Backups into Disk) and restoring on requirement.
• Used DMV’s and DMF’s for teh 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 teh 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.
• Installed and Configured SSRS and Deploying SSIS packages.
• Performed BCP failover exercises for Log shipping and Mirroring.
• Maintaining teh database consistency with DBCC at regular intervals
• Resolving performance issues using DMVs (Dynamic Management View).
• Developed and deployed OLAP cubes for reporting purposes using SSAS.
• Performed Query optimization and achieved Performance by tuning SQL queries using Profiler and Execution Plans.

Environment: MS SQL Server 2000/2005/2008/2012/2014, Windows 2000/ 2003/ 2008/ 2011/ 2012 servers, Outlook Express, .NET, MS Access, ETL, Visual Studio, BIDS, Power Shell, Performance Monitor, T-SQL, Clustering .

Confidential, Minneapolis, MN

Sr.SQL Server DBA

Responsibilities:

• Installed SQL SERVER 2008/2008r2 FAILOVER Cluster and standalone installation on Windows Server 2008 r2 64 bit system in PROD/TEST/DEV on Hyper - V.
• Implemented Transactional Replication for SSRS reports.
• Designed and Automated teh SSRS reportdeployment using Microsoft Utilities.
• Designed tables for teh application Users, Roles and Groups, Application Audit and Triggers.
• Setup Change Data Capture, designed tables to generate data snapshots from teh PAST.
• Installed, Administered SSRS and setup data driven subscriptions.
• Generated reports from SSRS (SQL server reporting services) and SSAS.
• Setup teh DB Mail and Alerts on PROD database servers to send out teh Notifications.
• Used Team City for code deployment Automation and JIRA for source control.
• Implemented Transactional Log shipping and mirroring for database high availability.
• Regularly installed service packs and hotfixes for both clustered and standalone environment.
• Used MS System Center Operations Manager (SCOM)SQL MANAGEMENT PACK 2012 to setup teh server and databaseAlerts.
• Fine tune long running SQL Queries from Application and SSRS.
• Used native tools DATABASE TUNING ADVISOR, PROFILER, PREFMONCE and ACTIVITY MONITOR.
• Developed T-SQL Scripts to scrub PROD data for TEST Environments.
• Updated and Maintained Passwords for teh SQL Server Service Accounts and Application Accounts before Expiration.
• Developed SSRSReports to pull teh application/user data for teh security team.
• Regularly deployed teh reports and configured teh subscriptions for automatedemaildelivery of teh reports.
• Developed SSISpackage to build teh content data for teh application.
• Designed Backup strategy for OLTP system and SetupBackups for point in time recovery.
• Used teh DMVs and DMFs for teh performancedatacollection and monitoring.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure databaseoptimization.
• Expertise in creating and supporting OLAP Cubes.
• Developed stored procedures, functions, triggers in T-SQL and batch scripts.
• Used Red Gate SQL Compare, Visual Studio 2012 for database object and schema compare.
• Provided 24X7 support and team player during production outage.

Environment:Windows 2003/2008/2008R2, SQL 2000/2005/2008/2008R2, T-SQL, Replication, SSIS, SSRS, SSAS Database mirroring, MS clustering, Lite Speed, MOM 2005/2007, SAN and Red Gate.

Confidential, New York, NY

SQL Server DBA

Responsibilities:

• SQL Server 2008 R2/2008/2005 Database Administration.
• Migrated databases from SQL Server 2000 to SQL Server 2005 and 2008 R2.
• Implemented teh disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Installing, Configuring and Maintaining SQL Server 2008R2/2008/2005 (64 bit) on Active/Active Cluster with latest Service Packs, Hot Fixes.
• Worked as Primary DBA for 50 Instances and 70 as Alternate DBA.
• Experience working with CRM Application issues.
• Installed and configured Microsoft SQL2 node Clustering (Active/Passive).
• Created documentation to install SQL Server, apply service pack, hot fix and clustering installation.
• Experience in Database security and integrity planning.
• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
• Deployed multi-campus backup environment based on EMC Data domain storage.
• Installed and configured Storage Area Networks(SAN) in a heterogeneous environment.
• Tuning queries which are running slow using Profiler and Statistics by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Successfully implemented teh Capacity planning for different servers.
• Experienced in configuring Powershell environment for SQL support.
• Implemented new T-SQL features added in SQL Server 2005 dat are Data partitioning, Error handling through Try- Catch statement, Common Table Expression(CTE).
• Worked in Active/passive and Active/Active cluster environment and Installed and Configured more than 50 Clustered SQL Instances
• Installed Service packs and Builds and Worked with SQL Server 2008 in place and side by side upgrade from SQL server 2005
• Worked on Project for setting up DB mirroring and troubleshooting.
• Worked on setting up Transactional Replication (push and pull) and Merge Replication and troubleshooting along with Slip stream installations and TDE.
• Working on daily tasks include Backup failures, Login creations, Data refresh and Disk space issues.
• Implementation of SQL failover cluster and setting up backup jobs and Checking Control Jobs.
• Creating and Maintaining Database Maintenance Plans and Worked in migrating database to different collations
• Implementing and Maintaining Server Level Auditing for auditing of Logins, Creating and Dropping Objects.
• Checking teh performance issues on servers as per request by using profiler, perfmon, DBCC and DMVs.
• Monitoring servers by checking Error Logs, Windows Logs, Creating Logins and Roles with appropriate permissions.
• Worked in Configurations of IIS (Internet Information Service) in ISP environment with access to SQL DBs
• Installed and Configured SSRS and Deploying SSIS packages.
• Analyzed execution plans, and tuned queries and databases for better optimal performance.
• Fixing Missing Indexes and Excess indexes using Data Tuning Advisor.
• Managed schema objects like Triggers, cursors, indexes, procedures.

Environment: Microsoft Windows 2008 Server, Microsoft SQL Server 2008 R2, Microsoft SQL Server 2008/2005, Windows 2003 Server, IIS 6.0, XML, MS Business Intelligence Development Studio, DB compare.

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Installed SQL Server on both 64 &32bit systems
• Managed and administrated SQL Server 2008R2/2008/2005/2000 on production and non-production servers
• Installed SQL Server 2008/05 and service packson Windows Server Clustered environment
• Migrated SQL Server 2005/2000 databasestoSQL Server 2008 databasesincludingDTS to SSIS packages
• Updated statistics, performed database integrity checks and Backup operations
• Performedbackup using backup compression and Data compression inSQL Server 2008 on clustered environment
• Set up and monitoredtransactional replication, database mirroring on Production, QA and Dev serversand troubleshot errors
• Developed and created teh new database objects including tables,views, index, stored procedures, functions, advanced queriesand also updated statistics using Query Analyzer and Enterprise Manager on teh existing servers
• Worked in setting upthe SQL Server configuration settingsto resolve various resource allocation & memory issues for SQL Server databases and to setupideal memory, min/max server options
• Configured SQL Server and SSRS using IIS
• Experience in using ERWIN tool for designing teh reporting databases
• Responsibleto monitor and troubleshooting Log Shipping
• Assisted on teh Adhoc-Query requests based on teh requirement by using joins, sub queries and co-related sub queries
• Designed and developedSSIS packages using different control flow tasks, Transformations and dataflow tasks
• CreatedSSIS packagesto load robust data from differentheterogeneous data sourceslikeOracle, DB2 to SQL server
• Created, scheduleddatabase maintenance planusingSSIS Maintenance plan task
• UsedOnline Indexingandonline RestoringinSQL 2005
• Extensively used Repositories like Team Foundation Server (TFS).
• Prepared, maintained and modified SQL server installation and configuration documents.

Environment: MS SQL Server 2008R2/2008/05/00 (Enterprise Manager, OLAP cubes with SSAS, SSIS,Query Analyzer, SQL Profiler, Index Tuning Wizard, DTS, MSSQL Server2000 Analysis Server), Windows 2008/2003 Server

Confidential, San Antonio, Texas

SQL Server DBA/Developer

Responsibilities:

• Designed and implemented multiple systems using MS SQL Server 2005
• Prepared estimates for Database, table size growth
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules
• Monitor connections, locks and performance of SQL server
• Responsible for MS SQL Server 2005 configuration, tuning and provide 24x7 dedicated support to all Production, Development and Cluster Servers
• Administered multipleSQL InstancesonCluster environmentfor Server Consolidation projects built onSANusingRAIDlevel
• Worked on physical storage SAN configuration on different RAID levels
• Installed and configured Microsoft SQL 2 node Clustering (Active/Passive)
• Creating Logins and Roles with appropriate permissions
• Involved in teh logical and physical data modeling using Erwin
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications
• Developed and managed DTS Packages and scheduled jobs for periodic and nightly batch processes
• Configured Log shipping of production servers and created teh DR servers
• Assigned permissions to users and roles. Supported column level permission. Administered secure authenticated logins including both Windows and SQL Server Accounts
• Expertise in Security Issues such as creation and granting permissions on various Objects.

Environment: MS SQL-Server 2005, DTS, SQL Diagrams, Erwin, Windows 2005 Server, MS Access, MS Excel, MS Analysis Services, MS Reporting Services, HTML 4.0.

Confidential

Jr. SQL Server DBA/DEVELOPER

Responsibilities:

• Installed configured SQL Server 2005.
• Migrated databases from SQL Server 2000 to SQL Server 2005.
• Worked on Client/Server tools like SQL Server enterprise manager and Query Analyzer to administrate teh SQL server.
• Created and managed schema objects such as Tables, Views, Indexes, Procedures, Triggers and maintaining referential integrity.
• Taking Database full Backup, Transaction log backup & differential backup as per backup strategy daily Routine.
• Monitoring of database size, disk space in all (Production, Model & Development) teh environments.
• Data migration (import & export - BCP) from Text to SQL Server.
• Worked on Complete Backing up of Database and Restored teh Database from Disaster Recovery.
• Used Windows Performance monitor to monitor CPU & Memory usage and SQL Server Profiler to monitor and record database activities of particular users, applications
• Configured SQL Mail.
• Modified teh existing stored procedures, views and triggers in teh part of performance tuning.
• Involved with MS SQL Server Log Shipping.
• Responsible for General Database Administration, Query Performance tuning.
• Monitor production Server Activity.
• Creating and monitoring all maintenance jobs (backups, integrity, optimization, etc.) on all databases.
• Worked with DTS packages to load teh massaged data into Data warehousing system.
• Tuned teh SQL queries using SQL profiler. Involved in tuning teh database.
• Trouble shooting Problems by using SQL server profiler. Very Proactively identifying teh problems before user complaints.
• Maintaining teh Database consistency using DBCC commands at regular intervals.

Environment: Microsoft SQL Server 2005 Enterprise Edition on Windows Server Enterprise Edition, Management Studio, Query Analyzer, BCP, Profiler, T-SQL