SUMMARY

• 8 years of IT experience which includes System Analysis and Design, Development, Support & MS SQL Servers 2000/ 2005/2008/2008 R2/2012 Production, Development and Testing in Clustered and Standalone Server Environment.
• Experience in installing MS SQL SERVER 2000,2005,2008,2008R2,2012 updating with the hot fix and service packs.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Performed In - place upgrade and side- by - sideupgrade of MSSQL server 2000/2005/2008 to 2008R2.
• Implemented Disaster Recovery techniques like Database Mirroring, Log Shipping and Replication Models.
• Configured HADR Always ON on SQL Server 2012.
• Hands-on experience with SQL Server 2008 new features like Change Data Capture (CDC), Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• 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, SQLCMD and Dedicated admin connection.
• Implemented SSMA (SQL Server migration Assistant) database migration tool for migrating Oracle/Sybase/MySQL and Microsoft Access databases to SQL Server.
• Explicitly used third party tool Idera SQL Diagnostic Manager to monitor performance.
• Analyzing and troubleshooting the IIS crashes.
• Extensively used the native tools like Index tuning wizard, Database tuning advisor, Profiler, Perfmon, Activity monitor, Event viewer for performance analysis.
• Experience in administrative activities comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, and Updating Statistics.
• Experience in analyzing Locks, Dead Locks and handling the Isolation Level and Concurrency Effects.
• Experience in Backing up, restoring the database manually and by scheduling the jobs and Maintenance Plans.
• Configured Security at Active Directory and SQL Server Level by Creating Principals (logins) and mapping users to roles (Securable and Permissions).
• Experience in using the DMVS, DMFS, SP PROCS, Information Scheme, and System Views and in built Global Variables for the instant analysis.
• Expert level skills in creating objects like Tables, Views, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing using T- SQL statements.
• Performed BCP, Bulk Insert, Imported and Exported data from different Data Sources.
• Experience in logical and physical data modeling of the database in ERWIN and MSVISIO, Normalization, DE normalization, and Database design.
• Expertise in analyzing and estimating the Execution Plan for better Query Optimization.
• 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.
• 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.
• Experience in generating Reports (SSRS) in Business Intelligence Development Studio (BIDS).
• Explicitly used third party tools like Lite Speed, Fog Light and Red Gate.
• Created linked servers between Oracle 10g and MS SQL SERVER 2008 R2 and also deployed SSIS packages for data transfer.
• Good knowledge of Oracle Database 10g Administration and Creating pl/sql packages, procedures and functions
• Capable of scheduling jobs, backup and restore in Oracle 10g using SQL plus(html mode)
• 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
• Involved in all phases of the SDLC (Software Development Life Cycle).
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.

PROFESSIONAL EXPERIENCE

Confidential, Piscataway, NJ

Senior SQL DBA

Responsibilities:

• Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers).
• Configured the Mirroring between servers
• Set up database Backup jobs for more efficient recovery by setting up Full/Differential Backup and more frequent Transaction Log Backup for more dynamic databases
• Schedule SQL Agent jobs in shrinking fast growing log files, deleting junk records or old logins, updating statistics, and checking integrity of databases
• Create and schedule stored procedures as jobs to check SQL Server Error Logs and identify issues;
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG.
• Monitoring constantly growth of databases and transaction logs, change of server configuration, database settings, and schemas for possible issues.
• Performance tuning of Windows and IIS servers.
• Analyzing and troubleshooting the IIS crashes.
• Constantly check the SQL Server Performance Dashboard Reports for Memory Consumption, top queries by Average/Total CPU Time, Average/Total IO, Top Sessions, among others
• Set up Transactional Replication to sync up data between servers on demand
• Create, alter, drop, maintain system Roles and Permissions to users on various database objects on demand
• Verify that backup files are complete and valid when alerted by the error message in the Error Logs;
• Document SQL server/database settings, configuration change history, maintenance plans, and MS Tech Support, surveyed and document the use of databases in all applications
• Troubleshoot performance issues
• Designed and implemented Backup Plans for mission-critical databases
• Use Performance Monitor to collect and view real-time info about memory, disk, processor, databases, and network activity
• Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).
• Apply the workload SQL Profiler collected to feed Database Tuning Advisor (DTA)
• Use DBCC utilities to check for and rectify problems, thus proactively avoid performance issues down the line
• Run system procedures, such as sp lock, sp who, sp who2, sp monitor, to monitor on-going performance
• Set up system alerts when a counter’s value is above or below a defined threshold;
• Check the performance of all indexes on a weekly basis, identify and drop indexes that have never been used for at least one month since last restart of the Server, in order to reduce maintenance overhead;
• Rebuild highly fragmented indexes, reorganize indexes with fragmentation, and defragmenting heaps by creating clustered indexes;
• Update statistics with full scan on a weekly basis to make sure that the query optimizer uses the most recent statistics.

Environment: MS SQL Server 2005,2008 R2,2012 Windows 2003 Server, Windows 2008 R2 Server, ERWIN, MS Visual Studio 2010, Excel, HTML,JIRA 4.3.

Confidential

Senior SQL DBA

Responsibilities:

• Verifying and maintaining database backups, integrity checks, and scheduled jobs;
• Migrating databases and database objects between multiple servers across production and development platforms;
• Created stored procedures for backup and restore of system and user databases from Disaster Recovery;
• Managing day-to-day SQL Server operations in SQL Servers 2005/2008/2008 R2;
• Designing and implementing Disaster Recovery Procedures like Log Shipping, Replication;
• Created and implemented DTS/SSIS Packages for importing and exporting data to other data storage;
• Conducting Root Cause Analysis of application availability related to coding practices, database bottlenecks, or network latency;
• Deploying IDERA Diagnostic Manager for monitoring SQL Server;
• Creating Linked Servers to move data from Oracle Server to other production servers;
• Documenting all the databases, database objects, jobs and the changes made to the database;
• Troubleshooting, monitoring, and tuning SQL server and databases performance using SQL Profiler, System Monitor;
• Resolving issues related to Query Optimization and Index Tuning;
• Checking the Configuration and performance of the existing databases including data file allocation, index, fill factor, fragmentation;
• Analyzing potential problems, e.g., Response Delay, Locking, server down time, for Optimization of performance;
• Resolved Locking and Blocking issues during peak period of website highest hits.

Environment: SQL Server 2008R 2/2008/2005/2000 , Windows 2008/2003/2000 Server, SQL Lite speed 4.5, MSE, ME Change Request, Visio Enterprise Manager, IDERA, SQL Query Analyzer, and SQL Profiler.

Confidential

SQL DBA

Responsibilities:

• Installing, configuring and maintaining SQL Server 2008 R2.
• Design and normalize the databases and created different objects like tables, views, Stored Procedures, Functions, indexes rules and defaults on MS SQL server using T-SQL.
• Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
• Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.
• Migrated MS Access, MySQL database to SQL Server 2008 R2 using SSMA tool
• Developed stored procedures for generating Reports as per management requirement.
• Tuned complex SQL Queries.
• Provided day-to-day administration tasks like space and log management.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
• Created reports based on database usage and perform capacity planning.
• Responsible for creating user groups and assigning permissions.
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Worked on database Design and Architecture based on business user requirements and performed Normalization (Third Normal Form) and De-Normalization.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Setup and maintained Linked Servers.
• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
• Managed user access. Created and managed new security accounts.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Extensively used Toad tool Connect to SQL server implementing the scripting.
• Designed and facilitated the implementation of data warehouses required by application systems
• Supported OLAP team to providing data from SQL Servers.
• Published the databases from old servers to new servers using snapshot replication.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2000/2005 ETL, DTS, SSIS, Windows 2003 Server, ERWIN, MS Access, Toad, Excel.

Confidential, Minneapolis, MN

SQL DBA

Responsibilities:

• Installation of SQL Server 2008/2005, service packs, hot fixes, security patches, Lite speed
• Implemented and maintained Database mirroring as a Disaster Recovery Solution
• Worked on the migration of SQL Server 2000 to SQL Server 2005
• Used Data Partitioning, Snapshot Isolation in SQL Server 2005
• Update statistics, database integrity check and Backup operations
• Generated reports from Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages
• Designed and implemented comprehensive Backup plan and disaster recovery model
• Worked extensively in Query Analyzer and Profiler for tuning queries using variable for characteristics and query costs
• Created and modified Stored Procedures and Functions to generate reports
• Used log shipping for synchronization of database
• Implemented AWE /PAE switches for SQL Server to grab more than 4 GB RAM
• Configuring Perfmon, blocking analysis, enabling of AWE and PAE, Max degree Parallelism
• Practical experience in managing the internal and external MS SQL database security.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
• Responsible for creating user groups and assigning permissions.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Setup and maintained Linked Servers.
• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
• Provided back-end support for functional testing and performance testing.

Environment: MS SQL Server 2000/2005 ETL, DTS, SSIS, Windows 2003 Server, ERWIN, MS Access, Toad, Excel.