Description: 1. Work with users and application developers to define requirements, design and implement data models, data acquisition and data access to support transactional processing and analysis and reporting
2. Design and implement logical and physical data models for use in high-volume OLTP processing and Business Intelligence solutions
3. Define practical information architecture (ODS, DW, Data Mart) and data management solutions for ongoing data quality assurance, data replication and synchronization between MS SQL Server 2008 R2 and Oracle 10g, data sharing / reuse and high volume data processing
4. Design and implement advance ETL solutions to process terabytes of data
5. Develop complex database access solutions including complex hierarchical and multidimensional queries (including federated) to support high volume data analysis, reporting, data mining
6. Design and implement data test bed to support ongoing OLTP and analytical application and reporting testing
7. Analyze and optimize database to improve performance and availability
8. Design and implement data replication solutions to support ongoing synchronization of off-line data analysis and transactions processing
9. Design and implement DBMS optimization, archive and recovery strategy, load strategy design and implementation, data security, and change management
10. Design and implement partitioning indexing, SQL optimization and summarization solutions.

Thank you & Best Regards,Bob Dara @ Infoway!PH: 732-238-2122X212 --- dara@infowaysoftware.comJob Website - http://www.hotrecruiter.comCareer Website - http://www.consultpal.comCorporate Website - http://www.infowaysoftware.com