Computer Systems Programmer - Operations & Maintenance
Position: Computer Systems/Programmer - Operations and Maintenance
Location: Remote
Clearance: Must be eligible to obtain a Public Trust (US citizen/Green Card)
Salary: $130k/year + comprehensive benefits package
Role Description
We are seeking a highly skilled resource to support ongoing Operations & Maintenance (O&M) activities for a mission-critical system. This role requires deep expertise in SQL, XML ingestion and processing, and relational databases, with a strong emphasis on operational stability, data integrity, and production support. The ideal candidate will be hands-on, detail-oriented, and comfortable working in production environments, supporting batch processes, troubleshooting data issues, and collaborating closely with application, infrastructure, and business stakeholders.
Key Responsibilities
- Support day-to-day Operations & Maintenance (O&M) activities, including monitoring, troubleshooting, and resolving production issues
- Perform SQL development and analysis, including complex queries, data validation, reconciliation, and performance tuning
- Manage and support XML ingestion pipelines, including parsing, transformation, validation, and error handling
- Investigate and remediate data quality and data integrity issues across systems
- Support and execute batch jobs and scheduled processes, including reruns, validations, and post-run analysis
- Work with relational databases (e.g., Oracle, SQL Server, PostgreSQL) to maintain schema integrity and optimize performance
- Analyze logs, database records, and system outputs to identify root causes of defects or failures
- Partner with development teams to support releases, hotfixes, and production deployments
- Document operational procedures, runbooks, and knowledge transfer materials to reduce single points of failure
- Participate in on-call or after-hours support as required
Required Skills & Qualifications
- Strong hands-on experience with SQL, including:
- Complex joins, subqueries, and performance tuning
- Data reconciliation and root-cause analysis
- Proven experience working with XML:
- XML parsing, validation, transformation
- Ingestion and processing of large XML datasets
- Solid background in Operations & Maintenance (O&M) or production support environments
- Experience with relational databases (Oracle, SQL Server, PostgreSQL, MySQL, etc.)
- Strong troubleshooting skills with a focus on data-centric issues
- Familiarity with batch processing frameworks and schedulers
- Experience supporting applications in lower and production environments
- Ability to follow and improve operational processes while maintaining strict change control
- Scripting experience (Python, Shell, PowerShell, etc.) for automation and operational tasks
- Familiarity with logging and monitoring tools (Splunk, etc.)
- Experience supporting government or regulated environments
- Understanding of data governance, auditability, and compliance requirements
- Prior experience documenting SOPs and training O&M staff
Soft Skills & Attributes
- Strong attention to detail and commitment to data accuracy
- Clear written and verbal communication skills
- Ability to work independently in a fast-paced production environment
- Proactive mindset with a focus on risk reduction and operational stability
- Collaborative and inclusive team player who can effectively partner across technical and non-technical teams