Database Expert

Job Description:If you are a developer or DBA looking for a broader role or are interested in Program Management, consider joining this growing Web Analytics team. This position offers a mix of hands-on technical work with PM activities. Writing and tuning SQL queries to enable high-performance reporting and bulk data extraction Creating and troubleshooting reports using SQL Server Reporting Services Working with business stakeholders to define reporting requirements and to help them prioritize requirements given schedule and resource constraints Working with development teams, who are feeding data into databases, to ensure apps are instrumented correctly Ensuring daily processes (data loading, aggregation creation, etc.) work well, including improving monitoring and automation/scheduling to provide increased reliability at lower cost Troubleshooting instrumentation and database problems Identifying and investigating reporting optimization opportunities (e.g. better indexes, improved partitioning, clustering, scheduled aggregations, OLAP, etc.)Job Experience: 5+ years related work experience Experience with SQL Server overall, and SQL Server Analysis Services, SQL Server Integration Services (SSIS) and SQL Server Reporting Services in particular Experience with OLAP and familiarity with alternate aggregation approaches for scenarios which OLAP does not address well Experience with C# and .NET Framework programming is preferred for unusual cases where T-SQL may not be the best choice for an analytics task A working knowledge of HTTP, HTML, and ASP.NET, which will be used to diagnose website instrumentation problems and to recommend and review application-layer instrumentation solutions Experience with the unique problems of building, querying, and managing large (50M+ rows) databases Ability to identify table, index, and other schema changes needed to improve performance while balancing read and write workloads Ability to easily read a SQL Server query plan use it to optimize queries and/or database schema Good written and oral communication skills and ability to write quick, clear emails and short specifications A pragmatic approach to problem-solving which balances long-term technical direction with short-term stakeholder needs Management and performance strategies for very large databases, including partitioning, clustering, data migration/replication, backup, etc. Experience managing offshore engineering projects is a plus, though not required Bachelor's degreeMinimum Education Required: BachelorYears of Experience Required: More than 5 years For more information about career opportunities with CompuCom Excell Data visit www.excell.com. Equal Opportunity Employer