SQL Server DBA

RESUME

Name :KADADASARIE CHENNAIAH.

Expertise :Microsoft SQL Server D.B.A.

IT Experience :6 years

Mobile Number :+91-966*******

Email-id :*******@*****.***

PROFESSIONAL SUMMARY

• Over 6years of Extensive Experience as Microsoft SQL Server Database Administrator.

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

• Implementing,configuring Databases and implementing Maintenance Plan.

• Hands on experience in Database Backup and Recovery procedures.

• Experienced with troubleshooting of database issues.

• Hands on experience in locking and blocking issues.

• 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 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

Project Experience:

Oct 2010 to Till date.

Current Organisation : Fujitsu Consulting India

Role : IT Consultant

Client : MunichRe(German)

Current Location : Pune

Technology : SQL Server 2000/2005/2008

Team size : 5

Project Experience:

July2008 to Oct 2010

Organisation : Zensar Technologies.

Role : Systems Engineer

Client : Derivco(Pty) Ltd,SouthAfrica(Durban)

Current Location : Pune

Technology : SQL Server 2000/2005.

Team size : 10

Responsibilities:

Deployment of new database packages and database object to the operator’s side.

Operator sites are configured in different O.S and CMS(Content Management Server) structure.

All live issues like IIS mismatch and database batching missing and connectivity problems are checked.

If they have any issues I am responsible to fix and resolve the issues without downtime.

Clients System Understanding and providing Database Administration support to online gamind services.

Need to check Gaming server Player in and all the in player related.

Data pulled down to the operator’s Casino without time delay.

Each operator has number of Backoffice database.

All the informations are properly down loaded from Casino to PTS servers through Replication configurations

Having 1 year Onsite Experience at Client’s place(South Africa).

Project Experience:

April 2005 to July 2008.

Project 3:

September 2007 to July 2008

Organisation : AvexaSystems

Role : DBA and Professional Services Engineer (P.S.E).

Title : Fraud Detection.

Client : 41st Parameter,Arizona,U.S.A.

Environment : SQL Server 2000/2005.

Products : Fraud Net, Phishing Net.

Scope:

Fraud Net is the most comprehensive convert fraud solution for internet,mail and telephone order merchants.This enables Forensic identification of devices, combining more than 41 unique machine parameters that monitor Fraudulent account activity and help protect sensitive customer data.By leveraging unique parameters captured form user’s P.C.FraudNet provides comprehensive analysis and greater visibility into each internet transaction using the following key technologies.

1.EZ Keys.

2.Time Difference Linking.

3.Data spider-linking Analysis

4.Over 280 Algorithms.

5.Investigator tool.

PhishingNet is designed to identify suspicious logins activity at website. It is a powerful tool to combat the growing threat of fraud and identity theft. This forensic device identification looks like for beyond user credentials and I.P Address to build an of every online user. Once the sketch of legitimate users is captured, unrecognized devices attempting to login a transact can be quickly flogged, monitored and handled by investigations.

Key features of PhishingNet:

1.End user Transperancy.

2.P.C.Print finger print.

3.Sketch match.

4.Time Difference Linking.

Responsibilities:

• Installation and configuration of products.

• Support the use of the methodology through the project.

• Lead workshops.

• Provide sample deliverables and knowledge to support configuration and testing.

• Provide best practices knowledge.

• Provide configuration expertise.

Project 2:

Apr 2007 to Aug 2007

Role : GDBA.

Title : Data Center Consolidation

Client : HP (Singapore)

Environment : SQL Server 2005/2000.

Internal Tools : CAPMAN, MARS, DCC, ESL,C.I.

Scope:

In this project mainly used to reduce their datacenters into three Zones Each Zone has two places. The Zones are Houston, Austin, and Atlanta. In this we have More than hundred data centers across the world. This Project planned to migrate the data from various part of data centers into three Zones. And Upgrade the version also. Currently this Project maintains the data in SQL 7.0, 2000 and 2005 also. So simultaneously planned to migration the data from SQL Server 2000 to SQL Server 2005.

Responsibilities:

• Tracking our application assignments through (Monitoring and Reporting Solution).

• After finding the move Id, Using this Id to DCC planning tool to find the Legacy servers.

• Analyses the application and collect the required data communicating with Application DBA (Application Team).

• After getting those details we have to put the Capacity allocation using the CAPMAN tool .The capacity DBA only allocates the space and Target servers to GDBA.

• Based on the application team report GDBA has to migrate the databases from Legacy servers to Target servers.

• GDBA has to test the Data bases and set the growth, owner and compatibility level.

• Dropping the existing users and create the new users based on their request.

• Creating new Maintenance Plan For those databases.

• GDBA has to put the ESL entries for every databases, in this tool is used to find the application owner and Primary DBA for those databases.

• Enterprise System List (ESL) is used for future clarifications.

• Configuration Item(C.I) for DB spy monitoring.

Project 1:

April 05 to March 07

Organisation : AvexaSystems .

Role : SQLServerDBA.

Title : Hospital Management.

Client : Hart ford, U.S.A.

Technologies : Win 2000, SQL Server 2000.

Scope:

Hospital Management is a health management System. It has above 30 modules. Some modules are Registration, Out Patient Billing, In Patient Billing, Laboratory, Pharmacy, Human Resource and Payroll, Security Admin and so on. It maintains the information about the In Patient and Out Patient details, Visitors and other Staff Details working in the hospital. It also schedules work fro all the employees and maintains their attendance details. This tool generates receipts, vouchers, bills, birth and death certificates etc.It also keeps track of the inventory stock in hospital. We have number of Input module and Output module. In Registration module we enter the patient details like name, age, city and concerned doctor details. After that doctor’s prescription medical details and other Laboratory tests details for that patient are entered in other module.

All of these details are gathered in Repository server from that we can get details of In-Patient / Out-Patient and generates bills using Output module Billing. In the same way we can maintain the hospital staff details their attendance details and by using these details generates Salary for staff using Output module Human Resource and Payroll. In this way this project has number of input and output modules.

Responsibilities

• Taking backups regularly through jobs.

• Transferring Data Using D.T.S.

• Monitoring jobs, troubleshooting on failure and addressing alerts.

• Monitoring log shipping.

• Transferring Data into different locations Using Replication.

• Restoring databases if database got corrupted.

• Applications troubleshoot with respect to Database issues.

• Database Maintenance activities like Index Defrag & running required DBCC Commands regularly.

Technical Skills :

Operating Systems : Win 2000/2003/XP.

Databases : MS SQL Server 2000.2005 and 2008

Academic Details :

M.C.A.(Master of Computer Applications) from Osmania University, Hyderabad.

Certification :SCRUM Methodology Training Provided by 41st Parameter.

Contact this candidate