Sql Server Manager

Sridhar

Email: ****************@**********.**.**

Phone: +91-970*******

Professional Background:

• Total 2.9 years of experience as SQL Server database admin and SSIS developer.

• Have configured and implemented on different database platforms like SQL server 2000/2005/2008.

• Experience in Database Backup, Recovery and Disaster Recovery procedures.

• Expertise in planning and implementing MS SQL server security and database permissions.

• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.

• Expertise in trouble shooting database issues.

• Expertise in writing and debugging stored procedures, functions and triggers.

• Extensive experience in writing complex Transact-SQL.

• Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.

• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS) and SSIS.

• Monitoring disk space utilizations, T-Log file size maintenance, and capacity planning.

• Creating Maintenance plans and troubleshooting SQL Server Agent Scheduled jobs like Backup, Integrity, Optimization, and Log Shipping jobs regularly.

• Maintenance and Implementation of high availability solutions with Log -Shipping, Replication, and Mirroring.

• Have hands on experience in Transactional Replication and Database Mirroring.

• Have proficient skills in replicating, backups and restore mechanisms for SQL databases.

• Have conceptual knowledge of memory management, and operating system concepts involved in configuring SQL server database.

• Have good knowledge on Oracle (SQL and PL/SQL).

• Having good knowledge in VISUAL BASIC 6.0.

Certificates :

• 'Star Performer Of the Year' award from persistent systems.

Work History:

Persistent Systems Ltd., Pune : ---2.9 years (Sep 2009 – Till Date)

Technical Background:

Operating Systems : Windows 95/98/XP, Windows Server 2000/2003.

Languages : PL/SQL, SQL.

Tools : Toad 9.x, MS Office, SSMS, Enterprise Manager.

Databases : ORACLE 9i/10g, MS SQL 7.0/2000/2005/2008, and Access.

Business Intelligence Tools : SSIS

Educational Background:

• B.Sc Computers, 2001, Sri Venkateswara University, Tirupati.

Work Details:

Company Name : Persistent Systems Ltd.

Project Title : IBM JD SQL DBA

Scope of the Project : SQL Server 2000/2005/2008, Windows 2003/XP

Duration : Since 01/10/2009

Team Size : 7

Role/Responsibilities : DBA – MS SQL Server.

Description

The DBA service is corporate database group which support heterogeneous database systems of various business units in John Deere. DBA team includes professionals for open systems like DB2 on LUW, Oracle, and MS SQL Servers and professionals for mainframe servers DBMS like IBM AIX5, Z/OS.

To provide solutions to corporate requirement and also provide tier 2 and tier 3 technical support to application development teams for business continuity. Team supports all Production, Development & Test (QA) databases. Team attend installation, configuration, Backup, restore, moving databases, monitoring and troubleshooting SQL server, implementing database mirroring, log shipping, replication, fail over clustering, performance tuning, upgrading the MS SQL servers, formulation & implementation of disaster recovery strategies, Creation of Database objects, Estimating the size, Altering the database objects, Migrating, upgrading database servers on Production to newer version, Solving the developers problems related to databases & performance related problems.

Software Tools : SQL Server 7.0/2000/2005/2008, Quest PA, SSMS, BIDS, Service Center, Service Manager, Kayako and Test Director.

• Installing Database Server, Service packs, and Hot fixes.

• Upgrading SQL Server 2000 to SQL Server 2005 & SQL 2000/2005 to SQL Server 2008.

• Ensuring that all databases are backed up on a regular basis by monitoring full, differential, transaction log backups.

• Migrating databases from one server to another server along with their associated logins.

• Maintaining the Database for producing accurate results.

• Fix backup failures, address and implement resolutions.

• Restoring databases as requested; troubleshoot databases with data consistency/torn page problems.

• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS).

• Monitoring disk space utilizations, sizing, and capacity planning.

• Point-in-time Recovery of the development databases on demand basis for testing purpose.

• Performed database consistency checks.

• Resolving escalated and complex problem within SLAs, establishing user acceptance performance bottom line.

• Managing Security, Permissions of Server Roles and Database Roles.

Software Tools : SQL Server 2005.

Company Name : Helix Technologies.

Project Title : Hxt Support

Scope of the Project : Network operating systems management and support.

Duration : From : Nov-2003 To : Nov-2005

Team Size : 12

Role/Responsibilities : System Administrator.

• Management and support for various environments

• Database Management and support.

• Backup and disaster recovery measures

• Setup and maintenance of security rights and access.

Software Tools : Windows-XP, Windows-NT-2000, Windows Server 2000.

Contact this candidate