California Institute of Technology - Pasadena, CA

posted 2 months ago

Full-time - Mid Level
Pasadena, CA
Educational Services

About the position

The Database Administrator (DBA) position at Caltech is a full-time role within the Information Management Services and Support (IMSS) department. This department is responsible for providing a wide range of computing support and resources across the Caltech campus, including email and calendar services, business applications, voice and data networks, information security, and digital media services. The mission of IMSS is to support Caltech by delivering robust, efficient, and secure computing services in a customer-oriented and collaborative environment. The DBA will play a crucial role in modernizing IT capabilities and solutions, focusing on database and middleware technologies for the Oracle E-business suite and its ecosystems. This position is essential for the response and recovery efforts of the campus, requiring the DBA to report to campus as soon as possible when needed. In this role, the DBA will be responsible for designing, configuring, and implementing databases, as well as establishing standards, guidelines, and procedures related to database management and ERP implementation. The DBA will maintain system integrity, security, performance, availability, and recoverability. Key responsibilities include performing critical patch management, customization, and configuration management of all Oracle EBS applications and databases. The DBA will also strategize for current and future technological developments, serve as the point of contact for database or middleware-related issues, and collaborate with technical infrastructure and application development teams to implement Oracle Databases in various environments. The ideal candidate will work independently and collaboratively, demonstrating a continuous improvement mindset and a commitment to Caltech's values of integrity, innovation, and inclusivity. The DBA will monitor database utilization, user functions, and performance metrics, analyze project requirements, and design solutions that align with business needs. Additionally, the DBA will work with storage and cybersecurity teams to establish backup policies, recovery procedures, and maintain database security policies. The role requires participation in on-call duty and providing 24x7 support when necessary, adhering to change control procedures and ensuring compliance with established policies.

Responsibilities

  • Design, configure, and implement databases.
  • Establish standards, guidelines, and procedures for database management and ERP implementation.
  • Maintain system integrity, security, performance, availability, and recoverability.
  • Perform critical patch management and configuration management for Oracle EBS applications and databases.
  • Strategize for current and future technological developments related to database and middleware technologies.
  • Serve as the point of contact for database or middleware-related issues.
  • Collaborate with technical infrastructure and application development teams to implement Oracle Databases in development, test, and production environments.
  • Monitor database utilization, user functions, and performance metrics.
  • Analyze project requirements and design solutions to ensure databases are functionally appropriate and technically valid.
  • Work with storage admins to establish and maintain backup policies and recovery procedures.
  • Implement and maintain database and system security policies in collaboration with cybersecurity teams.
  • Resolve issues with vendor support in a timely manner.
  • Perform incident and problem management and collaborate with application development and other support teams.
  • Participate in on-call duty and provide 24x7 support when required.
  • Ensure compliance with change control procedures and established policies.

Requirements

  • Bachelor's degree in computer science, information technology, or electrical engineering.
  • Minimum of 3 years of DBA experience.
  • Experience with Oracle Database Administration and/or OBIEE equivalent.
  • Experience in process automation and script development.
  • Knowledge of database administration activities including space management, backup and recovery, performance monitoring, and disaster recovery planning.
  • Experience supporting Oracle EBS and its ecosystems, including software installation, upgrade, patching, and performance tuning.
  • Ability to create and maintain processes, standards, and documentation for database activities.

Nice-to-haves

  • Experience with Linux OS and VM infrastructure.
  • Experience with Oracle's Single Sign-On, Identity and Access Management (SSO, OID, OAM).
  • Understanding of PGP, Oracle TDE, and other encryption solutions.
  • Experience in Oracle Application Express (APEX).
  • Experience with Oracle OCI, Amazon AWS, and/or other cloud providers.
  • Scripting skills with Unix shell scripts, WLST, Ansible, Python, and/or other scripting tools.

Benefits

  • Health insurance
  • Dental insurance
  • Vision insurance
  • 401(k) retirement plan
  • Paid holidays
  • Flexible scheduling
  • Professional development opportunities
  • Tuition reimbursement
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service