Database Performance Optimisation (520572)

All Services

Programming & Development Database Design & Administration

Database Performance Optimisation

$25/hr Starting at $2K

Relational database(MySQL, Postgres, SQL Server, Oracle)

Design/Review/Modify normalised/de-normalized data models to achieve better performance
Select and apply appropriate indexes to improve query results
Leverage db engine complex features - GIS, Replication, Full-text search, ltree, sequence etc.
Look for opportunities to create views
Identify time-consuming queries, locks
Migration strategy and execution to RDS/Aurora.

NoSQL database(MongoDB, Cassandra, HDFS, Redis, Neo4J)

Appropriate DB engine selection
Data modeling
Deployment - native, cloud, hybrid
Performance optimisation

About

$25/hr Ongoing

Download Resume

Relational database(MySQL, Postgres, SQL Server, Oracle)

Design/Review/Modify normalised/de-normalized data models to achieve better performance
Select and apply appropriate indexes to improve query results
Leverage db engine complex features - GIS, Replication, Full-text search, ltree, sequence etc.
Look for opportunities to create views
Identify time-consuming queries, locks
Migration strategy and execution to RDS/Aurora.

NoSQL database(MongoDB, Cassandra, HDFS, Redis, Neo4J)

Appropriate DB engine selection
Data modeling
Deployment - native, cloud, hybrid
Performance optimisation

Skills & Expertise

Database DesignDatabase DevelopmentDesignGISGraph DatabaseJ2EEJSPMicrosoft SQL ServerModelingMongoDBMySQLOraclePostgreSQLQuery OptimizationSQLStored ProceduresXML

8 Reviews

Craig_AU says,

The project is progressing well. Thanks for all your time you have put in. Thanks for also looking outside of my requirements and suggesting ideas. Top work. Hope we can work on another project soon.

for Website Database with codes generator on Sep 29, 2009
Craig_AU says,

Great fast work, on time, for this part of the project. Thanks

for Website Database with codes generator on Sep 11, 2009
Craig_AU says,

Great work to date. First part of the project was delivered ahead of schedule. Great to work with. Thanks

for Website Database with codes generator on Sep 03, 2009
Rolf_Stenberg says,

Lalit has been great, assisting us and advising us how to proceed with our online project. I would have no problem recommending him, and we will use Lalit again on the next project.

for Adding Payment options on Aug 16, 2009
bnbBoat says,

Extra ordinary skills, Glad I found very professional person to finish my work on desired date. I wish him good luck for future. cheerz buddy

for joomla Ajax gallery and search module on May 30, 2009