Database\'Data Architect


Position Overview


As a key member of the Data Management & Analytics (DMA) organization, the database\'data architect will be responsible for day-to-day technical support\'maintenance of our current database systems, as well as working on projects related to additional data systems, or data products. Also responsible for defining our database and data architecture moving forward including creating and championing policies and standards.


This role will work closely with internal customers, other DMA members, and report to Manager of Data Management & Analytics.






This is a fully remote position


Responsibilities

• 
  Database administration
  • including encryption, security, and high availability
  • Disaster recovery plans
  • Setup new prod and non-prod databases as required
  • Data/database security reviews
  • Approve the deployment of new indexes
• Database architecture
  • including encryption, security, and high availability
  • Documentation of environment
• Asset manager for SQL Server, DQS, MDS, SSIS, Data Cloud Factory, and Azure data options
  • Research industry best practices
  • Define and document standards, and policies, including for: usage, installation, configuration, preventative maintenance, monitoring, disaster recovery, and high availability
• Data architecture
  • Including best practices and standards
  • Oversight on any database/data projects
  • Oversight of DW design and development
• Manage internal architecture initiatives\'projects
• Informal research into data\'database tools, frameworks, and architectures
• Formal extensive research\'evaluation of data\'database tools, frameworks, and architectures
• Enforce data\'database standards and policies with other teams via manager\'lead
• Meet with external parties to determine technical architecture requirements for project initiatives involving data/database area.

• Support of team members with advanced SQL performance tuning and troubleshooting
• Help rest of data/database team with workload as much as possible, for example
  • Database development
  • SSIS development

Basic Qualifications

• 
  Minimum 10 years of experience in database and data warehouse development
• Minimum 5 years of SQL Server database administration
• Technical Skills
  • SQL
    • SQL query skills
    • T-SQL development
      • Stored procedures
      • Udfs
      • Triggers
    • performance tuning
    • trouble shooting
  • OLTP systems design and development
    • Relation data modeling (ERD)
    • Logical database design
    • physical database design, including knowledge of indexing
    • SQL for implementation of physical database design in OLTP database objects
      • Tables
      • Views
      • Indexes
  • Data warehouse design and development
    • Dimensional data modeling
    • Knowledge of data warehouse design principles
    • Knowledge of table\'view partitioning and indexed views
    • DW physical database design, including knowledge of indexing\'partitioning
    • SQL for implementation of physical database design in DW databases
      • Tables
      • Views
      • Indexes \xe2\x80\x93 including column store indexes
      • Partitions
  • Advanced knowledge of SQL Server Engine architecture
    • Installation best practices
    • Configuration best practices
    • Pre-emptive maintenance and monitoring
    • Disaster recovery
    • High availability
  • Advanced knowledge of SQL Server additional services architecture
    • SQL Server Integration Services
    • SQL Server Analysis Services
    • SQL Server Reporting Services
    • Master Data Services
• Personal Skills
  • Business Analysis
  • Basic project management skills
  • Mentorship\'Training
  • Research\'evaluation
  • Architectural diagrams\'documentation

Preferred Qualifications

• 
  Degree in business, computer science, or engineering or a related discipline
• Minimum of two years of database architecture experience
• Minimum of two years of data architecture experience
• Experience with SQL Server 2019 and Azure SQL database
• Technical skills
  • Master data services (MDS)
    • Installation
    • support and setup experience
    • design and configuration experience
    • development experience via staging
  • ETL
    • Advanced SSIS development \xe2\x80\x93 including enterprise SSIS features for DW ETL
    • Advanced Cloud Data Factory development
    • Data quality service (DQS) design and configuration
  • BI
    • Understanding of BI Semantic Models \xe2\x80\x93 SSAS and Power BI
    • Solid understanding of BI concepts

This is not necessarily an exhaustive list of responsibilities, skills, duties, requirements, or efforts associated with the position.

Direct Travel is an EOE/AA/Veteran/People with Disabilities employer.
About Direct Travel
Our growing company relies on excellence to deliver on our commitments to our customers. This starts with our employees. Our inclusive culture encourages entrepreneurial spirit empowering employees to build strong, long-lasting relationships with our clients and deliver innovative solutions. Direct Travel is one of the most respected Travel Management Companies in the industry providing our customers with smart consultation, tailored solutions and a true partnership. Our specific focus on the mid-market means our travel experts deliver personalized service to every client.
Additionally, Direct Travel offers full-service performance improvement solutions, including meeting and event management, group incentive travel and individual recognition solutions through its wholly owned subsidiary Creative Group, Inc. An industry leader, Creative Group has been honored with the CMI 25 Award, which recognizes the top 25 most influential meeting and incentive management companies in the US each year since the award\xe2\x80\x99s inception in 2007. The company is headquartered in Schaumburg, Illinois and maintains offices in Detroit, Appleton, San Francisco and Toronto. For more information about Creative Group, please visit www.creativegroupinc.com.
Together we will help our clients Navigate Their Way and Create Truly Moving Experiences. For more information, visit www.dt.com. Follow us on Twitter, YouTube and LinkedIn.