Senior DBA

Oneida Innovations Group; Town of Verona (NY); On-site; USD 110,000 - 160,000; Full time

Benefits offered by this job

Health Insurance

Dental and Vision

PTO/Sick Leave

401K with up to 5% match

Job summary

Oneida Innovations Group is seeking a Senior Database Administrator to join our team in New York. The role focuses on maintaining high-performance database servers, implementing designs, and ensuring security and recovery procedures in a regulated environment.

You will collaborate across IT teams to optimize hardware and software installations, manage backups, and support critical production and test databases.

Qualifications

• A degree in Computer Science or related field or equivalent experience (3–5 years) with databases.
• Experienced in Microsoft SQL Server and Oracle database administration or design/support.
• Proven experience with large databases and performance tuning.
• Scripting knowledge (shell scripts).
• Experience with open-source databases is a plus (MySQL).
• Knowledge of DB2 iseries is a plus.
• Strong concepts of schema design, triggers, logs, stored procedures, backups.
• Windows and UNIX operating systems proficiency.

Responsibilities

• Maintain database server performance and follow maintenance plans.
• Implement designs, data access, replication, and related tasks.
• Collaborate with Users, Consultants, and Tech Teams for hardware/software decisions.
• Manage installation and customization of database platforms for data access.
• Prepare charts/diagrams to explain operations and train staff.
• Analyze workload and trends to ensure adequate performance.
• Develop and monitor security, backup, and recovery procedures.
• Work with IT team on changes, upgrades, and enhancements.

Skills

Database administration

SQL Server

Oracle DB

Performance tuning

Scripting (shell)

Windows/UNIX

On-call readiness

Education

Degree in Computer Science or related field

Tools

SQL Server

Oracle

MySQL

DB2 (iseries)

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.