Must be authorized to work in the United States on a full-time basis for any employer.
Provide database architecture and administration for Oracle database environments supporting critical University business functions. Use skills and experience to work on complex technical problems by using or developing advanced concepts, with a full understanding of industry practices, campus policies and procedures.
Provide primary support for Oracle databases and applications as required by environment. Assist with architectural strategy for database environments. Create database designs and implementations that support academic and business objectives. Define efficiency improvements and implementation of database policies and procedures for data security and integrity across heterogeneous database platforms. Define, implement, and test disaster recovery and business continuity plans and technologies to ensure resilience of database services. Ensure that database performance is aligned to University business processes and usage peaks. Communicate information and issues clearly and succinctly with both technical and non-technical personnel.
Other related functions as assigned.
Extensive experience in DB architecture, design, data modeling, security, performance, monitoring, and tuning in an Oracle ERP environment typically demonstrated by 8+ years of experience. Demonstrated experience designing and implementing disaster recovery and HA configurations. Record of DB server performance tuning, DB-related component tuning, product-specific DB request tuning, database normalization, and benchmarking for multiple relational database platforms. Ability to define architectural and data model strategy for database design. Extensive SQL experience. Record of successful collaboration with software development groups. Record of identification, design and implementation of process automation with scripting tools. Project management skills and ability to lead large, complex technical projects. Record of developing project charters, timelines, deliverable, resource allocation, and task delegation. Strong verbal and written communication skills. Strong interpersonal skills. Strong orientation skills with attention to detail. Skilled at training tech staff. Demonstrated ability to work effectively, both independently and collaboratively in a team oriented environment. Equivalent combination of relevant education and experience may be substituted as appropriate.
Experience with Oracle RAC and Oracle Exadata implementation and administration. Able to design storage and network architectures to support highly complex Oracle based ERP environments for mission critical enterprise applications. Experience with support of data warehouse and data repository environments. Experience managing all aspects of ETL between multiple database environments. Authors publications or leads technical seminars as a subject matter expert in professional journals or conferences. Experience with RedHat or Oracle Linux. Graduate degree in computer science or related field.
May work around standard office conditions Repetitive use of a keyboard at a workstation Use of manual dexterity Climbing of stairs Work performed on concurrent multiple projects under pressure of rigid deadlines and/or time limitations. May require occasional extended work hours or on-call obligation.