Senior DBA

Oneida Innovations Group•Verona, NY

22h

About The Position

Oneida Innovations Group is seeking a Senior DBA to support database platforms for a tribally owned IT services enterprise serving complex, security-sensitive, and regulated casino gaming and hospitality environments. The role maintains database server performance, supports database design and administration, and works with users, consultants, technical teams, and vendors to guide appropriate hardware and software decisions. The position also supports database security, availability, recovery, and ongoing system enhancements, while helping prepare documentation and training materials for support staff.

Requirements

A degree in Computer Science or another related technical field, and/or equivalent experience of 3–5 years working with database management systems.
Experience with Microsoft SQL Server and Oracle database administration or database management system design and support.
Proven experience working with large databases and database performance tuning.
Knowledge of scripting languages and tools, including shell scripts.
Knowledge of database concepts such as schema design, triggers, transaction logs, stored procedures, and backups.
Knowledge of operating systems such as Windows and UNIX.
Ability to work with database, operating system, network, and hardware technologies.
Excellent organizational, verbal, and written communication skills.
Ability to perform well in a fast-paced environment and meet deadlines.
Experience handling multiple assignments.
Ability to work independently or as part of a team.
Ability to maintain confidentiality.

Nice To Haves

Experience with open-source databases such as MySQL.
Experience with iSeries DB2.

Responsibilities

Maintain database server performance and develop and follow maintenance plans to keep databases operating optimally.
Implement database designs and manage data access, table maintenance, replication, and other database-related needs.
Interface with users, consultants, technical teams, and vendors to help determine appropriate hardware and software installations.
Manage installation and customization of database platforms so personal computers can retrieve information from midrange servers and enter data.
Prepare charts, diagrams, checklists, and processes to explain database operations and train others, including Production Support Analysts and Network Technicians.
Analyze workload and system utilization trends to ensure adequate performance.
Develop and monitor security procedures to protect systems and data from physical harm, viruses, unauthorized users, and damage.
Provide backup and recovery procedures for production and test databases.
Work closely with the IT team to implement database system changes, upgrades, and enhancements, and support understanding of the philosophies and strategies aligned with the organization's mission.
Be on call 24/7.
Maintain confidentiality.