Database Manager

Thisiscny; Town of Verona (NY); On-site; USD 120,000 - 180,000; Full time

Job summary

Oneida Innovations Group is seeking a Database Manager to lead the database team and shape the data architecture across our hospitality, gaming, enterprise, retail and service brands in the United States. This direct hire role requires deep expertise in data modeling, data governance and enterprise data warehouse environments, with a focus on reliability and security.

You will oversee design, implementation, and maintenance of data structures, ensure data flows between internal and external

Qualifications

• Degree in Computer Science or related field, or 10+ years IT experience.
• 10+ years IT experience with 2+ years as Data Architect.
• One year leadership experience is a plus.
• Experience in developing data architecture for operational and data warehouse apps.
• Knowledge of big data, data lake and ETL technologies.
• Excellent organizational, verbal and writing skills.

Responsibilities

• Leads data architecture planning and data flows for enterprise systems.
• Develops database design aligned with overall structure.
• Maintains data governance and architecture standards.
• Resolves data architecture issues through assessment and upgrades.
• Provides strategic leadership on enterprise data governance strategy.
• On-call support for responsible systems as needed.

Skills

Data architecture

Leadership

Data modeling

Team training

Strategic planning

Education

Bachelor's degree in Computer Science or related field

Tools

SQL

ETL tools

Enterprise Data Warehouse

Job description

Oneida Innovations Group is a diverse organization comprised of hospitality, gaming, enterprise, retail and service brands. We offer guests, partners and team members alike a sense of community. We're a trusted name that signals quality, consistency, superior service and exceptional experiences. Everything we do is in the interest of enriching the lives of customers and employees, investing in and growing the economy and local communities, and securing prosperity for future Oneida generations.

We are currently seeking a Direct Hire (W2 Only, no C2C or Sponsorship available) Database Manager to lead our team.

Duties & Responsibilities

• Effectively plans, schedules, and assigns work to all Database team members; consistently monitoring the overall function of the team. Ensures proper training of staff.
• Responsible for data architecture and framework for specific all applications including Enterprise Data Warehouse:
• Develop database design & show how it will fit with our database structure
• Develop data flows & usage (internal & external systems)
• Develop and maintain the overall data architecture and planning, including
• 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 overall 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 provided by team members for accuracy and quality.
• Demonstrates experience in creating and maintaining strong teamwork ethic relationships, working with other IT team members to implement necessary changes, upgrades and enhancements to the systems.
• Assists the Director of Infrastructure Engineering in the development of philosophies, strategies and policies to support the IT mission.
• Mandatory 24/7 on-call support for responsible systems, this includes trouble-shooting root cause of issues, i.e. database or application issue, and determining action plan and making judgment call on required resource needed for resolution, i.e. Microsoft support, Applications Support, etc. Off-hours support is handled remotely, however judgment call is required to determine when it is necessary to be on-site, as well as, escalating issue to executive management.

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 Data Architect.
• One year of leadership experience in IT environment a plus.
• 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

• Experienced managing technical resources including Data Architects, Data Quality Specialists and Database Administrators.

Oneida Innovations Group is an equal opportunity employer and will consider all qualified applicants for employment without regard to race, color, religion, sex, national origin, age, disability, marital status, veteran status, sexual orientation, gender identity, genetic information or any other protected characteristic under applicable law.