Samatha Bodapati

Etobicoke, ON, M*C*A*

647-***-****, Email: aczaby@r.postjobfree.com

Highlights of Work Experience:

o 5 years of experience with SQL database application, administration, system analysis, design, development and support, installation & configuration, trouble shooting of Microsoft SQL Server 2014, 2012, 2008 R2, 2008, 2005, 2000 .

o Experience in implementing DR solution, High Availability of database servers using Database clustering, mirroring, replications and Log Shipping o Performing database maintenance activities like Backups, Restoring etc. o Implementation of SQL Logins, Roles and Authentication modes as a part of security policies for various categories of user support.

o Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users

o Experience in Data Migration Management.

o Experience in Monitor and maintain production, UAT and dev SQL servers o Creating the database performance reports in SQL Server Reporting Services o Define and implement database partitioning, purging/archiving and backup plans o Scheduled and maintained routine Jobs, Tasks, Alerts and Maintenance Plans. o Experience in upgrading SQL Server from version 2000 to 2005, 2005 to to 2012 o Disaster recovery and Log shipping of SQL Servers meeting the Service level agreements for the various customers.

o Having good exposure to Replication models like Transactional, Snapshot, Merge and Transactional with updatable.

o Document & Implement corporate SQL Server security & database standards o Maintained ODS (Operational Data Storage) databases from DEV, TEST, UAT and PROD o Providing 24x7 technical database supports for SQL Database systems. o Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.

o Experience in supporting and managing multiple Production, Staging & Development servers. o Good interpersonal skills, committed team player with team driven skills. Technical Skills:

Languages : C, C++, HTML, Java, windows PowerShell and Batch scripts, python, unix shell scripting, Visual Basic.Net

Operating Systems : Linux (Ubuntu, Red Hat), Windows XP/2000/2003/7/8, windows Server 2000/2003/2008/2012

Virtualization Tools : VMware, Microsoft Hyper –V, Citrix, Oracle VM Virtualbox Professional Experience:

Appshark Software Pvt Ltd Hyderabad, IND

Database Administrator May 2013 – July 2016

Manage databases for production support and new projects.

Assist in the team effort to maximize the availability, security, and performance of the databases.

Analyze long running slow queries and tune the same to optimize application and system performance.

Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures)

Responsible for configuration planning and installation of SQL servers.

Monitor performance and the capacity of the databases supported.

Worked on clustering for Clients on a High available environment. Scheduled Jobs and Alerts using SQL Server Agent. Designed and configured DB Mirroring in SQL Server 2008.

Monitor database and server performance and identify current and future potential bottle-necks.

Automate backup/recovery process, statistics management using shell scripts and PL/SQL.

Manage data migration, data integration, data cleanse, data audit control and Informatica ETL processes design/support for Data Warehouse environment.

Troubleshoot a variety of issues such as replication failures resulting from missing/renamed stored procedures and performance issues such as poor execution plans and locking/blocking issues.

Database health and high performance, monitoring, capacity planning, profiling and fine-tuning databases, proactive action

Ensure code developed by the DB Developers, reporting problems back to the developers prior to release to Operational Acceptance Testing, then to Production.

Responsible for maintaining database integrity across multiple QA test streams and development environments.

Traced long running queries, deadlocks and Blocking using SQL Sentry

Provided SLA based delivery as well as solutions with value additions to customers to achieve optimized performance and cost effective solutions. Supporting US clients – Brooks, Sherwin- Williams, Andrea, jack.

Appshark Software Pvt Ltd Hyderabad, IND

Junior DBA May 2011 – July 2013

Creating stored procedures, designing and creating tables and database structure.

Maintaining the documents of all the server health check, database size, handling the data requests that are requested by finance team.

As Administering SQL Server security, automatic e-mail notification, backup strategy and automation.

Creating Jobs and Operators and verifying indexes on server.

Creating logins, users and giving appropriate permissions

Handled weekly/monthly service review and reporting.

Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard

Monitor the status of jobs – schedule to run daily and on weekends (tasks like rebuilding indexes, Reorganizing Indexes, Update Statistics, System Database Backup and Check Database Integrity).

Moved databases from Production to Test environment on request. Worked on daily reports which notifies about the database growth, failed jobs, failed backups and failed transactional log backups.

Data transfers between various servers using BCP using linked server

Database code reviews and deployments in the client servers

Resolve ticket’s that are raises globally.

Troubleshooting the issues related to failed jobs and log space issues Database and application related issues.

Refresh database into different environments Database and server alerts monitoring, Jobs status and responds.

Handling Remedy and Change request for various issues.

Database Maintenance activities like Index Defrag & running required DBCC Commands on weekly basis

Certifications:

Microsoft Technology Associate (MTA)

MCSA: Microsoft Certified Solution Associate (SQL 2012) MCSE: Microsoft Certified Solution Expert (Data Platform) Education:

Bachelors of Technology in Computer Science

2007- 2011

JNTU University Andhra Pradesh, India

Contact this candidate