Jay Nagar, Database Administrator

Jay Nagar

Database Administrator

Universal Software

Location
India
Education
Bachelor's degree, Computer Engineering
Experience
10 years, 7 Months

Share My Profile

Block User


Work Experience

Total years of experience :10 years, 7 Months

Database Administrator at Universal Software
  • India - Ahmedabad
  • My current job since March 2016

Manage all data using SQL and/or other relevant platform. having strong ability to write queries and generate reports as required.
Creation of T-SQL, Stored Procedures, Functions, Triggers, Indexes, and other Database objects. Analyze Query Plans to optimize SQL.
SQL Development includes writing the complex SQL queries and Stored procedure to analyze the data.
Perform database tuning and cleanse activities to ensure optimal performance.
Install, setup and cluster the Database for Clients.

Database Administrator at Fivestake
  • India - Ahmedabad
  • December 2014 to March 2016

Design and implemented Store Procedure, views, triggers and application database code objects.
Maintained all SQL Scripts, Indexes, Replication, worked on Agent Jobs, User roles & permissions and work on complex queries and optimization with SQL Profiler.
Worked on Data Conversions, Bulk insert, Worked on SSIS Packages & SSRS Reports and also worked on Agencies production database for any types of issues regarding the database.

Software Specialist at eClinicalWorks India Pvt Ltd
  • India - Ahmedabad
  • October 2013 to December 2014

Over 1 Years of experience in IT with exposure to Software Implementation, Monitoring and Maintaining database engines like Microsoft SQL Server 2008 and MySQL.
Involved in a Shared Services Delivery model, supporting multiple customer with different business requirements and strategies over same technology and managing end to end support for it including Client Management, Patch Management, SQL Server Deployment and Troubleshooting.
Exposure to leading technologies & processes likes Microsoft SQL Server 2008 R2 Administration.
Excellent Communication and Client Handling, Strong Analytical and Reasoning Skills.
Strong work ethics, Self-Motivated, passionate to learn and growth Oriented, comfortable with working in teams.
Punctual, disciplined and strong determination to learn new things accepting challenges are my strength.

Education

Bachelor's degree, Computer Engineering
  • at Gujarat Technological Univeristy
  • June 2013

Specialties & Skills

Shell Scripting
MySQL DBA
Linux Server
Linux Administration
MSSQL Administration
MySQL Administration
Shell Scripting

Languages

English
Expert
Hindi
Expert

Training and Certifications

Red Hat Certified Engineer (Certificate)
Date Attended:
August 2013
Valid Until:
August 2016
Cisco Certified Network Associate (Training)
Training Institute:
Jet King
Date Attended:
July 2013
Duration:
60 hours
Microsoft Technology Associate (Certificate)
Date Attended:
July 2013
Valid Until:
July 2015

Hobbies

  • Trading
  • Cubing
  • Chess
  • Swimming