SUMMARY:

• Microsoft Certified SQL Server Database Administrator with more than five years of invaluable work experience, a thorough understanding of SQL Server. Well experienced in various aspects of Database Administration, Performance Tuning, Security, HA and DR solutions and incident handling. Experienced in SQL Server Configuration, Installation, Management, Upgrading system Analysis both in 24 x 7 Production, Development, Test and Cluster environments and provided on call and day­ to­day support.
• 5+ years of proven IT experience in Database Administration, Design Development and Support of MS SQL Server 2012/2008R2/2008/2005 in Production, Test, Development and Cluster Server Environments.
• Experience in RDBMS database design, MS SQL Server Performance Tuning, Query Optimization, Client/Server Connectivity, Data Transformation Services and running Database Consistency Checks Using DBCC in SQL Server 2005 and SQL Server 2008/2008R 2/2012/2014.
• Experience in DR and/or HA Planning, Execution and Testing at remote side.
• Solid experience and knowledge of high availability SQL Server solutions, including Mirroring, Log shipping, Replication and AlwaysOn Failover Cluster Instance (FCI) and AlwaysOn Availability Groups.
• Experience in Data migration between SQL Server 2000, 2005, 2008, 2012, 2014 from Excel, Flat file, DTS, SIS utility
• Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them).
• Worked in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
• Highly proficient in the use of T - SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models data integrity, SQL joins and query writing.
• Have hands on experience with DBCC DB checks, post installation setups (security (user & logins), and automating some jobs.
• Experience in extracting and transforming (ETL process).
• Extensive work experience on DTS/SSIS Import Export Data from various sources, Bulk Insert, Log Shipping, BCP and DTS/SSIS Packages.
• Master in query optimization & performance tuning, Using SQL Server Profiler, Execution Plan, Performance Monitor, extended events and DBCC Commands.
• Worked on Server side development according to the business requirements.
• Managed installation, upgrade, configuration and administration of Microsoft SQL Server 2008/2008 R2/2012/2014 database.
• Implementation of SQL Logins, Roles and as a part of security policies for various categories of users.
• Configuring and Managing SQL Server Instances, databases, Schema and Object.
• Troubleshoot SQL server performance including I/O, CPU, Memory and Disk space contention.
• Implementing and managing automated Backups and Restore, Mirroring, Replication, Log shipping, Failover Cluster, Availability Group jobs.
• Configuring database maintenance jobs, alerts, mail, triggers, executable store procedures.
• Experienced in Data migration between SQL server 2005/2008/2012/2014 from Excel, Flat file using BCP and SSIS utility.
• Experienced of indexes structure, index management, index maintenance of rebuilding, reorganize, defragment and updating statistics.
• Experienced in SQL server profiler for tracing events, stepping through problem queries, finding and diagnosing slow-running queries, blocking, dead lock, monitoring the performance of SQL Server to tune workloads, an error written to the SQL Server error log, the Start or end of a store procedure.
• Experienced in RDBMS and constructs to design relational databases model and implementation as per business needs.
• Import & Export data from Oracle, Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP.
• Generated Report using SSRS (SQL Server Reporting Services), Excel,HTML and text as well.
• Good knowledge and working experience on Operating Systems (O/S) include Windows Server 2012,2008 and MS-DOS.
• Worked with various teams like storage, network, security, and various system administrators in production and migration issues.

TECHNICAL SKILLS

SQL Server Databases: MS SQL Server 2012, 2008R2, 2008, 2005, 2000, MS Access 2000/2003.

Programming Languages: TSQL, SQL, Trigger, Stored Procedures, HTML, CSS.

Operating System: Windows Servers 2012/ 2008R 2/2008/2003/2000 , XP, Vista, Win 7. Microsoft word, Excel, and PowerPoint.

Tools: SQL Server Management Studio, Enterprise Manager, Business Intelligence Development Studio, Query Analyzer, SQL Profiler, SSIS and DTS, Replication, Clustering, Database Tuning Advisor and Index Tuning Advisor, Reporting Services Report Manager, Reporting Services Configuration and Report Builder, Client and Server Network Utilities, SQLCMD, Upgrade Advisor, ERWin, DB Artisan, Toad for SQL Server, Visio, Application Manager, Spotlight, Asset Explorer, SCOM, SSRS and RedGate, Idera.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server Database Administrator

Responsibilities:

• Provided 24 X 7 dedicated supports for Development, testing and Production MS SQL Servers.
• Install, Configure and Administered Stand alone and clustered SQL Server 2012/ 2008R2 instances.
• Implement Migration and Upgrade on MS SQL Servers 2005/2008R2/2012 and applied service packs.
• Design, review, and create primary objects like views, indexes, stored procedures, functions, and triggers based on logical design models, user requirements and physical constraints.
• Regular monitoring of SQL server, analyzing the logs, troubleshooting SQL Server problems such as SQL Server service, Concurrency problems (blocks, locks, deadlocks, activity monitor), and SQL Agent job execution problems.
• Administer the MS SQL Server security by enforcing security policy, creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Administered SQL Server/Database level Security and utilized Auditing and Data Encryption according to requirements.
• Performed replication for updating a critical table to various branches (Subscribers).
• Use transactional replication to update the publisher from the subscribers as well as from the subscriber to the publisher in periodically.
• Regularly configure and monitor mirroring, replication by script.
• Implemented SSIS Import/Export tool and migrated heterogeneous data from access, flat files, excel in to SQL server database and vice versa.
• Monitored and Troubleshoot Server performance and database activities of particular users using SQL Profiler, Performance Monitor, Extended Event, Trace flags, Activity Monitors, Store Procedures, DBCC, and DMVs.
• Fine tune slow running T-SQL queries using Execution Plan and Database engine tuning advisor.
• Evaluate CPU, Disk I/O and Memory related bottlenecks using Performance Monitor and improved the SQL server performance.
• Enhance performance by running index tuning wizard for creating, rebuilding and reorganizing indexes on various tables.
• Work with the agile team (DBA's, Application Developers, SAN Engineers', Infrastructure team members).
• Mirror one of our critical database with zero latency/synchronized- with witness/for critical Database on SQL 2008R2.
• Perform full, differential and transaction log backups both lab and production environments.
• Refresh Lab environments every week by taking the latest backup from production server.
• Perform deployment on testing, staging and production servers with different team.
• Implement maintenance plan, Jobs and alerts .
• Design Extraction Transformation and Loading (ETL) process using SSIS to extracted data from flat files, excel files and SQL server database.
• Use DBCC commands to check physical and logical consistency of the databases and Rebuild.
• Report daily database checks to the supervisor.
• Manage Jira dash board for each work order and use confluence to share documents to the team.

Confidential

SQL Server Database Administrator

Responsibilities:

• Installed and configured new SQL Server 2008R2, 2012 and 2014 Database Server instances on cloud virtual machines, SQL Server Integration Services (SSIS) for Development, Testing and Production Environment.
• Designed, reviewed, and created primary objects like views, indexes, stored procedures, functions, and triggers based on logical design models, user requirements and physical constraints.
• Regular monitored of SQL server, analyzing the logs, troubleshooting SQL Server problems such as SQL Server service, Concurrency problems (blocks, locks, deadlocks, activity monitor), and SQL Agent job execution problems.
• Administered the MS SQL Server security by enforcing security policy, creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Implemented a DB maintenance plan for MS SQL Server (DBCC, updating index statistics, monitoring database and disk space) and running, SQL Tracer and SQL Profiler.
• Enhanced performance by running index tuning wizard for creating, rebuilding and reorganizing indexes on various tables.
• Performed replication for updating a critical table to various branches (Subscribers).
• Used Merge replication to update the publisher from the subscribers as well as from the subscriber to the publisher in periodically.
• Log shipping database for reporting server within the firms’ latency objective.
• Mirrored one of our critical database with zero latency/synchronized- with witness/for critical Database on SQL 2008.
• Part of the team which configured AlwaysOn with availability group for one of our critical server on SQL 2012 that was installed via nodes on WSFC (Window Server Failover cluster).
• Performed full, differential and transaction log backups.
• Created the SQL Server Integration Services (SSIS) and DTS Packages for executing the required tasks.
• Created the Jobs and scheduled for daily running.
• Designed Extraction Transformation and Loading (ETL) process using SSIS to extracted data from flat files, excel files and SQL server database.
• Used DBCC commands to check physical and logical consistency of the databases and Rebuild.
• Used the SQL Server profiler to capture and store the execution plan.
• Modified queries to achieve better performance.
• Provided weekly, monthly, yearly quality control reports for work orders, service requests.
• Represent reports in different forms using graphs, charts, tabular, area and pie charts as required.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).

Confidential

Junior SQL Server Database Administrator

Responsibilities:

• Installed and configured SQL server 2005, 2008 and 2008R2 on a test environment to be the future production environment.
• Installed and configured SQL Server Reporting Services.
• Installed necessary Service Packs for SQL server 2008.
• Managed security on Production and Development environments.
• Designed, developed and implemented SQL server reporting service that extracts data and present in the user friendly formats.
• Created the logical and physical data modeling using Erwin tool.
• Database optimization such as performance tuning and improvement.
• Intensively analyzed the existing system in regard to the database administration and produced an inception.
• Develop procedures/protocols on database planning and implementation, database security aspects, database auditing, Backup and restore modality.
• Review the current procedure of backup and restoration, and introduced the differential back up into the system and periodic restoration of backups.
• Overall follow-up of the system and user support to address any issues and plan for potential problems in advance.
• Created Views to reduce database complexities for the end users.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008R2.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).