PostgreSQL/PostGIS Developer

Position summary

Motivf is recruiting a PostgreSQL/PostGIS database developer to join our Agile geospatial information systems integration team for Government clients. You will work in a team environment to support and monitor database development. An ideal candidate will be able to lead the team from data modeling to implementation and improvement.

Your Responsibilities:

  • Support database development throughout the software lifecycle from requirements analysis and design through to implementation and maintenance

  • Visually design (new) and/or maintain (existing) data models utilizing a robust and competitive data modeling tool or tools, to accommodate the client’s business requirements

  • Manage the full round trips between data modeling, database implementation, and change management

  • Maintain accurate and up-to-date documentation on data model, data dictionary, and data artifacts

  • Work with programmers by providing assistance to their SQL query needs - providing complex queries, tuning queries for a high performance, creating additional data structures to accommodate the data needs from applications

  • Automate regular and repeated activities, such as backup, regular data loads, and etc.

  • Bulk data extraction, transformation and loading (ETL) to assist data migration from various sources into the project’s database, and vice versa

  • Monitor the performance of application queries to meet the client’s response time requirements

  • Participate as a member in Agile teams, and work with other team members to review user stories, estimate effort to build functionality supporting user stories, and participate in sprint reviews

  • Monitor database health and security, implement table redesigns, update data in support of operations and testing, and SQL query design

  • Migrate data with complex rules and learn and implement new data technologies as needed

  • Ensure the availability and performance of the databases that support our systems have sufficient resources allocated to support high resilience and speed

Required Qualifications:

  • 3+ years experience as a database developer working with PostgreSQL

  • Proficiency in PostgreSQL + PostGIS

  • Proficiency in pgAdmin or equivalent

  • Experience with QGIS or equivalent in conjunction with PostGIS in dealing with day to data data management activities.

  • Expert level SQL, PL/pgSQL, including stored procedures, functions, triggers, and views.

  • Knowledge & work experience of JSON related PostgreSQL features.

  • Knowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels

Preferred Qualifications:

  • Ability to evaluate alternative solutions and/or workarounds

  • Ability to work successfully with teams, independently, and under pressure

  • Able to multitask, prioritize, and manage time efficiently

  • Strong skills in short-term planning, analysis, problem-anticipation and -solving, and customer service; ability to independently investigate solutions to challenges and anticipate leadership needs

  • Strong and effective interpersonal skills in working with colleagues at all levels

  • Ability to use discretion and maintain confidentiality

  • Cultural sensitivity and demonstrated ability to work diplomatically with diverse constituencies

WHAT WE OFFER

MEANING and PURPOSE at MOTIVF

  • Management Culture and Philosophy: At Motivf, we seek joy at work, so we prioritize psychological safety (the #1 trait of great teams), creativity, engagement, learning, human connection, and the meaning of the work. We minimize micromanagement by practicing agile-style self-management for maximum autonomy and engagement. Team members are largely accountable to each other, while their manager’s job is to coach them to career-defining performance and otherwise stay out of the way. We strive to hire managers people want to work for.

  • Purpose. Motivf is a Certified B Corporation: we meet the highest, verified standards of social and environmental performance, public transparency, and legal accountability to balance profit and purpose.

  • How We Value People. We believe talents, like empathy and strategy, analysis and learning, and drive (or passion and motivation) lead to greater engagement by you and productivity for us than arbitrary requirements of prior experience, having the right keywords of skills or knowledge, or degrees that may not be necessary. That’s true equal opportunity, and true respect for the individual and their unique story.

Regardless of how any job description is written, if you think you can do the job, we invite you to make a case for it! We’d love to hear how your unique blend of talents and drive can equip you to succeed in this role, including as it changes over time.

Julie KimRemote