Database(SQL) Developer III

If you need assistance during the recruiting process due to a disability, please reach out to our Recruiting Accommodations Team through the Accommodation Request form. This form is used only by individuals with disabilities who require assistance or adjustments in applying and interviewing for a job. This form is not for inquiring about a position or the status of an application.

Database(SQL) Developer III

Are you passionate about working with data/database technologies and have a consistent track record of delivering high quality BigData solutions. As part of this team, you will be responsible for the delivery of solutions on top of the MPP databases/Hadoop platform implementation and will be playing a key role in this huge technology pivot. You will not only help train our existing staff making the leap over to our new technologies, but you will also empower the team to approach problems differently. These solutions drive business value from powering the most critical business decisions to powering how the site behaves through various avenues of personalization. This entails working with the delivery team and business partners to flush out requirements, complete solution design, development and ultimate delivery to the end consumers.

What you'll do:

• Development of high-quality database solutionsensuring performance, security, and availability of databases

• Strong understanding of distributed systems, operating systems, networking, databases, security, and analytics

• Experience developing continuous integration, continuous delivery, and continuous deployment pipelines for distributed apps

• Participating in the design and database and able to create ER diagrams, integrate with applications and reporting

• Able to write tests for SQL connectivity, data validation and for performance throughput

• Strong proficiency with SQL and its variation among popular databases

• Knowledge of best practices when dealing with relational databases

• Good understanding ofANSISQLcode and databases such as MSsqlserver, Teradata and PostgresSQL

• Creating and maintain database objects such as Tables, Views, and Stored Procedures

• Develop various facets of the Hadoop ecosystem, data processing, and Map Reduce jobs

• Develop, implement, and optimize stored procedures and functions using T-SQL

• Writing optimizedSQLQueries and help and collaborate with software engineers to integrate with data and reports

• Review and interpret ongoing business report requirements

• Analyze existing SQL queries for performance improvements, Troubleshooting and resolving database performance Issues

• Develop procedures and scripts for data migration, and data ingestion from various source systems

• Handle common database procedures such as upgrade, backup, recovery, migration, etc

• Able to write shell and python scripts

• Hands on development skills around Hadoop, Hive, and Map Reduce

• Profile server resource usage, and optimize and tweak as necessary

• Collaborate with other team members and stakeholders

• Working with Client Management, ability to take ownership and mentor the team

• Providing code mentorship to theSQLdevelopers, experience with code reviews

• Strong analytical problem-solving skills

• Experience with Agile development methodologies

• Prepare documentations and specifications

• Good ETL experience using Informatica and SSIS

• Experience working with Cloud native databases

Who you are:

• Customer service skills and excellent verbal and written communication skills

• Excellent problem solving and analytical skills

• Ability and desire to work in a rapidly changing environment and stay motivated and flexible

• Ability to work effectively with team members to resolve technical, procedural, and operational issues Education and Work Experience:

• Master's or Bachelor's degree in Computer Science, related technical field, or equivalent work experience.

• SQL Developer requirements and qualifications

• Candidate must have 5-9 years demonstrable programming experience inSQLdevelopment

• A minimum of 5 year experience in MSSQLSERVER including proficiency inSQLand stored procedures

• Excellent understanding of Microsoft SQL Server, Teradata and Oracle

• Develop, implement, and optimize queries, procedures and functions using T-SQL(DQL, DML, DDL, DCL and TCL)

• Excellent knowledge in creating objects like Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency

• Hands on experience with performance tools likeSQLProfiler, Index Tuning Wizard and Database Engine Tuning Advisor

• Experience with ETL technologies, hands on experience with developing, deploying, and monitoring packages for ETL tasks using Informatica/ SSIS DTS Import/Export Utility, BCP and DTS packages

• Excellent understanding of T-SQL programming and Teradata SQL

• Understanding PERL for any legacy code debugging, ability to write shell and python scripts
  Hands on experience using SQLServer agent jobs and logshipping for SQLServer

• Develop a test framework for database migrations to compare objects and data from source systems to target systems

• Write test cases for comparing performance throughput across Hybrid data centers, and capturing and storing the results for performance benchmarking

• Good knowledge of HTML and JavaScript

• Experience with SQL Server Reporting Services and SQL Server Analysis Services

• Familiarity with the practical application of NoSQL\NewSQL databases

• Skilled at optimizing large, complicated SQL statements

• Working knowledge of Git or any other versioning software

• Experience with working in Production Support, ability to resolve L2 & L3 incidents, CRs and enhancements.

• Excellent Knowledge in query optimization & performance tuning

• BS/MS degree in Computer Science, Engineering or a related subject

About Expedia Group

Expedia Group (NASDAQ: EXPE) powers travel for everyone, everywhere through our global platform. Driven by the core belief that travel is a force for good, we help people experience the world in new ways and build lasting connections. We provide industry-leading technology solutions to fuel partner growth and success, while facilitating memorable experiences for travelers. Expedia Group's family of brands includes: Brand Expedia®, Hotels.com®, Expedia® Partner Solutions, Vrbo®, trivago®, Orbitz®, Travelocity®, Hotwire®, Wotif®, ebookers®, CheapTickets®, Expedia Group™ Media Solutions, Expedia Local Expert®, CarRentals.com™, and Expedia Cruises™.

© 2021 Expedia, Inc. All rights reserved. Trademarks and logos are the property of their respective owners. CST: 2029030-50

Employment opportunities and job offers at Expedia Group will always come from Expedia Group’s Talent Acquisition and hiring teams. Never provide sensitive, personal information to someone unless you’re confident who the recipient is. Expedia Group does not extend job offers via email or any other messaging tools to individuals to whom we have not made prior contact. Our email domain is @expediagroup.com. The official website to find and apply for job openings at Expedia Group is careers.expediagroup.com/jobs.

Expedia iscommittedto creating an inclusive workenvironmentwith a diverse workforce. All qualified applicants will receive consideration for employment without regard to race, religion, gender, sexual orientation, national origin, disability or age.