Hiring a Postgresql Developer / DBA - Remote

Hello,

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
<https://www.sfei.org/content/db-admin>*

*Job Description:*

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.

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

*Optional Skills:*

- 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.

*About SFEI:*

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
<https://www.sfei.org/programs/clean-water>, Environmental Informatics
<https://www.sfei.org/programs/ei>, and Resilient Landscapes
<https://www.sfei.org/rl>. 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 <https://www.sfei.org/user/32>*
Program Director for Environmental Informatics
San Francisco Estuary Institute
Pronouns: He/His