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.
