SUMMARY

• 8 +years of experience administering Microsoft SQL SERVER 2000, 2005, 2008R2, 2012, 2014 Clustered and Standalone Environments.
• Experience installing 2000, 2005, 2008, 2008R2, 2012, 2014 SQL Servers and applying Hotfix/Service Pack.
• Implemented new SQL Server 2012 technique ALWAYS ON for High Availability Disaster Recovery.
• Strong understanding of RDBMS concepts as well as Data Modeling Concepts.
• Extensive experience in implementing HADR solutions like Replication, Log shipping, Clustering and mirroring on physical and virtual machines.
• Extensively worked on Active - Active and Active-Passive Clustering.
• Configured Transactional and Snapshot Replication
• Configured Synchronous and Asynchronous Mirroring for DR.
• Implemented Inplace and Side by Side Migration of MS SQL SERVER of different Versions.
• Experience with Microsoft SQL Server Integration Services
• Experience with Policy Based Management, Resource Governor, and Transparent Data Encryption (TDE).
• Good experience in Deploying SSIS packages in MS SQL Server 2008 and MS SQL Server 2012.
• Expert in Data Integrity, Performance Tuning, Query Optimization
• Expert level skills in Objects creation such as Table, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing.
• Experience in logical and physical data modeling of teh database in ERWIN and MSVISIO.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large Databases.
• Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2003 Server.
• Experience in analyzing Locks, Dead Locks and Handling teh Isolation Level and Concurrency Effects.
• Upgradation of SQL server versions and applying patches and hot fixes.
• Worked in an environment with Change management process (Service-now tool) in place for all kind of production and non-production changes.
• Responsible for day-to-day activities, such as backups to teh disk and restore teh databases and transaction log on production/development servers as per business / IT needs using SQL Safe.
• Troubleshooting teh Disk failures in a Cluster Environment.
• Experience working in both OLTP and OLAP environments.
• Experience in transforming data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS) and SSIS.
• Used Index tuning wizard and rebuilding indexes for faster Query Performance.
• Implemented T-SQL features like Data partitioning, Error handling and Snapshot Isolation.
• Configured teh DB SMTP mail for teh notification purposes.
• Experience in identifying teh I/O and memory, bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, and handling them by implementing better Query Execution plans.
• Used DBCC Utilities to maintain teh consistency and integrity of each database in teh production server.
• Experience in Backing up, restoring teh data base manually and also by scheduling teh jobs and Maintenance Plans.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Good experience in Data modelling (Conceptual) and Meta Data services.
• Experience in configuring Registered Servers, Linked Servers, and Multi Server Administration.
• Extensively used teh 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.
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Expert in analyzing teh execution plan and index management for better Query Optimization.
• Configured SMTP Server for Database Mail setup and received Alerts for teh Threshold values.
• Experience in using DMV, DBCC and dynamic management functions.
• Migrated SQL Server 2000 databases into SQL Server 2005 and SQL Server 2008.
• Experience working with change control process.
• Responsible for validating and editing change control or change requests to ensure compliance including verification checks and fallback procedures.
• Strong ability in Scheduling and deploying reports on Report manager
• Experience in teh development of Reports using SQLServer2000/2005 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.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Good understanding of different RAID levels implementation.
• Explicitly used third party tools like Lite Speed, Fog light and Red gate.
• Auditing of database for users transaction, login and database action and removing orphan users
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.

TECHNICAL SKILLS

Languages: T-SQL, My SQL, C#, ASP. NET, HTML, XML, C/C++, Java Script

Operating Systems: Windows 2000/ 2003/20 R2, UNIX (Sun Solar), LINUX

RDBMS: MS-SQL Server 7.0/ 2000/2005/2008, 2012

ETL Tools: MS SSIS.

Third party Tools: Erwin, Visio, Red gate, Lite Speed, Tivoli TSM

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Sr. SQL Server DBA

Responsibilities:

• Install, Manage and administer SQL server 2005\2008R2\2012\2014 SQL servers.
• Migrations of SQL server from one version of SQL server to another.
• Implemented side by side and Inplace Migration of MS SQL server /2008R2 and applied Patches and Service packs to update different versions of MS SQL server.
• Implemented new SQL Server 2012 technique ALWAYS-ON High Availability groups.
• Building SQL 2008R2 cluster environments on VMware/ Physical environments.
• Applying patches and hot fixes.
• Adding nodes to already existing clustered servers as a part of data load\High availability.
• Configured Transactional Replication and Log Shipping.
• Fix teh Cluster and Replication issues on sql 2005/2008R2/2012 servers with in very strong SLA’s.
• Usage of new compression Techniques in SQL Server 2008(R2) for backup and restore jobs.
• Implementation of SQL server logins, Roles and Autantication modes as a part of security policies.
• Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans.
• Configured Database mail, linked servers, Transparent Data Encryption (TDE) and Auditing
• Performance tuning of databases by windows performance monitor and SQL Profiler
• Used Index tuning wizard to redesign and created teh indexes for better performance.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Documenting teh standard procedures on regular basis.
• Experience working with change control process.
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration
• Resource planning and coordination for application migrations with project managers, application and web app teams.
• Handled numerous Change Management requests on production servers.
• Reorganizing or Rebuilding Indexes based on teh Index fragmentation.
• Worked Extensively on Remedy application Database server tuning.
• Configured Transactional replication on migrated server.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas.
• Involved in Data Compression, Hot add CPU, Fact Table size reduction and improved performance using SQL Server 2008.
• Experience in transforming data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS) and SSIS.
• Experience in SQL Server Reporting Services (SSRS).
• Involved in capacity planning, sizing and database growth projects.
• 24*7 On Call production support.

Environment: MS SQL Server 2005/2008R2/2012/2014, Windows 2003/2008/2012, SSRS, SSIS, SSAS, PL/SQL, MS Access, Perl script, Erwin, companion, MS SCCOM, Tivoli TSM

Confidential, Olympia, WA

Sr. SQL Server DBA

Responsibilities:

• Setup Always-On High availability on 2012 SQL Servers.
• Migrating SQL server from 2008R2 to 2012 on standalone and cluster environment.
• Resolve locking and blocking issues.
• Tuning teh Production server to get teh performance improvement.
• Implemented Database Mirroring/Transactional Replication as a part of high availability and disaster recovery.
• Use log shipping for synchronization of database.
• Fixed high Memory utilization issues.
• Reorganizing or Rebuilding Indexes based on teh Index fragmentation.
• Build two-node/Multi-node cluster on physical/Virtual environments.
• Refresh non-prod environments with production.
• Checking Database Health by using DBCC Commands and DMVS.
• Added SQL Clustered Node to Existing Cluster for SQL Server 2008R2.
• Implementation of SQL Logins, Roles and Autantication Modes as a part of Security Policies for various categories of users.
• Restore Development and Staging databases from production backups as per teh requirement.
• Creating Backup strategies and scheduling them as a part of database maintenance plans.
• To analyze long running slow queries and tune teh same to optimize application and system performance.
• Involved in Change Data Capture process.
• Setup SQL Auditing to capture data changes.
• Performance Tuning & Establishing integrated change control.
• Planned teh Complete Backing up of Database and Restoring teh Database from Disaster Recovery.
• Documented and Created SLAs (Service Level Agreement) for teh server availability in case of disaster.
• Configure Transparent Data Encryption (TDE) on Financial Applications.
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, testing, training, production support and Project review with client.
• Used Rational Clear case and AccuRev for change management in teh SDLC cycle.
• To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security on SQL Servers databases.
• 24*7 On-Call Support.

Environment: T-SQL, MS SQL SERVER 2005/2008R2/2012, IIS Server 5.0, WINOWS SERVER NT/2003/2008R2/2012, SSIS, SSRS, SSAS.

Confidential, Minneapolis, MN

SQL Server DBA

Responsibilities:

• Created and maintained various databases on MS SQL Server 2005/2008R2/2012.
• Installed and configured SQL Server 2008R2/2012 on teh
• Tuning teh Production server to get teh performance improvement.
• Configure Active-Active/Active-passive cluster on Physical and Virtual Windows environment
• Upgrade SQL Server R2 and 2008R2 to 2012 servers
• Implemented Database Mirroring as part of disaster recovery plan.
• Implementing and Monitoring Transactional Replication and other SQL Server jobs using custom scripts.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Implementation of SQL Logins, Roles and Autantication Modes as a part of Security
• Involved in Performance Tuning for source databases, target databases
• SQL Diagnostic Manager to analyze poor performing store procedures, SQL batches and Single SQL statements on daily basis and reporting to developer community.
• Assists in teh design, coding, testing, and implementation of databases, and applying noledge of database design standards and database management systems (DBMS).
• Experience working in both OLTP and OLAP environments.
• Implementing security pertaining to Databases (Permissions, users, roles, Policies etc.)
• 24*7 On-Call Support.

Environment: T-SQL, MS SQL SERVER 2005/2008R2/2012, IIS Server 5.0, Windows Server NT/2003/2008R2/2012, SSIS, SSRS, SSAS.

Confidential, Plano, TX

SQL Server DBA

Responsibilities:

• Configure Transactional and Snapshot replication on SQL 2008R2 Servers
• Install SQL server 2008R2 servers on Physical/virtual servers and apply Service packs where needed.
• Used SQL Server Profiler to trace teh slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Responsible for creating teh reports basing on teh requirements using SSRS 2005.
• Used ETL tools to maintain teh quality of data and also to improve teh metadata capabilities.
• Created various Database Objects - Tables, Indexes, Views, and Roles.
• Performed Full and Differential backup with bulk-logged recovery models.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Tuning Wizard (DTA)
• Used Joins, correlated and correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, trigger and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Use teh SQL Analyzer and Profiler for studying teh SQL statements and procedures.
• Used T-SQL for programming for stored procedures and queries.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Development, Test and Production Environments.

Environment: T-SQL, MS SQL SERVER 2005/2008R2, Windows Server NT/2003/2008R2/2012, SSIS, SSRS, SSAS.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Managed and Administrated teh SQL Server 2008/2005/2000 production and Non-production servers.
• Designed a report on teh monitoring of SQL Server Performance. This report gives a detail report to teh management on teh Performance of teh server.
• Worked with SQL Server 2005 side by side upgrade from SQL server 2000.
• Installed couple of SQL Server 2005/2008 on cluster environment.
• Integrated SQL server profiler traces with Performance monitor to has better graphical analysis to find system bottlenecks.
• Created Documentation for steps need to be taken while upgrading teh SQL server 2000 to SQL server 2005.
• Implemented teh new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• 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
• Implementation of SQL Logins, Roles and Autantication Modes as a part of Security Policies for various categories of users.
• Extensively worked on performance issues like update statistics, Auto Stats.
• Created Database Maintenance Planner for teh Performance of SQL Server which covers Database Integrity Checks.
• Memory Configuration for SQL server on 32-bit boxes.
• Created various jobs to check health of teh server and to troubleshoot.
• Developed SSIS packages, stored procedures, functions, triggers.

Environment: T-SQL, MS SQL SERVER 2000/2005/2008 R2, Windows Server NT/2003/2008R2, SSIS.