SLAC National Accelerator Laboratory
Senior Database Administrator
SLAC National Accelerator Laboratory, Menlo Park, California, United States, 94029
Senior Database Administrator
Job ID
6138
Location
SLAC - Menlo Park, CA
Full-Time
Regular
SLAC Job Postings
Position Overview:
SLAC National Accelerator Laboratory is seeking a talented and enthusiastic scientific database administrator to support the next generation of data analytics, machine learning and large scale science that will be the bedrock of scientific computing.
The Scientific Computing Services group supports SLAC¿s broad and vibrant scientific program in fundamental physics, with research in cosmic survey science, cosmic microwave background, direct dark matter searches, proton collider physics and neutrino physics, as well as theoretical and computational physics. We host the US Data Facility for the Vera C. Rubin Observatory, providing unprecedented scale and time resolution of celestial objects; and we also support the data systems for the Linear Coherent Light Source providing ultra high resolution imaging - pushing the boundaries of biological and material science.
If you are excited and motivated to contribute to this world changing scientific effort we invite you to apply for a position as a skilled Senior Database Administrator to join our team. You will be responsible for ensuring the reliability and efficiency of our databases, including maintenance, upgrades, monitoring, and performance tuning. In addition, you will be responsible for designing growth strategies for our database infrastructure as they approach multi-PB sizes, ensuring that they can handle the increasing scientific challenges at scale and architect robust upgrade and migration strategies that ensure continual operation for our science users. You will be working closely with our Infrastructure, Applications and Data Management teams as well as science groups to determine their needs.
We want a highly motivated and experienced Database Administrator with a passion for managing large databases and ensuring their reliability and performance. We offer competitive salary and benefits packages, and a supportive work environment where you can grow your skills and knowledge. We are open to hybrid work arrangements. The SLAC Shared Science Data Facility operates 24x7, in support of science experiments that operate 24x7, with users all across the world. You are expected to be available to address and resolve critical networking and security issues outside normal working hours, on a rotating basis, as needed.
Your specific responsibilities include:
Manage and maintain our PostgreSQL and MySQL databases, ensuring high availability and reliability on our in-house kubernetes platform.
Perform routine maintenance tasks, such as reindexing, backups, patching, and software upgrades.
Monitor the performance and health of our databases, proactively identifying and resolving issues.
Design and implement growth strategies for our databases, ensuring they can handle our organization's increasing (meta)data needs.
Collaborate with software developers and other scientific computing staff to optimize database performance and support application development.
Develop and implement security measures to protect our databases from unauthorized access or data breaches.
Ensure compliance with data privacy regulations and best practices.
Participate in on-call rotations as needed.
To be successful in this position you will bring:
Bachelor's degree in computer science or a related technical field and at least 8 years of experience as a Database Administrator; or a combination of education and relevant experience.
Expert knowledge of PostgreSQL and MySQL.
Extensive experience with database design, performance tuning, and optimization.
Experience with database security best practices.
Strong analytical and problem-solving skills.
Proven ability to work independently as well as in a team environment.
Excellent written and verbal communication skills.
Preferred Qualifications:
Experience with running databases on Kubernetes
Experience with distributed databases
Experience with NoSQL databases such as Mongo and Cassandra
Experience with message bus technologies such as Kafka and ZeroMQ
Experience with logical replication and other high availability database technologies
Experience in the DoE lab complex and or scientific/academic environment
SLAC Competencies:
Effective Decisions:
Uses job knowledge and solid judgment to make quality decisions in a timely manner.
Self-Development:
Pursues a variety of venues and opportunities to continue learning and developing.
Dependability:
Can be counted on to deliver results with a sense of personal responsibility for expected outcomes.
Initiative:
Pursues work and interactions proactively with optimism, positive energy, and motivation to move things forward.
Adaptability:
Flexes as needed when change occurs, maintains an open outlook while adjusting and accommodating changes.
Communication:
Ensures effective information flow to various audiences and creates and delivers clear, appropriate written, spoken, presented messages.
Relationships:
Builds relationships to foster trust, collaboration, and a positive climate to achieve common goals.
PHYSICAL REQUIREMENTS/ WORKING CONDITIONS:
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.
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 environment, safety and security; communicates related concerns; uses and promotes safe behaviors based on training and lessons learned.Meets the applicable roles and responsibilities as described in the ESH Manual, Chapter 1¿General Policy and Responsibilities: http://www-group.slac.stanford.edu/esh/eshmanual/pdfs/ESHch01.pdf
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
**Classification Title:** Database Administrator 2
**Grade:** K, **Job code:** 4762
**Duration:** Regular Continuing
_The expected pay range for this position is $150,922 to $180,345 per annum. SLAC National Accelerator Laboratory/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._
SLAC National Accelerator Laboratory is an Affirmative Action / Equal Opportunity Employer and supports diversity in the workplace. All employment decisions are made without regard to race, color, religion, sex, national origin, age, disability, veteran status, marital or family status, sexual orientation, gender identity, or genetic information. All staff at SLAC National Accelerator Laboratory must be able to demonstrate the legal right to work in the United States. SLAC is an E-Verify employer.
Job ID
6138
Location
SLAC - Menlo Park, CA
Full-Time
Regular
SLAC Job Postings
Position Overview:
SLAC National Accelerator Laboratory is seeking a talented and enthusiastic scientific database administrator to support the next generation of data analytics, machine learning and large scale science that will be the bedrock of scientific computing.
The Scientific Computing Services group supports SLAC¿s broad and vibrant scientific program in fundamental physics, with research in cosmic survey science, cosmic microwave background, direct dark matter searches, proton collider physics and neutrino physics, as well as theoretical and computational physics. We host the US Data Facility for the Vera C. Rubin Observatory, providing unprecedented scale and time resolution of celestial objects; and we also support the data systems for the Linear Coherent Light Source providing ultra high resolution imaging - pushing the boundaries of biological and material science.
If you are excited and motivated to contribute to this world changing scientific effort we invite you to apply for a position as a skilled Senior Database Administrator to join our team. You will be responsible for ensuring the reliability and efficiency of our databases, including maintenance, upgrades, monitoring, and performance tuning. In addition, you will be responsible for designing growth strategies for our database infrastructure as they approach multi-PB sizes, ensuring that they can handle the increasing scientific challenges at scale and architect robust upgrade and migration strategies that ensure continual operation for our science users. You will be working closely with our Infrastructure, Applications and Data Management teams as well as science groups to determine their needs.
We want a highly motivated and experienced Database Administrator with a passion for managing large databases and ensuring their reliability and performance. We offer competitive salary and benefits packages, and a supportive work environment where you can grow your skills and knowledge. We are open to hybrid work arrangements. The SLAC Shared Science Data Facility operates 24x7, in support of science experiments that operate 24x7, with users all across the world. You are expected to be available to address and resolve critical networking and security issues outside normal working hours, on a rotating basis, as needed.
Your specific responsibilities include:
Manage and maintain our PostgreSQL and MySQL databases, ensuring high availability and reliability on our in-house kubernetes platform.
Perform routine maintenance tasks, such as reindexing, backups, patching, and software upgrades.
Monitor the performance and health of our databases, proactively identifying and resolving issues.
Design and implement growth strategies for our databases, ensuring they can handle our organization's increasing (meta)data needs.
Collaborate with software developers and other scientific computing staff to optimize database performance and support application development.
Develop and implement security measures to protect our databases from unauthorized access or data breaches.
Ensure compliance with data privacy regulations and best practices.
Participate in on-call rotations as needed.
To be successful in this position you will bring:
Bachelor's degree in computer science or a related technical field and at least 8 years of experience as a Database Administrator; or a combination of education and relevant experience.
Expert knowledge of PostgreSQL and MySQL.
Extensive experience with database design, performance tuning, and optimization.
Experience with database security best practices.
Strong analytical and problem-solving skills.
Proven ability to work independently as well as in a team environment.
Excellent written and verbal communication skills.
Preferred Qualifications:
Experience with running databases on Kubernetes
Experience with distributed databases
Experience with NoSQL databases such as Mongo and Cassandra
Experience with message bus technologies such as Kafka and ZeroMQ
Experience with logical replication and other high availability database technologies
Experience in the DoE lab complex and or scientific/academic environment
SLAC Competencies:
Effective Decisions:
Uses job knowledge and solid judgment to make quality decisions in a timely manner.
Self-Development:
Pursues a variety of venues and opportunities to continue learning and developing.
Dependability:
Can be counted on to deliver results with a sense of personal responsibility for expected outcomes.
Initiative:
Pursues work and interactions proactively with optimism, positive energy, and motivation to move things forward.
Adaptability:
Flexes as needed when change occurs, maintains an open outlook while adjusting and accommodating changes.
Communication:
Ensures effective information flow to various audiences and creates and delivers clear, appropriate written, spoken, presented messages.
Relationships:
Builds relationships to foster trust, collaboration, and a positive climate to achieve common goals.
PHYSICAL REQUIREMENTS/ WORKING CONDITIONS:
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.
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 environment, safety and security; communicates related concerns; uses and promotes safe behaviors based on training and lessons learned.Meets the applicable roles and responsibilities as described in the ESH Manual, Chapter 1¿General Policy and Responsibilities: http://www-group.slac.stanford.edu/esh/eshmanual/pdfs/ESHch01.pdf
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
**Classification Title:** Database Administrator 2
**Grade:** K, **Job code:** 4762
**Duration:** Regular Continuing
_The expected pay range for this position is $150,922 to $180,345 per annum. SLAC National Accelerator Laboratory/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._
SLAC National Accelerator Laboratory is an Affirmative Action / Equal Opportunity Employer and supports diversity in the workplace. All employment decisions are made without regard to race, color, religion, sex, national origin, age, disability, veteran status, marital or family status, sexual orientation, gender identity, or genetic information. All staff at SLAC National Accelerator Laboratory must be able to demonstrate the legal right to work in the United States. SLAC is an E-Verify employer.