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)