Paresh Prajapati

Current

SQL DBA at Elan Emerging Technologies

Past

SQL DBA at Asite Solutions Pvt Ltd
Database Administrator at Gujarat Infotech Pvt. Ltd.

Education

Gujarat University

Connections

150 connections

Industry

Computer Software

Websites

Paresh Prajapati’s Summary

Blog : http://paresh-sqldba.blogspot.com/
Twitter : http://twitter.com/paresh_sqldba
Tagged Profile : http://www.tagged.com/paresh_prajapati
Tagged Invitation : http://www.tagged.com/register.html?aa=72sjkis&a=1

Paresh Prajapati’s Specialties:

SQL Server 2005/08/00

Paresh Prajapati’s Experience

SQL DBA

Elan Emerging Technologies

(Privately Held; Information Technology and Services industry)

September 2008 — Present (1 year 3 months)

Over 3 years of IT Experience and with professional experience in design, implementation and managing of Databases. Following are the SQL server Database tasks for Database maintenance, Implementation and performance.
Experience in SQL Server Replication , Database Mirroring and Database transactional Log shipping for Disaster recovery.
Monitoring database access by privileged users and changes in privileges.
Check SQL Server Logs, and Security Logs for unusual events. Monitor databases for errors and perform problem determination when necessary.
Verify that all scheduled jobs have run successfully and for failed completion.
Confirm that backups have been made and successfully saved to a secure location. Verify the Backups and Backup file size and Check Database & Transaction Log Space. Verifying Backups with the RESTORE VERIFYONLY Statement Manage backup and recovery of databases.
Monitor disk space to ensure your SQL Servers won’t run out of disk space.
Periodically monitor performance using both System Monitor and Profiler. Monitor performance with PERFMON also.
Monitor and identify blocking & Waiting issues. Use SQL Tools to check SQL server databases activities.
Optimization and Tuning of Indexes and Code Analysis of procedures.
Maintain database changes from Development, QA and PreProduction to Production for Release process and sync databases from local to production .
Run some DBCC commands (dbcc checkdb / dbreindex / checkcatalog / inputbuffer) to check out database consistency, index fragmentation and Process statement for blocking and waiting and Check DBCC output.
Keep production /UAT/PreProduction databases in VSS for version of DB changes for Database version.
SQL DBA

Asite Solutions Pvt Ltd

(Privately Held; ASE; Computer Software industry)

December 2007 — September 2008 (10 months)

Technology proficiency include database Administration, Performance tuning, Backup Recovery, Troubleshooting, Installation, configuration and Managing Data center.
Configuration of other Database option like Replication Setup, Log Shipping, Database Mirroring, Database Snapshot, Cluster Administration, various Backup strategies.
Monitoring Blocking/Waiting of SQL Server, Other DBA Task like Instance Monitoring, Performance Monitoring, Planning of Resources of CPU & Memory, Disk Space and Automated Restoration Planning, Integration Service like Import/Export Data, and Database comparison and monitoring same.
Regular daily DBA admin tasks include managing servers, security, monitoring connections, Monitoring Scheduled Task/Jobs.
Checkout DBCC output, checkout Hard disk space, Check Database and Transactional space, Check Event Logs and SQL Server Error Logs.
Mastered the art of Performance Tuning of SQL Server. Used various tools like Database Tuning Advisor, SQL Profiler, Index Tuning wizard, various DBCC commands, System Stored Procedures and Extended Procedure, strong knowledge of query optimization and Query analysis.
Experienced in managing various database backups and recovery models, other options like Full Text Indexing, Transactional SQL (T-SQL) coding, writing queries,, Stored Procedures, Cursors & various DDL/DML Triggers.
Maintain development, Test and Production Databases. Good understanding of SQL Server security and Capacity Planning.
Determining and implementing the backup/recovery plan for each database while in development and as the application moves through test and onto production
Establishing and maintaining sound backup and recovery policies and procedures and Restoring database services for disaster recovery
Recovering the database in the event of a hardware or software failure.Using partitioning and transportable table spaces to reduce downtime, when appropriate
Backup and Restore Database, Job Scheduling.
Database Administrator

Gujarat Infotech Pvt. Ltd.

(Computer Software industry)

April 2006 — December 2007 (1 year 9 months)