SQL DBA/Developer

RESUME

Mothakuduri Sairam

E-mail id: ************@*****.***

Mobile number: +91-970*******

Career Objective:

Seeking a position of Jr.SQL Server DBA in the field of Information Technology to utilize my best of skills and abilities thereby adding value to organization

SQL DBA Summary:

1.2 years of experience in IT industry as SQL Server Database Administrator.

Experience in installation and configuration of SQL Server 2000 / 2005 / 2008.

Worked on upgrading SQL Server 2000 to SQL Server 2005 and SQL 2008

Experience in installing SQL Server 2005 & 2008, applying service packs (SQL2005-SP2 / SP3, SQL2008-SP1).

Experience in creating databases, transactions, tables, writing and debugging triggers, views.

Expert in monitoring SQL Server Performance, troubleshooting using SQL Profiler, Windows Performance Monitor and Maintenance plan.

Expertise in Database Backup, Recovery and Disaster Recovery procedures and creating logins.

Theoretical knowledge in implementing many types of high availability such as Clustering, Database Mirroring, Log Shipping, and Replication.

Monitoring Databases and server, estimating the growth of the databases.

Experience in Automating the Database Maintenance tasks by creating Jobs and Alerts using the Database Mail and SQL Server Agent.

PROFESSIONAL EXPERIENCE:

Anjani Portland Cement Limited,

Hyderabad, India.

March 2010 - Till date

Role: Associate SQL Server DBA - Production support

ASSIGNMENT:

Client : Anjani Portland Cement Limited, Andhra Pradesh, India

Role : SQL DBA

Team Size : 4

Environment : SQL Server 2005 DBA on Win Server 2003 & 2008

Duration : March 2010 to till date

KEY RESPONSIBILITIES:

Worked extensively on installation, upgrade and configuration of Microsoft SQL Server 2005/2000 and 32/64 bit SQL Server Cluster for SQL 2005 and SQL 2000.

Experience installing SQL Server 2008

Experience on migrating data from SQL 2000/2005 to SQL2008. Worked extensively on creation of databases, stored procedures, triggers, security, Import and Export, Transact-SQL, Backups, Recovery, and SQL Server profiler.

Worked extensively on data maintenance like re-indexing, and database shrinking.

Implementation of Point in time Backup and recovery plans of all databases and maintain documentation. Schedule the Administrative Tasks. (Like maintenance plans).

Created jobs and schedule them with notification.

Implemented disaster recovery production database as Fail-Over or Standby Servers.

Used Log Shipping Technique for warm backup solution for SQL Server databases.

Very good experience in the maintaining production Servers, monitoring performance issues, trouble shooting and solving production issues.

Experience working on SQL server Performance Monitor, working on slow running queries, dead locks, creating and analyzing traces.

Experience working on Database Engine Tuning Advisor.

Creation and maintenance of Users security permissions and Migration the entire database objects from one Server to another Server and database to another database.

Environment: Windows 2003 Server, MS-SQL Server 2005, MS-SQL Server 2000.

Educational Qualifications:

MCA from Padmasri Dr.B.V.Raju Institute of technology of JNTU University.

B.Sc from Pragathi Degree College of Osmania University.

Technical Skills:

Server : Windows Server 2003, Windows Server 2008.

Distor’s : Windows XP, Windows 7, Linux (Ubuntu 9.04, Fedora 9).

Database : SQL Server (2000, 2005 & 2008), Oracle 9i/10g.

Workstation : VMware workstation 5.0 & 7

Packages : MS Office.

Web Technologies : Html, Xml, Java script.

Achievements:

Received second prize in National level Tech Event.

Stood first in School level in SSC.

Certified as a database associate by IBM

Certified by Infosys campus connects

Certified as DOA(Diploma in Office Automation) by CMTES

Declaration:

I hereby declare that all above information stated is correct and genuine.

Place:

Date:

Yours sincerely

(M.SAIRAM)

Contact this candidate