Senior Consultant - GIS Database Administrator

Job Description:

The U.S. Forest Service (FS) seeks an individual to develop applications for the National Cruise System. The application has a geospatial component and is in active development.

Duties/ Responsibilities 

• Conduct architecture, engineering, and operational/administrative efforts required to build and operate Enterprise Geodatabase(s) on top of SQL Server RDBMS.

• Collaborate with GIS specialists, developers, and analysts to design and implement geospatial solutions.

• Provide technical support and troubleshooting for geospatial database-related issues.

• Design, develop, and implement geospatial databases using ESRI's suite of tools (ArcGIS, ArcSDE, etc.).

• Develop and optimize SQL queries, stored procedures, and scripts for data manipulation and analysis.

• Design and implement data models, including relational and spatial models, to support geospatial data storage and retrieval.

• Use Agency-approved and specified GitHub repository to store source code, document code, release packages, and associated artifacts.

Required Skills/Abilities

• At least 7 years of strong hands-on database development experience

• 3+ years of experience architecting, engineering, deploying, and troubleshooting ESRI Enterprise Geodatabases on top of SQL Server RDBMS.

• 2+ years of experience working with ArcGIS Enterprise (Portal, Federated Feature Services, Branch Versioning).

• 3+ years of experience working with ArcGIS Server including experience with ESRI Traditional Versioning.

• 5+ years of experience working with ESRI COTS Applications for mobile, web and desktop.

• Experience configuring and Automating Geodatabase workflows with Python

• Experience configuring high-availability and replication for SQL Server

• Experience with agile development

• Familiar with Git and GitHub (branching, merging, code review, pull request, etc.)

• Possession of excellent oral and written communication skills, including reading comprehension

Nice to Have Skills

• Familiarity with best practices in database security, including user access controls, authentication, and data encryption

Education and Experience:

• Bachelor’s degree in Computer Science, Geography, database engineering, software engineering, or other related field. If no degree, then 11+ years of development experience is required

Travel Requirement:

None

Clearance Requirement:

Ability to obtain a Public Trust

Salary:

$110,000 - $125,000 The salary range offered is an estimate made in good faith, intended to encompass various experience levels. Dynamo considers several factors when making an offer, including, but not limited to, the role, its functions and responsibilities, the candidate's work experience, location, educational background, and key skills.

Dynamo is a full lifecycle digital transformation company providing best-in-class technology and mission support services to our clients. An SBA 8(a) Program participant, Dynamo maintains SBA 8(a) Mentor-Protégé Program Joint Ventures, providing us significant scale and further deepening our capabilities. Dynamo’s mission is to lead the digital transformation industry and provide best-in-class solutions for our clients with a truly human touch. ​

We leverage industry leading practices to empower our clients, ultimately providing them with the necessary tools, knowledge, and information required to successfully achieve their strategic goals, while optimizing their operations. ​

Through our partnerships, boldness, and authenticity, Dynamo goes against the grain of a traditional government contracting company by providing top-caliber team members, delivering quality results, and always exceeding expectations.

Dynamo Technologies is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.