Veeranjaneyulu Ponduri

Overall 10+ years of experience in Database Administration, Database Design, Modeling, Development & Support of MS SQL Server 2008R2/2008/2005/2000 in Production & Development environments. Good knowledge of MS SQL Server 2008 implementing new features like Row and Page compression mechanism, CDC, Data Compression, Backup compression, Resource Governor, Performance Data Collector, and Transparent Data Encryption. Performed Log Shipping and implemented Replication as a high-availability technique. Experience in Database Mirroring as a Disaster Recovery Solution. Experience in Creating Tables, Views, Triggers, Cursors, Dynamic Stored Procedures, User Defined Functions, and others. Transact-SQL (DDL, DML) statements for various applications. Worked with SSIS & SSRS for various BI requirements. Proficiency and Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning. Tracked Server Activity, Query Performance, and Disk usage activity statistics via Performance Data Collection. Expert in designing Relational Database Models, implementation, and testing as per business needs. Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database consistency checks. DBCC Utilities. Implemented SQL Server 2005 new concepts like Data partitioning, Snapshot Isolation, Online Indexing, Try-Cache Blocks, DDL Triggers, and DMV & DMF. Created Partition function, Partition scheme, and multiple file groups and files to host the table data for Data partitioning. Optimized the Disk space for performance using RAID and SAN. Experience in data migrating (using tools like DTS, between different homogeneous/heterogeneous. Experience extracting, transforming, and loading data (ETL) using SSIS, DTS Import/Export Data, Bulk Insert, BCP, and DTS Packages. Extensive use of DTS in SQL Server, Performance Tuning & Application Design, Disaster Recovery Planning, Security Management, Managing server and clients, T-SQL, etc. Experience building Adhoc Reports, Parameterized Reports, Linked Reports, Toggle Reports, and Reports with Sub Reports using SSRS. Experience in generating Drill down and Drill through reports with Drop-down menu option, sorting the data, and defining. subtotals in SSRS 2005/2008. Intensive experience in Monitoring and Tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor. Expert in automating processes by creating jobs, and error reporting using Alerts, SQL Mail Agent. Experience in the creation of logins, users and configuring permissions, and assigning roles to users. Good understanding of Normalization/De-normalization, Normal Form, and database design methodology. Experience in Database Backup and Disaster Recovery procedures like Log shipping. Worked extensively in a Clustered environment (Active / Passive) to further increase the scalability and stability of the business. critical systems. Development of automated notification when SQL Server Backups and schedule-maintained Jobs. Expertise and Interests include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2 Terabytes. Experience in optimizing the query by creating various clustered, and non-clustered indexes and indexed views. Experience in the creation of logins, users and configuring permissions, and assigning roles to users. Experience in Migrating SQL Server 2000 to SQL Server 2005 & SQL Server 2005 to SQL Server 2008 using a suitable approach. Experience in working with Windows Server 2003 Enterprise Edition, Windows 2000 Advanced Server, Windows 2000 Server, and Windows NT. 24 x 7 Production Database on Call Support. Excellent Analytical, problem-solving, - solving, and communication skills. Excellent communication and interpersonal skills, self-motivated, quick learner, and determined to learn new technologies, strong troubleshooting skills, and good Team player with excellent interpersonal and teamwork skills.-.