Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

David Lim | Elance
 
176985602337900
Last Sign-in: Nov 11, 2014

David Lim

Senior Database Developer
   Philippines
  |   Batangas City, Batangas
  |  9:44 am Local Time

Overview

Highly motivated, dedicated and detail-oriented IT professional with 5.5 years of solid experience in database design, development and optimization.
Well-versed in T-SQL programming including writing complex queries, derived tables, common table expressions, aggregate functions, window functions, table variables, temporary tables, stored procedures, functions, indexed views, triggers, constraints, linked servers, indexes, execution plans, transactions, isolation levels and minimizing deadlocks.
Experience in creating and deploying...

Read More »

Portfolio

Skills (10)

Tested
SQL Server
Windows Azure SQL Database
SQL Server Reporting Services
SQL Server Integration Services
T-SQL
XML
Database Design
Database Development
Query Optimization

Service Description

Responsible for the overall database work of Regulatory Information Management.
Analyze business requirements and perform logical and physical data modeling.
Design, develop and maintain database objects such as tables, views, stored procedures, functions, triggers, indexes, constraints and advanced SQL queries.
Analyze query execution plans and apply the necessary performance tuning techniques and indexing strategies to speed up the system.
Design, develop and deploy RDL reports in SSRS.
Create and maintain SSIS packages to migrate data between each releases.
Code C# classes, interfaces, properties, methods efficiently.
Organized Entity-Relationship Diagram to document the structure of database and the type of relationship between each information stores.
Troubleshoot all kinds of software/database related issues.
Provide a demo showcasing new features and enhancements to Product Owner.
Work and collaborate closely with project team and provide support to software developers, testers and project manager.

Read More »

Employment

Fifth Leg Data Production Inc.
Database Development/DBA
2014 - Present
Responsible for the database work of Global Horse Racing and Soccer projects. The database contains more than 250 GB of data for each project. Resolve issues escalated by QA, Level 1/Level 2...
Virtify Philippines Inc.
Senior Software Engineer
2012 - 2014
Responsible for the overall database work of Regulatory Information Management. Analyze business requirements and perform logical and physical data modeling. Design, develop and maintain...
Virtify Philippines Inc.
Software Engineer
2009 - 2012
Responsible for end-to-end database development of an International Regulatory Information System: from user requirements, through design and development, into UAT, and release. Contribute to...

Education

Lyceum of the Philippines University - Batangas
Bachelor of Science in Computer Science
2005 - 2009
Overview  |  Job History  |  Portfolio  |  Resume/C.V.

Keywords

Microsoft SQL Server 2005/2008/2008 R2/2012
SSRS
SSIS
T-SQL
Stored Procedures
Database Design and Development
Performance Tuning
XML
HTML
C#
My Snapshot
All Categories
Elance Level
Level represents activity and experience on Elance. Freelancers start at Level 1 and achieve higher levels through their work. A higher "Level" indicates greater earnings, ratings and other achievements on Elance. Learn More »
  • 12 months
  • Lifetime
Jobs
0
0
0
Total
Milestones
Hours
Reviews
Recommend
Clients
Total
Repeat
Earnings
Total
Per Client
Identity
Username
davdidson_5262
Type
Individual
Member Since
May 2014
Elance URL
Verifications
0
David Lim | Elance

David Lim