Praveen Devaram Email & Phone Number

Los Angeles Ca

•Provided support to 75 database Servers having a volume of 15 terra bytes with an average throughput of 2 million transactions per day•Provided 24x7 support on an on-call rotation basis•Worked on Performance Tuning and Optimizing Queries by analyzing Execution Plans and Re-designing Indexes.•Configured and administered Transactional Replication•Configured and administered various high availability and Disaster recovery technologies such as Log Shipping, Clustering and Database Mirroring•Involved in planning a implementing Disaster Recovery Exercise•Involved in Capacity Planning and worked with storage team to add new storage space as needed•Analyzed and setup various Alert jobs on servers for pro-active monitoring.•Scheduled Backups of databases and recovered them periodically to verify integrity of Backups•Involved in Partitioning tables that have huge data and accessed more•Managed Security by using login/groups and assigning appropriate permissions

•Provided support to 50 database Servers. Support included Production, QA and Development•Worked on Performance Tuning and Optimizing Queries by analyzing Execution Plans and Re-designing Indexes•Scheduled Backups of databases and recovered them periodically to verify integrity of Backups•Developed SSIS packages to transform data between various data sources•Configured and administered Transactional Replication•Involved in Capacity Planning and adding new storage space as needed•Worked on evaluating various high availability technologies such as Log Shipping, Clustering and Database Mirroring•Configured Linked Servers•Managed Security by using login/groups and assigning appropriate permissions•Wrote complex T-SQL queries and Stored Procedures for the reports•Upgraded databases from 2000 to SQL 2005 and SQL 2008•Installed and Configured SQL Server 2005/2008 on Stand-Alone and Active/Passive clusters on Windows 2003

•Assisted the Professor in Database Systems course•Conducted help sessions in the evening to assist students with Database System course•Helped the students to clarify database concepts like Normalization, JOINS, Entity Relationships and other SQL queries•Involved in planning the course schedule•Involved in preparing Exam questions•Involved in Grading the Exams•Involved in Setting up the database server, created logins and granted required permissions on the database to the new students every semester

Hyderabad Area, India

•Designed Logical and Physical model using Erwin•Worked on writing complex Stored procs for reports•Involved in Performance Tuning using performance monitor and SQL Profiler•Involved in Optimizing queries by looking at the query plan & cost•Analyzed and Redesigned Indexes•Developed SSIS packages to transform data from various data sources•Imported and exported data from heterogeneous sources using various techniques like BCP and DTS•Involved in Capacity planning for Database Servers•Used Constraints and Triggers to enforce Business rules•Managed Security by using login/groups and assigning appropriate permissions

Master'S In Applied Computer Science, Computer Science

Bachelor Of Technology (B.Tech.), Electronics And Communications