Resume

Bhavesh Patel

Email ID:       bhavesh_183@rediffmail.com

bhavesh183@gmail.com

 

Blog:                  https://bhaveshgpatel.wordpress.com/


OBJECTIVE

 

Aspiring a challenging and motivating position as a DBA, in an organization that offers challenging tasks and enhances my career growth.


 

EDUCATION QUALIFICATION

 

Masters of Science – Information Technology, Mumbai University 2009

Bachelor of Science – Computer Science, Mumbai University

Higher Secondary Certificate, CBSE

Secondary School Certificate, CBSE


 

TECHNICAL PROFICIENCY

 SQL Server 2005, SQL Server 2005, SQL Server 2008

T-SQL, PL/SQL

C#.NET, VB.NET


 

PROFESSINAL EXPERIANCE

Bombay Stock Exchange (Marketplace Technologies), Mumbai

Oct 2010 – till date

Marketplace Technologies Pvt Ltd. (MT) is 100 percent subsidiary of Bombay Stock Exchange Limited. It one of the India’s leading software and IT services companies. MT provides Broking Solutions & Exchange Solutions to the Capital, Derivatives, Commodities & Currency Markets, Financial Services and IT Consulting to companies worldwide.

http://www.bseindia.com

www.mkttechnologies.com

SQL DBA

Responsibilities:

  • Managing all database Servers for www.bseIndia.com and www.bti-ignou.com websites.
  • Managing Clustering, Replication, Mirroring of database Servers.
  • Managing many database servers having different versions – SQL Server 2000, 2005 and 2008.
  • SQL Server production support and Development environment.
  • Installation of SQL Servers, Services Packs, Hotfixes, Patches and Updates.
  • Regular maintenance and performance-tuning of the database.
  • Managing Backup of Database, Restoration of Database.
  • Managing SQL-Server Security
  • Creating & Scheduling Jobs.
  • Creating View, Indexes, Triggers and Constraints to handle complex business rules.

Sphere InfoSolution Pvt. Ltd., Mumbai

Feb 2010 – Sep 2010

Sphere Info Solutions is an “Information Technology” company, provides end-to-end IT Services & Solutions to all our Enterprise Customers. The Company offer specialized services and solutions in Security, Disaster recovery, High Availability and Application performance tuning.

http://www.sphereinfosolutions.com

 

Posted at Mahindra & Mahindra Financial Services Limited as a MSSQL DBA.

Feb 2010 – Sep 2010

 

It is one of India’s leading non-banking finance companies. Through a vast network of branches, it provide personalised finance for the widest range of utility vehicles, tractors and cars, focusing on the rural and semi-urban sector.

http://www.mahindrafinance.com/

 

Responsibilities: 

  • SQL Server production support and Development environment.
  • Managing 10 SQL Database servers having different versions: SQL Server 2000, 2005 and 2008.
  • Monitoring all SQL Servers, check log files, system log files, alerts, database health, Index fragmentation, Log file size, slow running queries etc. – Preparing daily monitoring report for the IT Manager.
  • Creating DTS and SSIS packages as per the requirements.
  • Installation of SQL Servers, Services Packs, Hotfixes, Patches and Updates.
  • Regular maintenance and performance-tuning of the database.
  • Managing Backup of Database, Restoration of Database.
  • Managing SQL-Server Security
  • Creating & Scheduling Jobs.
  • Creating View, Indexes, Triggers and Constraints to handle complex business rules.

Achivements

 

  • Migration of main production Server from SQL Server 2000 Standard Edition to SQL Server 2008 Enterprise Edition. The 600 GB of data was involved
  • Optimized many “End of the Day” Stored Procedures, which saved around 50% execution time.

 

 

Biz Technologies Ltd., Mumbai

Junior DBA – July 2009 till Feb 2010

Biz Technologies provides IT consulting and software development services for different industries in domestic and international sector. It specializes in MLM software development and consulting with the client base of over 250 clients.

www.biztechnologies.in

www.bizmlm.in

Responsibilities:

  • Planning and designing of the Database, Tables, ER Diagrams.
  • Creating View, Indexes, Triggers and Constraints to handle complex business rules.
  • Expert in developing, modifying and optimizing complex stored procedures and functions.
  • Managing Backup of Database, Restoration of Database.
  • SQL Server 2005 production support and Development environment.
  • Installation of SQL Client on different machines and establishing connectivity with SQL Server.
  • Planning and designing of the Database, Tables, ER Diagrams.
  • Managing SQL-Server Security.
  • Creating & Scheduling Jobs.
  • Develop and monitor SSIS Packages and DTS.

 

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: