Location
Oneida Nation Enterprises
Job Code
PR07S
Shift
Days
Travel Involved
 
Category
Information Technology
Employment Status
Full-Time

Database Administrator - SR

Job Description

About the Company

Oneida Nation Enterprises 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.

About the Role

The growth in size, complexity and diversity of the Oneida Nation Enterprises necessitates the support of an executive leader to oversee our growing needs in Data Analysis.

We are seeking a Senior Database Analyst to fulfill the following duties and responsibilities:

  • Effectively maintains database server performance.  Develops and follows proper maintenance plans to keep database running in optimal state.
  • Successfully implements database designs, data access, table maintenance, replication and other database related issues. 
  • Consistently performs and promotes interfacing with Users, Consultants, Technical Teams, and vendors for maximum guidance in determining the most appropriate type of hardware and software installations.
  • Effectively manages the installation and customization of Database platforms to allow personal computers to retrieve information from the midrange servers; as well as allowing data to be entered from the PCs.
  • Assists in the preparation of 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.
  • Analyzes workload, including system and utilization trends to ensure adequate performance.
  • Develops and monitors appropriate security procedures to safeguard systems from physical harm and viruses, authorized users, and damage to data.  Provides back-up and recovery procedures as needed for all production and test databases.
  • Consistently works closely with IT team to implement necessary changes, upgrades and enhancements to the database systems and promotes an understanding of the philosophies and strategies necessary to support the organization's missions.

Job Requirements

  • A degree in Computer Science or other related technical field: and/or a minimum of equivalent experience of 3-5 years experience working with database management systems.
  • Experienced in Microsoft SQL Server and Oracle database administration or database management systems design and support.
  • Proven experience working with large databases and database performance tuning.
  • Knowledge of scripting languages and tools (shell scripts).
  • Experience with open-source databases is a plus (e.g. MySQL).
  • Experience in iseries DB2 is a plus.
  • Must possess knowledge of database concepts such as schema design, triggers, transaction logs, stored procedures, and backups.
  • Must knowledge of Operating Systems such as Windows, UNIX.
  • Proven ability to work working with Database and Operating Systems technologies, Network Technologies, Hardware technologies, etc.
  • Excellent organizational, verbal, and written communication skills.  The ability to perform well in a fast passed environment and meet deadlines is essential.
  • Experienced handling multiple assignments is necessary.
  • Must be able to work independently or as part of a team.
  • Expected to be on call 24/7
  • Must maintain confidentiality

Become part of a growing, exciting organization that offers stability, flexibility, competitive wages, outstanding benefits including medical, dental, vision, paid time off, 401K retirement plan, flexible spending account and many additional employee discounts and amenities.

 

Employment with Oneida Nation Enterprises, LLC is contingent on passing a mandatory hair-sample drug test and a background investigation. We are an equal opportunity employer. Qualified American Indians are encouraged to apply.