Job Closed
This listing is no longer active.
Trilon Group provides smart and sustainable infrastructure solutions across transportation, water, energy, environment, and community sectors. The firm offers a
Senior GIS & Database Engineer - CIMS
Location
United States
Posted
83 days ago
Salary
0
No structured requirement data.
Job Description
Senior GIS & Database Engineer - CIMS
Trilon Group
Senior GIS & Database Engineer - CIMS Department: Construction Management Employment Type: Full Time Location: Remote- USA Description The CIMS (Construction Information Management System) team is seeking a Senior GIS & Database Engineer to support a GIS-based construction data platform used for inspection, testing, and project management workflows. This role combines enterprise GIS administration with professional database management. The position supports a production system built on spatial and non-spatial relational data, web services, and mobile workflows. The successful candidate will demonstrate strong technical capability, sound database practices, and effective collaboration within a highly technical team. What are the core responsibilities for the role? - Administer and maintain enterprise GIS environments - Manage spatial and non-spatial relational databases (PostgreSQL-based) - Design and maintain ETL workflows for spatial and tabular data - Develop database schemas, relationships, and constraints - Monitor and optimize database performance (queries, indexing) - Implement backup, recovery, and data integrity procedures - Publish and maintain GIS services for web and mobile use - Support offline data collection and synchronization workflows - Troubleshoot system performance and data reliability issues - Develop automation scripts and custom tools to support operations - Collaborate with software developers and technical staff on system improvements Position Characteristics This is an enterprise systems role rather than a traditional GIS analyst position. The role requires ownership of GIS infrastructure, relational database health, ETL processes, and automation within a production environment. Qualifications, Skills, and Competencies: - Bachelor’s degree in GIS, Computer Science, Engineering, Information Systems, or related field - 5+ years of experience in enterprise GIS, database administration, or geospatial systems support - Experience managing relational databases (PostgreSQL preferred) - Experience with designing and maintaining ETL processes - Experience administering ArcGIS Enterprise or ArcGIS Server - Strong SQL skills, including query optimization - Experience with Python scripting for automation - Experience supporting multi-user production environments - Understanding of data security and database role management Technical Skills – Required - Enterprise geodatabase management - Relational database administration (schema design, normalization, documentation, indexing, constraints, roles) - SQL performance tuning - ETL design and data transformation workflows - ArcGIS Server administration - Backup and recovery procedures - Sync-enabled/mobile GIS workflows - Cloud-hosted systems (AWS or similar) Technical Skills – Preferred - Experience performing core DBA functions (performance monitoring, storage planning) - Experience developing custom automation tools or database scripts - Familiarity with Linux environments - Experience supporting production systems with uptime expectations - Basic understanding of civil design concepts and terminology. Interpersonal Requirements - Ability to work effectively within a highly technical team - Clear communication with developers and technical stakeholders - Strong troubleshooting and analytical mindset - Professional judgment in balancing technical standards with operational needs - Ability to work independently while contributing to a collaborative environment Why would a candidate want this job? At Horrocks, you can expect a competitive base salary and award-winning benefits. Including, but not limited to: - Medical, dental, vision, life, and disability insurance - Generous paid time off - 401(k): 50% match of contribution up to 6% - Professional development opportunities including in-house training - Paid professional organization membership and professional licensure For more information, visit our website at www.horrocks.com Equal Opportunity Employer including disability and protected veteran status #LI-KG1
Related Guides
Related Categories
Related Job Pages
More Database Administrator Jobs
Database Admin Specialist Advisor
NTT GroupA global IT innovator founded in 1965, NTT DATA specializes in system integration and networking system services for more than a dozen industries. As an employe
Req ID: 362195 NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Database Admin Specialist Advisor to join our team in Arlington (REMOTE), Virginia (US-VA), United States (US). Job Summary: We are seeking an experienced SharePoint Administrator hands-on SharePoint administration experience to support both SharePoint 2016 On-Premise Operations and Maintenance (O&M) and SharePoint Online (Microsoft 365) environments. This role requires a strong operational mindset, excellent troubleshooting skills, and the ability to manage hybrid SharePoint architectures while ensuring platform stability, security, and performance. The ideal candidate will be equally comfortable supporting legacy on-premise infrastructure and modern cloud-based SharePoint Online solutions. Job Duties: SharePoint 2016 On-Premise Administration (O&M) - Administer, maintain, and support SharePoint 2016 farm environments - Perform installation, configuration, patching (CUs/Service Packs), and upgrades - Manage SharePoint farm topology, service applications, web applications, and site collections - Monitor farm health, performance, and capacity planning - Manage backups, restores, and disaster recovery procedures - Troubleshoot platform, search, workflow, and authentication issues - Support SQL Server integration and performance optimization - Maintain documentation including system architecture, SOPs, and runbooks - Support incident, problem, and change management processes SharePoint Online Administration - Administer SharePoint Online within Microsoft 365 tenant - Manage site collections, permissions, governance policies, and content lifecycle - Configure and manage hybrid connectivity between on-prem and SharePoint Online - Support OneDrive for Business and Teams integration - Implement retention policies, compliance features, and DLP configurations - Monitor tenant health and security alerts - Support migration activities between on-premise and SharePoint Online - Configure and manage PowerShell automation for administration tasks Basic Qualifications: - Minimum 10 years of SharePoint Administration experience - Bachelor's degree, One-and-one- half (1.5) years of additional experience can substitute for one (1) year of a typical degree program. - Ability to obtain a Public Trust clearance Preferred Qualifications: - Experience with SharePoint migrations (on-prem to Online) - Knowledge of Power Platform (Power Automate, Power Apps) - Experience with security hardening and STIG implementation - Familiarity with backup tools (e.g., Veeam, AvePoint, Metalogix) - Microsoft certifications (e.g., MS-100, MS-101, or related) Where required by law, NTT DATA provides a reasonable range of compensation for specific roles. The starting pay range for this remote role is $100,778 - $233,281. This range reflects the minimum and maximum target compensation for the position across all US locations. Actual compensation will depend on a number of factors, including the candidate’s actual work location, relevant experience, technical skills, and other qualifications. This position may also be eligible for incentive compensation based on individual and/or company performance. This position is eligible for company benefits including medical, dental, and vision insurance with an employer contribution, flexible spending or health savings account, life and AD&D insurance, short and long term disability coverage, paid time off, employee assistance, participation in a 401k program with company match, and additional voluntary or legally-required benefits. About NTT DATA NTT DATA is a $30 billion business and technology services leader, serving 75% of the Fortune Global 100. We are committed to accelerating client success and positively impacting society through responsible innovation. We are one of the world's leading AI and digital infrastructure providers, with unmatched capabilities in enterprise-scale AI, cloud, security, connectivity, data centers and application services. our consulting and Industry solutions help organizations and society move confidently and sustainably into the digital future. As a Global Top Employer, we have experts in more than 50 countries. We also offer clients access to a robust ecosystem of innovation centers as well as established and start-up partners. NTT DATA is a part of NTT Group, which invests over $3 billion each year in R&D. Whenever possible, we hire locally to NTT DATA offices or client sites. This ensures we can provide timely and effective support tailored to each client’s needs. While many positions offer remote or hybrid work options, these arrangements are subject to change based on client requirements. For employees near an NTT DATA office or client site, in-office attendance may be required for meetings or events, depending on business needs. At NTT DATA, we are committed to staying flexible and meeting the evolving needs of both our clients and employees. NTT DATA recruiters will never ask for payment or banking information and will only use @nttdata.com, @nttdatafed.com and @talent.nttdataservices.com email addresses. If you are requested to provide payment or disclose banking information, please submit a contact us form, https://us.nttdata.com/en/contact-us. NTT DATA endeavors to make https://us.nttdata.com accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at https://us.nttdata.com/en/contact-us. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications. NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our EEO Policy Statement, please click here. If you'd like more information on your EEO rights under the law, please click here. For Pay Transparency information, please click here.
• Lead enterprise database strategy • Provide advanced administration, support, and troubleshooting for database systems • Define and drive enterprise database standards • Support disaster recovery processes • Collaborate with IT representatives across multiple business units • Ensure database environment is stable, secure, and scalable • Mentor and develop database administration talent • Maintain strong vendor knowledge
Database Architect
MetrcMetrc is the most trusted and experienced provider of cannabis regulatory systems.
• Evaluate and redesign heavily denormalized SQL Server database environments. • Architect solutions to separate historical data from real-time OLTP workloads. • Reduce table bloat and optimize large-scale tables for read/write performance. • Optimize indexing strategies, query performance, and access patterns across large datasets. • Assess and execute consolidation of approximately 30 independent database pods into a unified architecture. • Design and implement scalable multi-tenant database models. • Lead migration strategy from SQL Server to PostgreSQL where appropriate. • Work extensively within Azure environments, including Azure SQL Hyperscale. • Establish data lifecycle management practices and ETL/data movement strategies. • Operate directly in production systems, diagnosing and resolving complex technical challenges. • Lead modernization efforts through hands-on execution and technical example.
SQL Server Database Administrator
RESPECAchieving the impossible. Transforming our clients' visions into reality.
• Maintain, enhance, and further develop a long-lifespan, stored-procedure–centric application. • Lead query tuning, indexing, and performance diagnostics for large-scale, complex databases. • Design, develop, and deploy mission-critical SSRS reports. • Partner with internal client managers to capture business requirements and translate them into actionable technical tasks. • Manage and prioritize technical tasks triaged through the help desk (Javan). • Document all database changes and uphold best practices for multi-environment migrations. • Contribute to database design patterns for new or enhanced modules.



