Nirav Gajjar

Nirav Gajjar

Email : niravgajjar1986@gmail.com

Web : http://nirav.extreme-advice.com

Linked In : http://in.linkedin.com/pub/nirav-gajjar/48/a6/b36

Personal Profile:
I am Microsoft Certified DBA specializing in SQL Server programming and performance tuning over 3+ years of experience. I have experience to work onsite. Very good experience in Installation, configuration and maintenance of SQL Server.

Technology
SQL Server 2005/2008/2012
C# with SSIS
VB.Net
VBA
WMI

Skills
Disaster recovery planning, Mirroring, Replication, Performance Tunning, SSIS, SSRS, VB Script, WMI Script

Professional Experience:

DBA – Octobar 2011 to Present
Leading Health Care Company (Ahmedabad – India)
Responsibilities.

– Monitor and maintain health of all the servers (database and application).
– Monitor and maintain the health of databases.
– Responsible for database monitoring on production servers.
– Handling Production Server, Jobs, Server failure, Backup failure, Database Consistency, Synchronizing.
– Managed health of SQL Servers including backups, restores, monitoring.
– Creating SSIS packages and SSRS Reports for business needs.
– Monitor and maintain data replication processes such as replication, log shipping, mirroring etc.
– Monitor and maintain health of auto processes such as windows scheduled tasks, SSIS packages, SSRS Reports, SQL Jobs.
– Experience in Database backup and disaster recovery procedures.
– Good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
– Responsible for installation and configuration of SQL server 2005 and SQL Server 2008 database on Dell Servers.
– Developing SQL scripts for maintaining administration tasks.
– Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
– Database Security Management.
– Code review of database objects.
– Collect windows Performance Logs and IIS Logs to increase server health and performance.

DBA – November 2009 to August 2011
Leading Software Company (Gandhinagar- India)

– Handling Jobs, Server failure, Backup failure, Database Consistency, Synchronizing and Replication at Central Helpdesk.
– Looking after PR/CR’s at Central Desk for 30 District (Civil) Hospitals of Gujarat.
– Understand client requirement, Requirement gathering and analysis, preparation of functional requirement and system requirement specification documents.
– Analyzing and modifying MIS reports as per client requirement.
– Troubleshooting the problems occurred in Application and Database.
– Mapping client’s requirements to the requirement specification documents.
– Acting as the active link between the client and the development teams over all kinds of technical issues.
– Experienced in configuring application and testing.
– Experienced in Installation, configuration and maintenance of SQL Server.
– Solved critical production problems and performed point in time recovery plans.
– Developed Database Backup Scripts and automated this process.
– Experienced in support, applications and software development.
– Conducted root cause and analysis for database incidents and problems.

Education

Master, Computer Application (MCA), 2006 – 2009
Bachelor of Commerce (B.Com.), 2003 – 2006

Certifications

Microsoft Certified IT Professional (MCITP)
Microsoft Certified Technology Specialist (MCTS)
Oracle Certified Associate (OCP)

Regards,
Nirav Gajjar