Sign upLog in

WAMS Technical Resource

Artech LLC

Seattle, WA(remote)

Apply
JOB DETAILS
SALARY
$60–$65 Per Hour
SKILLS
Acceptance Testing, Asset Management, Auditing, Automation, Business Processes, Business Support, Cloud Computing, Cloud Storage, Computer Science, Data Mapping, Data Processing, Data Sets, Data Structures, Database Extract Transform and Load (ETL), Identify Issues, Information Technology & Information Systems, Information/Data Security (InfoSec), Integration Testing, JSON, Linux Operating System, Operational Audit, Operational Support, Operations Management, Oracle, Oracle Database, Quality Assurance, Reconciliation, Relational Databases (RDBMS), Requirements Management, Root Cause Analysis, SQL (Structured Query Language), Scripting (Scripting Languages), Secure/SSH File Transfer Protocol (SFTP), Security Architecture, Stored Procedures, System Architecture, System Integration (SI), System Test, Systems Administration/Management, Systems Maintenance, Technical Support, Technical Writing, Testing, Unix Operating Systems, Unix Shell Programming, Validation Testing, XML (EXtensible Markup Language)
LOCATION
Seattle, WA
POSTED
2 days ago
Request ID: SAIJP00038891
Title:WAMS Technical Resource
Locations: 100% Remote
Duration: 6 Months contract with possible extension
Rate Range: $60 - $65/Hour on W2 (Without medical benefits & no PTO meaning no federal/national holidays as well)

Job Summary:
Client is seeking a WAMS Technical Resource who is motivated by variety, is seeking a challenging environment for professional growth, and is interested in running large information technology projects in various customer businesses areas at a Utility client headquartered in the Seattle area.
In this position you will be responsible for supporting enhancements, maintenance, and data operations within the current Oracle Utilities Work and Asset Management (WAMS) environment, while also enabling secure file-based integrations to Oracle Cloud.
The candidate should have strong backend development skills, SQL expertise, and Unix-based integration capabilities.
The ideal candidate has hands-on experience with Oracle Utilities WAM v1.9x, strong data processing and backend skills, and the ability to support existing Unix/Shell automation and file-transfer workflows as they transition toward cloud-based patterns.

Responsibilities:
  • Support and maintain backend processes within Oracle Utilities WAMS v1.9x
  • Develop and document reusable patterns for data extraction, transformation, and integration
  • Ensure data design supports operational needs, audit controls, and performance requirements
  • Support ingestion of GDE datasets into Oracle Autonomous Database (ADB).
  • Provide day-to-day technical support, troubleshooting, and data correction across WAMS components
Business Rule Definition & Functional Alignment
  • Collaborate with business stakeholders to understand and document WAMS functional processes
  • Translate business requirements into technical logic and backend data flows
  • Document representations of work orders, labor, materials, and assets within WAMS and ensure alignment to operational workflows
  • Support business process mapping by connecting backend design with field and back-office operations
Data Mapping & Integration
  • Map WAMS data structures for reporting, analytics, and cloud ingestion needs
  • Define transformation logic for exporting WAMS data into CSV, XML, JSON, or other structured formats
  • Architect secure and auditable data-exchange workflows leveraging SFTP and Unix-based file movement pipelines
  • Support the migration of existing file-transfer processes to Oracle Cloud Object Storage
Development & Technical Requirements
  • Develop SQL queries, stored procedures, scripts, and extraction routines for WAMS backend support
  • Build and maintain Shell/Unix scripts used for automation, data processing, and secure transfers
  • Ensure all integrations follow client architectural and security standards
  • Troubleshoot backend and integration issues, identify root causes, and implement lasting solutions
Feedback Loop & System Update Management
  • Develop or refine processes that interpret cloud ingestion feedback or batch responses
  • Create mechanisms to update WAMS with integration results, including reconciliation statuses, error records, and operational flags
  • Ensure all backend synchronization components are traceable and auditable
Testing, QA, and UAT Support
  • Support system integration testing and backend validation activities
  • Prepare test datasets, simulate end-to-end backend scenarios, and assist in triage
  • Document technical components thoroughly to ensure production readiness and long-term supportability
Required Education & Experience:
  • Bachelor s degree in business, Information Technology, Computer Science or related degree. Additional years of experience may be considered in lieu of degree
  • 5+ years hands-on experience with Oracle Utilities WAM (preferably v1.9x)
  • Strong backend development skillset including SQL, data extraction, and ETL workflows
  • Proficiency in Shell scripting, Unix/Linux environments, and secure file-transfer processes (SFTP)
  • Experience supporting or migrating file-based integrations to Oracle Cloud Object Storage
  • Strong understanding of relational database structures and enterprise data patterns
Preferred Qualifications:
  • Experience working in utility operations or asset management environments
  • Familiarity with transitioning legacy processing pipelines to cloud-native approaches
  • Experience within regulated or municipal utility organizations
  • Background in large-scale data automation or backend pipeline development

About the Company

A

Artech LLC

Resume Resources

Free Resume TemplatesFree Resume Builder