ROHITHA MUPPAVARAPU

acri3o@r.postjobfree.com 425-***-****

PROFESSIONAL SUMMARY

Over 5+ years of professional experience with database administration and implementation for very large and complex OLTP databases in SQL Server 2014/2012/2008R2/2008 and 2005.

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

Expertise working with third party DBA tools and applications like SCOM, Confio Ignite.

Expertise in T-SQL writing stored procedures, views, triggers, T- SQL.

Administering SQL Server High Availability and Disaster Recovery strategies.

Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.

Proficiency with MongoDB. Currently working on MongoDB certification.

Having hands on experience in DR processes including Log shipping and Database Mirroring.

Worked extensively on Clustering and server consolidation; upgrading, patching, migrations, monitoring and alerting in Database servers.

Troubleshooting production issues and raising high availability.

Extensive experience in problem management, change management and incident management.

Excellent inter-personal, communicational and documentation skills.

Ability to work in-groups as well as independently with minimal supervision.

Able to perform multitasking and reprioritizing work in a changing business climate.

Write/review/update troubleshooting guides as necessary.

Working in fast paced environment with a sense of urgency on impacting incidents or change requests.

24*7 Production Database On-Call support.

PROFESSIONAL EXPERIENCE

SQL DBA, Microsoft XBOX LIVE

Redmond, WA November 2011 – Present

Primary DBA for production databases supporting Xbox 360; Xbox LIVE; Xbox ONE

Migrated SQL server 2008 to SQL Server 2012 and 2014 in Microsoft Windows Server 2012/2012 R2 Enterprise Edition.

Working extensively on SQL Server Always On-Windows Server Failover Cluster model.

Performing installation, configuration, maintenance on database servers including upgrades, RFCs, patching, failovers and migrations.

Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.

Rebuilding/monitoring the indexes at regular intervals for better performance.

Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Monitoring and tuning the database servers and queries for high performance.

Implementing and supporting database replication/mirroring/log-shipping.

Performing in-depth troubleshooting associated with SQL; SQL Servers and SQL Server jobs.

Troubleshooting issues in SQL Server 2014/2012/2008 R2/2008/2005 including, but not limited to:

Performance (blocking, query optimization), query failures (deadlocks, exceptions), distributed queries, logical and physical database design, and security models.

Monitoring database application usage and availability.

Tuning alerting thresholds.

SQL Design Engineer II, Expedia, Inc.

Bellevue, WA July 2011 – October 2011

Worked closely with users to gather requirements.

Responsible for deploying the build in different environments.

Scheduled/attended the triage meetings with development and internal test teams.

Writing/reviewing/updating the test plan/test cases/test scripts and test results.

Responsible for performing functional, integration, system, performance, user acceptance testing (UAT), regression testing, team management, action tracking, bug tracking through MS RAID, status reporting.

Attended change request meetings to document changes and implemented procedures to test changes.

Represented onsite team to communicate with offshore team on any technique issue.

Responded on a callback basis to customer development issues, specifically with technologies including SQL Server 2008 r2 and DB2.

SQL DBA, Microsoft,

Redmond, WA January 2011 – July 2011

Primarily involved with development and supporting Next Generation Matter Management-

Worked extensively on SQL Server Management Studio.

Responsible for ensuring the activities of QA team met business standards.

Validated the performance of batch jobs and SSIS packages per the business requirement.

Production Code Deployment and handling concurrent user requests.

SQL BI Programmer, People Tech Group

Bellevue, WA September 2010 – December 2010

Worked extensively on SQL Server Management studio and SQL Server BIDS.

Generated monthly reports on time spent on each activity, the phase of the project, money spent, members, etc. using SSRS 2005.

Created SQL scripts and stored procedures to create, insert, update and delete database objects.

Responsible for creating, enhancing and maintaining SSIS, SSRS.

Developed the SSIS packages with different transformations, precedence constraints, configuration settings, check points and security levels while gathering data from different sources.

Web Developer, ACE Solutions

Vijayawada, India January 2006 – Jan 2008

Planned, created, launched, and managed corporate web sites for the Company with strong emphasis on user-centered design, usability standards, and human factors testing.

SKILLS

Languages: SQL, C#.NET, Powershell

Databases: SQL Server 2008 r2/2012 (SSMS), Oracle 11g, IBM DB2, MS Access 2007

Operating Systems: Windows Server (2012R2/2012/2008/2005), Windows 7 Ultimate, Windows XP

Office Automation: Microsoft Office (MS Word, Excel, Power Point, Access and Outlook)

IDE: Visual Studio 2012/2010, Toad for DB2 4.7, IBM Data Studio 2.2

ETL Tools: SQL Server 2008 Integration Services, InformaticaPowerCenter 8.5.1

Other Tools & Services: Microsoft SCOM 2010/2012, Microsoft Service Manager 2010/ 2012,

SQL Server 2008 r2 reporting services, Microsoft VSTF 2010, Microsoft RAID, Perforce

EDUCATION

M.S., Computer Engineering, Wright State University, Dayton, OH - September 2008 – August 2010

Contact this candidate