OVERVIEW:

Chartwell Resource Group Ltd. is looking for a full-time Geographic Information Systems Administrator who is motivated, positive, and dependable. The position is based out of our North Vancouver office. We are seeking an outstanding individual to join our team of GIS, Software, and Resource Professionals. Our mission is to provide the highest caliber of service to meet the needs of our clients, and we are only as good as the people on our team.

JOB DESCRIPTION:

As a System Administrator at Chartwell, you will be responsible for managing, maintaining, and developing our GIS and web service infrastructure. This role involves working on our PostgreSQL database, ArcGIS Enterprise, Linux servers, AWS cloud, and all the other back-end systems that underpin the applications and services we develop for our staff and clients. You will be working as part of a small team of software and GIS developers on a variety of projects, bringing a combination of skills from database admin, Linux system admin, and data science, combined with an eagerness to learn and innovate.

QUALIFICATIONS:

• Formal education in GIS, Computer Science or related discipline
• 3 to 5 years of recent experience as a systems administrator or DBA
• Proficient in database development and software management
• Strong relational database and SQL experience, primarily with PostgreSQL
• Experience with geospatial databases (e.g. Esri SDE, PostGIS) will be considered a big asset
• Experience with Linux system administration
• Knowledge of Esri’s ArcGIS Platform (ArcGIS Pro, ArcGIS Server, ArcGIS Online)
• AWS experience preferred
• Analytical and problem-solving skills with attention to detail
• Ability to multitask, prioritize work, and manage time efficiently
• Excellent communication and data management skills
• Canadian citizenship or legally qualified to work in Canada

The position’s responsibilities will generally include:

• Database creation, management, and schema design
• Database optimization and performance tuning
• Writing SQL functions and triggers, as well as using SQL for data manipulation and analysis
• Writing Python scripts to manage systems and data
• Developing a robust monitoring and alerting system to minimize downtime and maintain data integrity
• Monitoring database and server performance
• Supporting and maintaining our PostgreSQL and ArcGIS Server environments, including version upgrades
• Managing backups for our database and GIS systems
• Troubleshooting technical issues related to our GIS systems and infrastructure
• Data ETL, management, and analysis