SUMMARY

• Around 7 years of experience with the 32bit, 64 - bit Microsoft SQL SERVER in Production, Development and Testing in Clustered and Stand-alone Server Environment.
• Experience installing MS SQL SERVER 2000, 2005, 2008, 2008 R2, 2012, 2014 & 2016 updating with hot fix and service packs.
• Extensive experience in implementing High availability solutions like different Replication models (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines.
• Migration experience from MS SQL Server 2000 to MS SQL Server 2005/2008, MS SQL Server 2005 to MS SQL Server 2008. MS SQL SERVER 2008 to MS SQL SERVER 2012 and 2014.
• Experienced in using the DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for instant analysis.
• Expert-level skills in Objects creation such as Tables, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing.
• Experience in analyzing Locks, Dead Locks and handling the Isolation Level and Concurrency Effects.
• Extensively used the native tools such as index tuning wizard, database tuning advisor, profiler, performance monitor, activity monitor and Event viewer for performance analysis.
• Experienced in comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
• Experienced in Backing up, restoring the database manually and also by scheduling the jobs and Maintenance Plans.
• Extensively worked on Hot, Warm and Cold Backups; Security Management, Managing server and client Connections.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Skilled in auditing of database for user transaction, login and database action and removing orphan users
• Skilled in use of features such as Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS)
• Experienced in using tools like Bulk Copy (BCP) and Data Transformation Services (DTS) and SSIS Packages According to the Specifications with MS SQL Server 2000/2005/2008 R2.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

Languages: C# ASP. NET, T-SQL, My SQL, VB.NET, HTML, XML, C/C++, CSS, DHTML, Java Script

Operating Systems: Windows 95/2000/2003/2008 R2/2012/2012 R2, UNIX (Sun Solar), LINUX

Databases: MS-SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000 , Oracle 10g and Oracle 11g

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS), Informatica, Sisense

Scripting: Shell Scripting

Reporting Tools: SSRS, SSAS, Crystal Reports

DB Utilities: SQL Server Management Utility, Query Analyzer, Toad

Application Software: Visual Studio 2005/2008/2012/2015/2017 , Visual Source Safe, TFS, MS Office Suite, JBOSS, Github

Data Modeling Tools: Erwin, Red gate, Lite Speed

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

S QL Server DBA /System Administrator

Responsibilities:

• Worked on installation of MS SQL SERVER 2012, 2014 & 2016.
• Building new VM’s both Windows and Linux using VMware-vsphere/vclient.
• Adding newly built servers into the domain.
• Worked on setting up Always on Availability Groups for SQL Server 2014 Databases.
• Adding new drives based on need or expanding disk spaces when any drives run low on disk space.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Perform weekly database health checks using sp blitz and also performing DBCC checks via automated process.
• Schedule automated jobs to report data based on client needs.
• Write SQL queries to pull data for reporting purpose based on any given requirement.
• Migrate databases from SQL Server 2014 to SQL Server 2016.
• Setup Transactional replication for DB’s wherein the secondary DB server as part of the replication will be used for reporting and the primary is used for application read’s & writes.
• Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning. (Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc).
• Configure the secondary node’s in Availability groups for read only access and also to point SQL Agent reports to run on secondary replicas.
• Worked on managing SQL Databases on Microsoft Azure.
• Worked on improving DB performance, under high CPU & high memory situations. Also making use of SQL Server Profiler and Performance monitoring tools.
• Performed monitoring tool installations like New Relic for monitoring Server & App performance. And also setting alerts for disk space, CPU & high web app response times.
• Experienced in setting up Sisense, which was used as a reporting application.
• Applied SQL Server upgrades from SP1-SP3 in 2014 and also apply OS updates without taking any downtime.
• Worked on configuring application on JBOSS.
• Worked on setting up haproxy & apache using puppet.
• Experienced in Kanban boards & Jira methodologies.
• Backups and Restore using Lite-speed for SQL Server.
• Performance tuning, trouble shooting and monitoring using Performance Dashboard reports, Database Tuning Advisor, SQL Profiler, Dynamic Management views (DMV).
• Experienced in working with puppet & github.
• Maintained JBOSS servers used by our application & when need be do a rolling restart of all the JVM’s
• Provide 24/7 on-call support, both for the DB’s and Application Servers as well.

Environment: Windows Server 2012 R2/2008R2, Linux Servers, Unix Servers, SQL Server 2012, SQL Server 2014 & 2016, SSRS, SSIS & Sisense

Confidential, Bothell, WA

S QL Server DBA

Responsibilities:

• Worked on installation of MS SQL SERVER 2008 R2, 2012, 2014.
• Implemented Side by Side Migration of MS SQL SERVER 2005 to 2008R2 on Windows 2008R2 server and also worked on migration from SQL Server 2008 to 2012.
• Extensively worked on Active-Active and Active-Passive Clustering and also experienced with Multi-subnet clustering which is an additional feature in SQL Server 2012.
• Worked on setting up replication such as Transactional and Snapshot replication.
• Enhanced the capability of Database Mirroring using the latest feature in 2012 i.e., the Always on Availability Group.
• Designed Always On Availability Groups and Database Recovery plan, Implemented Database Mirroring in SQL Server 2014/2012/2008 r2 and participated in Disaster Recovery Drill processes.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Experienced in handling health and performance issues using special procedures like sp blitz.
• Involved in Change Data Capturing (CDC) records INSERTs, UPDATEs, and DELETEs applied to SQL Server tables.
• Used the new concepts of SQL server 2012 and also the 2008 DMV’s for monitoring the fragmentation of indexes, blocks, memory page splits, Log space of all the databases.
• Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning. (Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc).
• Handled up to 3 TB size databases with clustered and replication environment.
• Configured Transactional replication between primary servers and read only server, with separate Distributor server and experience in troubleshooting replication problems.
• Worked on configuring Linked Server for SQL Server 2005 and 2008R2 to connect to a non-SQL Server data source using OLEDB Provider.
• Experience in handling SQL Server 2016 Databases and monitoring them.
• Worked on Performance tuning, trouble shooting and monitoring using Performance Dashboard reports, Database Tuning Advisor, SQL Profiler, Dynamic Management views (DMV).
• Troubleshoot various problems that arise in a day-to-day work and fix the issues.
• Extensively worked on some features of SQL Server 2008 like Log compression, transparent data encryption TDE, Performance data collector and Auditing.
• Worked on administering very large database with more than 10 billion rows and DB size up to 3 TB.
• Performed Back-up and restore of databases manually and also by scheduling jobs and Maintenance Plans.
• Once created the database Backups, monitor those backups are being performed regularly.

Environment: Windows Server 2012/2008R2, Linux Servers, Unix Servers, SQL Server 2005, SQL Server 2008, SQL Server 2008R2 and SQL Server 2012/2014, SSRS and also on Oracle 10g and Oracle 11g .