Deepak Godekere Panchakshara Murthy

Mobile: +1-682-***-****

ac187s@r.postjobfree.com

SUMMARY

* ***** ** ********** ** Database Administration and Development for very large and complex databases in SQL Server 2008 R2/2008/2005/2000.

Excelled in role requiring the ability to handle a variety of customer service and administrative tasks and resolve customer issues with expediency.

Led "cleanup" of company database and files. Restored organization to personnel, financial and operational records and accelerated data input, processing and retrieval times.

Consistently praised by management for the quality and timeliness of reports, attention to detail, exemplary customer service delivery and team-player attitude.

Involved in upgrading SQL servers using in place and side by side.

Used log shipping for synchronization of database.

Monitoring SQL server performance using profiler to find performance and deadlocks.

Created Stored Procedures, Triggers, Views and Functions for the Application.

Extensive testing on the Performance of the Stored Procedures.

.

Education

Bachelors in Mechanical Engineering, Visvesvaraya Technological University

Masters in Computer and Information Systems Security, University Of The Cumberlands

PROFESSIONAL EXPERIENCE .

RNC Software Solutions, Hyderabad, India. (June 2011 – May 2013)

SQL Server 2005 DBA/Developer

Description:

This application is used to supply data to different customers. Depending upon the requirements of customers, data is supplied in appropriate formats. All the data related to customers, in their respective formats and the schedule details are stored in database. This application will generate tab delimited text files from database, in the required format and these text files will be uploaded to the Customers through FTP. These applications have greater flexibility in the sense that there is no need to change the code for each and every new Customer. Whenever a Customer requires new data/new Customer is added, then all the details about the data requirement and schedule details are added to the database using VB application. BCP, Bulk insert, Snapshot Replication and DTS package technologies are extensively used throughout the application. This project eliminated the human Intervention to greater extent and reduced the Database Maintenance work.

Responsibilities:

Worked on Client/Server tools like SQL Server Management studio (2005), SQL Server Enterprise Manager (2000) and Query Analyzer to Administer SQL Server.

Migrated SQL server 2000 databases into SQL server 2005 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.

Handled up to 2 TB Size databases with clustered and stand alone environment

Configured Transactional replication on migrated server.

Wrote the packages using SSIS in SQL2005.

Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).

Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.

Integrated SQL traces with PerfMon log to have better graphical analysis to find system bottlenecks.

Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.

Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.

Used DTS packages to move logins and jobs from one server to another server.

Used log shipping for synchronization of database.

Monitoring SQL server performance using profiler to find performance and deadlocks.

Created Stored Procedures, Triggers, Views and Functions for the Application.

Extensive testing on the Performance of the Stored Procedures.

Volunteer/activities

Tutor computer students

Assist area school corporation with computer updates

Contact this candidate