Sachin J. Profile

5.0

(1 review)

You're now following

Error following user.

This user does not allow users to follow them.

You are already following this user.

Your membership plan only allows 0 follows. Upgrade here.

Successfully unfollowed

Error unfollowing user.

You have successfully recommended

Error recommending user.

Something went wrong. Please refresh the page and try again.

Email successfully verified.

$5 USD / hour

ahmedabad,

india

$5 USD / hour

It's currently 12:34 AM here

Joined February 26, 2017

1 Recommendation

Sachin J.

@joshisam1988

5.0

(1 review)

0.0

100%

$5 USD / hour

ahmedabad,

india

$5 USD / hour

100%

Jobs Completed

100%

On Budget

100%

On Time

N/A

Repeat Hire Rate

Database Administrator and SQL Developer

• 4+ years of experience in Database Administration and development for very large and complex databases in MySQL 5x, SQL Server 2012, SQL Server 2008R2, 2008, 2005 and MongoDB. • Experience in Database Administration, design, development, maintenance and production support of relational databases, new server setup, MySQL,SQL Server installation, upgradation and migration. • Experience in Replication set up, database optimization, performance tuning, developing stored procedures, Triggers, Cursors, Joins, Views and T-SQL • Strong MySQL & SQL Server skills along with significant general system administration skills on • Experience in Disaster Recovery Planning and Security Management operations. • Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support. • 24 X 7 Production Database on Call Support. • Experience in Scrum method of Agile software development(Sprint). • Experience of Jira, SVN and Git

See all SQL Developers in India

Contact Sachin J. about your job

Portfolio

3262950

Other Project Work

Client wants to use our product for that they gave us their all catalog (eCommerce data) data into text(CVS) file, I loaded that whole catalog data into our Database based on our product database structure. I am the only person who is do this migration task. Also generated Report file of data migration process. Report contain how many records migrated and how many not migrated with reason.

Other Project Work

3262944

There are thousand of users using Ucroo at the same time, Client wants application performance not going down even if current users cross 1000 number, so we used AWS MySQL EC2 with Auto Scaling service which give better performance. Created Multi tier architecture for application. QA-Staging and Production. Used Pentaho open source ETL tool for reporting purpose. All heavy DB process handle by Store procedure and View. Written shell scripts for deployment process.

Cygnet Infotech Job Work

3262895

Managing Saas and Client hosted MySQL and SQL Servers. Provided 24x7 on-call production supports. If client face any DB related issue they issue ticket for US and we worked on that ticket. Biggest challenge was, we have to solved all issue for all client within one hour. In Db related issue we were checking slow query logs,used SQL profiler and other tools to improve the performance.

eClinicalWorks Job Work

3262950

Other Project Work

3262944

Cygnet Infotech Job Work

3262895

eClinicalWorks Job Work

Reviews

Changes saved

Showing 1 - 1 out of 1 reviews

Filter reviews by:

5.0

$10.00 CAD

mysql workbench Erd correction and add entities -- 4

perfect work awsome communication on budget and on time

SQL

MySQL

Database Administration

Database Programming

Database Development

Raman D.

@raman0001

•

7 years ago

Experience

Cygnet Infotech

Aug 2014 - Present

• Administration and management of the entire development, QA and production environment of database servers. • Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan. • Developed stored procedures, triggers in MySQL and SQL SERVER for lowering traffic between servers & clients. • Proficiency in Unix/Linux shell commands.

eClinicalWorks

Jan 2013 - Aug 2014 (1 year, 7 months)

• Work beyond regular hours based on business demands. Provided 24x7 on-call production supports.. • Performance testing of the database servers and application servers. • Troubleshooting MySQL/SQL Server in production environments. • Performed query analysis for slow and problematic queries. • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users. • Database Administrator, Database Programming.