Database Administrator

Location
California, United States
Posted
25 Oct 2018
End of advertisement period
25 Dec 2018
Ref
79722
Contract Type
Permanent
Hours
Full Time

Would you like to help shape the future of Stanford’s School of Medicine as one of the most prestigious schools in the world? Join our Platform team in leading and changing medicine as we know it today. We are looking for energetic self-starters who want to make a contribution as a Database Administrator to drive and support initiatives in the Office of Information Resources & Technology (IRT). Stanford University is an employer of choice in the Silicon Valley, sitting next to, and interacting with the world’s preeminent high tech companies. We offer a variety of benefits beyond traditional medical, dental retirement and savings options. This is a culture where you can make a difference working alongside some of the brightest and advanced thinkers in the world. 

Our Database Administrator is a newly created full-time continuing benefits eligible position reporting to the DBA Manager. In this position, you will be responsible for ensuring the security of all databases, migrating databases to the Google Cloud Platform (GCP) and support the development teams in IRT.

Duties include:

  • Design, develop, and maintain multiple, large, highly-available databases. Implement backup and recovery strategies as well as monitoring the overall health of the database environment.
  • Install, configure, and support relational database management systems (RDBMS) 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. Automate database patching operations with tools like Ansible and Puppet.
  • 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.
  • Using appropriate code, develop and maintain local and cloud database infrastructure. 
  • Evaluate and test marketplace tools and utilities as well as system integration and automation to 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.
  • Develop and enforce database standards and/or new development protocols.
  • Will work with technologies such as, Docker, Kubernetes, and Hashicorp Terraform and Vault to manage and support MS SQL server, Postgres SQL, MySQL , and Oracle databases in Google Cloud Platform.

This position currently works in our Porter Drive office. We anticipate that this position will move to the new Stanford Redwood City campus in late May to late June 2019.
* - Other duties may also be assigned.

DESIRED QUALIFICATIONS:

  • BS in computer science, mathematics, physics or statistics is preferred.
  • Demonstrated fluency in Lunix Shell Scripting, SQL, Python, T-SQL programming. 
  • At least five years of experience with MySQL, Oracle, MS SQL Server or Postgres SQL.
  • Demonstrated fluency in Oracle Enterprise Manager.
  • Ability to communicate with users and translate technical concepts to a nontechnical audience. 
  • Desire to stay current in new developments related to DBA work.
  • Demonstrate initiative to identify areas for improvement and independently identify solutions. 
  • Must be a self-managed, self-motivated individual, willing to self-study new subjects.

EDUCATION & EXPERIENCE (REQUIRED):

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

KNOWLEDGE, SKILLS AND ABILITIES (REQUIRED):

  • Demonstrated experience in the support requirements of large database applications/systems including performance analysis and tuning of high volume, transaction systems. 
  • 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.

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:

  • May Work Extended and weekend hours.
  • Must be available for on-call work (rotational basis).

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.