Sr. Database Architect

Job Description

Duties & Responsibilities:

Responsible for data architecture and framework for all applications, including Enterprise Data Warehouse and Customer Relationship Management:

Develop database design & show how it will fit with our database systems.
Develop data flows & usage (internal & external systems).
Implement industry best practices regarding information security, data storage, and management.

Develop and maintain the overall data architecture and planning, including

The overall topology of the current database design (logical, physical, and Data Mart)
Complete understanding of data flows & usage (internal & external systems)

Maintains knowledge of data architecture components, recognizes when modifications must be made, and suggests new data architecture standards
Resolves data architecture problems through identification, assessment and resolution, and changes and upgrades
Provides strategic leadership into the development and implementation of the enterprise's data governance strategy.
Responsible for the overall database structure, including recovery, security, backup, and capability specifications. This definition provides a way for data architects to determine general requirements for database structure
Responsible for all activities related to data architecture/integration on all IT project initiatives.
Defines data/information architecture standards, policies, and procedures for the organization, structure, attributes, and classification of data elements, and applies accepted data content standards to technology projects.
Coordinate detailed data architecture design plans with Data Governance Board.
Propose and Implement Database Solutions

Create and propose solutions to management and stakeholders. And designing a new database and presenting it to related parties

Actively provide and promote the importance of documentation, accurate records of work performed, project tracking, and management reporting. Reviews documentation supplied by team members for accuracy and quality.
Demonstrates experience in creating and maintaining strong teamwork, working with other IT team members to implement necessary changes, upgrades and enhancements to the database systems.
Actively guide the database team members to help the team with technology adoption and strategic growth.
Assists the IT Management team in developing philosophies, strategies, and policies to support the IT mission.
Continually exploring innovation with database platforms and tools to increase productivity, improve the Guest experience, and/or enhance the organization's brand.
Support the On-Call database team for escalated priority issues, including the trouble-shooting root cause of problems, i.e., database or application issue, and determining action plan and making the judgment call on the required resource needed for resolution.

Job Requirements

Minimum Qualifications:

A degree in Computer Science or other related technical field and/or minimum equivalent experience of ten or more years working in an IT environment, with 2+ years as a Database Architect.
Advanced knowledge of SQL Server Database environment is required
Basic knowledge/experience of Azure Synapse is required, including usage of Azure Data Factory
Hands-on experience in developing and implementing data architecture and complex data models for operational and data warehouse applications
Understanding of Big Data architecture, data lake, and ETL technologies
Experience in developing conceptual, logical, and preliminary physical models for an enterprise (i.e., Enterprise Data Architecture) and solutions (i.e., Solution Data Architecture)
Excellent organizational, verbal, and writing skills and the ability to perform well under pressure.

Desired Qualifications

Experience in data lake implementation using Azure Synapse or Snowflake would be ideal.

This job description is intended to be illustrative of the position's duties and should not be construed to be an exhaustive statement of the essential functions of the job.

Return to Search

	Trouble cutting and pasting your resume into the window provided
	Copy the resume from your text document (example: MS Word) by opening/viewing the document and selecting Edit - Select All from the menu bar, then Edit, Copy. Go back to the enrollment page where you want to paste the resume. Click into the Resume text box. You will see your curser blinking in the box. Go to the menu bar at the top of the browser and select Edit, Paste. This will put the resume into the text area. View what you have pasted and make sure it is visible within the limits of the box

	Resume doesn't look like it will fit within the text box provided
	How your resume looks in the text box is not necessarily how it will look when an employer views it. Be sure to align the bullets, tabs and spacing to ensure a well-formatted view for the recruiters.

	Using HTML when formatting your resume within the text box
	Do not use HTML when submitting your resume. Your resume will be viewed by recruiters with widely varying screen dimensions, including Palm Pilots. Your resume might be converted into straight ASCII text and imported into a database or resume management software.

	Targeting your job search
	You can fine tune your job search by using specific keywords in the Keyword Search. If these keywords are in any part of a job, the search will return those jobs. Example keywords: marketing, business administration These words will result in job descriptions that include either marketing or business administration or both. Example: Business Administration These words together result in job descriptions that include both words in the order you type them in. Example: Business Administration and marketing and entry level These words result in job descriptions that include all of these words.

	Selecting more than one choice in a list box
	To select multiple choices in a drop down box, hold down the CTRL ("Control") key while clicking the options with the mouse. Use the SHIFT key if you're using a Macintosh.

	Printing your resume
	When you are reviewing your resume, click into that frame. From your browser's menu, select 'File' and 'Print - only selected frame.'

	Changing your username and password
	You will not be able to change your username or password. If you lose your password, you can click on the "Forgot Password" button next to the password box on the login page. If you have forgotten your username, you will need to register again.

	How your Job Spy work
	Routinely, your Job Spy will search the job database. If a new job has been added that contains your Job Spy criteria, that job will be emailed to you! Enter the keywords that a job should contain in the "Keyword(s)" box. Create a memorable name for your Job Spy.