Software Engineer Ii, Database

Company: Virtuoso, Ltd.
Location: Kennewick
Posted on: January 24, 2023

Job Description:

Virtuoso - is the leading global travel agency network specializing in luxury and experiential travel. This by-invitation-only organization comprises over 1,200 travel agency locations with 20,000 travel advisors in 50 countries throughout North America, Latin America, the Caribbean, Europe, Asia-Pacific, Africa and the Middle East. Drawing upon its preferred relationships with more than 2,200 of 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. Normalized annual sales of (U.S.) $25-$30 billion make Virtuoso a powerhouse in the luxury travel industry. For more information, visit www.Virtuoso.Com.The Software Engineer II, Database actively contributes to Relational database and Azure Data pipeline & data platform development, design, architecture, review, enhancing & creating new features within Virtuoso's marketing and reporting platform, and supporting critical production issues.Essential duties and responsibilities include the following. Other duties may be assigned.Work effectively with team and product owners to define & clarify requirements, perform detailed analysis, and develop robust & maintainable solutions meeting business requirementsAnalyze, plan, develop, deploy, and manage a large scalable distributed relational database system.Create automation SQL tests for unit, integration, regression, performance, and build verificationUnderstand and apply the advanced principles of entity-relationship model design, good data typing practices, index management, data management, and data security.Write a reliable and maintainable code at each layer of product development.Research and prototype new product & database features, design, and architecture ahead of mainstream development.Proactively initiate & contribute to system improvements and innovations.Provide support to troubleshoot and resolve technical & performance issues in aproduction environment.Review designs, code, and test plans of other developers and provide recommendations for improvement or optimizations.Build and support Microservice and Stateless architecture.Follow defined software development lifecycle best practices.Work effectively with management and members to clarify needs and priorities.Educational and Skills Requirements:Bachelor's degree in Computer Science, Engineering, or equivalent work experience8+ years of SQL Server database development and design experienceExpert-level knowledge of SQL, TSQL, performance tuning, Query Plans, and Query Plan optimization for TSQLExpert level development knowledge in SQL Server 2008-2016 including all the latest features introduced in SQL Server 2014, 2016 & 2019Advance-level knowledge of developing complex Data WarehousesAdvance-level knowledge of CI/CD using Azure DevOps to support Data Platform & Microservice projectsDevelopment experience of Snowflake cloud computing data warehouseIntermediate-level knowledge of developing solutions using C#/Python, and REST APIExperience in developing a relational & non-relational data platform/data pipeline using Azure cloud solutionsDemonstrated experience in working with at least one scripting language such as PowerShell, Perl, Python, Ruby, etc. with the intent to automate manual tasks (monitoring, deployments, testing, etc.)Strong technical and communication skillsDesire and ability to work as part of a team with minimal supervision in a results-oriented, fast-paced, dynamic environmentExperience in managing and developing SQL Server, BI Suite, and database custom tools using SQL Server Data Tools/Visual Studio 2015-2019 IDE'sAdvanced-level experience in Azure DevOps/GIT repositoryPreferred:Database architecture and designing experience.Travel industry experience; or Ecommerce experiencewith CRM or online sales.PowerShell scripting knowledge.Advance level knowledge in automation test creation.Experience/Knowledge integrating new technologies (e.G., Hadoop) with traditional RDBMSExperience/Knowledge in the Hadoop ecosystem: Spark, Kafka, Hive, HiveQL, Map Reduce, Yarn, HDFS, etc...Travel Requirements:Travel is rarely required for this position. (0-1 trips per year)Any travel will be entirely domestic.Type/Nature of Contacts:Internal: Key job contacts are primarily with clerical and technical personnel outside of the job's immediate work unit/department.External: There is almost no contact outside of Virtuoso staff. Position is primarily internal facing.We offer a competitive salary and full benefits package, including medical/dental/vision/life, 401(k) savings plan, and more. Virtuoso is an equal opportunity employer, dedicated to promoting a diverse workforce.

Keywords: Virtuoso, Ltd., Kennewick , Software Engineer Ii, Database, IT / Software / Systems , Kennewick, Washington