EDW Applications Database Administrator

Location
Stanford
Posted
Sep 13, 2017
Administrative Jobs
Technology, Database Administration
Institution Type
Four-Year Institution


Stanford University

EDW Applications Database Administrator

Job Number:
76296

Reporting to the Assistant Director of Technical Services team in Stanford University IT (UIT), this position requires the incumbent to provide application administration and database services in support of Data Management and Reporting's (DMR) systems.

JOB PURPOSE:

Install, configure, upgrade, administer, monitor, and maintain Enterprise Data Warehouse databases and relevant enterprise applications (OBIEE, Informatica Powercenter, Tableau, etc. ) under minimal supervision.

CORE DUTIES*:

  • Provide Database, Application and various Infrastructure support to Data Management and Reporting (DMR).
  • Install, configure, and support relational database management systems (RDBMS) , enterprise applications and related software to resolve highly complex and/or unique issues without precedent and/or structure. Work on databases using more advanced database administration concepts.
  • Design, develop, and maintain highly-available databases.
  • Take responsibility for database design and performance optimization, backup and recovery strategies and implementation, as well as monitoring the overall health of the database environment.
  • Execute complete database solutions from evaluation to implementation.
  • Provide on-going system administration and technical infrastructure support.
  • Review the physical and logical design of databases for optimal database structures, performance tuning, security, and database backup/recovery. Plan and implement pro-active and reactive performance analysis, monitoring, troubleshooting, and capacity planning.
  • Evaluate and test marketplace tools and utilities, including system integration and automation, which enhance server functionality and promote the development of RDBMS applications.
  • Develop and maintain efficient and appropriate connectivity solutions between various campus databases to ensure necessary data is available as needed.
  • Create data flow and data lifecycle documentation.
  • Develop and enforce database standards and/or new development protocols.

* - Other duties may also be assigned

MINIMUM REQUIREMENTS: Education & Experience:

Bachelor's degree and eight years of relevant experience or a combination of education and relevant experience.

Knowledge, Skills and Abilities:
  • Must be smart, highly resourceful and quick learner. Highly motivated.
  • Strong Oracle Database Administration skills. Strong backup and recovery skills. Demonstrated ability to clone large databases from any kind of source. Hands-on test may be asked during interview.
  • Strong UNIX skills. Strong Bash and/or Perl scripting preferred. UNIX Admin background preferred.
  • Admin skills in OBIEE/Fusion Middleware and/or Informatica Powercenter and/or Tableau.
  • Admin skills in Apache/Tomcat in UNIX.
  • Weblogic Administration experience preferred.
  • AWS/Cloud skills preferred.
  • Demonstrated experience in the support requirements of large database applications/systems including performance analysis and tuning of high volume, transaction systems on an Oracle/UNIX environment.
  • Knowledge of hierarchical database systems.
  • Extensive knowledge of systems platform.
  • Extensive knowledge and experience in the design and implementation of complex database architecture.
  • Extensive experience in programming environments.
  • Ability to develop a vision for future computing needs and to develop appropriate plans to meet these needs.
  • Ability to work well independently or as a team member.
  • Ability to maintain knowledge of new and current technology and trends.
  • Ability to collaborate with vendors and system service providers, provide administration for system solutions, and act as a liaison.
  • Extensive experience with database security protocol.
Other Preferred Skills:

  • Demonstrated programming ability for tool building or solving complex problems is a plus.
  • Oracle DBA OCP is a plus.
  • UNIX Administration certification is a plus
  • Technical certifications in OBIEE, Fusion Middleware, Informatica, Tableau is a plus

Certifications and Licenses: None
PHYSICAL REQUIREMENTS*:
  • Constantly perform desk-based computer tasks.
  • Frequently sit, grasp lightly/fine manipulation.
  • Occasionally stand/walk, use a telephone.
  • Rarely writing by hand, lift/carry/push/pull objects that weigh up to 10 pounds.

* - Consistent with its obligations under the law, the University will provide reasonable accommodation to any employee with a disability who requires accommodation to perform the essential functions of his or her job.


WORKING CONDITIONS:
  • Extended and weekend hours.
  • Must be available for on-call work.
WORK STANDARDS:

  • Interpersonal Skills: Demonstrates the ability to work well with Stanford colleagues and clients and with external organizations.
  • Promote Culture of Safety: Demonstrates commitment to personal responsibility and value for safety; communicates safety concerns; uses and promotes safe behaviors based on training and lessons learned.
  • Subject to and expected to comply with all applicable University policies and procedures, including but not limited to the personnel policies and other policies found in the University's Administrative Guide, http://adminguide.stanford.edu.

We are not able to provide sponsorship or relocation for this position.

Stanford is an equal opportunity employer and all qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other characteristic protected by law.




Job: Information Technology Services

Location: Business Affairs: Administrative Systems (IT)
Schedule: Full-time
Classification Level:

To be considered for this position please visit our web site and apply on line at the following link: stanfordcareers.stanford.edu

Stanford is an equal opportunity employer and all qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other characteristic protected by law.






jeid-53f8f2426cfeaa4ea191cfcb15db7e2c