Hello,
SFEI is seeking a Database Developer-Administrator to join the Environmental Informatics team. This position will be a part-time (50%) position, under the supervision of the Environmental Informatics Program Director. A successful candidate will be enthusiastic, self motivated, and passionate about applying technical expertise to database administration, while also working closely with the software engineering team to develop new PostgreSQL data structures in support of their projects. Strong candidates will also demonstrate familiarity with data extract, transform, and load processes to optimize the migration of data among repositories. You will collaborate with your colleagues to ensure an optimum relationship between data, data availability, and policy effectiveness through innovative approaches to data management. Ideal candidates will bring a combination of database administration skills, data science, familiarity with data management best practices, an eagerness to innovate, and an enthusiasm for open data in service of the public good.
This is a part-time position at 50% full-time equivalency.
Optional Skills:
The San Francisco Estuary Institute, an environmental science non-profit with a 28-year history of service and success, is interested in hiring a new Postgresql Developer - Administrator. Remote work is acceptable. The hiring process would include a remote interview.
We pass the Joel test with a 10. (Not great, but not terrible!)
We are relatively small, nimble, and most of all, meaningful. Our work helps preserve natural resources when we need them the most!
We'd love to hear from you at https://www.sfei.org/content/db-admin
Job Description:
This is a part-time position at 50% full-time equivalency.
Duties are likely to be diverse and will require an enthusiastic, team-oriented individual. Typical duties will include:
- PostgreSQL Development
- Database creation & design
- Optimization & performance tuning
- PostgreSQL Database Administration
- Security/Accounts
- Backups
- Upgrades
- PostgreSQL Data Management
- Server replication
- Data ETL
- Data analysis support
Required Skills:
- Experience working with and designing relational databases
- Experience working with QA/QC procedure integration and ETL
- Familiarity with multiple database technologies, but specialization in PostgreSQL
- Experience using PostGIS
- Troubleshooting performance issues and database optimization
- Experience managing large datasets
- Exceptional attention to detail and problem-solving skills
- Motivated to gain and develop new technical skills
- Ability to manage time effectively on multiple projects
- Works well in a collaborative team setting
- Ability to work independently and follow through with tasks under general guidance from supervising staff
- Effective written and verbal communication skills—ability to communicate technical information to non-technical clients
- Experience in drafting technical documentation
- Experience managing metadata and data catalogs
- Experience with automated mapping workflows
- Experience with key technical concepts, such as sensor-based data acquisition, display/visualization, spatial analysis, spatial statistics
- Experience with and interest in keeping up with advancing and emerging technologies, e.g., content management systems; new programming frameworks; managing lidar, multispectral imagery, remote sensing, discrete sampling data, BLOBs, etc.
- Experience with scripting/tool development with ArcPy, GDAL/OGR, PostGIS, R, QGIS
- Experience working with and managing geospatial databases (e.g. ESRI SDE geodatabases, PostGIS)
- Demonstrated knowledge of geospatial information systems theory and core methods including its association with relational database design
- Experience with the complete project lifecycle from conceptualization through requirements definition, design, development, testing implementation, maintenance, and user training
- Training and experience in the environmental sciences (e.g., coastal and wetland science, biology, geology, landscape architecture, and aquatic ecology)
- Experience working with laboratories and lab-derived data
- Experience managing continuous, real-time data
Location:
Remote or in-person
Term:
Permanent
Compensation:
The job is 50%-time and pays $50k-60k per year. (Up to $120k full time equivalency.) Excellent benefit package included.
SFEI Mission: We deliver visionary science that empowers people to revitalize nature in our communities.
San Francisco Estuary Institute (SFEI) is a 501(c)(3) non-profit organization which has a 27-year track record of serving local, state, and federal agencies by developing and translating science to measurably improve the health and resiliency of Bay-Delta ecosystems. SFEI is a boundary organization at the interface between science and policy, recognized nationally for our ability to build consensus to support effective environmental decision-making and policy. Over the next five years, SFEI will be implementing our Strategic Plan that will focus on advancing visionary science, harnessing innovative technology and big data, and communicating science to inform, inspire, and empower stakeholders in an effort to fulfill our vision and mission for the Bay-Delta and beyond.
SFEI has 70 staff who represent numerous scientific and technological fields including chemistry, modeling, ecology, wildlife biology, landscape planning, historical ecology, geomorphology, geospatial modeling and analysis, and web development. We are seeking a talented scientist to join a dynamic, supportive, team-oriented work culture that is driven by our vision and mission. We have many long-tenured staff who have built and expanded the foundation of the organization and are looking for a key person to grow with us.
Even More About Us:
SFEI has three major programs: Clean Water, Environmental Informatics, and Resilient Landscapes. These programs have multiple focus areas including the Regional Monitoring Program for Water Quality in San Francisco Bay, the Nutrient Management Strategy, contaminants of emerging concern, the Regional Data Center, aerial drone research, geomorphology, multi-benefit urban greening and design, ecosystem restoration and climate adaptation, urban biodiversity and resilience, and green stormwater infrastructure.
About SFEI:
San Francisco Estuary Institute (SFEI) is a 501(c)(3) non-profit organization which has a 27-year track record of serving local, state, and federal agencies by developing and translating science to measurably improve the health and resiliency of Bay-Delta ecosystems. SFEI is a boundary organization at the interface between science and policy, recognized nationally for our ability to build consensus to support effective environmental decision-making and policy. Over the next five years, SFEI will be implementing our Strategic Plan that will focus on advancing visionary science, harnessing innovative technology and big data, and communicating science to inform, inspire, and empower stakeholders in an effort to fulfill our vision and mission for the Bay-Delta and beyond.
SFEI has 70 staff who represent numerous scientific and technological fields including chemistry, modeling, ecology, wildlife biology, landscape planning, historical ecology, geomorphology, geospatial modeling and analysis, and web development. We are seeking a talented scientist to join a dynamic, supportive, team-oriented work culture that is driven by our vision and mission. We have many long-tenured staff who have built and expanded the foundation of the organization and are looking for a key person to grow with us.
Even More About Us:
SFEI has three major programs: Clean Water, Environmental Informatics, and Resilient Landscapes. These programs have multiple focus areas including the Regional Monitoring Program for Water Quality in San Francisco Bay, the Nutrient Management Strategy, contaminants of emerging concern, the Regional Data Center, aerial drone research, geomorphology, multi-benefit urban greening and design, ecosystem restoration and climate adaptation, urban biodiversity and resilience, and green stormwater infrastructure.
Best regards,
Tony
Tony Hale, PhD
Program Director for Environmental Informatics
San Francisco Estuary Institute
Pronouns: He/His