SUMMARY:

• Over 8 years of Database Administration and Development experience working on MS SQL Server 2012/2008 R2/2008/2005 and applying patches, hotfixes and service packs.
• Experience in implementing Side - by-Side Migration and in-place Upgrade of MS SQL Server 2012/2008R 2/2008/2005.
• Experience with the 32 bit, 64 bit Microsoft SQL Server in Production, Development, Testing in Clustered and Stand-alone Server Environments.
• Expertise in Database Administration activitiesthat includeInstallation, Configuration, Backup & Recovery, Database Security, Database designing and Query optimization.
• Extensive experience with configuring high availability and Disaster recovery scenarios like clustered environments, Set up different topologies in replication, Log shipping and mirroring.
• Extensively Worked on Transactional Replication and Snapshot Replication.
• Expertise in setting up Active/Passive and Active/Active Clusters for High availability.
• Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2000/2003.
• Hands on experience with 2012 features like Always on Availability Groups, Windows Server Core Support &User-Defined Server Roles.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks,
• Experience in implementing AlwaysOn Availability Groups in SQL Server 2012.
• Experience in using the DMVs, DMFs, System Views and in-built global variables for analysis.
• Experience in analyzing Locks, Dead Locks and handling Isolation Levels.
• Expert in Performance Tuning and Optimization (PTO) by analyzing index fragmentation, execution plans, and finding missing indexes.
• Extensively used the native tools SQL Server Profiler, PerfMon, Activity Monitor, Index Tuning Wizard, Database Tuning Advisor, Log Viewer and Event Viewer for performance analysis.
• Experience configuring and working MS SQL Server 2008 and MS SQL Server 2005 on VMware Environment.
• Experience trouble shooting SQL Server jobs and job monitoring tools.
• Extensive experience with Backup compression and data compression in SQL Server 2008.
• Worked on maintaining database security (logins, users, database/server roles and granting/revoking permissions).
• Experience in backup, restore the database manually and scheduling jobs and Maintenance Plans.
• Experience with Transparent Data Encryption (TDE).
• Experience in Configuring SMTP Server for Database Mail setup and received alerts for the Threshold values.
• Expert in creating database objects like Tables, Views, Indexes, Stored Procedures, Cursors and Triggers using T-SQL.
• Sound knowledge of RDBMS concepts including Normalization, Joins, Keys and Constraints.
• Handled multiple SQL Instances on clustered environment for projects built on SAN using RAID levels.
• Experience in configuring and managing Linked Servers.
• Rebuilding indexes with different fill factors and updating statistics.
• Experience in creating SSIS packages using control and data flow elements.
• Experience in extracting and transforming (ETL)data using SSIS, Import/Export, Bulk Insert, BCP and DTS Packages.
• Experience in creating and manipulating Cubes using SSAS.
• Experience in creating Table, Matrix, Chart, Graph, Gauge, Indicator reports using SSRS.
• Experience in Database design, Performance Analysis, Production Support for very large (VLDB) and Complex Databases.
• Experience in SQL Programming, logical and physical data modeling of the database in Erwin and MS Visio.
• Experience in using third party tools including Foglight, Spot Light, LiteSpeed and Idera.
• Strong knowledge of Software Development Life Cycle (SDLC), Agile and SCRUM methodologies.
• Strong experience in mentoring, working with a team, coordinating with developers, good communication and documentation skills, decision support meetings and 24/7 on call production support..

TECHNICAL EXPERTISE:

Operating System: Windows Server 2012/2008/2003/2000

RDBMS: MS SQL Server 2012/2008R 2/ 2008/2005/2000 , Oracle, MySql

Database Tools/ Technologies: SSMS, BIDS, SSIS, SSRS, SSAS, SQL Profiler, Query Analyzer, Power Shell

Programming Languages: T-SQL, C++, Java, HTML, CSS, JavaScript, JSP

Other Tools: LiteSpeed, Foglight, RedGate, Idera, MS Visio, Erwin, MS Office, MS Project, SharePoint

Network Protocol/Topologies: TCP/IP, SMTP, FTP

PROFESSIONAL EXPERIENCE:

Confidential, Houston, Texas

SQL Server DBA

Responsibilities:

• Managed and Administrated theSQL Server 2008/2005/2000 production and Non-production servers.
• Installation ofSQL Server 2008/05onWindows Server Clustered environment.
• Worked With 2008R2 Parallel Data warehouse Edition in handling extremely large amount of data. This is used to spread large tables into over multiple nodes.
• Experience with 2012 features like Always on Availability Groups, Windows Server Core Support &User-Defined Server Roles.
• Expert In 2008R2 Power pivot an end user tool that works in conjunction with share point, Sql Server 2008R2, and Excel 2010 to process large amount of data within Seconds.
• Migrated SQL Server 2000 databasestoSQL Server 2005 databasesincludingDTS to SSIS packages.
• Extensively workedon Profiler, Perfmon, DMVs, DMFs and DTAto tune the databases, servers and query tuning.
• Managed Security usingSQL Logins, Roles and Security Modesfor various users.
• Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and SQL SERVER LEVEL.
• Rebuilding the indexes on regular intervals and placing the huge table/non-clustered indexon theseparate file group to improve the performance.
• 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.
• Developed and created the new database objects including tables,views, index, stored procedures and functions, advanced queriesand also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Implemented Database Mirroring for HIGH AVALIBLITY of the Production Server.
• Developed & Deployed reports in SSRS using BIDS (Business Intelligence Development Studio).
• Analyze execution plans and generate suggestions for improvement.
• To set upSQL Server configuration settingsto resolve various resource allocation & memory issues for SQL Server databases and to setupideal memory, min/max server options.
• Configureddata partitioning/table partitioningon huge tables containing millions of rows for better performance.
• Used Change-data-capture (CDC) for capture changes on a daily basis.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas
• Supported24 X 7 Production environment

Environment: Microsoft Windows Server 2008/2003, SQL Server 2008 R2/2008/2005, SharePoint, SSAS, SSRS, SSIS, Microsoft Visual Studio 2008/2005, MS Business Intelligence Development Studio 2008, MS Access

Confidential, Boston, MA

SQL Server DBA

Responsibilities:

• As a DBA, my day to day task was creating logins, assigning permissions, scheduling jobs, alerts, operators, back-ups and restore
• Implemented and maintained Database mirroring as a Disaster Recovery solution
• Extensively worked on migrating the databases fromSQL Server and alsoSQL Server 2005/ 2008toSQL 2008 R2
• Implemented new features inSQL 2008likePolicy based Management, Table Compression & backup compression, SQL Server Auditing, Resource GovernorandMERGE statement inT-SQL
• Extensively workedon Profiler, Perfmon, DMVs, DMFsto tune the databases, servers and query tuning.
• Planned and worked on setting upTable Partitioningforfaster maintenancesuch as rebuild and update statistics
• Involved in Capacity Planning, Database Normalization and De-normalization process
• Worked on DBCC check DB to check the database consistency errors
• Worked in setting up the SQL Server configuration settings to resolve various resource allocation and memory usage of SQL Server databases and to setup ideal memory, min/max server options
• Worked on setting up theauditingin SQL 2008 for maintaining a better security in the environment
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Deployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources.
• Extract, Transform and Load data from heterogeneous data sources to SQL Server using the SSIS Packages
• Performed Failover drill test to check High Availability during disaster
• Developed and optimized database structures,stored procedures, DMVs,DDL triggersanduser-defined functions
• Tuned stored procedures using Execution Plans

Environment: MS SQL Server 2008R2/2008/05/00,Windows 2008/2003 Server, C#.net, VB and ASP.NET, MS Visio, Microsoft Visual Studio 2008/2005, MS Business Intelligence Development Studio 2008, MS Access

Confidential, Salt Lake City, Utah

SQL DBA

Responsibilities:

• Installed SQL Servers on 64 bit and 32bit systems.
• Managed and administrated SQL Server 2008R 2/ 2008/2005/2000 on production and non-production servers.
• Installed SQL Server 2008/2005 and service packson Windows Server Clustered and stand-alone environment.
• Migrated SQL Server 2005/2000 databasestoSQL Server 2008databases.
• Updated statistics and performed database integrity checks.
• Performedbackups using backup compression and data compression in SQL Server 2008 on clustered environment.
• Set up and monitored Database Mirroring on Production, Test and Development serversand troubleshoot the errors.
• Worked on setting up Transactional Replication (Push and Pull) and Merge Replication.
• Implemented and managed Log Shipping as a Disaster Recovery solution.
• Installed and monitored Active- Passive Clusters on multiple instances.
• Configured more than 2GB RAM on 32 bit environment.
• Designed and developedSSIS packages using control flow tasks and dataflow tasks.
• CreatedSSIS packagesto load robust data from differentheterogeneous data sourcesincludingOracle, DB2 to SQL server using various transformations.
• Created and scheduleddatabase maintenance planusingSSIS Maintenance Plan task.
• Created maintenance jobs for performance of SQL Server which includes updating statistics, database integrity checks and Index Rebuild.
• Found Missing Indexes and Excess Indexes using DMVs and fixed those.
• Monitored Event Viewer, SQL Error logs and Log File Viewer for software and hardware related errors.
• Monitored SQL Server performance using profiler to find issues like blocking and deadlocks.
• Used Transparent Database Encryption (TDE) for encrypting data sensitive databases.
• Created backup and scheduling strategies for Very Large Databases (VLDB).
• Migrated database to different collation.
• Managed Disk space, memory and User connections.
• Created and managed Logins, Users and granted required permissions.
• Captured inserted, updated, and deleted data into SQL Server tables by using CDC.
• Supported building reports, drill-down reports and drill-through reports using SSRS.
• Extensively used Repositories like Team Foundation Server (TFS).
• Generated script files of the database whenever changes are made to database objects like stored procedures or views.
• Used LiteSpeed for backups.
• Prepared, maintained and modified SQL server installation and configuration documents.

Environment: MS SQL Server 2008R 2/ 2008/2005/2000 , BIDS - SQL Server Integrated Services (SSIS), Windows 2008/2003 server, LiteSpeed, SSRS, SharePoint, MS Visio.

Confidential

SQL DBA

Responsibilities:

• Installed SQL Server 2008R2/2005, service packs, hot fixes and security patches.
• Implemented and maintained Database Mirroring as a Disaster Recovery solution.
• Worked on the migration of SQL Server 2005to SQL Server 2008R2.
• Used data Partitioning, Snapshot Isolation in SQL Server 2008.
• Created and scheduled Backup jobs, index maintenance jobs, consistency checks and update statistics.
• Designed and implemented comprehensive Backup plan and maintenance plan.
• Worked extensively on Query Analyzer and Profiler fortuning queries.
• Used Log Shipping for synchronization of database.
• Worked on Active- Passive clustered environment.
• Used DMVs and DMFs for identifying missing indexes, index usage stats and fragmentation level of indexes for query tuning.
• Managed MS SQL database security by creating Logins and Users with required permissions.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks).
• Optimized stored procedures and queries using Index Tuning Wizard.
• Worked on database Design and Architecture based on business user requirements and performed Normalization (3NF) and De-Normalization.
• Worked closely with development team to assist team in various problems solving and troubleshooting Web based applications which includes stored procedures, functions and triggers.
• Performed analysis for setting up a comprehensive Backup and Recovery strategy for SQL Servers.
• Monitored servers by checking Error Logs and Windows Logs.
• Worked on DTS, BCP and Bulk Insert.
• Maintained database consistency with DBCC at regular intervals.
• Restored the databases to point in time.
• Configured more than 2 GB RAM on 32 bit environment.
• Created and modified stored procedures and functions to generate reports.
• Used T-SQL to create database objects including tables, views, indexes, functions, CTE and triggers.
• Used Red Gate SQL compare and Data compare tools to compare and synchronize SQL database schemas.
• Supported 24/7 Production environment.

Environment: MS SQL Server 2008/2005, Windows 2003, SSRS, SSIS, SSMS - SQL Server Management Studio, BIDS - SQL Server Business Intelligence Studio, Red Gate.

Confidential

Developer/ SQL Server DBA

Responsibilities:

• Administrated SQL Servers 2005 and SQL Servers 2000 in production as well as non-production environment.
• Performed database administration including installing, upgrading, patching and backup.
• Migrated/Upgraded SQL Server 2000 databases to SQL Server 2005 databases including DTS to SSIS migration.
• Extensively used DMVs, DMFs and PerfMon to tune queries and improve performance.
• Monitored SQL Server Agent and error logs on regular basis.
• Created backup/restore and disaster recovery plan for production servers.
• Administered MS SQL Server2005 by creating logins with appropriate roles, granting permissions, denying permissions, monitoring user accounts, creating groups, granting the privileges to users and groups.
• Recreated indexes on tables by dropping previous indexes to improve performance.
• Used Import/Export of DTS to import and export data from data sources like flat files.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Used third party tool like Quest LiteSpeed for backups and restoring them.
• Monitored database status including CPU, memory, I/O, space, and dead lock issues using SQL Server Utilities.
• Participated in implementing and managing Log Shipping.
• Created and documented Schema designing, ER diagrams using Erwin and MS Visio.
• Created database objects including tables, views, stored procedures and triggers using T-SQL.
• Created tables with constraints and relationships between multiple tables using T-SQL.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Used try-catch blocks for error handling.
• Used various transformations in SSIS including Data Conversion, Derived Column, Conditional Split and Lookup.
• Created SSRS reports using Tables, Matrix and List.
• Actively participated in gathering client requirements and system specifications.
• Worked on all phases of database management with application development team and other vendors to maintain maximum availability.

Environment: Microsoft SQL Server 2005 Enterprise Edition, SSMS- SQL Server Management Studio, SSIS, SSRS.