Oneida Innovations Group is a tribally-owned enterprise of the Oneida Indian Nation, an innovative and experienced Indian Nation owning and operating several multifaceted business enterprises, each focused on delivering exceptional customer experiences and service. We are currently seeking an Application Support Analyst to join our team at Turning Stone Resort Casino in Verona, NY - supporting IT Applications for various business units throughout the organization including Turning Stone, YBR and Point Place Casinos, Maple Leaf Markets, and Savon Convenience Stores as well as our golf courses, off-site properties, police department, and other entities.
We are currently seeking a Lead Database Administrator to join our IT/Innovation team.
Summary: The Lead Database Administrator is responsible for mentoring other DBA's in the organization and being a trusted advisor to the Database Manager. His/her role is to direct, evaluate, review, and manage database resources and services across Oneida Nation Enterprises, LLC while ensuring high levels of data quality.
Duties & Responsibilities:- Effectively oversees and is responsible for the database function; ensuring the design, maintenance and implementation of database management systems. Acts as a mentor and provides leadership to lower level Database Administrators.
- Effectively manages technical resources and personnel to ensure optimal support of database systems.
- Determines the overall design of the enterprise wide data/information architecture, which maps to the enterprise architecture and balances the need for access against security and performance requirements.
- Designs and constructs data architectures, operational data stores and data marts while focusing on enterprise wide data modeling and database design.
- 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.
- Facilitates consistent business analysis, data acquisition, access analysis and design as it applies to the enterprise data architecture.
- Supports database management systems optimization, archiving and recovery strategy, load strategy design and implementation, security and change management at the enterprise level.
- Designs, specifies, and documents database schema configurations according to Customer needs and Engineering guidelines, and will consult with outside support resources as appropriate.
- Prepares charts and diagrams to explain database operations to be used for training others in proper use; this includes checklists and processes for Production Support Analysts and Network Technicians.
- Collaborates with the management to ensure services meet the needs of the IT and organizational strategies.
- Works closely with IT team members to implement necessary changes, upgrades and enhancements to the database systems; and has understanding of the philosophies and strategies necessary to support the organization's missions.
- Analyzes workflow and assigns and/or schedules work to meet priorities and goals.
- Provides the management with information on the status and accomplishments within the database function.
- Conduct frequent meetings with database team members to review and discuss various company and departmental policies and procedures, to address problems and concerns, and as a tool in building teamwork.
- Researches and develops standards, proposals and processes to promote growth, maturity, and effectiveness of the IT Department.
Minimum Qualifications:- A Bachelor's or Master's Degree in Computer Science or Information Systems or other related technical field and/or minimum equivalent experience of 10 to 12 years of experience with large and complex database management systems.
- Experience knowledge of Database Concepts such as schema design, triggers, transaction logs, stored procedures, and backups.
- Experienced managing Database Administrator, Data Analyst, Database Application Resources and/or other technical resources.
- Experienced guiding technical resources to support high complexity projects requiring in-depth knowledge across multiple technical areas and business segments.
- Experienced determining resources support levels and assessing skill levels and conducting performance reviews on technical staff members.
- Experienced conducting technical interviews.
- Professional certifications in a related discipline desirable
- Experienced knowledge of Operating Systems, such as Microsoft, Netware, AIX, Linux, Solaris, MAC, and guides staff members as necessary.
- Excellent organizational, verbal, and written communications skills. Ability to perform well in a fast pace environment and meet deadlines is essential.
- Expected to be on call 24/7.
- Must maintain confidentiality.
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.