Sql Server Data

Sowjanya Dondeti

mobile: 848-***-****

************@*****.***

Professional Summary:

IT professional with 8 years of experience in MS SQL Server Database Administration and managing large-scale databases in production support environment on windows and AZURE virtual machine platforms.

Expert Experience in Database Architecture, Installation, Configuration, Maintenance and Administration of SQL Server 2016, 2014, 2012, 2008R2, 2008, 2005 and 2000 in standalone and clustered environments.

Experience in migrating/upgrading Tera Byte size databases from SQL 2000\2005\2008 to SQL server 2008 R2\2012\2014\2016.

Expertise in implementing efficient Disaster Recovery Strategies and High availability include Always On, Replication (Snapshot, Transactional and merge), Clustering (Active-Active and Active Passive), Log shipping and Database Mirroring (Sync and Async).

Expertise in configure, monitor and troubleshoot SQL server Always on High Availability in between the data centers and participated in DR test.

Expertise in implementing SQL Server mirroring with different data centers in different data domains.

Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler, Trace flags, Extended Events and other related monitoring and troubleshooting tools.

Experience in using SQL server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.

Good experience on resolving performance tuning include query and server optimization, monitoring the growth of the database to ensure the smooth running of daily activities.

Experience in trouble shooting SQL server jobs, and job monitoring tool, Experience in creating Jobs, Alerts, Database Mail configuration and scheduling DTS and SSIS, SSRS Packages.

Created maintenance plans to perform Index De-Fragmentation, Re-Indexing and update the Index Statistics.

Good expose on Servicenow(SNOW) tool to implement the Change Request and tickets.

Experience on configure and maintain Snapshot replication, Transactional replication and merge replication.

Experience in troubleshooting and resolving DB integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.

Monitored and optimized system performance using SQL Server Profiler, Extended Events, Database Engine Tuning Advisor, Red-Gate monitoring tool.

Ensuring proper Disaster Recovery solution is in place for all production databases.

Experience in Subscribing the Azure subscription and setting up Azure for Organization.

Experience in creating, configuring and managing SQL Server Azure databases and Azure directory.

Configured Geo-Replication for SQL Server Azure databases.

Experience on creating the VM machine in SQL Server Azure and configured the Transaction replication from Physical server to Azure SQL Server database.

Experience on migrating the physical servers to Azure databases.

Experience on migrated the SQL Server 2012 and 2014 to SQL Server 2016 Azure with AlwayOn Availability groups.

Experience in creating storage account with blog, table and queue.

Strong Knowledge on TSQL and PL\SQL commands.

Strong Knowledge in Data Collection, Resource Governor, Extended Events, contained database.

Basic knowledge in UNIX, Linux commands environments.

Basic knowledge in Power Shell Scripting.

Good Knowledge on Installing pgadmin tool in windows & creating databases, tables, jobs in pgadmin of PostgreSQL.

Good knowledge on Backup and restore strategy in PostgreSQL.

24 X 7 Production Database On Call Support following the escalation matrix. Supporting the team in high priority issues.

Self-starter, capable of working independently, willingness to adapt and learn new technologies, along with excellent communication and interpersonal skills.

Technical Knowledge:

RDBMS

MS SQL Server 2000\2005\2008\2008 R2\2012\2014\2016, Azure VMware, PostgreSQL(pgadmin),Oracle 12c, 11g

MSBI

SSIS\ETL, SSDT, SSRS

Supporting Tools

LiteSpeed Backup and restore, Azure portal, Azure storage explorer, Azure SQL migration wizard, Azure data migration assistant, SQL Profiler, SSMS, Upgrade Advisor, Red-Gate, SCOM

Ticketing Tools

ITIL - Service Now, CQSR

Programming Languages

C, C++, HTML, XML, TSQL, PL\SQL, JAVA, .NET, UNIX, LINUX, PowerShell Scripting

Operating System

Windows Server 2003\2008 R2\2012

Education Summary:

Bachelor of Technology in Computer Science Engineering from JNTU, 2008.

Professional Experience:

Client: Becton Dickinson, Franklin Lakes, NJ. Project: KPI Metrics

Role: Sr. DBA Consultant Jan’ 17 – Dec’ 17

A medical technology company specialized in medical devices and instruments. Worked as Sr. DBA in Production and Implementation, maintaining 300+ Production, UAT and Development Servers, databases size including 10 TB VLDB's.

Responsibilities:

Troubleshoot various problems that arise in day-to-day work and fix the issues.

Worked as a 2rd line Production DBA Support and Provide 24X7 On Call Support.

Installation of SQL Server 2016\2014\2012\2008 R2 and DB migration from SQL 2000\2005\2008 to SQL server 2008 R2\2012\2014\2016.

Maintain MS SQL Server 2005\2008 R2\2012\2014\2016, including security, server configuration and install service packs upgrades.

Configured and maintained the Transactional replication from SQL Server physical server Azure databases.

Configure, monitor and troubleshoot SQL Server mirroring between two data centers, two different domains

Configure, monitor and troubleshoot SQL Server Always on High Availability in between the data centers.

Configure, monitor and troubleshoot SQL Server log-shipping .

Configure, monitor and troubleshoot efficient Disaster Recovery Strategies and High availability solutions include Clustering (Active-Active and Active Passive), Log shipping and Database Mirroring.

Configure and monitor Transaction and merge Replication, resolved critical issues.

Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, integrity verification, replication verification, and indexing updates.

Implement and maintain database security include create and maintain logins, users, roles, assign privileges.

Expertise in production change management process and resolving production issues as per ticketing priority.

Performance Monitoring using SQL Profiler, Performance Monitor, planning for CPU and Disk space requirements and DB maintenance and optimization using DBCC commands.

Experience on Optimizing Code and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.

SQL Server 2008R2/2012/2014 profiling with Dynamic Management Views in both Server-scoped DMV and Database-scoped DMV.

Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions As part of a team, established security policy using windows domain accounts and implemented a security strategy to protect against threats and attacks.

MS SQL Server database administration, configure Scheduled Tasks for regular Database Backup and Maintenance Activities.

Optimized the database by creating various clustered, non-clustered indexes and indexed views.

Troubleshooting of site issues, DB Performance issues and long running queries.

Planning, implementation and support of database backup, database recovery and disaster recovery policies of databases in a highly availability environment.

Monitoring Disk Space of all the Servers and freeing up space as per SQL Server.

Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.

Gained good knowledge about migration from SQL server On-Premises to SQL server running on Azure SQL Virtual machines.

Environment: SQL Server2005\2008\2008 R2\2012\2014\2016, Windows 2012, SQL Server Integration Services (SSIS), SSRS, DMV, SQL Profiler, Red-Gate tool, CQSR, Azure portal, Azure storage explorer, Azure SQL migration wizard, Azure data migration assistant.

Client: UBS Project: Stamford DC

Role: Sr. SQL DBA Jan’ 16 – Nov’16

As a part of Stamford DC, involved in migration and maintenance of 200 +servers.Worked as Sr. DBA in Production and Implementation, Maintaining Production, UAT and Development Servers.

Responsibilities:

Installed and configured SQL Server 2008 clustered environment with high availability groups on Windows server 2008.

Maintained database performance by calculating optimum values for parameters, implemented new releases, completed maintenance requirements.

Provided DBA support and technical expertise for multiple applications in DEV\test\QA\production - SQL Server 2005\2008\2008R2, and MS SQL Server 2012 environments on Windows Server 2012.

Proactively monitored the database health through automated scripts: index optimized.

Performed SQL Server database upgrades to later version using copy database wizard and import/export.

Administered and analyzed SQL Server High Availability and Disaster Recovery Strategies.

Performed day-to-day capacity planning, designed storage for new databases, benchmarked servers.

Creates Users, Logins and database objects as per organization requirements and fix orphan Users in Prod Servers.

Ensure all database servers are backed up and tested to meet the organization's RPO and RTO.

Help developers improve the performance of queries by refreshing databases and updating statistics\indexes.

Performance tuning (fragmentation, compression drive distribution, load balancing), technical documentation and implementation of SQL Server disaster recovery models.

Build and design automated jobs for indexes, backups, daily maintenance and task scheduling.

Configure and support mirroring, replication and log shipping in both SQL Server 2008 and SQL Server 2012 Enterprise editions.

Creates jobs using maintenance plans for Full, Differential and Transactional Log backups.

Worked as a 2nd line production support DBA and provide 24x7 On Call Support.

Environment: SQL Server2005\2008\2008 R2\2012, oracle 11g, Windows 2012\2008\2003, SQL Server Integration Services (SSIS),SQL Profiler, SSMS.

Client: Hexaware, Chennai, India. Project: E&Y DCC

Role: Sr. Database Administration. Sep’12-Apr’15

DCC* - The Data Center Consolidation (DCC) program is an IT priority project that consolidates over 400 current data centers and hub sites into a limited number of global data centers, disaster recovery sites and local data rooms and upgrade all SQL Server 2005\08\08 R2 to SQL Server 2012. This effort will encompass standardizing and reducing the amount of equipment, applications and software across all of EY.

Responsibilities:

Migrating the all DEV\TEST\UAT\PROD SQL server instances from SQL server 2005\08\08 R2 to SQL server 2012 version includes required user databases, logins, linked servers, SQL server Agent jobs, triggers, alerts, operators, proxy accounts, DB mail, Data collection, SSIS packages.

Consolidated databases from multiple servers to one server during Data center consolidation.

Analyzed databases using Upgrade Advisor and shared recommendations.

Good Experience on Creating, Handling and Closing tickets in the Service Now Ticketing tool (ITIL).

Experience in installation and configuration of MS SQL SERVER 2005\2008\2008 R2.

Troubleshooting and fixing the performance related issues on post upgradation.

Worked on deploy, configure and migrate SSIS\ETL (Extract\Transform\Load) packages 2005\08\08 R2 to 2012.

Worked on execute the SSIS\ETL packages in a scheduled job in SQL server agent.

Worked in creating, configuring, deploying SSIS packages for exporting/importing data from table to excel\Text files from PROD\DEV servers.

Coordinating with Application team when migrating the Applications and Databases.

Monitored and optimized system performance using SQL Profiler monitoring tool.

Creating the user required databases and monitoring the database status and growth of databases to ensure the smooth running of the daily activities.

Shrinking the database log file, tempdb files if it is required.

Ensure to check the fragmentation percentage levels based on the priority rebuild or reorganize the indexes to increase the performance.

planning and executing database backup and recovery tasks.

Creating of Logins, Users, assigning responsibilities as a part of Security Policies and troubleshooting orphaned users

Scheduling and monitoring SQL Server jobs, and resolving issues, monitoring health of the database servers, storage, memory & CPU utilization.

Taking care of disk space, database file size (MDF, LDF, LOG) Scheduling and running jobs in production server for backup of databases.

Interacting with the people and resolving the issues in a timely manner.

Rebuilding indexes and update statistics for better performance.

Attend daily status meetings and provide detailed status report to the client/onsite coordinator.

Environment: SQL Server2005\2008\2008 R2, SSIS, oracle 12c, 11g, Windows 2008\2003, SQL Server Integration Services (SSIS), DMV, SQL Profiler, SSMS, Service Now

Client: Hexaware, Bangalore, India. Project: EMEA Product Development Healthcare

Role: Jr. Database Admin. Sep’ 10-Aug’12

This project is about medical product catalogs. Client deals with distribution of medical products. To deal with different catalogs we were given project to convert all the data into SQL database for faster access. To accomplish the Medical database is presently being developed. Data is provided by the client in terms of printed Catalogs, used by the client for the selling of products.

Responsibilities:

Performing daily checks on regular day-to-day basis.

Maintenance and administration of Microsoft SQL Server databases. Monitoring the growth of the databases to ensure the smooth running of the daily activities.

Ensuring uptime of all database servers through monitoring tools.

Troubleshooting connectivity issues raised by Application users.

Maintenance of large databases using LiteSpeed maintenance plans for backups and shrinking.

Creation of Jobs Schedules, Alerts using SQL Server Agent and Notifications.

Security issues related to Database Engine, SSIS, SSAS and SSRS.

Designed and implemented comprehensive Backup plans and disaster recovery strategies.

Export or Import data from other data sources using Import\Export wizards.

Installation of SQL Servers and Lite Speed backup tool.

Applying Service Packs and Cumulative Updates for the SQL Servers as released\requested.

Regular monitor of servers, which includes backup Job Monitoring and troubleshoot all the issues on regular basis.

Database creation/decommissioning, database backup and recovery and migration from Dev to PROD.

Creating the subscriptions in SSRS and granting permissions to users on reports.

Maintenance of large databases using maintenance plans.

Configuring Database Mail & SQL Mail for notifying status of Jobs.

Environment: SQL Server 2000\2005\2008, SharePoint, Windows 2008\2003, SQL Server Integration Services (SSIS), SSRS, DMV, SSMS, SQL Lite Speed backup tool.

Client: Enterprise T Systems, Bangalore, India. Project: Retail Management

Role: Associate DBA Jul’ 08-Aug’10

Responsibilities:

Maintaining the jobs Scheduled for all types of the Backup of Databases.

Installation, configuration and upgrading SQL server software and related patches.

planning and executing database backup and recovery tasks.

Ensure to check the fragmentation percentage levels based on the priority rebuild or reorganize the indexes to increase the performance.

Verify SQL Server and Error logs on the servers and troubleshoot if any failures or alerts.

Monitoring the Database Server's Health and Tuning Accordingly.

Rebuilding the Indexes run update-statistics at regular intervals for better performance Creating, Scheduling, executing SQL Jobs.

Troubleshooting Login, Privilege related issues and providing solutions in timely manner.

Contact this candidate