Sql Server Insurance

CURRICULUM VITAE

VENKATESH ANKARLA

Phone : 970*******

SQL Server DBA

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

PROFESSIONAL SUMMARY

SQL Server DBA with 3year 3months of experience in Database Administration

& Development Support of MS SQL Server 2008, 2005, 2000.

Maintaining and performing day to day activities on various

environments,including Production, Test and Development.

Installed SQL Server 2005 and SQL Server 2008 on windows 2003 and windows

2008 servers.

Experience in designing and implementing Disaster recovery strategies using

Database Backups, replication models, mirroring.

Experience in Writing and Debugging Stored Procedures and Triggers.

Performed upgrades from SQL server 2000 to SQL server 2005 and SQL server

2005 to SQL server 2008 and applying windows patches and Service packs.

Maintained Database authentication modes, creation of users, configuring

permissions and assigning roles to Users.

Experience in Performance Tuning, Query Optimization, client/server

connectivity, Database consistency checks using DBCC Utilities.

Expertise with Table Design, Index Design and Performance Tuning.

Involved in Optimizing code and Improving efficiency in databases including

re-indexing, recompiling stored procedures.

Expert in planning and scheduling Backup & Recovery

Utilization of DBCC commands for maintaining database consistency

Trouble shoot Performance issues on SQL Server & Database level Performance

Monitoring (CPU,Memory,Disk,SQL Server Profiler)

Scheduling and monitoring SQL Server jobs, and resolving issues, monitoring

health of the database servers, storage, memory & CPU utilization.

Checking all the servers services are running up and fine.

Monitoring the growth of the databases to ensure the smooth running of

daily activities.

Using Performance Monitor/Profiler to solve Dead Locks/Long running

queries.

Excellent interpersonal, analytical and communication skills.

TECHNICAL SKILLS

RDBMS : SQL Server 2008/2005

Operating Systems : Windows Server 2008/2003, XP

Languages : SQL,T-SQL

SQL Server Tools : Management Studio, Enterprise Manager, Perfmon,

Profiler, Query Analyzer.

EDUCATIONAL QUALIFICATIONS

Bachelors in Technology (Computer Science Engineering), Jawaharlal Nehru

Technological University, India.

Experience Summary

Presently working with Karvy Insurance Repository (KARVY),as a Database

Administrator from 2012 Jan 9th- Till Date.

PROFESSIONAL EXPERIENCE

Company Name: Karvy Insurance Repository

Project Title : ADMIRE

Environment&Tools Used : SQL Server 2008/2005, SSIS/DTS, PROFILER,

PERFMON, SCM, SAC.

Team Size : 3

Role : Administrator

ADMIRE is to provide policyholders a facility to keep insurance policies in

electronic form and to undertake changes, modifications and revisions in

the insurance policy with speed and accuracy in order to bring about

efficiency, transparency and cost reduction in the issuance and maintenance

of insurance policies.

ROLES & RESPONCIBILITIES:

Installed SQL server 2008 on windows 2008 servers, applied service packs

and Security fixes

Performed upgrades from SQL server 2000 to SQL server 2005 and SQL server

2005 to SQL server 2008 and applying windows patches

Maintained Database authentication modes, creation of users, configuring

permissions and assigning roles to users.

Performed daily backups and developed recovery procedures.

Creation of schema objects, rules and granting of roles to the users..

Using Performance Monitor/Profiler to solve Dead Locks/Long running

queries.

Setting up backups for the newly created databases.

Scheduling the Jobs,alerts &maintenance plans.

Helped the developers in writing Stored Procedures & Functions & Triggers.

ENVIRONMENT: MS SQL Server 2008, SQL Server 2005, Windows 2008 Server

&windows2003server.

Name: TATA AIG General Insurance Company

Client: AXIS BANK

Team Size: 4

Role: Administrator

Description: TAGIC is an Application that supports end to end of an

Insurance Company.It provides easy way to Process the Applications &

Generate Reports.

TAGIC contains modules which go by a flow like inflow of proposals

Scanning,Inwarding,Scrutining,Indexing,DataEntry,TaskAssignment,TaskAllocati

on and generating Reports in different formats.

ROLES & RESPONCIBILITIES:

Database Backups and Restores job.

Grant privileges to users to access Databases.

Space Monitoring.

Creating Databases, Logins and providing permissions.

Hands on experience on writing queries.

Creating a job and send an email on daily basis.

Rebuilding the indexes at regular intervals for better performance.

Sql Server Installations and Up gradations.

Scheduler for Automatic Backups.

Created,Administered & Maintained SQL Server Databases (Production,

Development, Test Env.) for various groups such as Developer, QA, DA, User

etc and ensured the Availability of the Database Server in a 24X7

Environment.

ENVIRONMENT: MS SQL Server 2008, SQL Server 2005, Windows 2008 Server &

Windows 2003 Server.

Declaration:

I do here by declare that the above information given by me is true and

content to the best of my knowledge and belief.

(VENKATESH ANKARLA)

Contact this candidate