Sridhar Bonala

toa06w@r.postjobfree.com

Mobile: +91-888*******

SUMMARY

Around 5 years of experience in SQL Server Data Base Administration.

Extensive knowledge of Relational Data Base Management Systems.

Extensive experience in Installation and Configuration of MS SQL Server 2000, 2005 and 2008 versions.

Experienced in Creating Database Objects like Database, Tables, and Cluster/Non Cluster index, Unique/Check Constraints.

Hands on experience in Database Backup and Recovery procedures.

Experienced with troubleshooting of database issues.

Hands on experience in locking and blocking issues.

Utilization of Dynamic Management Views for knowing Blocking issues, Fragmentation information, user information etc.

Utilization of DBCC commands for maintaining database consistency

Having Experience of Data Base Mirroring and Log Shipping

If opportunity fines I am keen interested to learning in clustering

Experience in implementing different types of Replication models like Snapshot, transactional .

Experience in maintenance of Database authentication modes, creation of users and logins, configuring permissions and assigning roles to users.

Experience in Code Optimization and Improving Efficiency in databases including Re-indexing, Updating Statistics and performing other maintenance tasks.

Experience in Performance Tuning, index maintenance and table scans etc.

Experience on Automation of SQL Server (Jobs, Alerts and creating Operators).

Worked closely with management, applications development staff, and users on database solutions to business problems.

Good team player strong interpersonal and communication skills combined with self motivation, initiative and ability to think outside the box

ACADEMIC CREDENTIALS:

Masters of Computer Applications from Andhra University

WORK EXPERIENCE:

Presently working as Senior SQL Database Administrator with Zensar Technologies from May 2009 to till date.

Worked at Client Location London UK, for Client Inetlliq, from June 2009 to July 2009.

Worked as SQL Database Administrator with Unisoft Technologies from July 2006 to April 2009.

PROJECT #1

Project title : Barlow Logistics

Client : RAKBank, UAE

Duration : April 2010 – Till Date

Role : Senior Database Administrator

Environment : SQL Server 2005/2008, Windows Server 2003, SSIS.

Client Description:

RAKBANK, the trading name of the National Bank of Ras Al-Khaimah, is a public joint stock company, headquartered in the emirate of Ras Al-Khaimah, in the UAE. The bank is engaged in providing retail and corporate banking services through a network of twenty eight branches in the United Arab Emirates, but all the transactions are handled on a strictly commercial basis.

RESPONSIBILITIES:

Installed SQL Server 2005 and SQL Server 2008 on windows 2003 advanced server.

Scheduling and monitoring SQL Server jobs, and resolving issues, monitoring health of the database servers, storage, memory & CPU utilization as well as work with systems administrators to ensure optimal database performance.

Configure and Maintenance, Monitoring, Installation, patches, DBA tools and Clustering.

Loading & extracting of data to/from the servers, planning & executing database backup and recovery tasks.

Provide on-going technical administration and support for development, test and live production SQL database Include all aspects of SQL database administration from operational tasks such as backups and system monitoring to database configuration.

Replication configuration, and maintenance, DTS.

Backup and Restore need to follow while doing migration and setting up compatibility level to 90 for 2005 while migrating.

Import/export data, backup restore database, managing servers, and managing clients.

Performance Tuning in terms of server &DB level by enabling AWE& setting DB options.

Capacity allocations for migration databases.

Setup Windows and Web server administration.

Coordinate with developer to enhance the codes and responsible for support backup operation.

PROJECT #2

Project title : lntelliq

Client : Intelliq, UK

Duration : June 2009 – March 2010

Role : Senior Database Administrator

Environment : SQL Server 2005, Windows Server 2000, RightFax Application, BMC Remedy

Client Description:

IntelliQ supports Retail, Financial and Government sectors, IntelliQ’s solutions helps clients to generate rapid, substantial and sustainable ROI. IntelliQ provides clients to efficiently analyze transactional data from multiple sources and quickly identify instances of potential fraud, loss or failure of process compliance.

RESPONSIBILITIES:

Setting up new SQL Servers 2000 and 2005 and configuring the required users.

Created schedules for Backups and Replication.

Worked on migration and maintenance of data using various utilities like DTS, EXPORT & IMPORT and ATTACH & DETTACH Databases.

Performed Database Administration and Management activities in a safe, recoverable and professional manner that ensures the optimal operation of all database environments.

Performed data integrity by using constraints, data Types and triggers.

Export and Import data from text file to SQL Server 2005 using Bulk Copy Insert utility.

Maintain and troubleshoot Replication issues by continuous monitoring.

Regular monitoring of servers, this includes Backup job monitoring and troubleshoot all the issues on regular basis.

Installing SQL Server service packs based on the errors and flaws that are found in the application.

Using the Database Maintenance Wizard to make some necessary changes and keeping the performance of the server at acceptable levels.

Import/export data, backup restore database, managing servers, and managing clients.

PROJECT #3

Project title : Telecom Billing Software

Client : BIBBY, SA.

Duration : July 2006 to April 2009

Role : Database Administrator

Environment : MS SQL Server 2000/2005, Windows sever 2003

Client Description:

Nortel Networks decided to hang up on the telecom sector. Once one of the largest makers of telecommunications equipment in North America, The company made core network switching, wireless, and optical systems. Its wire line and enterprise network equipment included systems for digital voice and data switching, routing, and call center communications. Wireless products included cellular base stations and controllers. The company also made such long-haul fiber-optic products as multiplexers and switches.

RESPONSIBILITIES:

Installed SQL Server 2005 and SQL Server 2008 on windows 2003 advanced server.

Scheduling and monitoring SQL Server jobs, and resolving issues, monitoring health of the database servers, storage, memory & CPU utilization as well as work with systems administrators to ensure optimal database performance.

Configure and Maintenance, Monitoring, Installation, patches, DBA tools and Clustering.

Loading & extracting of data to/from the servers, planning & executing database backup and recovery tasks.

Provide on-going technical administration and support for development, test and live production SQL database Include all aspects of SQL database administration from operational tasks such as backups and system monitoring to database configuration.

Replication configuration, and maintenance, DTS.

Backup and Restore need to follow while doing migration and setting up compatibility level to 90 for 2005 while migrating.

Performance Tuning in terms of server &DB level by enabling AWE& setting DB options.

Capacity allocations for migration databases.

Setup Windows and Web server administration.

Coordinate with developer to enhance the codes and responsible for support backup operation.

Maintenance and Administration of Microsoft SQL SERVER Databases. Monitoring the growth of the databases to ensure the smooth running of daily activities.

Index defrag, reindex, Capacity Planning, Performance tuning &Replication.

Taking care of disk space, database file size (mdf, ldf, log) Scheduling and running jobs in production server for backup of databases and optimizing the database for better performance. Install and maintain SQL SERVER 2000 Software, configure, implement and maintain SQL Server databases.

Personal Details:

Name : Sridhar Bonala

Father Name : B.S.N Murthy

Date of Birth : 16/01/1983

Marital Status : Married

Passport Number : F0216673

Date of Expiry : Oct 2014

E-mail : toa06w@r.postjobfree.com

Contact Number : 837-***-****

Contact this candidate