Sql Server Data

SREEKANTH PEDDI

**************@*****.***

PHONE: 889-***-****

PROFESSIONAL SUMMARY

5+ years of experience in Database Administration for very large and complex databases in SQL Server 2016,2012, SQL Server 2008 R2, 2008 and 2005.

Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting

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

Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.

Knowledge in T-SQL writing stored procedures, triggers and functions.

Administering SQL Server High Availability and Disaster Recovery strategies.

Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.

Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.

Worked on logical and physical data base modeling with UML and ERWIN tools.

Experience in using DMV and dynamic management functions for finding out long running queries.

Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.

Experience in Disaster Recovery Planning and Security Management operations.

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

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

Worked on configuring SQL Server with minimum privileged access.

Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.

Troubleshoot performance problems, fine-tuning of databases and index Analysis.

Worked on SQL Server 2016 migration from SQL Server 2012 / 2008.

Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.

Implemented Always-ON (AAG) on SQL Server 2012 SP2 CU5

Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.

Having Experience on Data center servers and handling 1.4 TB databases.

Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.

Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.

Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.

Working knowledge in Analysis Services(SSAS), Reporting Services(SSRS) and Clustering.

Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.

Strong experience in mentoring team members and writing documentation.

24 X 7 Production Database on Call Support

Technical Education

Bachelors in Electronics and Communication Engineering, M.A.M COLLEGE OF ENGINEERING

Masters in Computers and Information Systems SHEFFIELD HALLAM UNIVERSITY, NOTTINGHAM,U.K

Technical Expertise

Databases:

MS SQL Server 2016,2012, 2008, MS SQL Server 2005

Programming:

Visual Basic 6, Visual Basic 5, C, C++ & SQL

DBA:

database administration of MS SQL Server 2012,2008, 2005

Operating System:

Windows 2008/2003 Advanced Server, NT & Windows 9x, Linux

Other Software:

Windows 2008/2003 Advanced Server, NT & Windows 9x, Linux

Network Topologies:

TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

Professional Experience

Title: SQL Server DBA

Client: Advent INC (Raytex IT)

Duration : (September 2018 – Present Working)

Responsibilities

Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Congiduration

Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.

Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.

Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.

Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

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.

Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.

Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA).

Expert in implementing the snapshot isolation and DDL triggers.

Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Environment: SQL Server 2008/2012 Enterprise, Windows Enterprise Server 2012, .NET, Microsoft Reporting Services.

Professional Experience

Title: SQL Server DBA

Company : Yash Technologies

Duration :4 Years

Responsibilities

Perform business analysis, technical analysis, systems design, application software programming.

Prepared DFD's & Entity Relationship(ER) diagrams.

Restructuring the stored procedure,designing, coding and developing the same using the T_SQL Programming .

Transferring the data (ETL) to Data warehouse (Informatica) by SSIS.

Extensively worked on Dynamic Management Views in SQL Server 2005.

Installed, authored, and managed reports using SQL Server 2005 Reporting Services.

Managed the migration of SQL Server 2000 databases to SQL Server 2005.

Monitoring SQL server performance using SQL Profiler to find performance and dead locks.

Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.

Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.

Re-engineering Customer Cognos and People Soft modules into SQL Server 2005 Integration Services.

Prepared the project management and technical documentation.

Unit Testing the SSIS packages with respect to its flow and performance issues.

Solving the Bugs Reflected by the Testing team.

Rebuilding the indexes at regular intervals for better performance.

Monitored and modified Performance using execution plans and Index tuning.

Rebuilding the indexes at regular intervals for better performance.

Managing the VERITAS net backups.

Extensively worked on DBCC commands and Dynamic Management Objects.

Expertise in SQL Server Reporting Services and SQL Server Analysis Services.

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

Complete documentation about the database. Recovering the databases from backup in disasters.

Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.

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

To set up SQL Server configuration settings for better server management.

Monitoring the servers using Idera third party software.

Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

Database Administrator, Database Programming.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Rebuilding the indexes at regular intervals for better performance

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

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

Monitored and modified Performance using execution plans and Index tuning.

Rebuilding the indexes at regular intervals for better performance.

Deploying new code base release to UAT and Production Environments.

Perform SQL Server service pack and Windows Service pack upgrades.

Working with customers on Application rollouts and server migrations.

Extensively worked on Enterprise Manager for managing the database.

Troubleshoot performance problems and fine-tuning of databases.

Involved in Index Analysis and Performance Tuning.

Worked with different upstream team for downloading ETL MART data.

Converting DTS packages into SQL Server 2005 Integration Services.

Migrating SQL Server 2000 data bases into SQL Server 2005.

Recovering the databases from backup in disasters.

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

Installing SQL Server with minimum access privileges service account to improve security and to attain high ratings in SOC audits.

Installed, configured SQL Server 2005 Clustering on Microsoft Clustering services (MSCS) from Hardware inventory to test environment.

Involved in Analyzing and Upgrading SQL Server 2000 test servers to SQL Server 2005.

Having experience on SAN and RAID levels and building SQL Cluster servers on SAN Environments.

Perform SQL Server service pack and Windows Service pack upgrades.

Designed and implemented comprehensive Backup plan using SQL LiteSpeed.

Resolved and tweaked memory pressures caused during product release.

Worked with customers on Application rollouts and server migrations.

Troubleshoot performance problems and fine-tuning of databases.

Expertise in designing databases and capacity planning.

Rebuilding the indexes at regular intervals for better performance.

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

To provide 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.

Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.

Monitored and modified Performance using execution plans and Index tuning.

Transferring the data (ETL) to Data ware house by SQL Server 2005 Integration Services.

Rebuilding the indexes at regular intervals for better performance.

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

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.

Designed and created databases, tables, views, store procedures and triggers.

Monitoring the server for High availability of the servers.

Solving the request raised by user support.

Participate in implementation of new releases into production.

Facilitates application deployment and joint effort deployments.

Meet the SLA (Service Level Agreement) established.

Day-to-day administration of live SQL Servers.

Designed and implemented Security policy for SQL Servers.

Used Stored Procedures, DTS packages, BCP for updating Servers.

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.

Automated messaging services on server failures, for task completion and success.

Execute procedures to accomplish short-term business goals.

Deploying Administration tools like SQL DB Access, Performance Monitor and Backup Utility.

Deploying monitoring tools like Sitescope and spot light.

Table partitioning to improve I/O access.

Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.

Using database level triggers code for database consistency, integrity and security.

Tested and Implemented procedures to detect poor database performance, collecting required information, root cause analysis.

Environment:SQL Server 2016, SQL Server 2014, IIS, Windows 2003/2000 Server, SQL DB Access, Performance Monitor, Backup Utility, MOM, MSE and Sitescope.

Contact this candidate