Position Summary
Costco Travel is seeking a creative, team-oriented, and motivated Database Administrator to be responsible for the successful administration and growth of the Data Warehouse and Tableau environments at Costco Travel.

The position will include daily administration of all operational and functional aspects of the Data Warehouse environment at Costco Travel. The Database Administrator will have a background in practical Data Warehousing concepts and architecture (dimensions, facts, star schemas, aggregates, etc.), create code for design specs, database and ETL performance tuning, implementing ETL processes with SSIS, and support production and development databases.

The operations and maintenance of the Tableau Server application, includes but is not limited to setup of user/group, permissions, configuration of trusted authentication, projects, workbooks, views and data sources; permissions, security, and metadata management; Tableau Server application development, including visualizations, parameters and report optimization; knowledge in Tableau Server report performance optimization; thorough understanding of data warehousing concepts, designing and developing enterprise reporting solutions.

Job Duties/Essential Functions
  • Analyzes and address code issues and inefficiencies in production related to potential blocking, timeouts and deadlocks.
  • Works with DBAs to establish routine maintenance, monitoring, alerting, collecting metrics to proactively identify database related issues, and keeps all databases highly available and highly responsive at all times.
  • Supports the data warehousing team with their design and development of the data warehouse, ETL processes, Business Intelligence, and analytics efforts.
  • Deploys code onto Production Data Warehouse systems.
  • Creates documentation of systems, processes, troubleshooting steps, etc.
  • Data Warehouse capacity planning.
  • Diagnoses and resolves database and data warehouse configurations, access and performance issues.
  • Monitors and troubleshoot development, testing, staging and production servers for performance, configuration and resource issues.
  • Designs, develops, monitors and maintains backup/recovery strategies for development, testing, staging and production databases.
  • Develops and maintain support utilities, scripts and tools.
  • Follows security practices and identify areas and processes where security can be improved. Suggest recommendations for improvement where applicable.
  • Participates in a scheduled On-Call rotation, and occasional weekend and off-hours work as necessary.
  • Regular and reliable workplace attendance at your assigned location.
 Non-Essential Functions
  • Assists in other areas of the department as necessary.
  • Assists in other areas of the company as necessary.
 Ability to operate computer, phone, printer, copier.
 
Experience, skills, education & licenses/certifications
Required:
  • 5+ years’ of MS SQL Database Administration experience.
  • 5+ years’ of experience in dimensional data modeling, ETL development, and Data Warehousing.
  • 3+ years’ of database design & architecture following best practices in an OLTP environment.
  • 1+ years’ of Tableau software configuration and administration.
  • Experience with data warehousing principles, architecture and its implementation in large environments.
  • Bachelor’s degree in Computer Science or related field.
 Recommended:
  • Understanding of Data Warehouse design practices, including database normalization concepts.
  • Demonstrated experience in troubleshooting and resolving database problems.
  • Experience with systems that maintain 24/7 availability.
  • Strong technical planning and analysis skills.
  • Excellent written and oral communication skills.
  • Team oriented and capable of working and effectively communicating with both business and technical teams.
  • Able to easily shift focus with changing priorities.
  • Ability to work both independently and within a close team environment.
  • Must be motivated and a quick learner capable of multi-tasking.
  • Familiarity or experience with the travel industry a plus.
 
Other Conditions
  • Management will review the Job Analysis for this position prior to a job offer.

Department: Information Technology
This is a full time position

Subscribe to be notified of new jobs

Personal Information









Attachments

Other Information