Project details

Description







Skills:
- Create conceptual, logical and physical data models (Entity-relationship and/or UML)
- Model data warehouse structure, and define ETLs
- Optimize transactional and reporting databases and queries for performance
- Proficiency in MS-SQL Server required
- Setup and troubleshoot DB connectivity
- Generate DDL scripts
- Create stored procedures, functions, triggers, user-defined data types, etc. for performing CRUD operations
- Ability to identify performance
- Audit trail and historical storage
- Define and implement policies for data retention and backups
- Experience working with partitions, temporary tables and materialized views
- Experience in handling CLOB/BLOB data
- Experience working with persistence frameworks such as Hibernate, Spring, MyBatis is desired
- Experience creating data flow diagrams (DFDs) will be a plus

Client info

Microsoft SQL Server DB Architect and SQL Developer
de***ea
The client's account will appear to you if he contacts you

Required skills

Project summary

Budget
$0.00 – $0.00
Budget type
Fixed price
Bids
0
Avg bid
$0.00
Status
Completed
Clicks
0
Impressions
0
Posted date
4 years ago