SUMMARY:

• About 8+ years of Experience in Database Administration, Architecture as a DBA and in application development as SQL Developer using MS SQL Server 2005/2008/2012/2014/2016. Work Experience in Major Industrial Sectors such as Brokerage and Trading Services, Banking Services, Insurance Services, Manufacturing and Technology.
• Extensive experience in installing MS SQL SERVER 2005, 2008, 2008 R2, 2012, 2014; updating with hotfixes and service packs.
• Strong understanding of RDBMS concepts as well as Data Modeling Concepts.
• Solid Experience and outstanding knowledge of High availability and Disaster Recovery solutions like Always On Availability groups, Replication (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines.
• Extensively worked on Active - Active and Active-Passive Clustering.
• Implemented new features in MS SQL Server 2012 like Always ON HADR in production and non-production environments.
• Implemented In place and Side by Side Migration of MS SQL SERVER 2000/ R2 and 2008R2 to 2012.
• Experience in developing T-SQL (DDL, DML, and DCL) statements.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Experience using SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Experience in using the DMVS, DMFS, SP PROC’s, INFORMATION SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for the instant analysis.
• Expert in Data Integrity, Performance Tuning, Query Optimization.
• Expert level skills in Objects creation such as Table, Normalization, Indexes, Stored Procedures, Cursors, Triggers, Views and other SQL joins and query writing.
• 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.
• Experience in Normalization, 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 Server.
• Experience in SQL Upgrades SQL and Building SQL Clustering.
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
• Expert in analyzing the execution plan and index management for better Query Optimization.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Extensively used Repositories like 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.
• Created effective Backup and Recovery plan by Transactional Log and Full Database Backups and utilized to recover data in point in time in case of disaster of server.
• Experience in using DMV and DBCC commands for various performance issues.
• Extensively used third party tools like Spotlight, Lite Speed, Fog light and Red gate.
• Auditing of database for users transactions, login and database action and removing orphan users
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers
• 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 creating deployment utility to deploy SSIS packages over Production, QA and Local System.
• Experience in creating SQL Server Reports using SSRS 2005 and 2008.
• Experience working on Hyper-V and VMware environments
• Experience working with Change control process/Change management
• Solid team work and negotiation skills with IT(DBA & Application teams) Management and Developers.
• Very enthusiastic to explore new technologies and to monitor other team members as necessary.
• Extensively worked in 24*7 Production environment.

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

Responsibilities:

• Installation and Maintenance of SQL Server 2008(R2)/2012/2014 on Production and Non-Prod environments.
• Upgrades of SQL server 2005/2008R2 to 2008R2 /2012 and apply Service packs wherever needed.
• Worked on Scottrade-Broadridge conversion program, involved in setting up environment, deployments.
• Involved in TDE project, for enabling Transparent Data Encryption on Databases which have highly sensitive data.
• Configured Always-On with synchronous and asynchronous secondary replicas.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Configured Active- Active, Active- Passive clustering (two node and multi node) on physical and virtual environments.
• Creating and Maintaining Database Maintenance Plans.
• Performed database refreshes from prod to non-prod environments.
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Tune slow running queries using SQL Server Profiler.
• Worked with database tuning advisor, SQL server profiler, Performance counters and activity monitor for Performance tuning.
• Used DBCC and DMV commands for day-to-day troubleshooting tasks.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• Optimized the database server using DMV’s and DMF’s and performed a code review and tuning for the best performance of the application.
• Involved in Logical and Physical Data Modeling process using MS Visio.
• Use MS Visual Source Safe as a Version Control System.
• Involved in Change Data Capture process.
• Disaster Recovery Planning, Testing and analyzing and continuous update of documentation.
• Pro-Active Monitoring of all my SQL Servers and avoided many production outages/Impacts.
• Provided 24* 7 on-call production support.

Confidential, Jersey City, NJ

Sr. SQL Server DBA

Environment: MS SQL Server 2000/2005/2008 R2/2012/2014, Windows 2003/2008R2/2012, SSRS, SSIS, SSAS, PL/SQL, MS Access, Perl.

Responsibilities:

• Installation and Maintenance of SQL Server 2005/2008(R2)/2012/2014 on Production and Non-Prod environments.
• Migrated sql servers from Virtual to physical environments for improving performance.
• Upgrades of sql server 2005/2008R2 to 2008R2 /2012 and apply Servicepacks wherever needed.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Configured Active- Active, Active- Passive clustering (two node and multi node) on physical and virtual environments.
• Configured Always-On with synchronous and asynchronous secondary replicas.
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Tune slow running queries using SQL Server Profiler.
• Worked with database tuning advisor, SQL server profiler, Performance counters and activity monitor for Performance tuning.
• Used DBCC and DMV commands for day-to-day troubleshooting tasks.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• Optimized the database server using DMV’s and DMF’s and performed a code review and tuning for the best performance of the application.
• Involved in Logical and Physical Data Modeling process using MS Visio.
• Use MS Visual Source Safe as a Version Control System.
• Disaster Recovery Planning, Testing and analyzing and continuous update of documentation.
• Mentoring junior team members and creating documents on daily basis.
• 24* 7 on-call production support.

Confidential, Alabama

SQL Server DBA

Environment: SQL Server 2000/2005/2008 R2,Windows 2003/ 2008 Server, C#.net, VB and ASP.NET, Lite Speed, MS Visio, Microsoft SQL server Visual Studio 2005/2008 R2

Responsibilities:

• Installed and configured SQL Server 2005/2008 R2 on Prod and Non-Prod environments.
• Configured HA & DR techniques like replication (snapshot and transactional), Mirroring, log shipping and clustering on virtual and Physical environments.
• Worked on side-by-side migrations of sql server.
• Applied service packs as a part of standardization project.
• Implemented sql server Auditing to collect data for Quarterly audits.
• Troubleshoot Performance issues on production environments using Performance counters, extended events/Profiler and DMV’s to find the resource bottlenecks.
• Resolve locking and blocking issues.
• Refresh non-prod environments with production data on regular basis.
• Implemented data availability solutions like online restore, online index, database snapshot and fast recovery.
• Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Provided RAID level suggestion for data files, log files and tempdb drives.
• Used Index tuning wizard for optimal query performance.
• Monitoring SQL Server LOGS, Application logs and analyzing the logs.
• 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.
• Providing 24*7 support.

Confidential, Connecticut,NY

SQL Server DBA

Environment: SQL Server 2000/2005/2008 R2, T-SQL, Excel, Windows 2003/2008 Server

Responsibilities:

• Migrated SQL server 2000 databases into SQL server 2005 and SQL server 2005 databases into SQL server 2008 databases by In-place upgrade process and also used upgrade advisor tool in up gradation process.
• Setting up and Monitored Clustering, transactional replication, Database mirroring on Production environments.
• 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.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• 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).
• Experience working with MS SCOM and MS SCCM.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Used DTS packages to move logins and jobs from one server to another server.
• Used log shipping for synchronization of database.
• Good experience in data modeling and metadata services.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Extensive testing on the Performance of the Stored Procedures.

Confidential, Loredo, TX

SQL Server DBA

Environment: MS SQL Server 2000/2005/2008 R2, Windows 2000/2003/2008 servers, .NET, MS Access.

Responsibilities:

• Installing, configuring, tuning and providing 24X7 support for SQL Server 2000/2005/2008 R2
• Created and scheduled jobs to setup log shipping between production servers.
• Implemented Database Mirroring on the SQL Server 2005 production databases.
• Job Monitoring and making sure all jobs run successfully every night.
• Creating databases and logins with permissions in SQL Server 2005 as per the developer’s request.
• Worked extensively on SQL Server Reporting Services to generate reports.
• Created Linked Servers between 2005 and 2008 R2 servers.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation and data extraction.
• Migrated and tested DTS packages to SQL Server 2005 Integration Services.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Restore Development and Staging databases from production backups as per the requirement.
• Extensively used SSIS to move data from text files to SQL Server.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Prepare daily report on the job failures, backup failures and disk space.
• Extensively used Database Performance Monitoring tools for performance tuning.
• Designed and implemented database maintenance plan.
• Used Index tuning wizard and rebuilding indexes for faster Query Performance.
• Involved in resolving dead lock issues and performance issues.

Confidential, St. Louis, MO

SQL Server Developer/DBA

Environment: MS SQL Server 2000/2005/2008, T-SQL, Windows NT/2000/ 2003

Responsibilities:

• Installation and configuration of MS SQL Server 2005/2000/7.0
• Created Stored Procedures, User defined functions, Views and Wrote T- SQL codes maintaining query standards for the project.
• Created ER diagrams
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns, triggers and configured IIS and Worked on Index tuning, stored Procedure tuning.
• Involved in Optimization and normalization of database and tables.
• Involved in conceptual and physical modeling of data using ERWin tool.
• Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL).
• Part of team for analyzing and implementing the physical design for database.
• Writing complex Stored Procedures to meet the business requirements.
• Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
• Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• Designing and building data load procedures, using MS SQL Server.
• Wrote DTSActiveX scripts that extract data from database tables and write the data to text files
• Responsible for transferring of database and database objects from Development to Production Server using DTS.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Involved in Analysis and tuning complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures.