Database Administrator (DBA)

Company: California Institute of Technology
Location: Pasadena
Posted on: March 19, 2023

Job Description:

Caltech is a world-renowned science and engineering institute that marshals some of the world's brightest minds and most innovative tools to address fundamental scientific questions. We thrive on finding and cultivating talented people who are passionate about what they do. Join us and be a part of the diverse Caltech community. Job Summary The Information Management Services and Support (IMSS) department provides a wide range of computing support and resources for the Caltech campus, including email and calendar services, business applications, voice and data networks, information security, and digital media services. Our mission, "IMSS supports Caltech by providing robust, efficient, and secure computing services in a customer-oriented and collaborative environment. Applies advanced technologies to create effective solutions, which meet the evolving needs of Caltech's research, academic, and administrative communities and cultivates and supports a talented workforce in a culture of mutual respect and professionalism." This is an Essential Reporting position. An employee designated as essential reporting has essential job skills that are needed for response and recovery and is expected to report to Campus as soon as possible. Essential Job Duties The Infrastructure and Data Services (IDS) - Business Systems Architecture (BSA) team is looking for a Database Administrator (DBA) to modernize its IT capabilities and solutions. This exciting opportunity focuses on supporting the database and middleware technologies for Oracle E-business suite and the ecosystems, as well as building out capabilities to automate support processes and optimize systems performance. The ideal candidate works independently and in collaboration with other team members in developing and supporting innovative solutions with agility and continuous improvement mindset. Candidates must exhibit Caltech values of integrity, embrace innovation, build, and operate an environment of openness and inclusion, and ensure quality in all that we do. Responsibilities include designing, configuring, and implementing databases as well as establishing standards, guidelines and procedures relating to database management and ERP implementation, maintaining system integrity, security, performance, availability, and recoverability. Additional Responsibilities: Perform critical patch management, customization and configuration management and administrations of all Oracle EBS application and databases. Apply technical expertise to strategize for current/future technological developments and serve as point of contact for database or middleware related issues. Work closely with technical infrastructure and application development teams to design, develop, and implement Oracle Databases in support of development, test, and production environments. Monitor database utilization, user functions, and performance metrics as required. Analyze project requirements and design solutions to ensure that databases are functionally appropriate, technically valid, and well-integrated in accordance with the business requirements, methods, and standards throughout the project lifecycle. Work with storage admins and relevant teams to establish and maintain backup policies and recovery procedures. Work with Cybersecurity admins and/or relevant parties to implement and maintain database and system security policies, TLS/SSL setup, access privileges, and associated account provisioning. Work with vendor support to resolve issues in an effective and timely manner. Perform incident and problem management and collaborate with Application Development and other support teams. Participate on-call duty and provide 24x7 support when required. Work according with the change control procedures and ensure compliance of change control and any other established policies and procedures. Basic Qualifications Typically requires a bachelor's degree with a minimum of 9 years of related IT experience. Substantial Oracle Database Administration expertise. Solid background in patching, administration, management and upgrade of application stacks and database of Oracle E-Business Suite. Demonstrable experience in process automation with good knowledge of script development. Proficient use of Oracle's Enterprise Management (EM13c) tool. Experience with OBIEE configuration and other Business Intelligent analytic software. Experienced in covering all facets of database administration activities including space management, backup &recovery, real-time and historical performance monitoring, proactive and reactive tuning, disaster recovery planning and execution, risk mitigation, patching, and cloning. Experienced in supporting FMW and application tier Oracle EBS as well as the ecosystems, including software installation, upgrade, patching, cloning, concurrent processing, workflow administration, performance monitoring and tuning, capacity management, troubleshooting and problem resolution. Ability to create and maintain processes, standards, and documentation for various database activities and risk control to ensure database integrity and compliance. Preferred Qualifications Good demonstrable understanding with Linux OS and VM infrastructure. Solid experience with Oracle's Single Sign-On, Identity and Access Management (SSO, OID, OAM) as well as ECC and other key E-business suite peripheral configurations. Good 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. Good scripting skills with Unix shell scripts, WLST, Ansible, Python and/or other scripting tools. Required Documents Resume

Keywords: California Institute of Technology, Pasadena , Database Administrator (DBA), Other , Pasadena, California