SUMMARY

• SQL Server DBA with more than nine years of IT experience with various Industries as a SQL Server DBA in MS SQL SERVER in administration, analysis, design, development, testing, presentation and implementation experience using SQL Server 2014/2012/2008 R 2/ 2008/2005/2000 .
• Good knowledge of Relational Database Management Systems (RDBMS).
• Good experience in installation, upgrade and configuration of MS SQL Server and databases in clustered and non - clustered environments.
• Expertise in Database administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Integration Services, Database designing and Query optimization.
• Good working experience in maintaining SQL Server Active/Passive cluster environment.
• Experience in Migration from MS SQL Server 2005 to MS SQL Server 2008 and MS SQL Server 2008 to MS SQL Server 2012/2014.
• Experience in implementing different types of Replication models like Snapshot and Transactional.
• Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL Server 2014/2012/2008 R2/2005 databases.
• Experience in configuring and monitoring Database Mirroring.
• Setup and configured AlwaysOn Availability Groups for DR and Reporting.
• Experience in Installing and Configuring SQL Server on virtual machines (VMware).
• Experience in MS SQL Server 2000 and 2005 installation with latest service pack, configuration, performance tuning, client/server connectivity, query optimization, Database Maintenance plans, Database Consistency Checks using DBCC.
• Experience in implementation of Policy Based Management.
• Extensive experience in Capacity planning, Disaster Recovery, troubleshooting, backup and restore procedures.
• Knowledge on RAID 1-5 & 10 technologies.
• Overall database design, such as creating normalized databases, authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types.
• Experience in creating packages, Jobs, Sending Alerts using DatabaseMail/SQL Mail.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity.
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP, DTS and SSIS (using BIDS & SSDT).
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Good experience in resolving blocking and Dead lock Issues by using SQL commands.
• Experience working in Production support including weekend and Change control support over nights.
• Documented disaster recovery plans and participated in disaster recovery drills.
• Monitoring SQL Server job logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.
• Monitoring Dashboard Reports for Performance Tuning and finding bottleneck in DB.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

TECHNICAL SKILLS

Languages: T-SQL,C, C++, HTML, XML, html, JavaScript, PHP

RDBMS: MS SQL Server 2014,2012,2008R2, 2008, 2005, 2000

SQL Server Tools: SSMS, SQL Server Profiler, SSIS, Query Analyzer, Performance Monitor, Enterprise Manager etc.

Operating Systems: Windows Server 2008/2003, Windows 2000 Advanced Server, Windows NT 4.0 / 3.51, Windows 95/98/XP

Other Tools: IDERA Diagnostic Manager, SQL Light speed, ERWIN 4.0, Sharepoint, Red Gate SQL belt, BMC Remedy Pac 2000 (for helpdesk tickets, change requests - CR, work order - WO, problem tickets -PO).

Hardware: PowerEdge 1900 Server, Dell PowerEdge 8450, IBM servers, HP servers

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Sr. SQL Database Analyst/Sr. MS SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2014 Enterprise edition on Active/Passive Cluster and standalone environment.
• Implemented SQL Server 2014 new features like AlwaysOn Availability Groups for high availability of multiple databases in place of database mirroring.
• Successfully migrated from SQL Server 2008R2 to 2014 on Development/Testing/production Environment.
• Pre installation check before installing SQL Server 2014 that identified unsupported configurations.
• Applied Page and row compression to efficiently organize the space.
• Migrated new database structures, such as tables, indexes and stored procedures from test to the production environment.
• Monitored database system details within the database, including stored procedures and execution time and implement efficiency improvements.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, Mirroring, database integrity verification, indexing and statistics updates.
• Implemented table partitioning to improve performance and data management.
• Database and SQL Query Tuning to improve performance of loads.
• Reduced the dead locks by using the SQL Server Profiler hence the performance of the query is tuned.
• Created automatically running stored procedures for day-end operation using SQL Server agent.
• Implementing different Development and Test Server instances for the Application Development Team and to co-ordinate Development and Testing Environments and keep them updated.
• Worked on SQL Server Parallel Data Warehouse for Tera Data DataBases.
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.
• Creating logins and roles with the appropriate permissions.

Environment: Windows server 2008, MS SQL Server 2014/2008R2, SQL Server Management Studio, SQL Profiler, SQL Server 2012, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services(SSAS).

Confidential, Cleveland

SQL Database Analyst

Responsibilities:

• Installed and configured SQL Server 2014/2012/2008 R2 Enterprise edition on Active/Passive Cluster and standalone environment.
• Implemented SQL Server 2012 new features like AlwaysOn Availability Groups for high availability of multiple databases in place of database mirroring.
• Successfully migrated from SQL Server 2008 to 2012 and also to 2014 on Development/Testing/production Environment.
• Pre installation check before installing SQL Server 2012 that identified unsupported configurations.
• Implemented Resource Governor for one of the critical server for better performance.
• Applied Page and row compression to efficiently organize the space.
• Migrated new database structures, such as tables, indexes and stored procedures from development to the production environment.
• Monitored database system details within the database, including stored procedures and execution time and implement efficiency improvements.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, Mirroring, database integrity verification, indexing and statistics updates.
• Implemented the Data Collector to capture the CPU, DISK, Memory counters.
• Implemented table partitioning to improve performance and data management.
• Database and SQL Query Tuning to improve performance of loads.
• Reduced the dead locks by using the SQL Server Profiler hence the performance of the query is tuned.
• Created automatically running stored procedures for day-end operation using SQL Server agent
• Implementing different Development and Test Server instances for the Application Development Team and to co-ordinate Development and Testing Environments and keep them updated.
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.
• Creating logins and roles with the appropriate permissions.
• Designed and deployed SQL Server Integration Services (SSIS) Packages, with error handling, environmental and SQL server package configurations.
• Successfully implemented database mirroring between Primary server and Mirror Server.
• Implemented log shipping to support DR servers, worked on high availability concepts like always on and clustering.
• Assisted in maintaining and updating the sharepoint platform.
• Provided 24 X 7 dedicated supports for SQL Server production server.

Environment: Windows server 2003/2008, MS SQL Server 2012/2008R2/2005/2000, SQL Server Management Studio, SQL Profiler, SQL Server Tuning Advisor Idera’s SQL Diagnostic Manager, Red-gate SQL Compare.

Confidential, New York

SQL SEVER DBA

Responsibilities:

• Installed and configured SQL Server 2008 Enterprise edition on Active/Passive Cluster environment.
• Successfully migrated from SQL Server 2005/2008R2 on Development and Testing Environment.
• Pre installation check before installing SQL Server 2008 that identified unsupported configurations.
• Created SSIS packages for the ETL the data from SQL Server 2005, flat files, Excel files.
• Implemented Resource Governor for one of the critical server for better performance.
• Applied Page and row compression to efficiently organize the space.
• Migrated new database structures, such as tables, indexes and stored procedures from development to the production environment.
• Monitored database system details within the database, including stored procedures and execution time and implement efficiency improvements.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, Mirroring, database integrity verification, indexing and statistics updates.
• Implemented transactional replication to enhance the failover capabilities increased over all database manageability and improved performance.
• Implemented the Data Collector to capture the CPU, DISK, Memory counters.
• Implement table partitioning to improve performance and data management.
• Designed and deployed SQL Server Integration Services (SSIS) Packages, with error handling, environmental and SQL server package configurations.
• Incremental loading of dimensions, facts, error handling in SSIS.
• Database and SQL Tuning to improve performance of loads.
• Reduced the dead locks by using the sql server profiler hence the performance of the query is tuned.
• Created automatically running stored procedures for day-end operation using SQL Server agent
• Implementing different Development and Test Server instances for the Application Development Team and to co-ordinate Development and Testing Environments and keep them updated.
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system using diagnostic manager from Idera.
• Creating logins and roles with the appropriate permissions.
• Monitoring & Analysis of SQL Log, Perfmon counters and Performance Tuning for all development and staging environment.
• Worked extensively on data refreshes from production to test environments, automated the whole data refresh process at database level using PowerShell scripts, stored procedures, Backups and SQL Agent jobs without having any performance impact on Production server.
• Successfully implemented database mirroring between Primary server and Mirror Server.
• Implemented log shipping in standby mode to support DR servers.
• Provided 24 X 7 dedicated supports for SQL Server production server.

Environment: Microsoft Windows Server 2008 Enterprise Edition, Microsoft Windows 2003 Server, Microsoft SQL Server 2005, 2008, Microsoft SQL Server Integration Services, Microsoft SQL Server Reporting Services, Microsoft OFFICE 2007.

Confidential, Boston, MA

MS SQL SERVER DBA

Responsibilities:

• Development of T-SQL Stored Procedures for Export & Import of data from databases and Transaction Databases of different agencies.
• Administration of around 25+ SQL server 2008/2005/2000 servers. Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.
• Developed SSIS packages and schedule jobs for loading data between different sources.
• Creation and maintenance of databases, creating roles and managing user permissions.
• Created Views and Index Views to reduce database complexities for the end users.
• Code Review for different modules of SQL Technology Team.
• Implement Replication for Reference Data across different Instances of the application.
• Installation of SQL server Instances and Service Packs. Applying Hot Fixes.
• Testing and analyzing effects of Server Upgrades and Security Fixes on customized server instances with Mount Points etc. Implementation of new changes through Change Request.
• Implementing different Development and Test Server instances for the Application Development Team and to co-ordinate Development and Testing Environments and keep them updated.
• Documented disaster recovery plans and participated disaster recovery drills.
• Reviewed third party tool (Idera) so as to help automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.
• Performed query tuning, assigned proper Indexes for better performance.
• Provided 24 X 7 dedicated supports for SQL Server production server.

Environment: SQL Server 2000/2005, Transactional-Sql, Visual studio.net, Windows 2000 data center/advance server, Crystal reports 8.0, dell power edge 6650, Third party tools (Idera diagnostic tools).

Confidential

SQL SEVER DBA/DEVELOPER

Responsibilities:

• Installed and configured SQL Server 2008 and maintained 50 servers.
• Upgraded and migrated the servers from SQL Server 2000to SQL Server 2005/2008.
• Involved in various stages like development, system Analysis, design, and creating stored Procedures.
• Designing and validating the forms according to client requirement by using VB.
• Importing and Exporting of the Database using DTS utility.
• Creating, maintaining the users, roles and granting privileges.
• Security features were implemented for restricted set of users.
• Wrote SQL stored procedures to implement business logic.
• Developed and coded applications in PL/SQL.
• Planned, modified and resolved Chain-of-ownership problems in the server.
• Designed reports on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Writing stored procedure and SQL Queries.
• Fine tuning the Database Settings as well as the Server Settings.
• Developing customized applications based on customer requirements.
• Development of modules assigned.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.
• Had good experience in 24/7 production support.
• Migrated SQL Server 2000 DTS Packages to SQL Server 2005 SSIS packages and resolved issues during migration.
• Migrated Stored Procedures from 2000 to SQL Server 2005 to refer to Dynamic Management Views.
• Implemented Replication and Log Shipping to overcome Disaster Recovery plan.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• Analyzed database growths for Capacity Planning, Normalized the data for efficient performance and also Partitioned data into multiple Files and File groups.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Monitored the application & database performance using SQL Profiler, Performance Monitor.
• Used Index tuning wizard to get a better idea of implementing indexes on the existing databases and rebuilding only necessary indexes for faster query response.
• Extensively used Database Tuning Advisor to improve the performance of Query.
• Implemented backup and retention strategies based on business policies.
• Performed Backup/Restore by using VERITAS Net Backup.
• Implemented and maintained SQL Server Agent Jobs, Monitor SQL Server Agent Job history.
• Improved performance of slow running queries using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Created SSIS Packages to (ETL) Extract, Transform and Load the data into Reporting instance to generate the reports easily and quickly.

Environment: Microsoft Windows Server 2003 Enterprise Edition, Microsoft Windows 2000 Server, Microsoft SQL Server 2000, Microsoft SQL Server Data Transformation Services, Microsoft SQL Server Reporting Services.

Confidential

SQL DBA/DEVELOPER

Responsibilities:

• Worked extensively as a DBA to create the databases for Confidential . Also created monitoring jobs in these servers.
• Preparing and maintaining database for production and solving issues as and when needed.
• Creating database backup and transactional log backup plans and scheduling them as and when required. Also monitored these jobs on a daily basis.
• 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.
• Solved automated Log shipping failures & manual log shipping failures and other issues related to it.
• Worked extensively in creating the INTRANET server from scratch which is used for storing the employee information and the company information.
• Played the key role in configuring Transactional replication between Primary Server and three Read - Only (Subscribers) servers, with the separate Distributor server.
• Giving 24x7 ON Call support to the application team.
• Performed prime role in managing all the databases during peak holidays like Mother’s day, Valentine’s Day and Christmas.
• Developed workaround solutions for jobs that failed due to space constraints in Development servers and Archive servers.
• Also involved in creating the quarterly data required for Data Warehousing needs.
• Created logins as and when required for the application team and giving appropriate permissions to these Logins.
• Created logins as and when required for the application team and giving appropriate permissions to these Logins.
• Configured the latest version of DIAGNOSTIC MANAGER from Idera solutions for the monitoring of servers.
• Creating operators and alerts in getting notifications.
• Also worked extensively setting up all the servers in Diagnostic Manager, tweaking the settings for individual servers.
• Created and updated statistics on various tables as required by the query run by the application team.

Environment: MS Windows 2000 Server, SQL Server 2000 Enterprise Edition, Visual Studio 2002, Microsoft Office Excel 2000, IIS 5.0, Visual Basic 7.0/6.5,Third party tools.