Senior Database Administrator - IT Solutions

Senior Database Administrator

The Senior Database Administrator is responsible for managing and supporting university-wide ERP application, file and database systems including the performance, integrity and security of those systems. In this role they are involved in installing, upgrading, cloning, and patching of ERP applications. They will plan and develop database architecture, logical and physical design, automation, documentation, installations, shell scripting, backup and recovery concepts, as well as the troubleshooting of any database performance or data integrity issues.

As a member of the IT Solutions (ITS) team, the Senior Database Administrator is expected to uphold the division's mission to "empower an agile, digital university and elevate technology as a strategic institutional asset" and contribute positively to a collaborative, human-centered, innovative, accountable, transparent, and inclusive culture within ITS.

Reports to:

Manager, Data Warehouse & Integrations
Supervises:
No supervisory responsibilities

• Designs, develops, implements and clones Oracle file systems, application servers, and databases.
• Monitors and maintains maximum performance of databases and applications, including Oracle configuration and change controls, components, concurrent requests, system alerts and metrics.
• Administers and troubleshoots Oracle database, including patching (security, critical, service patching), SQL tuning, capacity planning, and schema design.
• Develops, manages, and tests back‑up and restoration plans as well as disaster recovery plans.
• Maintains proper configuration management and change controls for database, applications, and file systems.
• Actively contributes to the creation, development, and maintenance of technical documentation, data standards, procedures and definitions for a university data dictionary.
• Supports developers with SQL tuning, indexing, partitioning approach to achieve read/write efficiency.
• Develops administration automation and monitoring scripts as needed.
• Creates alert and diagnostic monitoring.
• Supports the organization as needed in a transition from on‑premise database systems to cloud database systems.
• Assumes the additional tasks and skills as needed to support a cloud‑based data warehouse, business intelligence, or analytics system.
• Partners with ITS security to design access permissions and privilege controls.
• Performs off‑hours production support, as needed.

• Develops an in‑depth understanding of the university's ERP systems & databases.
• Leads and/or participates in design, implementation, and assessment of database‑related initiatives and projects, as assigned.
• Researches, recommends, and pilots innovations in database technology.
• Takes a lead role in documenting systems and common support procedures and encourages and facilitates cross‑training.
• Stays current with emerging trends and advances in database administration that may have relevance to the university's evolving needs and goals. Proactively educates other team members on findings and new insights.
• Continuously evaluates internal processes, procedures, practices, and standards and proactively proposes changes to bring greater efficiencies.
• Mentors other database administrators and developers in their area.

• Maintains awareness of current practices and future trends in database technologies, administration, and best practices.
• Represents IT Solutions and participate in the campus community by serving on working groups, project teams, and university committees.
• Performs other duties as requested.

Bachelor's degree required. Additional job‑related experience may substitute for the required education on a year‑for‑year basis.

Seven years of relevant experience in database development and/or administration. Additional job‑related education may substitute for the required experience on a year‑for‑year basis.

Regular and reliable attendance at the University during regular scheduled days and work hours is an essential…