Job Information
Stanford University EDW Applications Database Administrator in Stanford, California
EDW Applications Database Administrator
Business Affairs: University IT (UIT), Redwood City, California, United States
Information Technology Services
Post Date Jul 30, 2024
Requisition # 104084
Job Purpose
Stanford’s central IT organization is looking for an experienced Database Administrator with Oracle Analytics Server and Informatica PowerCenter experience to join the Enterprise Technology team to support the implementation, maintenance, and upkeep of multiple data warehouse systems.
This position will provide technical expertise in the setup, configuration, administration, and maintenance of Oracle database , Oracle Analytics Server and Informatica PowerCenter that support mission-critical projects, processes, and activities. The position monitors and tunes applications to optimal performance and ensures proper security, integrity, and recovery of data. This role is responsible for upgrades and patches to the infrastructure components of the Data Analytics and Reporting ecosystems. Components will include Oracle database, Oracle Analytics/WebLogic Servers, web servers, replication servers, Application Express(Apex) and ORDS.
Administration of Oracle Database, Goldengate, Oracle Analytics Server, WebLogic, Informatica Power center, Apache, Tomcat, Apex, ORDS
CORE DUTIES
Install, configure, and support relational database management systems (RDBMS) with Oracle Data guard.
Oversee and manage a complex WebLogic and Oracle Fusion Middleware environments, encompassing installation and configuration.
Hands on experience or knowledge in administering Oracle Analytics Service (OBIEE) administration, Informatica PowerCenter
Install, configure and troubleshoot replication with Goldengate
Troubleshoot application deployment and runtime issues, ensuring minimal downtime and smooth operation.
Utilize Python and Shell scripting to automate routine database tasks and maintenance.
Strong working knowledge in Linux based systems are a must.
Secure applications using Secure Socket Layer, Single Sign On setups. Scan and fix vulnerabilities using Qualys
Provide on-going system administration and technical infrastructure support.
Develop and maintain efficient and appropriate connectivity solutions between various campus systems to ensure necessary data is available as needed.
Develop and Enforce security standards
Develop and implement policies and procedures for infrastructure management adhering to organizational best practices.
Other duties may also be assigned
EDUCATION & EXPERIENCE
Bachelor's degree and eight years of relevant experience or combination of education and relevant experience.
KNOWLEDGE, SKILLS, AND ABILITIES
Experience in administrating, upgrade, monitoring, and tuning
Oracle database 19c
Application servers - Oracle 12c WebLogic, Tomcat
Informatica PowerCenter
Web servers – Apache
Experience with replication tools such as Oracle Golden Gate
Experience with programing languages like Python, Shell scripts
Experience with versioning tools git, SVN
CERTIFICATIONS AND LICENSES
AWS certifications and Oracle Certified Professional (OCP), a plus.
The expected pay range for this position is $130,000 – 160,000 per annum.
Stanford University provides pay ranges representing its good faith estimate of what the university reasonably expects to pay for a position. The pay offered to a selected candidate will be determined based on factors such as (but not limited to) the scope and responsibilities of the position, the qualifications of the selected candidate, departmental budget availability, internal equity, geographic location and external market pay for comparable jobs.
At Stanford University, base pay represents only one aspect of the comprehensive rewards package. The Cardinal at Work website (https://cardinalatwork.stanford.edu/benefits-rewards) provides detailed information on Stanford’s extensive range of benefits and rewards offered to employees. Specifics about the rewards package for this position may be discussed during the hiring process.
This is a hybrid-eligible position.
The job duties listed are typical examples of work performed by positions in this job classification and are not designed to contain or be interpreted as a comprehensive inventory of all duties, tasks, and responsibilities. Specific duties and responsibilities may vary depending on department or program needs without changing the general nature and scope of the job or level of responsibility. Employees may also perform other duties as assigned.
Consistent with its obligations under the law, the University will provide reasonable accommodations to applicants and employees with disabilities. Applicants requiring a reasonable accommodation for any part of the application or hiring process should contact Stanford University Human Resources by submitting acontact form.
Stanford is an equal employment opportunity and affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law.
Additional Information
Schedule: Full-time
Job Code: 4762
Employee Status: Regular
Grade: K
Requisition ID: 104084
Work Arrangement : Hybrid Eligible