Senior Database Engineer

  • eXcell,
  • Seattle, WA
company banner
eXcell
(SSIS ) AND (SSRS ) AND (SSAS ) AND (SPARK OR KAFKA OR HIVE OR HIVEQL OR YARN OR HDFS ) AND(TSQL OR T-SQL )
Full Time
BASED ON EXPERIENCE
Work from home not available Travel not required

Job Description

Our client is the leading international travel agency network specializing in luxury and experimental travel. The invitation-only organization comprises over 800 travel agency partners with more than 16,000 elite travel advisors in over 45 countries through North America, Latin America, the Caribbean, Europe, Asia-Pacific, Africa, and the Middle East. Drawing upon its preferred relationships with the world's best hotels and resorts, cruise lines, airlines, tour companies, and premier destinations, the network provides its upscale clientele with exclusive amenities, rare experiences and privileged access.

Position Summary:

This role actively participates as a Senior Database Developer, contributing to database architecture and designing, development, implementation, review, and supporting critical production issues.

Essential Functions:
  • Work effectively with leads and product owners to define & clarify requirements, assignment priorities, perform detailed analysis, and develop robust & maintainable solutions meeting business requirements
  • Analyze, plan, develop, deploy, and manage BI infrastructure
  • Create automation SQL tests for unit, integration, regression, performance, and build verification
  • Understand and apply the advanced principles of entity relationship model design, good data typing practices, index management, data management, and data security
  • Develop ad hoc queries and reports on demand with short turnaround times as determined by business priorities
  • Research and prototype new database features, design, and architecture ahead of mainstream development
  • Proactively initiate & contribute in system improvements and innovations
  • Provide support to troubleshoot and resolve technical & performance issues in production environment
  • Review the database designs, code, and test plans of other developers and provide recommendations for improvement or optimizations
  • Perform basic database administration activities for lower and production (on demand) environments including: job monitoring, release deployment, basic configuration, process monitoring, and database backup & restore
  • Follow defined software development lifecycle best practices
  • Work effectively with management and members to clarify needs and priorities
  • Miscellaneous duties as assigned
Qualifications:
  • Master s / Bachelor's degree in Computer Science, or STEM majors, or related experience
  • 8+ years of database development experience including Data Warehouse design & development, SSIS, SSAS, and SSRS
  • 8+ years of experience in developing database in MS SQL Server utilizing stored procedures, functions, triggers, queries, etc. (or alternately 5+ years with an equivalent product such as DB2, Oracle, or MySQL)
  • Knowledge of SQL Server 2008-2017 including all latest features introduced in SQL Server 2012, 2014, 2016, & 2017
  • Strong technical and communication skills
  • Ability to think analytically, plan for future growth of systems / tools, troubleshoot, and solve database issues
  • Desire and ability to work as part of a team with minimal supervision in a results-oriented, fast-paced dynamic environment
  • Expert level knowledge of T-SQL, performance tuning, Query Plans, and Query Plan optimization for T-SQL
  • Expert level knowledge of developing complex Data Warehouses
  • Experience of developing SSIS, SSAS, SSRS solutions, and MDX & DAX queries
  • Experience working in small teams with a good mix of autonomy and accountability
  • Experience of managing and developing SQL Server, BI Suite, database custom tools using SQL Server Data Tools / Visual Studio 2013-2015 IDEs
  • Strategic and in-depth technical understanding and development experience of BI / DW architectures
  • 5+ years' experience in TFS
Preferred:
  • SQL Server 2012 / 2014 certified
  • Database architecture and designing experience
  • Travel industry experience or Ecommerce experience with CRM or online sales
  • PowerShell scripting knowledge
  • Advanced level knowledge in SQL automation unit test creation
  • Experience with B2B data integrations work, including a variety of integration modes (file transfer, web services, SSIS, etc.)
  • Experience / knowledge integrating new technologies (e.g., Hadoop) with traditional RDBMS
  • Experience / knowledge in Hadoop ecosystem: Spark, Kafka, Hive, HiveQL, Map Reduce, Yarn, HDFS, etc.

We offer a competitive salary and full benefits package, including medical / dental / life, a company matched 401(k) savings plan, and more.

W2 only, no Corp to Corp. We are unable to sponsor H1B visas at this time. **eXcell Supports Equal Employment Opportunity** eXcell , a division of CompuCom Systems, Inc., a global company headquartered in Bellevue, Washington, provides IT staffing services and solutions to Fortune 1000 companies as well as small and medium business. For more information, visit www.excell.com.

Posted By

Damon Thomas



Company Information

eXcell™ started out as Excell Data back in 1991 in Bellevue, Washington and rapidly grew as a privately held IT professional services firm. We were acquired by CompuCom in 2001. Our culture is passionate, collaborative and results-oriented. We pride ourselves on our long standing customer and associate relationships which have been the foundation of our continued success.
Dice Id : excell
Position Id : 19-00401

Similar Positions at eXcell