Job Description: Database Developer I
Job Category: Database Administration
Job Title: Database Developer I
Job Requisition: DEV7119 - CWEB
VEGAS.com is the No. 1 destination travel site in the world. Millions of people use VEGAS.com every month to plan and book their hotel rooms, show tickets, air-hotel packages and more. Join our fast-growing team and enjoy a challenging work environment, great benefits and opportunities for career development.
ESSENTIAL JOB FUNCTIONS
- Work with development team to design and implement database components of projects through the SDLC in conformance with overall corporate data architecture and predefined standards
- Act as database and SQL liaison and mentor for development team
- Work with Quality Assurance team to assist with validation of database content in support of testing activities
- Work with non technical teams to produce adhoc query requests
- Document design and implementation of database components and turn over to production operations team
The ideal candidate will have the following experience and qualifications:
- Bachelor’s degree in a business technology related field
- At least 3-5 years of experience with SQL Server 2000 / 2005
- Excellent understanding of RBDMS principles, logical and physical database design, and data normalization
- Expert-level skills in Transact SQL, including development of stored procedures and triggers
- Knowledge of techniques for analyzing query execution plans and tuning queries and databases for optimal performance
- Ability to work collaboratively with the application development team to design database components of applications
- Experience creating and maintaining essential business data flow diagrams and ERD documentation
- Experience with the following SQL Server 2005 Tools;
- SQL Server Profiler
- SQL Server Integration Services
- Database Engine Tuning Advisor
Desirable Skills:
The following skills are not absolute requirements but preference will be given to candidates with any or all of them:
- Experience developing queries against other databases, particularly Oracle
- Familiarity with ERwin or similar data modeling tools
- Experience working with or creating elements of a data warehouse or repository model
- Familiarity with version control systems and configuration management of database-related artifacts
- Familiarity with SQL Server Reporting Services (SSRS)
- Familiarity with Crystal Reports
- Strong experience in developing database processes, including extract/transform/load (ETL), using SQL Server Integration Services (SSIS)
- Experience using SQL Server Replication and/or SSIS processes to synchronize data between databases
VEGAS.com offers competitive salary and a benefits package to include: medical, dental, vision, basic life, long term disability, 401K, and an aggressive PTO plan.
If you think you have what it takes to be our next Database Developer, send your resume to jobs@vegas.com with DEV7119 - CWEB in the subject line.VEGAS.com is an Equal Opportunity Employer
