Senior DBA

Oneida Innovations Group•Town of Verona, NY

2d•$100 - $125

About The Position

Oneida Innovations Group is seeking a Senior DBA to support database systems for its IT services organization. The role maintains database performance and availability, implements and supports database designs and platforms, and helps ensure databases meet the organization’s operational and security needs. The Senior DBA works with users, consultants, technical teams, and vendors to guide hardware and software decisions, and collaborates with the IT team on system changes, upgrades, and enhancements. The position includes analyzing workload and utilization trends, maintaining security safeguards, and providing backup and recovery procedures for production and test databases. It also contributes to training materials and documentation for Production Support Analysts and Network Technicians. The role is expected to be on call 24/7 and requires maintaining confidentiality.

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 systems 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 and operating systems technologies, network technologies, 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.
Must be able to participate in 24/7 on-call coverage.
Must 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 address data access, table maintenance, replication, and other database-related issues.
Interface with users, consultants, technical teams, and vendors to 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.
Assist in preparing charts, diagrams, checklists, and processes explaining database operations and supporting training for Production Support Analysts and Network Technicians.
Analyze workload, system trends, and 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 with the IT team to implement database system changes, upgrades, and enhancements, and support understanding of the strategies needed to serve organizational missions.
Maintain confidentiality and participate in 24/7 on-call coverage.