SUMMARY

• 8 years of experience in SQL Server Administration, Development and Database Design in Production, Development and Test environments with Microsoft SQL SERVER 2000, 2005, 2008, 2008R2, 2012 & 2014.
• Experience working with 32bit, 64 - bit MS SQL Server in Clustered and Standalone Server Environment.
• Handful experience and outstanding knowledge on High availability (HA) & Disaster recovery solutions (DR) - Log Shipping, Mirroring (High safety, High performance & High availability), Replication (Snapshot, Merge, Transactional & Peer -to- Peer) and Clustering (Active-Passive & Active - Active).
• Experience installing, configuring, upgrading and maintaining MS SQL Server 2000, 2005, 2008, 2008R2, 2012, & 2014; updating with hot fixes and service packs.
• Wrote conversation scripts using SQL, PL/SQL. Stored Procedure to migrate data from SQL server database to Oracle database.
• Experience in Client-server application development using Oracle 11g/10g/9i/8i.
• Upgraded Oracle 9i to 10g software in different environments for latest features and also tested databases.
• Experience in Oracle Supplied Packages and Dynamic SQL,PL/SQL Tables.
• Performed PL/SQL tuning using various tools like EXPLAIN PLAN, AUTOTRACE.
• Implemented new SQL Server 2012 technique ALWAYS ON for High Availability.
• Implemented In-place and Side-by-Side Migration of MS SQL Server 2000/ .
• Experience working with Azure SQL Database Import and Export Service.
• Expertise in Creating Linked Servers between different Servers in SQL environments and also between 32 and 64 bit servers to access database objects in remote locations.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Extensive experience in implementing Clustering and mirroring on physical and virtual machines.
• Expertise in Database Administration on Production Servers with server configuration, Performance Tuning and maintenance with outstanding troubleshooting capabilities.
• Worked with Tivoli Data Protection (TDP) and TSM for backup of databases and scheduling the backups on the Microsoft SQL Server 2005/2008/2008 R2.
• Experience in Share Point integration with SQL Server.
• Experience working in both OLTP and OLAP environments.
• Experience working with data-tier application (DAC) for Migration.
• Experience in deploying SQL Databases in CLOUD (AZURE & AMAZON).
• Experience in Database designing, RDBMS, and Normalization/De-normalization.
• Experience in Index Maintenance, Index tuning, Rebuild & Reorganizing according to Index fragmentation, running DBCC checks and Update Statistics to check Data Integrity.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Experience in identifying the 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.
• Good at SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Expert in Data Integrity, Performance Tuning and Query Optimization.
• Expertise in implementing Business logic by using T-SQL (DDL, DML, DCL) and User Defined Functions (UDF).
• Expert level skills in Objects creation such as Table, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL Joins and query writing.
• Experience in Error handling through TRY-CATCH statement, Common Table Expression.
• Experience in logical and physical data modeling of the database in ERWIN and MSVISIO.
• Implemented the 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.
• Configured the AWE for the SQL server 2005 on 32-bit boxes.
• Expertise in writing and debugging Stored procedures, Triggers, Optimizing Code and Improving efficiency in databases including Re-indexing, Updating Statistics and performing other maintenance tasks
• Experience in using the DMV’S, DMF’S, SP PROCS, INFORMATION SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for the instant analysis.
• Experience in performing database regular Backups (Full/Differential/Transaction Log Backups) and Restoring on requirement.
• Experience in handling the Isolation Levels and Concurrency Effects.
• Good knowledge about Database Recovery models.
• Experience in Backing up, restoring the database manually and also by scheduling the jobs and Maintenance Plans.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience working with Active Directory Groups.
• Extensively worked on Hot, Warm and Cold Backups, Security Management, Managing server and client Connections.
• Experience in daily database maintenance and administrative tasks like Space issues, Transaction log file size growth, Connectivity issues and regular monitoring of SQL Server error logs and windows event viewer.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Experience in using third party tools, for Data modeling SQL Diagrams Erwin, for Backup Solutions SQL LiteSpeed, for performance Foglight, and for alerting Idera.
• Auditing of database for users transaction, login and database action and removing orphan users.
• 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.
• Expert in using Version Control Software like Visual SourceSafe (VSS).
• Extensive experience in the 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.
• Strong ability in Scheduling and deploying reports on Report manger.
• Experience working with change control process.
• Experience configuring and working Microsoft SQL server 2005, Microsoft SQL Server 2008R2 on VMware Environment.
• Thorough knowledge of all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Worked with Tivoli Data Protection (TDP) and TSM for backup of databases and scheduling the backups on the Microsoft SQL Server 2005/2008/2008 R2.
• Experience in Analysis Services (SSAS) OLAP Cubes, Star Schema and Snow Flake Schema, ETL and Data Warehousing.
• Worked with NO SQL Databases like Mongo DB in Hadoop environment
• Experience in analysis, development and deploying of windows application, web services and window services in Microsoft Visual Studio .Net IDE using C#. Net 1.1, C# .Net 2.0, VB.Net, ASP.NET, ADO.NET and SQL Server.
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers, My objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines.
• Worked on call 24/7 availability of database Services.

TECHNICAL SKILLS

RDBMS: MS SQL Server 7.0/2000/ 2005/2008/2008 R2/2012/2014, Oracle 11g/10g/9i MS Access.

Programming Languages: T-SQL, C/C++, VB.NET, Java script, XML, Windows scripting & Power shell.

Operating Systems: Windows 2008 R2/2008/2003 R2/2003/XP/Vista/7, Unix (Sun Solar), Linux.

SQL Server Tools: SSMS, Configuration Manager, Performance Tools & SQL Profiler, Data Tuning Advisor.

BI Tools: SSIS, SSAS and SSRS.

DB Utilities: SQL Server Management Utility, Query Analyzer.

Application Software: Microsoft Visual Studio 2005/2008/2010/2012/2013 , Visual Source Safe, MS Office Suite.

Third party Tools: Microsoft Visio, Erwin, Idera, SCCM, TFS, Red gate, Lite Speed, Commvault.

Other Tools: IBM SPSS Modeler, Microsoft products (Word, Excel, Power Point, Outlook, Share point), Adobe Photoshop and Adobe Light room, ASP.NET 1.1, ASP.NET 2.0, VB.NET, C#.NET.

PROFESSIONAL EXPERIENCE

Confidential, Peoria, IL

Sr. SQL Server DBA

Responsibilities:

• Install, Manage and administer SQL server 2005\2008R2\2012\2014 servers.
• Migrations of databases from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012.
• Implemented new SQL Server 2012 technique ALWAYS ON for High Availability.
• Deployment of databases, jobs, cubes from pre-production to production.
• Building SQL 2005\2008 cluster environments on VMware or Physical windows.
• Performed installations of SQL 2005\2008\2012 on clustered and standalone servers.
• Upgradation of SQL server versions and 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 with SQL Server Management.
• Fix the Cluster and Replication issues on SQL 2005/2008/2012 servers with in very strong SLA’s
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Worked on weekly Issues reports which are generated as a part of infrastructure setup.
• Used IDERA SQL Diagnostic Manager for Performance monitoring, analyzing and troubleshooting.
• 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 the indexes for better performance.
• Documenting the standard procedures on regular basis.
• Working on tickets\incidents with in the SLA’s, as a part of operations support DBA.
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration.
• Resource planning for application migrations with project managers and web app teams.
• Involved in capacity planning, sizing and database growth projects.
• Worked in an environment with Change management process (Service-now tool) in place for all kind of production and non-production changes.
• 24/7 On Call production support.

Environment: MS SQL Server 2005/2008R2/2012, Windows 2003/2008/2012 , SSRS, SSIS, SSAS, PL/SQL, MS Access, Erwin, Idera, TDP, MS SCCOM, Tivoli TSM, Perl script, companion, ADP Pay Roll.

Confidential, Olympia, WA

SQL Server DBA

Responsibilities:

• Worked on Client/Server tools like SQL Server Management studio 2005/ 2008R2, SQL Server Enterprise Manager 2005 and Query Analyzer to Administer SQL Server.
• Migrated SQL server 2000 databases into SQL server 2005 and SQL server 2005 databases into SQL server 2008R2 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.
• Managed SQL Server using PowerShell.
• 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 SQL 2008R2.
• 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.
• 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 SQL Server which covers Database Integrity Checks.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• 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.

Environment: TSQL,MS SQL SERVER 2005/2008, SSRS, QUERY ANALYSER, VISUAL STUDIO 2005, IIS Server 5.0, VB.NET, C#, WINOWS SERVER 2003/2008, SSAS, Care Advance, Biz Talk.

Confidential, Alpharetta, GA

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2005/2008 on the server and client machines, provide connections and manage databases.
• Created and maintained various databases for Production, Development Servers using MS SQL Server 2005/2008.
• Planning the location of data, indexes, and Transaction log files on the disk.
• Use of DBCC Utilities to maintain the consistency and integrity of each database in the production server.
• Resolved locking and blocking issues.
• Tuning the Production server to get the performance improvement.
• Running Index tuning wizard for optimal query performance.
• Implemented Database Mirroring/Transactional Replication as a part of high availability and disaster recovery.
• Experience working with IDERA for Performance Monitoring, Dead Lock, and Blocking.
• Monitoring SQL Server Logs, Application logs and analyzing the logs.
• Provided 24/7 support to SQL application developers in implementing them production server.
• Reorganizing or Rebuilding Indexes based on the Index fragmentation.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Creating Backup strategies and scheduling them as a part of database maintenance plans.
• Created the SSIS packages for executing the tasks, created the Jobs and scheduled for daily running.
• Involved in Change Data Capture process.
• 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, production support and Project review with client.
• To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.
• To design & develop data models and perform forward and reverse engineering using data modeling tools like ERWIN.

Environment: SSQL Server 2005/2008/2008 R2/2012 with clustering, Sybase, T-SQL, Lite Speed, Windows 2000, Oracle, VB and ASP, .NET, Visual Basic, QNXT.

Confidential, Minneapolis, MN

SQL Server DBA

Responsibilities:

• Created and maintained various databases for Production, Development and Testing Servers using MSSQL Server 2008.
• Planning the location of data, indexes, and Transaction log files on the disk.
• Installed and configured SQL Server 2008R2 on the server and client machines, provided connections and managed databases.
• Used DBCC Utilities to maintain the consistency and integrity of each database in the production server.
• Conducted root cause analysis of application availability and narrow down the issues related to coding practices, database bottlenecks, or network latency and resolved locking and blocking issues.
• Tuning the Production server to get the performance improvement.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Ran Index Tuning wizard for optimal query performance.
• Implemented Database Mirroring as a part of disaster recovery plan.
• Monitored SQL Server LOGS, Application logs and analyzing the logs.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Created Backup strategies and scheduled them as a part of database maintenance plans.
• Created the SSIS packages for executing the required tasks, created Jobs and scheduled for daily running.
• Involved in Performance Tuning for source databases and target databases.
• Upgraded Oracle 9i to 10g software in different environments for latest features and also tested databases.
• Experience in Oracle Supplied Packages and Dynamic SQL,PL/SQL Tables.
• Performed PL/SQL tuning using various tools like EXPLAIN PLAN, AUTOTRACE.

Environment: MS SQL Server 2005/2008, Oracle 9i/ 10g, Windows Server 2008 advanced server NT, IIS Server 5.0, SSIS, Reporting Services, SQL Profiler and XML.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the 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 have better graphical analysis to find system bottlenecks.
• Created Documentation for steps needs to be taken while upgrading the SQL server 2000 to SQL server 2005.
• Implemented the 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 Authentication 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 the 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 the server and to troubleshoot.
• Developed SSIS packages, stored procedures, functions, and triggers.

Environment: MS SQL Server 2000/2005/2008 R2, Windows Server 2000, SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, Maintenance Wizard, DTS, VB Script, IIS Web Server, MS Excel, and MS Access.