Responsibilities:

  • Perform logical and physical database design to support our customers.
  • Prepare current database structure and configuration for high-performance/high-availability through analysis and optimization.
  • Handle development escalations that require data manipulation on high volume production servers.
  • Design and build standard reports and the framework for ad-hoc reports utilizing Microsoft toolset: SQL Server, Analysis, and Reporting Services.
  • Participation in a rotating on-call schedule.

Job Requirements:

  • At least 5 years of experience developing in T-SQL and/or Oracle SQL.
  • Fluent knowledge of ANSI-SQL (all versions).
  • Experience writing stored procedures using established coding conventions.
  • Experience with optimization and troubleshooting techniques to address performance problems on SQL Server 2000 / 2005 and/or Oracle.
  • Experience in developing OLAP cubes, MDX and OLAP reporting.
  • Knowledge of statistical concepts and their application in reporting and data mart applications.
  • Proficiency with SQL Profiler, DTS packages, and other tools to manage and tune SQL Server.
  • Experience in alternate database solutions is a PLUS; Oracle a PLUS.
  • Experience working in a high availability, VLDB environment a PLUS.
  • Java coding knowledge a PLUS.
  • Excellent customer relations, technical support, and people skills.
  • Attention to detail and the ability to deliver on deadlines and perform with minimal supervision.