SUMMARY:

• Over 7 years of Database Administration & Development experience in SQL Server 2012/2008R2/2005 in production and non - production environments.
• Very good Knowledge of Relational Database Management System (RDBMS).
• ExperiencewithBuildingSQLServerWindowsClustering,VMandStandaloneserverswithallversionsof SQL Server and their Installation, Configuration and Maintenance.
• Hands on experience on SQL Server Always ON availability groups, column store Indexes and In-Memory Tables
• Good expertise in Performance Tuning, Indexing, monitoring SQL Server, using Database Tuning Advisor, SQL Profile (dead locks/ long running queries), Windows Performance Monitor and Database Consistency Check using DBCC Utilities
• Extracted, Transformed and Loaded (ETL) data in Data warehousing using SSIS packages
• Installed and configured SQL Server 2012/2008R2 on new 32-bit and 64-bit Operating Systems.
• Resolved issues with Indexes, Blocking and locking issues to remove the performance bottlenecks
• Proficiency and Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning
• Successful in Implementing Database Mirroring in SQL server 2008.
• Strong experience in Migrating database objects such as Tables, Views, Stored Procedures, UDF's and Logins in SQL Server 2005/2008R2/2012.
• Strong experience in performing database administrative tasks such as Database Backups, Restore and Recovery Procedures, Data Loading using SQL Server Import and Export wizard, Attach/Detach databases, Database Shrinking, Rebuild Indexes, Upgrading Service Packs, creating database level Roles, using DBCC commands, Cleaning up Orphaned users, Database Compatibility levels and Collation
• Involved in Installing, Configuring and Maintenance of Cluster in SQL Server 2008R2 and SQL Server 2012 on Active nodes
• Monitoring and optimizing the performance of the Queries and Indexes using SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor, DBCC commands and Dynamic Management Views
• Good experience in creating Maintenance Plans, Linked Servers, Operators, SQL Server Jobs, Configure Database Mail and Checking the SQL Server Error Logs to ensure that processes have completed successfully.
• Proficient in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP and DTS utility.
• Working in adherent toService Level Agreements (SLA’s) according to the client’s requirement
• Working knowledge in SQL Server Reporting Services (SSRS) and hands on experience in working with SQL Server Integration Services (SSIS).
• Hands on experience in Batch Processes, Import, Export, Backup, BCP, DTS and SSIS (including data loading).
• A Team-Player with motivation and ability to work independently, Worked closely with the Case Teams, Business Analysts and Data Analysts and Functional Design Teams
• 24/7 on call Production support

TECHNICAL SKILLS:

Languages: T-SQL, VB.Net, HTML, C

Services: Database Engine, SSIS, SSRS(Visual Studio 2008, 2005)

RDBMS;: MS SQL Server, 2005, 2000, 7.0, Teradata sql assistantMS Access databases.

Reporting Tools: BIDS, Report Builder 2.0, Report Builder 3.0

Modeling Tools: Microsoft Visio, SQL Diagrams, SQL Server Enterprise Manager

Operating Systems: Windows 2008 R2/2003/2000 Server (64/32 Bit), Windows 2000 Professional, Windows NT 4.0/3.5.

Other Tools: DTA, SQL Profiler, DTS XCHANGE, Citrix, Diagnostic Manager, SQL Lite speed, RMAN,Precise, Spotlight.

PROFESSIONAL EXPERIENCE:

Confidential, Boise, ID

SQL Server DBA

Responsibilities:

• Production supporting DBA activities in huge OLTP environments.
• Analyzing and designing and implementing different types of Replication Models.
• Supporting Huge Databases, Troubleshooting the problems.
• Spreading huge tables to different file groups to achieve maximum performance.
• Writing TSQL code and complex stored procedures for different tasks. Tuning the code written by team members to achieve optimum performance.
• Setting up Disaster Recovery solutions using Log shipping, Mirroring, Always On (2012) in windows clustering environments for High Availability.
• Setting up monitoring alerts and dashboards in addition using of SQL built-in dashboards.
• Discussion with peers about performance issues, SQL Internals about log shipping, DB mirroring, replication etc.,
• MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Database creation, restoration, recovery, User/Schema Creation and maintenance Space Management.
• Monitoring and Troubleshooting SQLServer using Windows System Monitor, creating an Alert in Windows System Monitor, creating a SQL server Performance Alerts.
• Data migration (import & export - BCP) from Text to SQL server.
• Setting up High availability always on future on new 2012 servers.
• Good understanding and experience in SQL Server 2008 features like Change Data Capture (CDC), Transparent Data Encryption (TDE) and Policy based Management.
• Prepared and documented Backup & Restore Plans and manage data import and export form multi-agency interfaces
• Managed team of 6 DBA’s on a 24*7 production support basis.
• Supported Application Development team with any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc

Environment: SQL Server 2014/2012/2008, SSIS, SSRS, Visual studio 2008, MS Visio 2007, XML, VB.Net, Report Builder 3.

Confidential, Hartford CT

SQL Server Database Administrator

Responsibilities:

• Installed and Upgraded from SQL Server 2005 to SQL server 2008 and 2008 R2, 2012, 2014.
• Excellent knowledge on MS SQL server 2014.
• Created Databases, Objects, Stored Procedures, Triggers, Security, DTS (i.e. Import and Export), BCP, Transact-SQL, Backups, Recovery and SQL Server Agent, SQL Server profiler using SQLServer 2012.
• Created and maintained Database mirroring with automatic failover, Replication as a High availability.
• Worked extensively on Data Maintenance like Re-indexing, Integrity Checking, Database Shrinking.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Prepared Documentation for the Disaster Recovery plan
• Responsible for maintaining High availability servers like Clustering and transactional Replication.
• Implemented Point in time Backup and Recovery Plans of all databases and maintained documentation.
• Involved in Scheduling Tasks, Setting Alerts, Managing Task Scheduling, setting up SQL Mail, Managing Alerts, Monitoring and Tuning SQL Server, and also suggested better Scheduling Strategy for jobs to overcome Blocking and Dead Locks.
• Executed Data migrations from one database structure to another Using SSIS Review and Migrated Stored Procedure.
• Installed and Configured Reporting Services, Created Monitoring Reports.
• Worked on a package Migration wizard in SQL Server 2005 to migrate DTS Packages to SSIS, SSIS Package Configuration, and passing variables dynamically and used SSIS Logging.
• Advanced extensible reporting skills using SQL Server 2005 Reporting Services (SSRS)
• Implemented Disaster Recovery for SQL Server DBA Production Database as Fail-Over or Standby Servers.
• Used Log Shipping Technique for backup solution for MS SQL Server databases.
• Very good experience in the Maintaining Production Servers, Monitoring Performance issues, Trouble Shooting and Solving Production Issues.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Created Triggers, User-defined Functions, and Views for both Online and Batch requests handling business logic and functionality of various modules.
• Analyzed the existing application programs and tuned SQL queries using Execution plan, Query Analyzer, SQL Profiler and database Engine tuning Advisor.
• Creation and maintenance of Users security permissions and Migration of entire database objects from one Server to another Server and database to another database.

Environment: Microsoft SQL Server 2012/2008R2, Enterprise Edition, Microsoft Windows 2008 R2/2003 Server,Microsoft SQL Server Integration Services, Microsoft SQL Server Reporting Services

Confidential, Kalamazoo MI

SQL SERVER DBA

Responsibilities:

• Upgraded SQL server from SQL 2000/20 R2/2012/2014
• Worked as a team to maintain 100 percent up time to keep the environment running irrespective of any infrastructural changes in the environment.
• Implemented and Maintained DBA tasks like scheduling jobs, creating maintenance plans.
• Performed Permissions, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Worked migration tools like ATTACH/DETACH using excel.
• Created & maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions and other schema objects.
• Monitoring SQL server performance using profiler to find performance, dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Responsible for Stored Procedures optimization, Performance tuning & index tuning.
• Provided necessary data validation checks against the data entry.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Strong experience in handling Microsoft office suite like word, PowerPoint, excel to generate reports
• In Analysis Services (SSAS) OLAP created Cubes, Star Schema and Snow Flake Schema, ETL and Data Warehousing
• Utilized PowerShell to maximize SQL server productivity and efficiency.
• Derived and documented the Analysis for production issues in SSAS.
• SSAS native tools utilized to generate reports in Microsoft Visual Studio
• Implemented Always ON High Availability in SQL Server 2012
• Worked on call 24/7 Support on weekly basis.

Environment: SQL Server 2000/2005/2008/2008 R2 with clustering, Replication,Log shipping,Mirroring, TSQL,Windows2003/2008R2,BugZilla,DTS,SSIS,RedGate,Profiler,SQLSentry,Sharepoint,IBMDB2,TSM,TFS,LiteSpeed,SVN.

Confidential, Pittsburg, PA

SQL Server DBA/ Application DBA

Responsibilities:

• Installed and configured SQL Server 2005/2008/2012 in production and non-production environments
• Maintaining database objects like Tables, views, indexes.
• Successfully performed DBA activities like database backup and scheduling backup jobs.
• Resolved deadlock issues using SQL Server profiler by creating traces on objects.
• Applied patches and responsible for database migration in different versions
• Performed IN-place upgrade method for migrating SQL server 2005 databases into SQL server 2008 databases
• Performed routine DBA tasks likemonitoring, troubleshooting, debugging and performance optimization for SQL server database and application related issues in SQL server environments across the system.
• Assign security permissions to users, roles, and object. Administrate security for server's logins with windows and SQL accounts.
• Regularly checked growth and changes according to database audit report.
• Worked with Application development using Visual Basic.
• Participated in testing and debugging to validate data after the export/import/delete.
• Actively participated in gathering of User Requirement and System Specification.
• Maintained and createdReplication:Merge,Transaction and Snapshotand also implemented data transformation to the published articles
• Used DDL and DML to writing triggers, developed stored procedure, functions, views and triggers.

Environment: SQL Server 2005/2008, T-SQL, Windows Server, HTML 4.0, JavaScript, Access

Confidential

Jr Database Admin

Responsibilities:

• Performed server installation and configurations for SQL Server 2005 and SQL Server 2000.
• Maintaining regular DBA tasks like creating users, roles and granting and revoking security.
• Performed regular database backup and restore activities
• Coordinate with windows team in patching
• Create packages, procedures, functions, and triggers; handle database performance and tuning.
• Assisted users in modifying stored procedures over performance issues.
• Developed backup and recovery strategies and disaster recovery plans.
• Involved in migration from SQL server 2000 to SQL server 2005
• Involved in performance tuning and monitoring of T-SQL blocks.
• Developed report models and deployed report server.
• Generated DML scripts using T-SQL procedures to modify database objects on basis of user inputs
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Worked with a team that involves in 24*7 operations

Environment: SQL Server 2005, 2000, T-SQL, CVS, Windows NT/2000/XP