SQL Server DBA

Shravya K

*.************@*****.*** - 904-***-****

Status: Permanent residency (Green card)

Professional Summary

* ***** ** ********** ** a Database Administration in Microsoft SQL Server and over 6 years of experience as a Migration Engineer and SQL Database architecture with experience in requirement analysis, design, development, testing of client/server, web, Data warehouse and n-tier architecture applications.

6+ years of experience in administering the enterprise-level production MS-SQL servers and databases.

Expertise on RDBMS concepts as well as Data Modeling Concepts.

Extensive experience in implementing High availability solutions like Always on, Replication models (Snapshot and Transactional), Log shipping, dynamic management views, clustering and mirroring on physical and virtual machines.

Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting.

Extensively worked on Active-Active and Active-Passive Clustering.

Strong in standard Software Development Life Cycle (SDLC) and software development methodologies.

Experienced in different phases of Software Development Life Cycle (SDLC) including Strategic Systems Planning, Designing, Object Oriented Programming (OOP) concepts, Programming, Testing, Documentation, and Presentation to clients and preparing customer specifications as part of software technical requirements and Customer support.

Having good experience of Microsoft SQL Server 2008, 2008R2, 2012, 2014 and 2016 with Production support, Microsoft SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS) using Business Intelligence Development Studio (BIDS) and Crystal Reports 7.0/8.0.

Experience in Data Modeling, Normalization, and Building Referential Integrity Constraints.

Developed complex Stored Procedures, Triggers, Views, Functions, Indexes, Normalization, Data types using MS SQL Server 2005, 2008, 2012, 2014 and 2016.

Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.

Experience in Query Optimization and Performance Tuning.

Experience in Replication – Snapshot, Merge and Transactional.

Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.

Worked in In-Memory OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.

Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.

Worked on configuring VLAN’s and IP’s for the new SQL DB cluster.

Strong Business and Application analysis skills with excellent communication & professional skills.

A self -motivated Individual with exemplary analytical and problem solving skills.

Technical Skills

SQL Server Tools

SQL Server Management Studio, SQL Server Business Intelligence Development Studio

Operating Systems

Windows

Databases

MS-SQL Server 2016, 2014, 2012, 2008R2, 2008/2005/2000

ETL Tools

Data Transformation Services(DTS), SQL Server Integration Services (SSIS)

Business Intelligence

SSRS, SSIS, SSAS

DB Utilities

SQL Server Management Utility, Query Analyzer

Software Tools

Visual Studio 2005/2008/2010, VMware, AWS, Azure Visual Source Safe, TFS, MS Office Suite, SCOM

Professional Experience:

Citizens Property Insurance Oct 17 – Present

Sr. Microsoft SQL Server DBA

Responsibilities:

The ability to assist in finalizing a Microsoft SQL Server migration design in which to migrate older Microsoft SQL server machines into a right-sized Virtual Machine (VM) residing within the customer’s environment. Includes analyzing previous discovery data.

Physical to Virtual (P2V) SQL Server migration.

Sizing the environment bases on empirical performance metrics and best practices

Implemented Always On Availability Group, Replication and log shipping as a High Availability.

Configured and Maintained Database Servers from 2005 through 2016 version.

Worked on Azure Resource Manager to manage the resource for the solution in a single, coordinated operation.

Deployed Azure SQL instance as the secondary replica in Always On.

Analyzed execution plans, and tuned queries and databases for better optimal performance.

Used SQL server Profiler for the trace files and Database Tuning Advisor (DTA) for better query level performance.

Maintained production SQL servers and Databases with daily maintenance job and performed SQL server security management.

The ability to understand and tune how a database interacts with a specific application.

The ability to understand and make use of tools available (vSphere Web Client, MS Windows Server Perfmon) to troubleshoot and tune SQL DB performance after DB migrations where applicable.

Design and build architecture to support Tableau environment and data feeds.

Proactively and continuously improve IT metric dashboards and cost allocation models for IT leaders. Assist in evaluating client business requirements, think outside the box and providing technical recommendations.

The ability to minimize downtime completing SQL server migrations with knowledge in detailed troubleshooting of their infrastructure environment SQL 2000, SQL 2005, SQL 2008/R2, SQL 2012/R2 and 2016

Ability to script and develop SQL server components like stored procedures, views and functions.

Black Knight Financial Service, Dallas, TX Oct 14 – Sep 17

Microsoft SQL Server DBA/ Migration Engineer

Responsibilities:

Joined as a part of SQL Server 2012 upgrade project in December 2014.

Migrated more than 500 production databases to SQL server 2012 environment from the older versions in production, UAT, Testing and Development server.

Migrated more than 20 databases from Oracle and Teradata.

Worked on the SQL Server 2014 upgrade project.

Co-ordinate with the DR migration to their new Denver, CO location.

Installation and Maintenance of SQL Server 2012 on Test, Development and Production Environments.

Implemented Clustering and used VM Ware as part of Server consolidation project.

Co-ordinate with the Online Banking, CRM, First Hawaiian Bank (FHB) and other major projects.

Configured, Developed and supported OLAP solutions using Microsoft SSAS.

Implemented Query Optimization, Indexing and Table Partitioning, along with In-Memory OLTP to improve the performance for the CCAR project.

Familiar with the SSRS, SSAS and SSIS in SQL Server 2012.

Implemented Transparent Data Encryption (TDE) on production data.

Co-ordinate with the application team and the Business Users for a successful project completion.

Maintained database warehouse for the online banking application and on building staging data as per new requirement.

Usage of new compression Techniques in SQL Server 2012 for backup and restore jobs along with the Windows Azure for the cloud backup.

Involved in the implementation of Always On Availability Group as a High Availability solution on clustered and stand-alone scenarios on SQL Server 2012.

Implemented Database Mirroring, Log shipping, Transactional Replication and Always On as a part of DR plan.

Closely monitored the performance for the reporting DB’s by SQL Profiler tool.

Created Logins and Roles with appropriate permissions.

Created and Maintained Database Maintenance Plans.

Worked on Microsoft and internal audits, security, vulnerability assessment and compliance using third party tools like GridApp clarity and SQL compliance manager by IDERA.

Modify Stored Procedures and complex T-SQL Queries to improve query execution process.

Write T-SQL Scripts for database backup jobs and daily/weekly jobs.

Familiar with the SQL Server Profiler for the performance tuning for the SQL query.

Import data across multiple instances using BULK INSERT and BCP Utility.

Hands-on experience in Performance Tuning and Index Tuning.

Able to communicate effectively with a wide range of people, by showing interest and carefully listening to their needs.

Familiar with Team Foundation Server (TFS).

Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SSRS.

Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.

Create Clustered and Non-Clustered Indexes to improve the performance of database access.

Create and manage databases across Development and Production instances using SQL Server Management Studio.

Involved in Logical and Physical Data Modeling process using MS Visio.

Closely worked with the production environment for the upgrade, security patching and RFC.

Closely worked on fail over clustering as a part of database consolidation project.

Health Management Systems, Jacksonville, FL Jan 13 - Sept 14 Microsoft SQL Server DBA/ Migration Engineer

Responsibilities:

Upgraded SQL Server 2005 Production, Test and Dev environment to SQL Server 2008.

Developed stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.

Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.

Configuring, tuning, and optimizing SQL 2008.

Worked on SSIS, SSAS and SSRS configuration.

Performance testing on stored procedures, indexes, and triggers.

Creating DTS Packages for data import, export, scrubbing and scheduled jobs for backups.

Data migration using Bulk copy program and DTS.

Helping the front-end application developers with their queries.

Job Monitoring and making sure all jobs run successfully every night.

Performing low-level scripting, fixing of codes and software enhancement process.

Administrator tasks like managing users, roles, and profiles

Performed Database backups with tools like lite speed.

Development of various reports and reporting interfaces utilizing Microsoft SQL Reporting Services.

Scheduled and monitored all maintenance activities including database consistency check and index fragmentation.

Analyzed execution plans, and tuned queries and databases for better optimal performance.

Fixing Missing Indexes and Excess indexes

Generated script files when changes applied to stored procedures and functions.

Managed schema objects like Triggers, cursors, indexes, procedures.

Contact this candidate