Pradyothana D.P
Email:
Mob : [login to view URL]
Professional Summary
? Have 6 years of experience in SQL Server Database Administration.
? Have extensive experience with installation and configuration of MS SQL Server 2000/2005/2008.
? Good Upgrading/migration experience from older versions to MS SQL Server 2005/08.
? Have extensive experience with Backup tools like TSM, VERITAS Net backup.
? Have experience with Database Backup, Recovery and Disaster Recovery Procedures.
? Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.
? Have experience with using Trace flags / Profiler to solve Dead Locks/Long running queries.
? Experience in investigating and applying necessary SQL Server database service packs and patches.
? Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
? Good experience with the implementation of database management standards, controls procedures and documented the same.
? Configured and worked on Log Shipping & Replication.
? Have experience in SQL Cluster Administration.
? Experience working with production and 24 x 7 on call environments.
? Participated as a Young Scientist for Indian Science Congress, in Jan 2005 and presented a technical paper on Solar Thermal Power Generation Plant (STPGP)
IT Experience
Company Designation Duration
Aditi Technologies Sr. Development Engineer May 2010 - Till Date
IBM System Engineer Apr 2009 - May 2010
ZeOmega Database Developer Jan 2008 - Apr 2009
Genisys Software Technical Analyst Feb 2005 - Jan 2008
Non - IT Experience
Institute Designation Duration
Govt. Arts & Science College Part Time Lecturer Dec 2003 -Feb 2005
Managerial Skills
? Train and delegate tasks to junior associates
? Preparing technical documents.
? Presenting technical aspects as and when required.
? Managing the team with respect to rotations so that delivery should not affect.
? Handling L3 and L4 issues with the team
? Make sure SLA for projects are in sync.
? Verifying the scripts or process on staging or development before applying on production.
On Site Co-Ordination
? Worked in client place for a period of 2 months as a Knowledge Transition on the account of HMH.
Technical Skills
Languages : C, C++, Java, Visual Basic
Databases : SQL Server 2000/2005/2008
Operating Systems : Windows 2008/2003/2000/NT, Windows XP
SQL Server Tools : Enterprise Manager, Profiler, Query Analyzer, Export & Import (DTS)
Education
? Master of Computer Application (MCA), from VTU, Bangalore, Dec 2003.
? [login to view URL] (PME) from Kuvempu University May 2000.
? PUC from Karnataka PU Board.
? SSLC from Karnataka SSLC Board.
Certifications
? 70-444: Optimizing and Maintaining a Database Administration Solution by SQL 2005
? 70-431: MCTS
? RDBMS, Concepts from Brain Bench
Project Details
Company : Aditi Technologies, Bangalore
Clients/Projects : Onvia, HMH, Marthas, Cedar and KDS
Environment : SqlServer 2000/2005/2008
Duration : May 10 - Till Date
Role : Sr. Database Administrator
Responsibilities
o Creation of New NT Logins and granting privileges to users/Groups and objects
o Used DBCC commands to check physical and logical consistency of the databases and Rebuild indexes
o Provide dedicated support to all Production, QA & Development MS SQL Server Environments
o Review / test / apply all database changes to all environments including QA, Development and Production Servers.
o Trouble shooting performance issues.
o Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
o SQl Server 2008R2 clusters installations and maintenance.
o Reports scale out deployment.
Company : IBM India Private Ltd, Bangalore
Clients/Projects : Service Master, NCL and Pearson
Environment : Sql Server 2000/2005/2008
Duration : April 2009 - May 2010
Role : Database Administrator
Responsibilities
o Creation of New NT Logins and granting privileges to users/Groups and objects
o Used DBCC commands to check physical and logical consistency of the databases and Rebuild indexes
o Provide dedicated support to all Production, QA & Development MS SQL Server Environments
o Review / test / apply all database changes to all environments including QA, Development and Production Servers. Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
o Setup Transactional Replication and maintain the servers.
o Involved in SQL Server 2005 installation and migrations from older version to MS SQL 2005 version.
Company : ZeOmega InfoTech Private Ltd, Bangalore
Client/Projects : NWBH, QE
Environment : SqlServer 2005
Duration : Jan 2009 - April 2009
Role : Database Developer
Responsibilities:
o Responsible for Logical & Physical Database Design.
o Create/alter of new table, Stored procedure, triggers and views
o Developed SSIS packages for both import and export.
o Developed SSRS reports and deployed to client
o Report server configurations
o Creation of New NT Logins and granting privileges to users/Groups and objects
o Used DBCC commands to check physical and logical consistency of the databases and Rebuild indexes
o Monitor NT Event log for system, application errors, available disk space, Backup registry, keep emergency repair disk as current
o Used NT Performance monitor to monitor CPU & Memory usage and SQL Server Profiler to monitor and record database activities of particular users, applications.
o Established Replication, log shipping on client environment.
o Worked on Linked servers to run distributed queries between SQL servers
Company : Genisys Software, Bangalore
Client/Projects : Contact Center
Environment : Sql Server 2005
Duration : Sept 2006 - Jan 2008
Role : Technical Analyst
Responsibilities:
o Creation of user Databases and installation of MS SQL Server 2005
o Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
o Handling junk data with T-SQL scripts.
o Recovering the Backups of SQL Server production databases in test servers as part of regular maintenance activities
o Replication maintenance and monitoring
Company : Genisys Software, Bangalore
Client/Projects : Young America
Environment : Sql Server 2000
Duration : March 2005 - Sept 2006
Role : Trainee
Responsibilities:
o Creation of user Databases and installation of MS SQL Server 2000.
o Developing stored procedures and triggers.
o Writing VB code for application customization.
o Preparing scripts for data issues using T-Sql.
o Recovering the Backups of SQL Server production databases in test servers.
Personal Details :
Name : Pradyothana D.P
Date of Birth : 05th April, 1980
Father's Name : Prabhakara Vardhan D.K
Mobile : [login to view URL]
Email ID :
(Pradyothana D.P)
