Technical Consultant - Enterprise Data Engineer

About the role

Esri's Professional Services division partners with customers on enterprise database design and implementation, applying Esri technology best practices. You will consult on business and technical requirements, design enterprise data management strategies and implement them across the engagement lifecycle, working independently and within project teams to configure back-end geospatial database capabilities supporting ArcGIS web, desktop and mobile applications. The team supports Defense and Intel clients, and relocation assistance is available for candidates moving to the Redlands, CA area.

Key responsibilities

• Design and implement robust, scalable and secure database solutions for mission-critical applications
• Work with cross-functional teams through requirements, analysis, design, build/configuration and deployment
• Configure and maintain database environments, including backup, restore, high availability and disaster recovery
• Monitor and tune database performance using tools such as query optimization and indexing strategies
• Implement data security, access controls and compliance standards
• Automate routine database loading, maintenance and monitoring tasks
• Advise on database design, migration and integration projects

Required profile

• 5+ years of hands-on experience designing, administering and optimizing databases for Oracle, SQL Server, PostgreSQL or SAP HANA
• Familiarity with database design, data loading, backup and recovery, performance tuning, maintenance and security
• SQL and Python scripting for automation and data workflows
• Exposure to geospatial concepts such as spatial data types, coordinate systems and spatial indexing
• Clear communication of complex technical concepts to peers, project managers and customers
• US citizenship with Active or current (within 2 years) Top Secret clearance with SCI eligibility
• Bachelor's degree in computer science, mathematics, GIS or a related STEM field

Required skills

• Oracle, SQL Server, PostgreSQL or SAP HANA
• SQL and Python
• Geospatial concepts
• Preferred: ArcGIS Enterprise geodatabases, CompTIA Security+, and industry-standard IT certifications (Esri, Microsoft, Amazon, PostgreSQL, Oracle)

What we offer

• Estimated base salary of $84,240-$142,480 USD
• Medical, dental, vision, life insurance, 401(k) and profit sharing
• Minimum 80 hours of vacation and 12 paid holidays
• Relocation assistance for the Redlands, CA area