[Hiring] Senior Oracle Apps Database Administrator @EDI Staffing

Role Description

This position manages focused initiatives set forth by the Group Leader and the Information Management department. Supports all critical enterprise database management systems (DBMS) for Oracle E-Business Suite, Peoplesoft, Hyperion, Kronos, Data Warehouse, and custom applications using Oracle database, Microsoft SQL Server, MongoDB, MySQL, and technologies running in OCI (Oracle Cloud Infrastructure).

• Performs or directs all aspects of database administration for the assigned Database Management Systems, including:
  • Space management
  • Backup and recovery
  • Real-time and historical performance monitoring
  • Disaster recovery planning
  • Security planning
  • Proactive and reactive tuning
  • Capacity planning
  • Problem troubleshooting and resolution
• Performs or directs all application administration functions related to the enterprise application being supported, including:
  • Installation and upgrade
  • Performance monitoring and tuning
  • Capacity planning
  • Problem troubleshooting and resolution
• Proactively innovates and implements tailored database solutions, leads data modeling efforts, and actively contributes to all stages of database development.
• Acts as "go-to" for issues regarding the enterprise application and the underlying DBMS; consults and advises on all matters, including database requirements for ongoing and future projects; recommends hardware and software solutions.
• Works with vendor support to resolve issues in an effective and timely manner.
• Enhances own knowledge of the enterprise application and underlying DBMS platform through formal training and professional reading.
• Adheres to change control standards and policies.
• Proactive and reactive administration of the associated enterprise application as demonstrated by prevention and/or timely resolution of user issues.
• Continuous improvement in service and processes.
• Demonstrable increase in knowledge and understanding of the enterprise application and the DBMS platform.

Qualifications

• Oracle ERP e-Business Suite (EBS) - must have knowledge of Internet and Web technologies to enable databases to participate in Web-based applications.
• In-depth knowledge of:
  • Oracle database
  • Microsoft SQL Server
  • MongoDB
  • MySQL
  • Postgres
  • PL/SQL
  • Web Services – Tomcat, WebLogic
  • Microsoft Office
  • Autosys
  • Linux shell scripting
  • SVN – Version control software
  • Oracle ODI
  • OICS
  • OCI
  • Toad
• Data modeling and database design - must possess the ability to create an efficient physical database design from a logical data model.
• Backup and recovery - must be able to implement an appropriate database backup and recovery strategy based on data volatility and application availability requirements.
• Performance management and tuning - must be able to proactively monitor the database environment and optimize performance.
• Ensuring availability - must be able to ensure applications and data are up and available 24x7.
• Data security - ensure that only authorized users have access to data.
• Capacity planning - must be prepared to support more data, users, and connections.
• Extensible data type administration - must understand how user-defined data types are implemented by the DBMS vendor.
• Storage management techniques - must understand the storage hardware and software.
• SQL code reviews and walk-thru - must possess in-depth SQL knowledge to recommend changes for optimization.
• Procedural skills - must possess procedural skills to help design, debug, implement, and maintain stored procedures, triggers, and user-defined functions.
• Behavioral skills - demonstrates a people-oriented personality with proactive and collaborative traits.
• Ability to work on projects and meet deadlines with little or no supervision.
• Detail oriented and thorough, following up on issues until resolved satisfactorily.

Education & Experience

• BS Computer Science or equivalent; MS Computer Science preferred.
• 5 to 8 years' experience in most aspects of DBMS Information Management.

Travel

• 10% overall; may be significantly higher during the duration of a project.

Salary

• 130-150K