Sql Server Project

Satya Karishma Prem Nandivada

SQL Server DBA

Cell: +91-996*******

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

Objective:

Seeking a challenging role in a world class Organization that gives me the opportunity to utilize my skills and experience.

Professional Summary:

Have an Extensive knowledge in SQL Server DBA with 3.3years hands-on experience in SQL Server 2005/2008.

Expertise in planning and implementing MS SQL Server Security and Database permissions.

Sound knowledge in Database Backup, Restore and Disaster Recovery procedures.

Experience in implementing different types of Replication types like Snap shot, Merge, Transactional and Transactional with immediate updatable subscribers.

Maintained Database Authentication modes, Creation of user, Configuring permissions and assigning roles to users

Experienced with Index design and Performance tuning

Experience in scheduling Alerts and Jobs

Worked closely with clients, management, development team and users.

A team player with excellent communication, analytical and inter-personal skills.

Work Experience:

Organization

Intranz Solutions Designation

SQL Database Administrator Duration

Dec2008 to Till date Location

Hyderabad

Technical Skills:

Languages: C, C++.

RDBMS: MS SQL SERVER 2005/2008

.

Database: Oracle9i-10g-11g, SQL Server.

Operating Systems: Windows 2000/2003/XP/VISTA/7, LINUX/UNIX.

Professional Experience:

Assignments 1 LifePro

Project : LifePro

Client : LifePro, Inc. Ozark, Missouri

Duration : Nov 2011 to Till Date.

Team Size : 5

Environment : SQL Server 2005, 2008 Windows server2003.

Project Description:

As a DBA, for this project I provided support to all User Databases and also to self-hosted clients. Maintained hosted databases to achieve contracted service level agreement requirements for uptime. Support for self-hosted clients included functioning as a database consultant, reviewing the customers practices and offering advice. When requested I would remotely connect to the customer and perform maintenance activities.

Responsibilities:

Involved in Up gradation of SQL Server 2005 to SQL Server 2008

Maintaining the jobs Scheduled during the night for the Backup of Databases.

Scheduled Full and Transactional log backups for the user created and

System databases in the production environment using the Database

Maintenance Plan Wizard.

Managing security, monitor server performance and activities.

Fixed some performance issues.

Managing databases, tables, indexes, jobs, alerts, and operators.

Daily Monitoring of the Database Performance .

Administering the MS SQL Server by Creating User Logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups. SQL Authentication

Maintaining the Log shipping, Database Mirroring for huge Databases.

Assignments 2 Youriss

Project : YOURISS

Client : INCH CAPE (Norway).

Duration : Feb 2009 to Nov 2011.

Team Size : 6

Environment : SQL Server 2005, Windows Server 2003

Project Description:

Sinchcape Shipping Services is the world’s leading marine services provider. Through its proprietary network of over 200 owned offices in 52 countries, ISS provides its customers with an unparalleled global resource delivered locally and tailored to each customer’s individual needs. Ship Net provides business critical solutions to ship owners, charterers and ship managers, based on a comprehensive ERP software platform that ties together all departments within a maritime enterprise, ship to shore

Responsibilities:

• Installed SQL Server 2005 on windows 2003 server

• Implementation of SQL logins, roles and authentication modes as part of security policies for various categories of users

• Scheduled Full, Differential and Transactional log backups for the user defined and system databases using the Database Maintenance Plan Wizard, by running backup and restore commands.

• Utilization of copy database wizard (for moving or coping the database along with other objects to other server)

• Used SQL Server Profiler to monitor and record database activities of particular users and applications.

• Maintaining the jobs Scheduled during the night for the Backup of Databases.

• Maintained high availability of database using Log shipping and Mirroring

• Worked with linked servers and distributed transactions.

• Creating Jobs, Alerts, Operators and Scheduling.

Educational Profile:

Bachelors in Electronics & Communication Engineering (ECE) 2005-2009 with 63% from

JNTU UNIVERSITY (MRCET), Hyderabad, A.P, INDIA.

Contact this candidate