Xceligent Inc is a nationwide provider of information for the commercial real estate industry This information assists real estate professionals appraisers owners investors and developers that make strategic decisions to lease sell and develop commercial properties Experience in SQL Server technology Expertise in SQL Server security concepts and best practices Expertise in SQL Server disaster recovery methods Expertise in SQL Server disaster avoidance methods (eg Clustering Log Shipping Replication) Expertise in database engine performance and bottlenecks (locks blocks profiling) Expertise in TSQL Expertise in object design (Table Procedure Function Index View) Expertise in best practices for performance (partitioning physical object separation clustered indexes versus nonclustered) Expertise in Declarative Referential Integrity (DRI) Expertise in ACID properties across domain Experience in Data Integration and ETL Expertise in building data integration solutions using SSIS Expertise in Extract Transformation and Load (ETL) solutions For bulk cleansing loading of external data to internal databases For bulk and realtime loading of data from and to production databases and data marts Data Warehousing and Business Intelligence concepts and best practices Star versus Snowflake Object modeling for OLAP implementations Indexing for OLAP Data Analysis SQL for data access and analysis Modeling concepts Experience in Data Modeling DDL versus DML Data Quality Understanding of DQ concepts and familiarity with DQ tools and methods Collaboration and Presentation MS Office Suite (Word Excel PowerPoint Visio Outlook) Minimum 7+ years experience 2+ years management of technicalsupport personnel 2+ years project management 5+ years experience with Data Modeling tools Experience managing data intensive software solution projects
Dice - 11 months ago
- save job
-
block
