SUMMARY

• 10 years of experience in Database Administration, Design Development supporting various versions of MS - SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000 in Production, Test, Development andClusterServer Environments.
• Experience in RDBMS database design,performance tuning, optimization, backupand recovery in SQL Server 2000/2005/2008/2008 R 2/2012/2014/2016.
• Experience in configuring monitoring and troubleshooting Always-On- Availability groups and Disaster Recovery Planning
• Experience in using SQL Server Tools like DTS,Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler, Execution Plan andSQL Query Analyzer.
• Extensive experience on Migrating and upgrading SQL server from previous versions to latest versions
• Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAPtechnologies.
• Experience in Database administration activities forDB Security(creating logins, users, roles, and assigning permission to them).
• Master in performing administrative tasks: database files management,backup/restore, security management,Database Mirroring, data integrationandsynchronization.
• Extensive use of DTS/SSIS in SQL Server, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.
• Experience in implementing high availability using Log shipping, and knowledge of DB mirroring in SQL Server 2005.
• Expertise in Implementing new SQL features like Row and Page compression mechanism, CDC, Data Compression, Backup compression, Resource Governor, Performance Data Collector and Transparent Data Encryption.
• Solid experience onhigh availabilitySQL Server solutions, includingReplication Models(Snapshot/Transactional) andSQL Server clusteringActive-Active, Active-Passive, Always on Availability groups.
• Having experience on Cloud database hosting providers like Azure VM and Azure SQL Database
• Experience in creating SSIS packages. Experience inDTS MigrationandMetadata Management:Migrating DTS Packages to SSIS, Package Migration Wizard, and Storage Management.
• Worked on power shell Scripts and windows Azure Concepts
• Experience working with Active Directory Services and Active Directory Certificate Services.
• Experience in using SSIS(SQL Server Integration Services)for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools likeImport and Export Wizard, Package Installation and SSIS Package Designer.
• Experience in designing/generating/using/deploying Visual Studio 2005 Business Intelligence Reports, SQL Server 2005Reporting Services(SSRS),Crystal Reports.
• Migrated, Upgraded and Installed MS-SQL 2008/2008R2 to 2012 using service packs.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

Languages: T-SQL, ASP, VB.NET, HTML, XML

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

Web Server: Internet Information Services(IIS) 5.0/6.0/7.0

Database Management systems: MS-SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000, MS Access

ETL Tools: Data Transformation Services(DTS), SQL Server Integration Services (SSIS)

Reporting Tools: Business Objects, Crystal Reports, SSRS

DB Utilities: SQL Server Management Utility, Query Analyzer

Application Software: Visual Studio 2005/2008, Visual Source Safe, TFS, MS Office Suite

Scripting: Powershell, VB Script

Database Tools: DB Moto, Erwin, Redgate, Lite Speed, Solarwinds

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Sr. MS-SQL Server DBA

Responsibilities:

• Installed and Upgraded from SQL server 2005, 2008 and 2008 R2, 2012, 2014 and 2016 upgraded servers from Standard to Enterprise edition.
• Migrated Databases from SQL Server 2008r2, 2012 to SQL server 2014 and 2016.
• Worked on the installation of the latest SQL Server 2012, and also well experienced in its additional features.
• Enhanced the capability of Database Mirroring using the latest feature in 2012 i.e., the Always on Availability Group.
• Worked in Active-Passive, Active-Active Cluster and DB Mirroring environment as a High availability solution and also the latest Multi-Subnet Clustering in SQL Server 2012.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.
• Set up of Transaction Replication from Application Server to Reporting Server.
• Experienced in configuring Power-Shell environment for SQL support.
• Performing Backup/Restore to/from Disk.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Installed and configured Team Foundation Server(TFS) 2008/2012.
• Monitored, maintained Team Foundation server (Backups & Restorations, Disaster Recovery preparation and TFS Server health checkups, performance). Managed TFS users, groups and permissions
• Creating SQL agent maintenance jobs for purging data, maintaining indexes, archival operations.
• Checking Database Health by using DBCC Commands and DMV’s.
• Monitored and modified Performance using execution plans and Index tuning.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breaches.
• Performed database management responsibilities in Microsoft Azure for production and non-production workloads.
• Encrypted data and log files using transparent data encryption (TDE) solution. Prepared Documentation for the Disaster Recovery plan.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.

Environment: SQL Server 2016/ 2014/2012/2008 R2/2008, Windows2012r 2/2012/2008/2008 r2/2005 Server, Powershell, Lite Speed, MS Visio, EMC Data domain, SAN, Microsoft SQL server Visual Studio 2005/2008, TFS 2008/2012, MS Business Intelligence Development Studio 2008, FogLite.

Confidential, Sacramento, CA

Sr. MS-SQL Server DBA

Responsibilities:

• Administrated and Managed SQL Server 2014/2012/2008 R2/2008/2005 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 2008 and 2008R2 databases to SQL Server 2012 databases and mentored other technical staff.
• Worked on Active Directory Domain Services where it stores directory data and manages communication between users and domains, including user logon processes, authentication, and directory searches.
• Created more than one availability groups using the Always ON Availability group.
• Experienced in working on Always on Fail-Over clustering.
• Enhanced the capabilities of Database Mirroring and ensured availability of application databases using the Always on Availability groups.
• 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 Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Installing, Configuring and Maintaining SQL Server 2012/2008R2/20 bit) on Active/Active Cluster with latest Service Packs, Hot Fixes.
• Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
• Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
• Designed AlwaysOn Availability Groups and Database Recovery plan, Implemented Database Mirroring in SQL Server 2014/2012/2008 r2 and participated in Disaster Recovery Drill processes.
• Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.
• Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing, Resource Governor and Merge statement in T-SQL.
• Performed data partitioning for efficient management of database tables and indexes. Extensively working on performance issues like update statistics, Auto Stats.
• Involved in Change Data Capture process.
• Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.
• Debugged and Deployed SSIS packages in to file system server and MS SQL Server with the help of manifest file.
• Designed, Developed, Configured and Deployed custom build business reports using MS Reporting Services - SSRS.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.

Environment: MS SQL Server 2014/2012/2008 R2/2008,Oracle10g/11g, Windows 2000/2003, SSRS, DTS, SSIS, BCP, SQL Server Profiler, VB.NET,T-SQL,Erwin4.0,Erwin3.5.2, DBMoto, Database engine tuning Advisor,IIS.

Confidential, Schenectady, NY

Sr. MS-SQL Server DBA

Responsibilities:

• Prepared maintained and modified SQL server installation and configuration documents.
• Installed SQL Server 2012, 2008r2 and 2008 onWindows Server Clustered environment.
• Managed and Administrated theSQL Server 2008/2005 production servers.
• Migrated data from Legacy system to SQL Server 2008 using SSIS packages.
• Upgraded/Migrated SQL Server 2005 databasestoSQL Server 2008, 2008r2 and 2012 databases.
• Performedbackup using backup compression and Data compression in SQL Server 2008 on clustered environment.
• ResolvedApplication connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Monitoredtransactional replication on Production, UAT, QA and Dev servers.
• Used SQL Server Activity Monitor When troubleshooting a performance issue or monitoring a server in real time.
• Implemented new features inSQL 2008likePolicy based Management, Table Compression & backup compression, SQL Server Auditing, Resource GovernorandMERGE statement inT-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 makingrecommendationsforperformance improvementin hosted databases. This involvedindex creation, index removal, index modification, file group modifications, and addingscheduled jobstore-indexandupdate statisticsin databases.
• CreatedDatabase Maintenance Plansfor the performance of SQL Server which coversDatabase Integrity checks, update database Statistics and Re-indexing.
• Managed Security usingSQL Logins, Roles and Security Modesfor various users.
• Optimized the query performance with modification inTSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins,creating usefulclustered indexandnon-clustered indexes.
• Handled numerous change management requests on production and UAT servers
• Maintaining the databaseconsistencywithDBCCutility at regular intervals.
• Provided documentation for SQL configuration, and Performance measures.
• Developed and created the new database objects including tables,views, index, stored procedures and functions, advanced queries.
• Extensively used Redgate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas
• Involved in SourceData Analysis, analysis and designing mappings for data extraction
• Created, deployed and managed reports usingSQL Server Reporting Services(SSRS)
• Created and managed financial reports using SSRS
• Evaluated data storage considerations to store databases andtransaction logs.
• Created the technical specification document.
• Review of Technical and Functional High-Level Documents (HLDs).
• Developing Test cases for the Interfaces.
• Involved in Batch Processes.

Environment: SQL Server 2012/2008R22008/2005 (SSMS, SQL Profiler, Index Tuning Wizard, Powershell Scripting, Data Transformation Services (DTS), SSRS, SSIS), Snap Manager for SQL

Confidential, Orange County, CA

Sr. SQL Server DBA

Responsibilities:

• Worked on Client/Server tools like SQL Server Management studio 2008/2005, SQL Server Enterprise Manager (2000) and Query Analyzer to Administer SQL Server.
• Migrated SQL server 2000 databases into SQL server 2005 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
• Setting up and Monitored transactional replication, Database mirroring on Production, QA and Development servers.
• Migrated DTS packages into SSIS packages.
• Handled up to 2 TB Size databases with clustered and stand-alone environment
• Configured Transactional replication on migrated server.
• Wrote the packages using SSIS in SQL2005.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Integrated SQL traces with Perfmon log to have better graphical analysis to find system bottlenecks.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Created Database Maintenance Planner for the Performance of SQL Server which covers.
• Database Integrity Checks.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Used DTS packages to move logins and jobs from one server to another server.
• Used log shipping for synchronization of database.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Extensive testing on the Performance of the Stored Procedures.

Environment: SQL Server 2008/2005, SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, MSE, ME Change Request, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler

Confidential, Minneapolis, MN

SQL Server DBA

Responsibilities:

• Involved in the migration of SQL Server 2000 databases to SQL Server 2005/2008
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Evaluated data storage considerations to store databases and transaction logs. Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.
• Managed trouble shooting of Client connections, viewing error log and applications.
• 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
• 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.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE), Data Partitioning, Snapshot Isolation.
• Transferred data (ETL) to Data Warehouse Environment using SSIS.
• Managed VERITAS net backups and Litespeed backups.
• Monitored servers using Spotlight third party software.
• 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.
• Maintaining the database consistency with DBCC utility at regular intervals.
• Using Log shipping for synchronization of database.
• Worked in Cluster Environment.

Environment: SQL Server 2008/2005 and SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, MSE, VSS and Password Updater.

Confidential

MS SQL Server DBA

Responsibilities:

• Installed SQL Server 2005/2000 and created Development Database for testing, upgrades and development.
• Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.
• Created System Schema Diagram and Tables.
• Created logical Entity relationship diagrams and implemented logical model physically.
• Set up Database Maintenance Plan using SQL Server Enterprise to update the statistics.
• Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
• Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.
• Performance tune stored procedures, to make the report processing faster.
• Used log shipping for synchronization of database.
• Maintaining the database consistency with DBCC at regular intervals. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. To analyze long running slow queries and tune the same to optimize application and system performance.
• Used ROBO Copy to move large files through networks.
• Performed daily backup and created named backup devices to backup the servers regularly.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Implementing and administering database replication between SQL Server databases as well as dissimilar databases.
• Setup the agents for replication and defined disaster recovery plan.
• Provided secondary support to the Local area network (LAN).
• Provided a robust back-up system that ensures data integrity.
• Configured PC Anywhere software to connect to other sites through DSL using TCP/IP.

Environment: SQL Server 2005/2000/7.0, IIS, Windows 2003/2000 Server, SQL DB Access, Performance Monitor, Backup Utility, MOM, MSE and Sitescope.