Professional Summary:

• Over * years of a database administrator, application developer, and analyst experience

• Experience as SQL Server Database Administrator and Support of SQL Server 2005/2008/2012/2014 in Production, Development and QA environments

• Experience in high availability SQL server solutions, Including log shipping, Mirroring, Replication and clustering

• Experience in migrating the SQL Server 2005 to SQL Server 2008 and SQL Server 2008 to SQL Server 2012

• Experience with Incident, Problem, Change and Project Management

• Experience with optimizing the queries, tracing long running queries and using Performance Monitor, SQL Profiler, Client/Server Connectivity, Database consistency checks using DBCC Utilities

• Experience with ServiceNow & ITSM Tool and ITIL Process and providing user support using the tools

• Experience with working on Production, UAT/Testing and 24*7 on call environments

• Expert in Database Backup, Refresh and Disaster Recovery Procedures

• Hands-on experience in using DTS, BCP & Bulk-insert, Import and export Wizard and SSIS, Comfortable using DBCC commands, Triggers and T- SQL etc.

• Knowledge and applied usage of reporting tools such as SSRS, Tableau and Excel. Work Experience:

Unisys India Private Limited (Aug 2015-Dec 2016)

Operations Analyst II

Responsibilities:

• Handled responsibilities as an Incident Coordinator(IC) for midsize project/development teams

• Designed, coded, tested and debugged custom queries using Microsoft SSMS as per defined technical specifications

• Monitoring the SQL servers by accessing remotely & analyzing the databases size

• Checking the status of Backup, Troubleshooting the failed backups and restoration of databases

• Monitoring SQL Server Agent errors and Window's Event logs

• Scheduling Ad-hoc, SQL server jobs using SQL server agent

• Monitoring SQL Server Agent jobs- Review for failed SQL Server Agent jobs

• Ensuring data consistency in the database through DBCC commands

• Designing a successful backup strategy to ensure backups are done at regular intervals.

• Adding users in the database and granting necessary permissions as and when required

• Managing Security Permissions of Server roles and Database roles.

• IIS Installation configuration and Administration of web Sites on IIS 6.0/7.0 Infosys Technologies Limited (Oct 2012- Aug 2015)

Sr. Operations Executive

Responsibilities:

• Tactical execution of Information Technology Infrastructure Library (ITIL) process, managed the performance of the ITIL process (per SLAs, metrics, KPIs) within the immediate sphere of control including escalations and Project Management.

• Assisted with detection of possible errors/problems and engaged incident Management, Problem Management team by raising incident, problem records.

• Assisted managers and business analysts in developing reports, presentations, and analysis for project management.

• Wrote and executed SQL queries using SSMS to provide custom reports as per business team requirements.

• Maintained, Troubleshoot SSMS failures, the configuration of SQL errors and IIS Servers.

• Maintained the application servers, databases, server logins, database issues. Education:

University of Central Missouri (Jan 2017-May 2018) Degree: Masters

Major: Computer Science

GPA: 3.20

Osmania University, India (May 2009- May 2012)

Degree: Bachelors

Major: Computer Science

GPA: 3.29

Certifications:

• Microsoft Certified Professional(MCP) SQL Server Database

• ITIL Foundation

• ServiceNow

Skills:

Languages: SQL, Java, C++, HTML, CSS, JavaScript, jQuery,XML, Python, R Tools: SQL Server Management Studio(SSMS), Active Directory, ServiceNow, ITSM, JIRA, SSRS, Tableau, Splunk, R Studio, MySQL, PyCharm

Framework: .NET Framework

Operating System: Windows, Linux, Unix

PRASANNA RENIGUNTALA

https://www.linkedin.com/in/prasanna-reniguntala

4206 E 105th St, Kansas City, MO 64137 ac57q5@r.postjobfree.com 816-***-****

Contact this candidate