Database Administration Lead

Oneida Innovations Group•Town of Verona, NY

101d•Onsite

About The Position

Oneida Innovations Group is seeking a Lead Database Administrator to join their IT/Innovation team. This role involves mentoring other DBAs, acting as a trusted advisor to the Database Manager, and managing database resources and services across Oneida Nation Enterprises, LLC to ensure high data quality. The position is responsible for the overall design of the enterprise-wide data/information architecture, including data modeling, database design, and establishing data standards, policies, and procedures. The Lead DBA will also oversee database optimization, archiving, recovery, load strategies, security, and change management, and will design and document database schema configurations. This role includes preparing training materials, collaborating with management on IT and organizational strategies, implementing changes to database systems, analyzing workflows, assigning tasks, and reporting on the status of the database function. Regular meetings with the database team are expected to discuss policies, address concerns, and build teamwork. The role also involves researching and developing standards and processes for IT department growth.

Requirements

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.
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.

Nice To Haves

Professional certifications in a related discipline desirable

Responsibilities

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.
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.