PROFESSIONAL SUMMARY:

• Microsoft Certified SQL Server Database Administrator with more than 5 years of proven professional experience in RDBMS database design, administration, development and production support of very large and complex database on a windows and windows server cluster environments.
• Installation, Configuration, upgrade and administration of SQL Server Instances, databases, Schema and Objects.
• Proficient in Query Optimization, Performance Tuning, Client/Server Connectivity, Data Transformation Services and running Database Consistency Checks Using DBCC commands in SQL Server environments 2000/2005/ 2008/2008 R2/2012/2014
• Thorough Experience in DR and/or HA Planning, Execution and Testing at remote side.
• Extensively worked on Active - active/active-passive clustering.
• Solid experience and knowledge in setup of high availability SQL Server solutions, including Mirroring, Log shipping, Replication and Failover Cluster Instance (FCI) and AlwaysOn Availability Groups.
• Configured Database Mirroring for multiple databases on different versions of SQL Server.
• Implementation of Database administration activities for DB Security (Creating Logins , users, roles, and assigning permission to them).
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database model’s data integrity, SQL joins and query writing.
• Have hands on experience with Powershell for backups, DBCC DB checks, post installation setups (security (user & logins) and automating of jobs.
• Experienced with all phases of Software Development Life Cycle (SDLC) and project methodologies
• Troubleshoot SQL server performance including I/O, CPU, Memory and Disk space contention.
• Master in query optimization and performance tuning, Using SQL Server Profiler, Execution Plan, Performance Monitor, extended events and DBCC Commands
• Experience in OLTP/OLAP system study, Analysis and modeling
• Worked on a client and server side development environment as per the business requirements
• Automation of Backups and Restore , Mirroring, Replication, Log shipping, Failover Cluster, Availability Group jobs.
• Configuring database maintenance jobs, alters, mail, triggers, executable store procedures.
• Professional in managing SQL server profiler for tracing events, stepping through problem queries, diagnosing slow-running queries, blocking, deadlock and monitoring the performance of SQL Server to tune workloads.
• Knowledge of index structure, index management, index maintenance ( rebuild, reorganize, defragment ) and updating statistics. knowledge and working experience of Operating Systems (O/S) including Windows Server 2012 and 2008r2
• Data migration SQL server 2000/2005/2008/2012 from Excel, Flat file using BCP and SSIS utility .
• Generated Report using SSRS (SQL Server Reporting Services), Excel, HTML and text format.
• Microsoft Business Intelligence technologies expert by creating SQL Server Integration Services (SSIS) packages (conditional split, derived column on data retrieved, data validation checks during staging and loading into Data warehouse) and SQL Server Reporting Services (SSRS)
• Extensive experience in extracting, transforming and loading (ETL) data from various sources (Oracle, Flat file, CSV file).
• Worked with an Agile team (DBA's, DBD's, SAN Engineers', Infrastructure team members) on Storage, Network, security, performance and testing issues

TECHNICAL SKILLS:

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

Programming Languages: TSQL, C#, XML, HTML, Visual Studio2003

Operating System: Windows Servers 2012/ 2008R 2/2008/2003/2000 , XP, Vista, Win 7.

ETL Tools: SSIS, SSAS, SSRS, DTS

Third Party Tools: Erwin, Redgate, Spotlight, Litespeed

Database Tools: SQL Server Management Studio, Enterprise manager, Query Analyzer, SQL Profiler, Replication, Clustering, Database Tuning Advisor and Index Tuning Advisor Client, SQLcmd, Upgrade Advisor, Application Manager, Asset Explorer, SCOM.

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

SQL SERVER DBA

Responsibilities :

• Installed and configured new SQL Server 2008R2, 2012 and 2014 Database Server instances, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) on cloud virtual machines for Development, Testing and Production Environment.
• Designed, reviewed, and created primary objects like databases, views, indexes, stored procedures, functions, and triggers based on logical design models and user requirement.
• Used PowerShell scripts for backups, list of failed jobs, running database integrity checks, and setting default data and log file locations for post installation activities (setting up users and logins, automating jobs)
• Administered MS SQL Server security by enforcing security policy, creating user logins with appropriate roles, monitoring user accounts, creating groups, granting privileges to users and groups.
• Applied Data partitioning on one of the large tables where reports has shown I/O contention and significantly improved the performance.
• Conducted root cause analysis of performance issues and narrowed down issues related to coding practices, database bottlenecks, or network latency.
• Performed database regular Backups (Full/Differential/Transaction Log Backups into Disk and striping for large Databases) and verified their restoration.
• Implemented a Database maintenance plan for MSSQL Server (DBCC, updating Index statistics, monitoring database and disk space)
• Expertise in using Performance Monitor(Perfmon), SQL Profiler, Activity Monitor to resolve dead locks, Long Running Queries, and Bottlenecks caused by complex queries.
• Regularly Boosted performance of databases by implementing Index Maintenance, Index tuning, Rebuild & Reorganizing according to Index fragmentation, running DBCC checks and, Update Statistics to check Data Integrity
• Resolved tickets issued by regularly monitoring health of SQL server, analyzing the logs, troubleshooting SQL Server problems such as SQL Server services, Concurrency problems (blocks, locks, deadlocks) and SQL Agent job execution problems
• Configured Replication for updating a critical table to various branches (Subscribers)
• Used Merge replication to update the publisher from the subscribers in an periodically
• Configured Log shipping of database for reporting server within the firms’ latency objective
• Mirrored one of our critical database with zero latency/synchronized, with a witness on a SQL 2008
• Part of the team who Implemented AlwaysON availability group for one of our critical server on SQL 2012 that was installed via nodes on WSFC cluster
• Regularly run DBCC commands to check physical and logical consistency of the databases and Rebuild when loss of integrity is reported
• Modified queries to achieve better performance and used SQL Server profiler to capture and store the execution plans.
• Designed Extraction Transformation and Loading (ETL) packages using SSIS to extract data from flat files, excel files and SQL server database and created DTS Packages for executing jobs and regular tasks
• Developed and deployed custom reports on server using SQL Server Reporting Services (SSRS) in different forms using drill down, matrix, drill through, cascading and parametrized reports.
• Providing SQL Server implementation changes requested from application teams.
• Created automation of day to day operations, critical SQL server alerts and repetitive tasks.
• Provided assistance on data modification and configuration of Production environment.

Environment: MSSQL Server 2005/2008/2008 R2/2012/2014 Enterprise on 64X-bit OS, Windows server 2008R2, Windows server 2012R2 data center, SQL Server Management Studio, Enterprise manager, Query Analyzer, SQL Profiler, Replication, Clustering, Redgate

Confidential, Raleigh, NC

SQL Server DBA

Responsibilities:

• Installed, configured and administered SQL server 2008R2/2008/2005 in production, staging, testing and development environments.
• Applied recommended Service Packs and hot fixes for SQL server 2008.
• Created logical and physical data modeling using Erwin tool.
• Managed security on Production and Development environments.
• Intensively analyzed and documented the existing database administration protocols since inception and developed procedures on database planning and implementation, security aspects, auditing and created new policy based managements using available conditions.
• Reviewed the current procedure of backup and restoration scenario, and introduced the differential back up into the system and periodic restoration of backups.
• Monitored SQL Server and Application Logs at regular intervals to analyze the application and system behavior.
• Overall follow-up of the system and user databases to address any issue and plan for potential problems in advance
• Configured mirroring and log shipping, and regularly monitored when issues where raised
• Measured and recorded user database space usage trends and Proactively managed capacity by implementing right maintenance steps
• Configured user database and Tempdb space issues on production servers, and improved efficiency of performance.
• Maintained and monitored production database for performance and system uptime by Identifying the bottlenecks of contention
• Created Views by joining multiple tables to reduce database complexities for the end users
• Involved in development of new codes and maintenance of existing ones by fixing bugs whenever tickets are issued through testing procedure.
• 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
• Installed and configured SQL Server Reporting Services.
• Implemented, designed and developed reports using SQL server reporting service that extract data and present daily, weekly and monthly reports in a user friendly format

Environment: MSSQL Server 2008R 2/ 2008/2005/2000 , Windows server 2008/2003 Datacenter and Enterprise edition 32X-bit and 64X-bit OS, T-SQL, SSIS, SSRSTFS (Team Foundation server), Visual studio2005, Erwin tool

Confidential, Chicago, Illinois

Jr. SQL Server DBA

Responsibilities:

• Installed and configured new standalone MS SQL Server services ( 2008/2005/2000 ) with latest Service packs.
• Migrated databases from SQL Server 2000 to future production environment SQL Server 2005 and troubleshoot security issues (Orphan users) after migration.
• Created and designed user databases on test and development environments
• Monitored SQL Logs to ensure success of schedules, jobs, and backups
• Inspected log shipping and mirroring issues on production servers
• Run DBCC consistency checks and fixed data corruption in application databases.
• Configured Database Mail.
• Implemented security by creating user logins with proper roles and granted an appropriate privilege to groups.
• Setup of transactional and merge replication and troubleshooting replication errors.
• Solved production issues and incident tickets timely.

Environment: MS SQL Server 2008/2005/2000 , Windows server 2008/2003 Datacenter and Enterprise edition 32X-bit and 64X-bit OS, T-SQL, SSIS, SSRS, Visual studio2005