Senior DBA

Oneida Indian Nation/Turning Stone Casino; Town of Verona (NY); On-site; USD 90,000 - 125,000; Full time

Benefits offered by this job

Health Insurance

Dental

Vision

PTO/Sick Leave

401K with up to 5% match

Job summary

Oneida Innovations Group is seeking a Senior DBA to join our IT team in New York. You will maintain database performance, implement designs, and support high-availability in a regulated hospitality environment.

You will collaborate with users, vendors, and technical teams, manage security, backups, and recovery, and contribute to ongoing upgrades to meet operational needs.

Qualifications

• A degree in Computer Science or related field and/or 3-5 years of DBMS experience.
• Experience with Microsoft SQL Server and Oracle DB administration.
• Proven experience with large databases and performance tuning.
• Knowledge of scripting languages and shell scripts.
• Experience with open-source databases (e.g., MySQL).
• Experience in ISeries DB2 is a plus.
• Knowledge of schema design, triggers, transaction logs, stored procedures, and backups.
• Operating systems knowledge: Windows and UNIX.
• Ability to work with DB, OS, networks, hardware, etc.
• Excellent communication and ability to work in a fast-paced environment and meet deadlines.
• Experience handling multiple assignments; able to work independently or in a team.
• On-call 24/7.
• Must maintain confidentiality.

Responsibilities

• Maintains database server performance and follows maintenance plans.
• Implements database designs, data access, replication and related issues.
• Interfaces with users, consultants, and vendors for guidance on hardware/software installations.
• Manages installation and customization of database platforms for PCs and servers.
• Assists in preparing charts/diagrams to explain database operations for training.
• Analyzes workload and utilization trends to ensure performance.
• Develops security procedures and back-up/recovery for production and test databases.
• Collaborates with IT to implement upgrades and enhancements to database systems.

Skills

On-call 24/7

Team collaboration

Fast-paced environment

Multitasking

Education

Bachelor's in Computer Science or related field

3-5 years DBMS experience

Tools

MS SQL Server

Oracle

MySQL

ISeries DB2

Job description

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.

Many IT services companies approach cyber solutions from a technological standpoint. Our coming of age in the casino gaming and hospitality industry - complex security and regulated environments - supporting New York's most awarded resort and casino means our approach is not only sophisticated, but also highly customer-centric.

We don't just take care of problems. We seek out ways to anticipate and prevent them. We don't just improve connectivity. We constantly strive to make connecting safer and in doing so, more accessible. And we do so as IT professionals, as trusted allies and as partners in your success.

Come join our team as we are currently seeking a Senior DBA to join our group!

Duties & Responsibilities

• Effectively maintains database server performance. Develops and follows proper maintenance plans to keep the database running in an 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 system 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 organizations' missions.

Minimum Qualifications

• A degree in Computer Science or another 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 communications skills. Ability to perform well in a fast passed environment and meeting 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

Oneida Innovations Group offers exceptional benefits to include Health Insurance, Dental and Vision as well as PTO/Sick Leave availble upon hire and a 401K option with up to a 5% match!

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.