RAJAN PATEL (10+ Years)
- -
skype: patelrajan2000
Recent Work
Implementation of High Availability with AlwaysOn Availability Group
SSRS Dashboard Report and Business Reports
Spin Up an RDS Instance on AWS
Migration of SQL SERVER Database on AWS EC2
Profile Summary
Excellent experience in Database Server Administration
Installation & Up gradation
Backup & Recovery Planning
Managing Database and Log Files
Database Mirroring , Log Shipping , Snapshots
Performance Tuning & Migration
Configuring Linked Servers
Configuring Recovery Model
Database Replication
Managing Security & Logins
Data Transfer, Database Mail
Handing Blocking & Deadlock
Configuring Jobs & Alerts , Transferring Database
Database Protection & Availability
Implementing High Availability & Disaster Recovery
Excellent experience in Database Development
Manipulating Relational Data
Database Integrity & Optimization
Developing T-SQL DML & DDL
Query & Index Optimization
Tables, Views, Index, Constraints
Configuring & Managing Database Objects
Store Procedure, Functions, Triggers
Error Handling, Transactions, Collations, Scripts
Excellent Experience in Business Intelligence
SQL SERVER Integration Services (SSIS/DTS)
SQL SERVER Reporting Services (SSRS)
Employment History
Company
Industry
Period
Role
Sql & Server Technologies
(www.sqlserver.co.in)
Database Services
Oct 2014 – till now
Independent consultant
RecordFlow (MedNautix)
(www.recordflow.com)
Record Retrieval
June-2014-Sep 2014
Consultant IT Manager
QBS Pvt Ltd. (www.hclworkforce.com)
(www.qxltd.com)
Health Center,
Remote DBA
Feb 2011 – May 2014
Principal Database Administrator
Shakti Informatics Pvt Ltd.
(www.americallgroup.com)
Call Center,
Remote DBA
Dec 2008 – Jan 2011
Sr. Database Administrator Team Leader
Logical Software Solutions Ltd
(www.capitallegals.com)
Litigation & E-Discovery
Dec 2007 – Dec 2008
Database Administrator
Asite Solutions Ltd.
(www.Asite.com)
Construction & Supply Chain
Jun 2006 – Nov 2007
Jr. Database Administrator
As Core SQL Production DBA
Up gradation of Database from SQL Server 2000 to 2005 and 2008.
Installed & configured database software, associated database tools and performance monitoring software.
Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
Provided optimal database file layout for utilization of storage and performance acceptable to client.
Participated in meetings impacting databases physical design.
Provided appropriate access to client except system databases owners’ and Client will have access to their respective needed application schema owners.
Developed & maintained scripts, utility jobs or implement needed software for database maintenance.
Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions).
Developed & executed scripted changes requests in accordance with change control procedures.
Researched, reviewed and recommended for preventive maintenance.
As Application DBA
Involved in performance tuning, code optimization
Performed all the Database related activities such as Database Backup, Restore Operations, Troubleshooting Issues as and when occurs, Performance Tuning, monitoring error logs, jobs etc.
Involved in Logical Data and Index Partitioning using SQL Server 2005.
Designed, implemented & maintained DTS Packages
Handled data Migration from legacy systems as well other RDBMS such as MYSQL.
Involved in Fine Tuning the Procedures After studying the Processing time through SQL Trace.
Modified & created Indexes, Optimizing Indexes.
Migrated data from various sources such as MS Access, flat files etc.
As SSIS/SSRS Developer
Demonstrated expertise in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS
Proven ability in utilizing ETL tools including SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and ETL package design.
Custom ETL solutions using T-SQL stored procedures schedules as jobs.
Manage migration from Crystal Reports to SQL Server 2005 Reporting Services (SSRS)
Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS
Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS). Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
Academics
Exam
Year of Study
Master of Computer Application (MCA-
Bachelor of Computer Application (BCA-
Certificates
Microsoft Certified Technology Specialist
Microsoft Certified Information Technology Professional
Microsoft Certified Solutions Associate
Microsoft Certified Solutions Expert
https://mcp.microsoft.com/authenticate/validatemcp.aspx
Transcript ID 995278 Access Code-
BrainBench
MS SQL Server 2008 Administration
MS SQL Server 2008 Programming
http://www.brainbench.com/transcript.jsp?pid=-
ITILF ITIL Foundation Certificate in IT Service Management
http://www.itil-officialsite.com/ITILEISCRquery.aspx
Candidate No-
REFERENCES:-
-- References available on request.
Personal Details:-
5,15th August Avanue, Nr.Prithvi Hotels, Nr. L.G. Hospital Corner, Maninagar, Ahmedabad, India 380008
