PROFESSIONAL SUMMARY:

• For a past 8+ years working with the 32bit, 64 - bit SQL SERVER as MS-SQL Server (2000, 2005, 2008,2012) DBA in various critical projects resolving connectivity, performance and ad-hoc user issues, involved in installing both SQL Server standby installation, cluster failover installation (Active-Active, Active-Passive) and administration in handling of Production, Development and Testing in Clustered and Stand-alone Server Environments.
• Microsoft Certified SQL DBA(MCTIP, MCTS) with staunch understanding of Database development, Administration, Design, Implementation & Support of MS SQL Server 2000/2005/2008/2008 R2/2012.
• Expertise in core DBA tasks like Installation, Maintenance, Configuration, Backup & Restore, DR, Database Security and Database designing.
• Experience in installing MS SQL Server 2005, 2008R2, 2012 and updating with hot fix and service packs.
• Extensive experience in implementing high availability solutions on physical and virtual machines.
• Implemented Side-by-Side Migration and in-place Upgrade of MS SQL Server 2000/2005/2008 to 2008 R2.
• Experience in identifying the I/O and memory bottle necks, analyzing Locks, Dead Locks and handling the Isolation Levels and Concurrency Effects and handling them by implementing better Query Execution plans.
• Expert in designing and implementing Backup and Recovery Strategies.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, Spotlight and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Experience in using Performance Monitor/Profiler to resolve Dead locks/Long running queries. And also good experience in data (table) partitioning.
• Expertise in Migrating SQL Server 2000 data bases into SQL Server 2005 and SQL Server 2008 and also expert in migrating DTS packages to SSIS Packages.
• Experience in using the DMVS, DMFS, INFORMATION SCHEMA, SYSTEM VIEW Sand in-built Global variables for the instant analysis.
• Experience with TOAD in data modeling. Planning and executing SQLSERVER/MYSQLDatabase and Grid Infrastructure upgrades.
• Designed DR plans while satisfying SLA requirements and conducted DR tests.
• Experience in implementing different types DR (disaster recovery) scenarios like Replication models like Snapshot, transactional, log shipping and Configure Database Mirroring in Cluster environment.
• Highly skilled in data migration of data from Excel, Flat File, Sybase, Oracle to MS SQL Server using tools like DTS, SQL Server Integration Services (SSIS), BULK INSERT, BCP and Replication between SQL Server (heterogeneous/homogenous).
• Handful experience in Installs, deployments, certificate renewals, service accounts resets, process job tickets & bugs, test verify backups and recovery.
• Expert in Data Integrity, Performance Tuning and Query Optimization.
• Expert level skills in creating objects like Tables, Views, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing using T- SQL statements.
• Expertise in writing Stored Procedures, Functions and Triggers using T-SQL and also expert in tuning Complex Queries.
• Involved in ETL based applications and provided support.
• Performed BCP, BULK INSERT, imported and exported data from different Data Sources.
• Experience in Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2003/2008 Server
• Extensively used the native tools like index tuning wizard, database tuning advisor, SQL Server Profiler, Performance Monitor, Activity Monitor, and Event viewer for performance analysis
• Auditing of database for user transactions, login and database action and in removing orphaned users.
• Provide software build support & ongoing assistance with build activities to ensure timely delivery of testing & production software builds in a highly software development life cycle process.
• Designed and documented Logical and Physical Data Models.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Troubleshooting the Disk failures in a Cluster Environment.
• Expert in creating SQL Server Reports using SSRS 2005 and 2008
• Thorough understanding of different RAID levels implementation.
• Strong ability in Scheduling and deploying reports on Report manager
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.

TECHNICAL SKILLS

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

Operating Systems: Windows 95/2000/2003/2008/ XP/VISTA/7, Sun Solaris 9,VMware ESX servers

Databases: MS SQL Server 2008R 2/2008/2005/2000 , Oracle 10g/11g,, MS Access

ETL & Reporting Tools: DTS, SSIS, SSRS, SSAS, Crystal Reports, MOM

DB Utilities: SQL Server Management Utility, Query Analyzer

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

Data Modeling Tools: Erwin

Other Tools: Lite Speed, Red gate, Fog light, Spot light, Blade Logic, Altiris

PROFESSIONAL EXPERIENCE

Confidential, OMA, NE

Sr. SQL Database Administrator

Responsibilities:

• Experience in installation, configuration, and up gradation of MS SQL Server 2005 to 2008 R2 servers and from 2008R2 servers to SQL Server 2012.
• Experience in Resolving the Memory contentions using SQL Min/Max Settings, SQL 2008 Resource governor and Lock pages In Memory settings, Page File settings, Memory related DMV’s
• Identify deadlock, blocking scenarios and Perform Re-indexing and Index defrag operations for the maintenance of large tables to resolve performance issues.
• Controlling Database Server file system management for data storage capacity and authority on SAN and RAID levels.
• Backup and recovery of production databases (using 3rd party tool Lite speed) on daily /weekly basis to ensure data integrity, striping the backups to ensure easy backup management.
• Perform database monitoring data and log growth, Jobs, Alerts, disk usage and cleanups, using various custom scripts in SQL Server Agent jobs, setup of Database Mail /operators for alerting.
• Database Design -reviewing\approving database designs before moving to production
• Database Code - reviewing\approving database code before moving to production
• Release Performance - responsible for monitoring all release testing and gathering performance metrics to determine if adjustments need to be made before production migration. This includes load testing a simulated production load. Work with Tech services Database administration as needed.
• Production Performance - reviewing production performance metrics to determine if\how changes are needed to prevent issues. Work with Tech services Database administration as needed.
• Application\Database Tuning- Proactively reviewing database specific application code (e.g. stored procedures, packages, etc.) to ensure optimal application and database performance. Work with Tech services Database administration as needed.
• Database Production\QA Turn support - responsible for creating, documenting &coordinating all Production\QA turn scripts via the Turn Center, and non-scripted changes with Tech Services Database administration. (e.g. SSIS Packages)
• Database Test Turn support - responsible for creating, documenting, coordinating, communicating and executing turns for stored procedure, tables, views, DTS packages and SSIS packages for Test.
• Liaison between IT and Tech Services Database administration for Production Support - Communicates between the Tech Services Database administration and IT Application support teams to ensure everyone is aware of release schedules, turns, issues, fixes.
• Database Data Loading - data loading through application code, DTS packages, SSIS packages, BCPing, FTping, or exports
• Database Data extracting - data extraction through application code, DTS packages, SSIS packages, BCPing, FTping, or exports
• Database archiving\purging - responsible for determining what data should be archived\purged.
• Database Size - Maintaining space requirements for Database and monitoring for change

Environment: MS SQL Server 2008R2/2008/05,Windows 2008/2003 Server, UNIX, ASP.NET, Java, CA Service Desk Lite Speed, MS Visio, Microsoft Visual Studio 2008/2005, MS Business Intelligence Development Studio 2008.

Tools: BMC Remedy, PRO Task, Jira Board, Blade Logic, Altiris.

Confidential

Sr. SQL DBA

Responsibilities:

• Installed stand-alone and clustered SQL Server2008 and 2008 R2 on 64bit systems.
• Migrated SQL Server 2005 databasestoSQL Server 2008 R2 databasesincluding SSIS packages and from SQL Server 2008 to SQL Server 2012.
• Performed in-place upgrade from SQL Server 2008 to 2008 R2
• Implemented and maintained always-on, Database Mirroring, Log shipping and Transactional Replication as Disaster Recovery solution in SQL Server 2008 R2/2012.
• Managed and administrated SQLServer2012/2008R2/2005 on production and non-production servers.
• Involved in supporting Multi node Cluster environment in production having databases of size 3 to 10TB.
• Experience in Resolving the Memory contentions using SQL Min/Max Settings, SQL 2008 Resource governor and Lock pages In Memory settings, Page File settings, Memory related DMV’s
• Identify deadlock, blocking scenarios and Perform Re-indexing and Index defrag operations for the maintenance of large tables to resolve performance issues.
• Implemented Policy Based Management on the servers and also wrote a Power Shell script which generates reports for monitoring space of the drives on the servers.
• Used Idera SQL Safe tool for performance monitoring, backup and recovery, security, auditing and Power Shell scripting
• Worked and provided production support to ETL based applications.
• Deploying and promoting SSIS packages from TEST to Prod environment.
• Developed a SSIS package to load data from SQL Base to SQL Server 2008 R2.
• Performed Failover drill tests to check the High Availability during disasters.
• Worked and responsible for design, implementation and enhancement of ETL jobs.
• Used Lite Speed for backups and maintenance jobs which includes updating statistics, database integrity checks
• 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
• Developed and created the new database objects including tables,views, index, stored procedures, functions, triggers, advanced queriesand also updated statistics
• Modified Stored Procedures and complex T-SQL queries to improve query execution process
• Used SQL Diag utility tool for troubleshooting some issues.
• Worked on Hardware SAN and RAID levels configuration and placement of database files/file groups across different drives.
• Used third party tools like Quest lite speed for taking backups and restoring them, Spotlight and Confio Ignite tool for SQL performance monitoring.
• Created Logins, Roles and Proxy accounts with appropriate permissions and maintaining Database Maintenance Plans.
• Configured DB mail by creating accounts and profiles
• Worked on extensively on Linked servers and also was part of Oracle 11g Upgrade.
• Created and managed nightly Prod copy Jobs on the lower environments
• Monitored alerts usingFog LightandSpotlight and also looked into Event Viewer, SQL Error logs and Log File Viewer for software and hardware related errors.
• Worked on many Enhancement Projects and Upgrade Projects
• Provided On call Production support

Environment: MS SQL Server 2008R2/2008/05,Windows 2008/2003 Server, C#.net, VB and ASP.NET, Lite Speed, MS Visio, Microsoft Visual Studio 2008/2005, MS Business Intelligence Development Studio 2008, Ignite, Spotlight, Radmin, Oracle 11g/10g, Double Take

Confidential

Sr SQL DBA

Responsibilities:

• Planned, installed, configured and maintained the SQL Server 2008 in Environment of Active/Active Cluster.
• Implemented and maintained Database mirroring as a Disaster Recovery solution.
• Involved in migrating data from DB2 to SQL Server and SQL Server to DB2 through import/export and BCP utility
• Extensively worked on migrating the databases fromSQL Server 2005to 2008and 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, DMFs and DTAto tune the databases, servers and query tuning.
• Involved in performance analysis and monitoring of SQL Server using Confio Ignite tool using through response time analysis.
• Developed SSIS packages, scheduled them as jobs and deployed packages in SQL Server Integration Services.
• Rebuilt the indexes on regular intervals and placing the huge table/non-clustered indexon theseparate file group to improve the performance
• Planned and worked on setting upTable Partitioningforfaster maintenancesuch as rebuild and update statistics
• Involved in Capacity Planning, Database Normalization and De-normalization process
• Deployed SSRS reports in share point for web based access for multiple end users
• Worked on the new compression techniques in SQL Server 2008 R2 for backup and restore jobs
• Worked on setting up theauditingin SQL 2008 for maintaining a better security in the environment
• Extract, Transform and Load data from heterogeneous data sources to SQL Server using the SSIS Packages
• Plan, analyze and develop Ad-hoc Reports using the SSRS and Report Manager to support various user requirements.
• Involved in physical storage configuration and optimization of SAN/NAS/DASD with different RAID levels.
• Worked with TDP and TSM tool forbackup and recoveryand also written SSIS packagesfor the backup and restores for few applications
• Developed and optimized database structures,stored procedures, DMVs,DDL triggersanduser-defined functions.
• Used third party tool like Quest lite speed for taking backups and restoring them.
• Created Jobs to Automate & Schedule database administrative tasks.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.
• Worked on all phases of database management with application development team and other vendors to maintain maximum availability.

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

Confidential

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
• Performedbackup using backup compression and Data compression inSQL Server 2008 on clustered environment
• Set up and monitoredtransactional replication, database mirroring on Production, QA and Dev serversand troubleshot errors
• Developed and created the new database objects including tables,views, index, stored procedures, functions, advanced queriesand also updated statistics using Query Analyzer and Enterprise Manager on the existing servers
• 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
• Experience in using ERWIN tool for designing the reporting databases
• Responsible to monitor and troubleshooting Log Shipping
• Assisted on the Adhoc-Query requests based on the requirement by using joins, sub queries and co-related sub queries.
• Capacity Planning - Analyzed the Database Growth and reported future space requirements.
• 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.
• Successfully done with Failover cluster testing and resolution on servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Created various reports like charts, sub reports, graphs and scheduled these reports using windows task scheduler to run on daily, weekly and monthly basis.
• Closely worked with client services and development team for analysis of client requirement and worked with development team to configure those changes into database management configuration.

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, Glendale, CA

SQL Server DBA

Responsibilities:

• Installed SQL server 2000 on windows 2000 server, applied service packs and security fixes.
• Designed databases for different projects and resolve database issues.
• Addressed the Replication Issues. Created new replications, DTS packages to maintain high availability of the data between the servers.
• Implemented the SQL login security for developers and users.
• Created DTS packages to pull data from Oracle and Flat Files.
• Created DDL for physical model using Erwin and handed over to the DBA team.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Used the descriptors for getting the input and output values in ANSI SQL.
• Planning, Implementing and troubleshooting Replication.
• Created logical and physical data modeling for development database using ERWIN tool.
• Creation of schema objects, rules and granting of roles to the users.
• Compare and synchronize your database schemas or data by using REDGATE
• Worked and coordinated with developers in writing and tuning new stored procedures.
• Developed business, database objects and security objects using C# and ADO.NET
• Used CSS (Cascading Style Sheets) for branding purposes and user look and feel.
• Setting up backups for the newly created databases.
• Scheduling transfer of backups and log files to different servers.
• Provided a support for data issues and given appropriate solutions.

Environment: MS SQL Server 2000, MS Access, ANSI SQL, C#.Net, ADO.Net, CSS, Oracle, Windows 2000, XML, SQL Profiler.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Responsible for improvement and maintenance of the databases to include rollout and upgrades.
• Responsible for implementation and release of database changes according to agreed timescales.
• Provided24x7 L1-Production support for the database and application issues.
• Installed and configured SQL Server 2000/2005 with latest service packs.
• Implemented database standards and naming convention for the database objects.
• Research on upgrading the SQL Server from 2000 to 2005.
• Managed manual Log shipping for the servers running on SQL Server 2000 by creating SQL scripts and configuring them in a job to run hourly, every day.
• Played the key role in configuring Transactional replication between Primary Server and three Read - Only (Subscribers) servers, with the separate Distributor server.
• Experienced in creating logins, userroles and managing user permissions to the SQL Developers and application users.
• Maintaining security permissions for the internal and external users of the respective databases and servers.
• Creating and monitoring all maintenance jobs (backups, integrity, optimization, etc.) on all databases.
• Managing space issues by shrinking files (data and Log), moving data to different drive and file groups.
• Develop successful backup strategies based on recovery model for accomplishing optimal data safety and to ensure nil loss of information.
• Involved in developing Stored Procedures, Triggers and user defined functions as per requirement.

Environment: MS SQL Server 2005/2000, T-SQL, DTS and Crystal reports 8.0, IIS 5.0, VB 6.0, Windows 2000 Server/Pro.