SUMMARY

• Overall 8 Years of experience in Database Administration, Design, Development (MSBI) and Support of MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 in Production, QA, Test, Development Environments
• Experience in Installation and maintaining of different version of SQL Servers (2016,2014, 2012, 2008R 2/2008/2005/2000 ) in both OLTP and OLAP lower regions and Production environments and hotfixes service packs on standalone and clustered Servers.
• Implemented High Availability & Disaster Recovery techniques like Always ON Availability Groups, Clustering (Both Active - Active and Active--Passive), Database Mirroring, Transactional Replication and Log Shipping.
• Upgraded SQL Server databases from SQL Server 2000/2005 to SQL Server 2008R 2/2012/2014.
• Hands on experience in working with MSSQL SERVER 2005, 2008 and 2008R2 features and extensive knowledge on SQL 2012/2014 new features.
• Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup/Recovery of databases, Replication, Linked Servers, and Database Maintenance.
• Expertise in Performance Tuning, Index Tuning, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Expert in using Native tools like SQL Server Profiler, Database Tuning Advisor and Perfmon, Idera, RedGate, LightSpeed,
• Hands-on experience in resolving locks deadlocks, handling Isolation levels and performance issues like CPU, I/O, Memory bottlenecks.
• Experience in planning and implementing Database Security by creating Logins, Users, Roles and assigning permissions according to the requirement.
• Worked on logical and physical data base modeling with UML and ERWIN tools.
• Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.
• Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.
• Handled numerous Change Management requests on production servers and Supported 24 X 7 Production on Call.
• Documenting procedures in runbooks.
• Involved in installation and administration of Reporting Services (SSRS), Integration Services (SSIS), and Analysis Services (SSAS).
• Involved in designing SSIS /DTS packages to import and transform Data between databases and external data sources.
• Experience in Extraction & Migration of data from Heterogeneous Data sources like Excel, MS Access, Oracle, DB2 to MS SQL server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities
• Involved in migrating DTS packages to SSIS packages and troubleshooting migrating issues.
• Performed Backup and restore of SSAS cubes.
• Involved in Reporting services Administration by creating roles, users and providing security to reports.
• Experienced in enterprise reporting in generating reports using Linked Reports, Sub Reports, Adhoc Reports, drill down reports, Drill through reports and filters, charts in SQL server reporting services.
• Excellent communication and interpersonal skills with ability to co-ordinate activities and work in a team environment to meet the deliverables.
• Subscribe SQL Server Azure Cloud Services.
• Create Database(s) on SQL AZURE
• Setting up SQL Azure Firewall
• Create, manage SQL Server AZURE Databases
• Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio(SSMS) for Developers
• Migrated On premise SQL Databases to Azure SQL.

TECHNICAL SKILLS

Scripting: Shell, PowerShell

Database Tools: Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, DTS, SSIS, Upgrade Wizard, Lite Speed, Idera.

Programming: Visual Basic 6, Visual Basic 5, C, C++ & SQL

Issue Tracking: Jira, Squids

Version Control: SVN, TFS

Applications: Microsoft Office, Visio, and Visual SourceSafe, TFS.

Operating systems: Windows 2012/2008/2003 Server

Reporting Tools: SSRS, Cognos, Business Objects, Micro Strategy, QlikView, Tableau.

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

MS SQL Server DBA

Responsibilities:

• Managed workforce effectiveness SQL Server databases. The applications and associated databases track worker activities throughout the day and allow management to review and use the data to improve productivity. The primary database application I supported has 20,000+ users who daily and in real-time record all their work.
• Migrated the primary database from a SQL 2008 physical server to a VMware SQL 2012 AlwaysOn AG Cluster.
• Configured the Cluster for read-only routing to the secondary replica node for heavy SSRS reporting.
• Migrated on Premise Sql Server Databases to Azure SQL Databases on logical Server.
• Installed Azure SQL VM and set the Firewall settings.
• Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio(SSMS) for Developers.
• Used Sql server Virtualization(Nutanix) to migrate on premise physical servers to virtual environment.
• Experience on Active Geo Replication for Disaster Recovery on Azure SQL.
• Removed nearly two Terabytes of unwanted old data and helped implement SSIS processes to cleanse the data daily.
• Refined and implemented new views and SSIS data feeds for external business partners and data warehouse.
• Involved in Huge Database Migrations for Bank Several Districts Object Stores and analyzed legacy systems and databases to support data store FileNet Servers.
• Improved database performance by adding missing indexes, reviewing queries and assessing instance configuration.
• Used Fog light to monitor the performance of SQL Server.
• Upgraded SQL server databases from 2008R2 to 2016.
• Experience in tuning the performance of the queries using Query store.
• Used Memory optimized tables(In-memory) to boost more performance of sql2016 databases.
• Used Stretch databases to migrate the cold data to the cloud.
• Created and updated data verification plans and expected outcomes to be used for script runs.
• Involved in creating new and Modifying SSIS Packages for different business object stores.
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Expert in implementing the snapshot isolation and DDL triggers.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Using BCP to Bulk copy data
• Implementation of Logins, creating assigning responsibilities as a part of Security Policies for various categories of Users.
• Restructuring the stored procedure, designing, coding and developing the same using the T SQL Programming.
• Transferring the data (ETL) by SSIS.

Confidential, Tulsa, OK.

MS SQL Server DBA

Responsibilities:

• Responsible for Logical & Physical Database Design.
• Experience in Handling 70+ Production Servers out of 10 Servers are having 1- 2 TB Databases.
• Migrated Huge databases of 5 TB from SQL server 2008R2 to 2012.
• Built Extended Events tool mechanism for BI Servers on SSAS platform.
• Experience in handling Tivoli TSM Tool for database backups.
• Handled Capacity Planning for Crucial Servers which are of 2TB databases.
• Experience in Resolving the Memory contentions using SQL Min/Max Settings, SQL 2008 Resource governor and Lock pages In Memory settings,Page File settings, Memory related DMV’s
• Identify deadlock, blocking scenarios and Perform Re indexing and Index defrag operations for the maintenance of large tables to resolve performance issues.
• Optimize the TempDB performance by striping and move to dedicated SAN.
• Assisted in Installation and Support of Transactional Replication.
• Experience in Handling High Availability Log shipping.
• Handled Database Refresh in QA-Test and stage environment and fixed orphaned users.
• Created and maintained databases, tables, views, users, logins, indexes, check constraints, CTE and business rules using T-SQL.
• Convert the packages using Package Deployment Model and deploy the packages into production environment by using Integration Services Catalogs.
• Troubleshooting Application issues using SQL Profile Trace.
• Analyzing long running slow queries and tuning the same to optimize applications and system performance using IDERA.
• Backup and recovery of production databases on daily /weekly basis to ensure data integrity, striping the backups to ensure easy backup management.
• Capacity Planning for Crucial Servers in Production Environment.
• Perform database monitoring data and log growth, Jobs, Alerts, disk usage and cleanups, using various custom scripts in SQL Server Agent jobs, setup of Database Mail /operators for alerting.

Confidential, Houston, TX

MS SQL Server DBA

Responsibilities:

• Performed aspects of database administration, including data modeling, backups and recovery, Security Issues such as creation of various Objects and granting permission to user(s), role(s).
• Analyzing long running slow queries and tuning the same to optimize applications and system performance. Performing DBCC checks.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Overall database design, such as creating normalized databases, authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types using T-SQL statements.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build and fixed orphaned users
• Developed Complex Stored procedures, functions, Cursors, Trigger and Views as per the business requirements using advanced SQL functions such as Rank(), CTE, Dynamic SQL Queries and Table valued functions etc.,
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and loaded the data into target tables by performing different kinds of transformations using MS SQL Server Integration Services.
• Used Data Transformation Services to extract data from source databases, transforming the data as needed, and loading the finished data into the cube.
• Monitoring and report generation for the database infrastructure. These reports are presented to management on regular basis.

Confidential, Burlington, VT

MS SQL Server DBA

Responsibilities:

• Monitoring and Setup maintenance plans like backup\restore database.
• Implementing Disaster recovery model solutions to the customers in SQL server through
• Database Mirroring, Replication (Snapshot, merge, transactional), Log shipping
• Setting up and Monitored transactional replication, Database on Production and QA servers.
• Implemented SCDs in SSIS packages.
• Developed and involved in optimization of stored procedures, Functions, Views for faster data retrieval.
• Unit Test plan and Integration Test Plan Preparation.
• Involved in updating SQL patches and Hot fixes and Production deployment.
• Troubleshooting transaction logs and tempdb when full.
• Continuously monitoring and updating the Backup & Recovery strategy and also monitoring scheduled jobs of backup and restore procedure for database
• Loading feed files got from ERP team into SQL Server database on weekly basis.
• Involved in Path Deployment of SQL and Production deployment
• Setting up Transactional Replication and monitoring it.

Confidential, Commerce,TX

Research Assistant

Responsibilities:

• Installed and configured SQL Server 2008 and setup sample databases and User databases for the different teams in the course.
• Worked on setting the growth of Databases and created tables and inserted data using different datatypes using SSMS.
• Worked on creating the indexes with appropriate included columns in databases.
• Backing up the tables and databases to protect without loss of data.
• Automated the scheduled jobs using SQL Server Agent for backups and index reorganizing and defragmentation.

Confidential

MS SQL Server DBA

Responsibilities:

• Installation of SQL Server 2000/2005
• Creating & Managing the Databases
• Creating Jobs and Maintenance Plans
• Backing up and recovering of data
• Creating Index and Managing
• Managing database users and security
• DB space issue like expanding DB file size, shrinking files, dealing with tempdb full
• Importing and exporting SQL related files
• Writing SQL Queries & Stored Procedures.
• Log Shipping, Mirroring and Replication
• Migration of database from SQL 2000 to SQL 2005
• Applying Service Packs to SQL Servers