Job ID: EBM032 GIS Database Administrator Shillong, India About Us Earthtree is an India headquartered company that develops agroforestry projects – rapidly scaling up climate action with real and measurable social and environmental benefits. In India, Earthtree grows new forests in a highly data driven manner, supporting regenerative horticulture and agriculture projects that can restore ecosystems that bring back biodiversity and support farmers with new sources of revenue. We support communities to help their land regeneration goals and engage with farmers, and landholders to help them achieve their land productivity goals. Who and what are we looking for? We are seeking an experienced and motivated GIS Database Administrator to join our team based in Shillong (Meghalaya), in support of our existing tree planting project. You will be responsible for implementing, managing and maintaining the organization's spatial and non-spatial databases, ensuring data integrity, performance optimization, and system availability. This role combines traditional database administration with specialized knowledge of geographic information systems to support spatial data management, analysis, and visualization needs across the organization. Main tasks & responsibilities: Design, implement, and maintain spatial and non-spatial database structures Configure and maintain geodatabases in various formats (Enterprise Geodatabase, File Geodatabase, etc.) Perform regular database maintenance, including backup and recovery procedures Monitor database performance and implement optimization strategies Manage database security, user access, and permissions Develop and maintain documentation for database structures and procedures Oversee spatial data management workflows and quality control procedures Implement and maintain spatial data models and schemas Manage spatial data versioning and reconciliation processes Coordinate data updates and maintenance schedules Ensure compliance with spatial data standards and metadata requirements Create and optimize spatial queries and stored procedures Support application development teams with database-related requirements Implement automated processes for routine database maintenance tasks Provide technical support for GIS users and applications Collaborate with GIS analysts and developers on data architecture solutions Train staff on database best practices and procedures Troubleshoot database-related issues and implement solutions Requirements: Bachelor's degree in Computer Science, GIS, or related field Minimum 5 years’ experience in database administration Minimum 3 years’ experience with Enterprise GIS systems Strong background in spatial database management Expert knowledge of enterprise RDBMS (e.g., PostgreSQL/PostGIS, Oracle Spatial, SQL Server) Strong SQL programming skills and experience with spatial SQL Strong problem-solving and analytical skills Ability to work collaboratively in an interdisciplinary team, as well as independently, with colleagues based in different locations and time zones around the globe Experience with version control systems Excellent communication and documentation abilities Understanding of coordinate systems and spatial reference systems Knowledge of IT security best practices Desirable Attributes: Experience with Python or other scripting languages Knowledge of ETL tools and processes for spatial data Experience with cloud database platforms (AWS, Azure, etc.) GISP certification or relevant database certifications preferred Working at Earthtree This role is full-time Join a fast-growing business with a great opportunity to quickly grow your career. Collaborative and dynamic work environment where you can make a significant impact. Opportunity to positively impact climate, biodiversity and communities in India and globally. We value diversity and inclusion, and are proud to be an equal opportunity employer. All applicants will be considered for employment without any form of discrimination. Must mention the Job number in the subject line when applying for the job & sending CV via email to Last date for submission of application is 07-Feb-2025
Job Title
GIS Database Administrator