Divya Bethi

MS SQL Server DBA/ Developer

770-***-**** Ext 117

acz3om@r.postjobfree.com

Professional Summary:

7+ years of progressive experience in Database Administration and Development for very large and complex databases in MS SQL Server 2012/2008 R2/2008/2005 on 32 bit and 64 bit environments.

Good knowledge of Relational Database Management Systems (RDBMS).

Expert in installation, upgrade, configuration and administration of MS SQL Server in clustered and stand-alone environments.

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Migration from MS SQL server 2005 to 2008, 2008/2008 R2 to 2012 by using In-Place upgrade process and as well as side-by-side upgrade process.

Extensive Knowledge on SQL server Always on Availability Groups and Always on Failover Cluster Instances.

Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL Server databases.

Proactively maintaining activities like monitoring of database space allocations, transaction log space allocations, monitoring memory, CPU utilization, disk utilization, locks, alerts and runtime of queries.

Extensively worked on implementing High availability solutions like different Replication models (Snapshot and Transactional), Clustering and Mirroring on physical and virtual machines.

Experience in database monitoring, Normalization, Database design and capacity planning.

Experience in Query Optimization, analyzing the execution plan and index management for better Query performance.

Highly experienced in investigating and applying necessary SQL Server database Service packs, Hot-fixes and Security Patches.

Expert in Index Defragmentation, optimizing execution plans, proper usage of indexes, horizontal and vertical partitioning.

Extensively worked on Locks, Deadlocks, Handling Isolation Level and Concurrency Effects, Detect CPU, I/O, Memory Bottlenecks.

Monitoring Event Viewer, SQL Error logs and Log file viewer for software and hardware related errors.

Provide or coordinate troubleshooting support for data warehouses.

Extensive experience in Disaster Recovery, troubleshooting, backup and restore procedures.

Expertise in writing Stored Procedures, Functions and Triggers using T-SQL and also expert in tuning Complex Queries.

SQL Server Business Intelligence Development Studio expertise to create SSRS reports, SSIS packages and SSAS with OLAP.

Configured Data Integrity at Active Directory and SQL SERVER LEVEL by establishing standards, creating Principals (logins) and Mapping users to roles (Securables and Permissions).

Strong experienced in all insurances such as Property and Casualty Insurance.

Active involvement in all the phases of the Software Development Life Cycle (SDLC) like Requirement Analysis, Design, Development, Unit Testing and Maintenance using RDBMS, with waterfall and agile scrum methodologies.

Follow policies, procedures and ITIL practices for incident, release, change, issues and requests.

Strong analytical, Logical, communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

Strong experience in mentoring with team members, documentation and 24/7 on call Production support.

Education:

Bachelor’s in Technology from JNTU, Hyderabad, India.

Skill Set:

Databases MS SQL Server 2012/2008 R2/2008/2005, Oracle 9i/10g/11g

ETL Tools SQL Server Integration Services, Data Transformation Services (DTS)

Reporting Packages SQL Server Reporting Services(SSRS), MS Excel

Tools Perfmon, SQL Profiler, Backup utility, BMC Partol, Litespeed, Erwin,

Analysis Services, BIDS, Database Tuning Advisor, Idera, RedGate

Languages T-SQL, PL/SQL, ANSI SQL, DDL, DML, DCL, Powershell, C#, VB.Net

Operating Systems Windows 2012, 2008, 2003,2000 Advanced Server, windows 2008/2008 r2 data center, windows NT, windows 95/98/2000 XP

Projects Summary:

Paychex, Rochester, NY May 2015- Present

MS SQL Server DBA/ Developer

Responsibilities:

Worked in Active- Passive/ Active-Active 2 node Cluster environment as a High availability solution.

Setup and maintained Database Mirroring with automatic failure and Transactional Replication on MS Sql servers.

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

Worked on MS SQL Server 2012 side by side upgrade from SQL server 2008 R2.

Performed Database Backup & restores and periodical database refreshes.

Involved in setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio(SSMS).

Worked on Operational side for Disk Space, Log Space, Blocking and Deadlock issues.

Designed and implemented comprehensive Backup plan and disaster recovery strategies.

Developed data mapping documentation to establish relationships between source and target tables including transformation processes.

Created entity relationship diagrams and multidimensional data models, reports and diagrams for marketing.

Installed Service packs for MS SQL Server 2012 and patched the servers with appropriate hot fixes

Created Database Maintenance Plans for the performance of MS SQL Server which covers Trouble shooting, Database Integrity checks, update database Statistics and Re-indexing.

Implemented of Active Directory services by issuing SQL Logins, Roles and Authentication Modes as a part of Security Policies.

Applied necessary MS SQL Server database service packs, Hot fixes and Security Patches.

Created SSIS Packages to export and import data from CSV files, EDI files, .XRL, .LRO, Text files and Excel Spreadsheets.

Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.

Reviewed and optimized SQL queries, CDC, stored procedures, functions, Indexes, views and triggers.

Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.

Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas.

Use custom scripts so as to help automate routine tasks such as Maintain operators, Alerts, Notifications, Jobs, Job Steps and Schedules.

Manage hierarchical security (access control, permissions, encryption keys and certificates) for databases and ensure data integrity using templates and schemas.

Used DMV’s, SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.

Moved Tempdb files from One Drive to another Drive and wrote scripts for daily/weekly jobs and performed health checks.

Environment: MS SQL Server 2012/2008R2, MS SQL Server Integrated Services (SSIS), DTS, Azure, SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS), C#.Net, SQL Agent, SQL Profiler, Redgate, Windows 2012 server

Nationwide Insurance, Harleysville, PA Oct 2014-May 2015

MS SQL Server DBA

Responsibilities:

Extensively worked on Administration, Database Design, and Performance Analysis on very large and highly transactional production databases.

Installed and configured MS SQL Server 2008 (R2) on servers with service packs.

Involved in configuring and managing Linked Server, Data transfer between MS SQL Server and Oracle.

Monitoring the server for High availability of the servers solving the raised by user support.

Installed and administered clusters on SAN environment.

Create, manage SQL Server AZURE Databases.

Reconfigure the default locations of the data files, log files and error log files onto the SAN environment for all the servers.

Worked on capacity planning and optimization for MS SQL Server database.

Worked with tools like SQL Profiler, counters and Activity Monitor for event monitoring.

Stabilized a volatile SharePoint application database server with multiple issues, and implemented database mirroring for high availability.

Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.

Handled Database recovery (disaster recovery), diagnosed, repaired and was involved to transfer the OLTP data to Data Warehouse

Explicitly used third party tools like Lite Speed and BMC Patrol.

Troubleshooting performance issues and performing database upgrades and security patches.

Fix data issues and write various SQL scripts and procedures for migration process.

Developed and optimized databases using stored procedures, DMVs, Triggers, Full-Text Indexing, XQuery, XML and user-defined functions.

Involved in Data Compression, Hot add CPU, Fact Table size reduction and improved the performance.

Expert in using and implementing DMV’s, DMF’s, data partitioning, DDL triggers, Mirroring and Online indexing.

Working on production Break fix issues which include performance, blocking and space related issue.

Maintain security, assign logins, permissions, Database encryption and desk support for problems related to Active Directory.

Created automated procedures for daily, weekly and monthly system maintenance tasks such as database backup, replication verification and database integrity verification and indexing updates.

Monitor and modify performance using execution plans and Index tuning.

Migrated MS SQL Server 2008 to 2008 R2 and DTS to SSIS (ETL), used log shipping for synchronization of databases.

Responsible for day-to-day activities such as backups to the disk, restore the databases, health checks and transaction log on production/development servers as per business / IT needs using SQL Safe.

Environment: MS SQL Server 2008 & 2008 R2 Enterprise Edition on Windows Server 2008, VMware, Oracle, Erwin, Management Studio, Query Analyzer, Azure, Profiler, T-SQL, C#.Net, DTS, Performance monitor, Event viewer.

Everest National Insurance Company, Liberty Corner, NJ Jul 2013- Aug 2014

MS SQL Server DBA/ Developer

Responsibilities:

Installed and configured more than 2GB RAM in MS SQL Server 2008.

Configured the servers on 32 bit and 64 bit clustered and standalone server environments

Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.

Installation of MS SQL Server Service Packs & hot fixes and assisted in capacity planning.

Setting up High availability and DR solutions over Azure, production and QA servers.

Implemented Database Mirroring and Replication as a part of Disaster Recovery plan.

Responsible to Monitor and troubleshooting Log Shipping.

Database migration from the physical instance to cloud using AWS, created linked servers between sql server and oracle.

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.

Involved in data modeling for the application and created ER diagram (ERD) using Erwin.

Installed, authored, and managed reports using MS SQL Server 2008 Reporting Services.

Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS and Created Summary Reports, Sub Reports for data visualization.

Experience in trouble shooting Client connections, viewing error logs and application logs.

Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Designed, developed, and implemented scripts to automate the loading of SQL.

Creating cubes using MS SQL analysis services. Developed SNOW and STAR FLAKE schemas.

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.

Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.

Personalized the dashboards to reflect user-specific alerts and metrics to track Key Performance Indicators KPI.

Transferred data (ETL) to Data ware house Environment using SSIS.

To analyze long running queries and tune the same to optimize application and system performance.

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

Environment: MS SQL Server 2008, SSAS, SSIS, MS SQL Server Reporting Services 2008 (SSRS), DDL, Unix, VB.Net, ETL, Erwin

Fresenius Medical Care, Lexington, MA Dec 2012- Jun 2013

MS SQL Server DBA

Responsibilities:

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

Worked with MS SQL Server 2008 In-place and side by side upgrade from SQL server 2008.

Strong experience in working on Very Large Databases (VLDB) over 80 GB for OLTP and 2TB for OLAP databases.

Worked in Active-Passive, Active-Active multi node Cluster environment and configured more than 2 GB ram on 32 bit Environment.

Implemented Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.

Implemented and maintained Database mirroring as a Disaster Recovery Solution.

Creating Logins and Roles with appropriate permissions.

Creating and Maintaining Database Maintenance Plans for troubleshooting and high performance.

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, perform health checks and Tune slow running queries using SQL Server Profiler.

Performed data partitioning for efficient management of database tables and indexes.

Maintaining the database consistency with DBCC at regular intervals

Monitoring SQL server performance using profiler to find performance and deadlocks.

Managed Disk space, memory and User connections.

Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.

Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.

Generated Script files of the databases whenever changes are made to stored procedures or views.

Used CDC (Change data capture), Table valued parameters and other new features in new applications.

Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.

Monitored and modified Performance using execution plans and Index tuning.

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

Environment: SQL Server 2008/2005,Windows 2003, Windows 2008 Server, VB.net, Microsoft SQL server Visual Studio 2005/2008, SSIS, SSAS, MS Business Intelligence Development Studio 2008.

STATE BANK OF INDIA, India Sep 2009 - Nov 2012

Jr. MS SQL Server DBA

Responsibilities:

Collaborated with software engineers, architects, and technology specialists to design database, clustering and migrations.

Deployed and Administrated MS SQL 2005 server on production environment.

Develop and implement Replication, Archiving, Backup and Recovery strategies.

Proactively monitor the Production Database and optimize stored procedures for better performance.

Resolve locking conflicts, trouble shooting and resource utilization.

Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases.

Manage and Create database schemas for Relational Database Systems (optimize index creation, table creation, storage allocations, etc.).

Ensure all database environments (Development, Staging, QA and Production) are in sync.

Define db scripts versioning system to keep track of database versions for all environments.

Design, review and implement production SQL Server database objects, models and database designs (schema)

Wrote optimized T-SQL stored procedure to improve performance, preserve referential integrity and provide application functionality.

Maintained the database consistency with DMV’s/DMF’s at regular intervals.

Good experience in maintaining Log Shipping, Replication and Clustering.

Identify and resolve database performance issues, database capacity issues and other distributed data issues.

Environment: SQL Server 2005, SQL Enterprise manager, Query Analyzer, ERWIN, Red Gate, Power shell, DTS, MS Access 97 / 2000 & Windows Server 2003 x86/x64.

Contact this candidate