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.
• Implemented new SQL 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/20 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 the AWE and /3 GB switch for the 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 the execution plan and index management for better query optimization.
• Expertise in using DBCC trace flags handling blocking and dead lock situations and handling the Isolation Levels and Concurrency Effects, detect CPU, I/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 the jobs and Maintenance plans.
• Extensively worked on Hot, Warm and ColdBackups, Security Management, Managing server and Client connections.
• Very Extensively used the 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.
• Experience working with data-tier application (DAC) for Migration.
• 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.
• Experience workingwith Azure SQL Database Import and Export Service.
• Good knowledge of Dimensional Modeling using Star Schema and Snow Flake Schema for faster, effective 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 the 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/2012 R2/XP/VISTA/7, UNIX (Sun Solar), LINUX

Databases: MS SQL Server 2014/2012/2008 R 2/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, Houston, TX

Sr. SQL Server DBA

Responsibilities:

• Installed and configured SQLServer 2014 Instances and Management tools using SQL Server Setup.
• Extensively worked on setting up Always On Availability Groups on a Multi-subnet failover network.
• Worked along with the Windows team to configure Windows Failover Cluster on which the Always-On setup was done.
• Migrated 2005 SQL Databases in to 2014 SQL databases using Side-by-side Migration process.
• Worked on Migration of DTS to SSIS packages.Solving Memory Problems related with SSIS Packages
• Used SSIS packages to move data from development to QA and QA to Production.
• Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, production support and Project review with client.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Installed, configured and maintained transactionalReplication Server.
• Configured Different RAID Levels
• Checking Database Health by using DBCC Commands and DMV.
• Automated and enhanced daily administrative tasks, including space management, backup& Recovery and performance monitoring.
• Created alerts and notifications for system errors, insufficient resources, and fatal database errors.
• Created Triggers to enforce data and referential integrity.
• Involved in writing T-SQL Programming for implement Stored Procedures and Functions for different tasks.
• Performance Tuning, Analysis and optimizing for SQL Server Application by using performance monitor. Assist the SQL Developers in SQL tuning.

Environment: MS SQL Server 2005/2008R2/2014, Windows 2008/2012, SSRS, SSIS, SSAS, Idera, TSM/TDP.

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.
• Implemented newSQL Server 2012 technique ALWAYS ON for High Availability.
• Upgradationof SQL server versions and applying patches and hot fixes.
• 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 /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.
• 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.
• Upgraded SQL server from SQL 2000/20 R2/2012/2014 usingInplaceand side by side migration techniques.
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Setup and configures alerts using the IDERA SQL Diagnostic Manager and IDERA Defragmenter for Index maintenance.
• Worked in an environment with Change management process (Service-now tool) in place for all kind of production and non-production changes.
• Developed and deployed OLAP cubes for reporting purposes using SSAS.
• Met SLA’s, fine 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 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 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.
• 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
• 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 the SSRS reportdeployment using Microsoft Utilities.
• Designed tables for the application Users, Roles and Groups, Application Audit and Triggers.
• Setup Change Data Capture, designed tables to generate data snapshots from the PAST.
• Installed, Administered SSRS and setup data driven subscriptions.
• Generated reports from SSRS (SQL server reporting services) and SSAS.
• Setup the DB Mail and Alerts on PROD database servers to send out the Notifications.
• Migratedand maintained data using various utilities like DTS, SSIS, Import and Export, Attach/Detach Data Migration tools.
• 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 the 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 the SQL Server Service Accounts and Application Accounts before Expiration.
• Developed SSRSReports to pull the application/user data for the security team.
• Regularly deployed the reports and configured the subscriptions for automatedemaildelivery of the reports.
• Developed SSISpackage to build the content data for the application.
• Designed Backup strategy for OLTP system and SetupBackups for point in time recovery.
• Used the DMVs and DMFs for the performancedatacollection and monitoring.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• 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/2008 R2, SQL 2000/2005/2008/2008 R2, 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 the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Installing, Configuring and Maintaining SQL Server 2008R2/20 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.
• 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 the Capacity planning for different servers.
• Experienced in configuring Powershell environment for SQL support.
• Implemented new T-SQL features added in SQL Server 2005 that 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
• 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 the 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 2008R 2/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
• Set up and monitoredtransactional replication, database mirroring on Production, QA and Dev serversand troubleshot errors
• 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
• 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
• 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
• Worked on physical storage SAN configuration on different RAID levels
• Installed and configured Microsoft SQL 2 node Clustering (Active/Passive)
• Involved in the 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 the 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 the 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) the environments.
• Data migration (import & export - BCP) from Text to SQL Server.
• Worked on Complete Backing up of Database and Restored the 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 the existing stored procedures, views and triggers in the 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 the massaged data into Data warehousing system.
• Tuned the SQL queries using SQL profiler. Involved in tuning the database.
• Trouble shooting Problems by using SQL server profiler. Very Proactively identifying the problems before user complaints.
• Maintaining the 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