SUMMARY

• 7 years of professional IT experience with a focus as a SQL Server DBA in enterprise environments.
• Proficient at implementing disaster recovery strategies, performing database backup/recovery, restoring, monitoring, and performance tuning.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
• Adept at creating and maintaining SSIS packages, setting up/schedule jobs and database structure checks and Administering SQL Server Analysis Services and Reporting Services.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Experience in Disaster Recovery Planning and Security Management operations.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Having hands on experience in DR processes including Log shipping and Database Mirroring.
• Worked on configuring SQL Server with minimum privileged access.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Troubleshoot performance problems, fine - tuning of databases and index Analysis.
• Expert in Security Administration creating Users, Roles, Granting Privileges, Managing Schemas (2005) handling Database Security for windows/web applications.
• Worked on SQL Server 2012 migration from SQL Server .
• Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.
• Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Having Experience on Data center servers and handling 1.4 TB databases.
• Handling Memory configurations for SQL Server 2012 and SQL Server 2008 on Windows 2008.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Working knowledge in IntegrationServices (SSIS), Reporting Services (SSRS) and Clustering.
• Strong experience in mentoring team members and writing documentation.
• 24 X 7 Production Database on Call Support

TECHNICAL SKILLS

Databases: MS SQL Server 2000/2005/2008/2008 R2/2012

Programming: Visual Basic 6, Visual Basic 5, C, C++ &T-SQL, PowerShell2.0, 3.0

DBA: Database administration of MS SQL Server 2012, 2008R

Operating System: Windows 2008 R2/2008/2003 Advanced Server, NT & Windows 9x, Linux

Other Software: Windows 2008 R2/2008/2003 Advanced Server, NT & Windows 9x, Linux

Tools: Backup Utility, SQL Lite Speed, Visio

PROFESSIONAL EXPERIENCE

Confidential, NY

SQL DATABASE ADMINISTRATOR

Responsibilities:

• Experience in SQL Server 2008R2 database development and data migration.
• Designed and created databases, tables, relations and also configured linked server in SQL server 2008R2.
• Used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and cursors to be used in production.
• Created Database Triggers to handle history data and advanced auditing of changes made to a table for audit analysis.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Worked on creation and scheduling of T-SQL jobs to run daily.
• Implemented comprehensive backups and restoration.Creation and scheduling of Maintenance plans (database and log backups and cleanups).
• Member of the Infrastructure Automation team to deliver tools for the Engineering lab support teams to gain efficiencies.
• Migrated Database from MySql to SQL server 2008R2.
• Prepared operational documentation to help support the Engineering labs.
• Focused on delivering quality releases during the software life cycle and experienced in agile methodology.
• Interacted with Team and Analysis, Design and Develop database using ER Diagram and relational database concept.
• Installed and configured a database full text search catalog and index for enabling full text search on tables.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Setting up and Monitored transactional replication and Database mirroring on Production and QA servers.
• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace and index tuning wizard.
• Tuned and Traced long running queries anddeadlocks using SQL Profiler.
• Developed and automated powershell script to find network information of remote servers.

Environment: SQL Server 2008 R2Enterprise, Windows Enterprise Server 2008, .NET, PHP storm, Microsoft Visio 2003, MySQL Server 5.5, pgAdmin v1.18.

Confidential, NY

SQL DATABASE ADMINISTRATOR

Responsibilities:

• Responsible for Database support, troubleshooting, planning and migration. Creating and maintaining various databases on production and development environments using SQL Server 2008R2.
• Installed and administered Two-Node cluster Active/Passive on Microsoft Windows Server 2008 R2 Enterprise Edition on SAN environment.
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Automated messaging services on server failures, for task completion and success.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Experience in using PowerShell 3.0 script we scheduled the jobs,Session connectivity kind of stuff.
• Created Views to facilitate easy user interface implementation, and triggers on them facilitate consistent data entry into the database
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• SQL 2000,2005 Performed installation of SQL Enterprise bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data CentersPatch applications.

Environment: SQL Server 2008/2008 R2/2012Enterprise, Windows Enterprise Server 2008 R2, IIS 7.5, .NET, Microsoft Visio 2003, SFTP, Microsoft Reporting Services.

Confidential, Atlanta, GA

SQL DATABASE ADMINISTRATOR

Responsibilities:

• Performed daily tasks including backup and restore by using SQL Server 2008 R2/2008tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Extensively worked on Dynamic Management Views in SQL Server 2005.
• Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Prepared DFDs & Entity Relationship(ER) diagrams.
• Transferring the data (ETL) to Data warehouse (Informatica) by SSIS.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Perform business analysis, technical analysis, systems design, application software programming.
• Prepared the project management and technical documentation.
• Unit Testing the SSIS packages with respect to its flow and performance issues.
• Solving the Bugs Reflected by the Testing team.
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Expertise in SQL Server Reporting Services and SQL Server Analysis Services.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. Recovering the databases from backup in disasters.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings for better server management.
• Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

Environment: SQL Server 2008R2/2008 Enterprise, Windows Enterprise Server 2008,IIS 6.0, IIS7.5,.NET, Microsoft Visio 2003, SFTP, Microsoft Reporting Service and ASP.

Confidential, North Castle, NY

SQL DATABASE ADMINISTRATOR

Responsibilities:

• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance
• Deploying new code base release to UAT and Production Environments.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Working with customers on Application rollouts and server migrations.
• Extensively worked on Enterprise Manager for managing the database
• Troubleshoot performance problems and fine-tuning of databases.
• Involved in Index Analysis and Performance Tuning.
• Converting DTS packages into SQL Server 2005 Integration Services.
• Migrating SQL Server 2000 data bases into SQL Server 2005.
• Recovering the databases from backup in disasters
• To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: SQL Server 2005/2008, SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, MSE, ME Change Request, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.

Confidential

SQL DATABASE ADMINISTRATOR

Responsibilities:

• Monitoring the server for High availability of the servers.
• Solving the request raised by user support.
• Participate in implementation of new releases into production.
• Facilitates application deployment and joint effort deployments.
• Meet the SLA (Service Level Agreement) established.
• Day-to-day administration of live SQL Servers.
• Designed and implemented Security policy for SQL Servers
• Used Stored Procedures, DTS packages, BCP for updating Servers
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers
• Automated messaging services on server failures, for task completion and success
• Execute procedures to accomplish short-term business goals.
• Deploying Administration tools like SQL DB Access, Performance Monitor and Backup Utility.
• Deploying monitoring tools like Site Scope and spot light.
• Table partitioning to improve I/O access
• Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users
• Using database level triggers code for database consistency, integrity and security.
• Tested and Implemented procedures to detect poor database performance, collecting required information and root cause analysis.

Environment: SQL Server 2000/7.0, IIS, Windows 2003/2000 Server, SQL DB Access, Performance Monitor, Backup Utility, MOM, MSE and Site Scope.