Title: PostgreSQL Database Developer - Database Administrator
Program: Environmental Informatics
Reports to: Program Director
Requisition number: EI 22-2
Full-Time Equivalency: 50%
Salary range for 50% time: $50k-60k, depending on qualifications
Remote work OK
Posted: 8/28/2021 (open until Sept 30th)
About the Position
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.
Environmental Informatics Program
The Environmental Informatics Program provides clients and partners with the most current technology tools and information available to meet the Institute’s mission. We think carefully about how best to transform data into knowledge usable by our public stakeholders, whether those people are community members, unfamiliar with water quality-related matters, or deeply initiated scientists residing in federal, state, or local agencies. Database administration is a key part of the chain of information. Our Data Services (processing and analysis) and Software Engineering teams both depend on the effectiveness of our database administrator and will benefit from your innovative ideas. While many of the DBA’s activities concern the foundational infrastructure which are often in the background, our organization is nimble and agile enough to benefit from forward-thinking DBAs who wish to introduce new technologies and procedures, as long as they achieve greater efficiencies, insights, transparency, and/or client satisfaction. In other words, the Environmental Informatics program is a team that welcomes your ideas.
The DBA will work closely with scientists in SFEI’s Clean Water and Resilient Landscapes programs, helping to meet data management needs for water quality data, wetlands mapping, shoreline inventories, and landscape analyses.
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
- PostgreSQL Data Management
- Server replication
- Data ETL
- Data analysis support
- 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
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.
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.
SFEI is committed to building a culturally diverse staff, and we strongly encourage applications from women, people of color, and other groups commonly under-represented in environmental science.
San Francisco Estuary Institute is an Equal Opportunity/Affirmative Action employer and prohibits discrimination and harassment of any kind. We are committed to the principle of equal employment opportunity, and to providing employees with a work environment free of discrimination and harassment. All employment decisions are based on business needs, job requirements, and individual qualifications. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, including sexual orientation, gender identity or expression, national origin, physical or mental disability, family or parental status, protected Veteran status, or any other characteristic protected by applicable federal, state, or local law.
If you are a qualified individual with a disability or a disabled veteran, you have the right to request an accommodation if you are unable or limited in your ability to use or access our career center as a result of your disability. To request an accommodation, contact Linda Russio at 510-746-7355 or [email protected].
Please note that SFEI cannot sponsor an employment visa (e.g., H-1B) to fill this position.
Do not use any third-party web sites to apply for the position. No phone calls please.