Programmer OIT

Location: Augusta ME

Onsite Flexibility: Remote (Eastern and Central Time Zones preferred)

• Position Type: Contract
• Contract Duration: Project-based (ask recruiter)
• Pay Rate: $62.00$62.01 / Hour (USD)
• Work Authorization: Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.

This role is for a senior-level Programmer (Specialist) responsible for application development database programming and production support. The resource is expected to work with limited supervision and exercise sound technical judgment independently analyzing complex systems and data issues determining an appropriate course of action and carrying work through development testing implementation and production validation.

• Monitor and validate scheduled and ad hoc data loads reconcile source and target results investigate discrepancies and resolve data-quality issues.
• Investigate production incidents analyze application and database behavior identify root causes correct defects and verify that solutions do not introduce unintended impacts.
• Translate business needs operational concerns and user-reported issues into clear technical requirements and workable solutions.
• Review and fully understand assigned tasks applicable requirements dependencies expected outcomes and acceptance criteria before beginning development work. The resource must seek clarification when requirements are incomplete inconsistent or ambiguous.
• Analyze design specifications and proposed solutions identify technical risks or limitations and provide constructive feedback regarding alternative designs implementation methods and performance considerations.
• Develop and execute appropriate unit integration system regression and data-validation tests. Testing must confirm technical functionality data accuracy error handling and compliance with defined requirements.
• Create and maintain accurate system program operational support and user documentation.
• Participate effectively in reviews of system designs database designs source code test plans implementation procedures and deployment activities.
• Assist technical and business users in understanding application functionality warehouse data data relationships and reporting capabilities.
• Manage assigned work independently organize priorities meet established deadlines and coordinate effectively with other team members.
• Identify and communicate risks dependencies technical concerns and blockers promptly including their potential effects on scope schedule system performance and data quality.
• Communicate incident status technical findings recommended solutions implementation progress and resolution details clearly to customers stakeholders and technical team members.
• Anticipate downstream effects on applications ETL processes warehouse data interfaces and reports.
• Evaluate more than one potential solution and explain the benefits risks effort and maintainability of each approach.
• Produce reliable maintainable secure and well-documented code.
• Provide technically sound recommendations and respectfully challenge a proposed design when a more effective approach is available.
• Collaborate effectively with developers analysts database administrators business users project managers and support personnel.
• Take ownership of assigned work and production issues through completion.
• Explain complex technical matters in language appropriate for both technical and nontechnical audiences.

• Advanced proficiency in Oracle relational database technologies.
• PL/SQL development including packages procedures functions triggers and complex stored program units.
• Writing analyzing and optimizing complex SQL queries.
• Oracle SQL Developer or comparable Oracle development and diagnostic tools.
• Troubleshooting existing application code and identifying the underlying cause of defects.
• SQL and PL/SQL performance analysis including the ability to identify inefficient queries execution-plan issues indexing opportunities and database-related performance bottlenecks.
• ETL processing data integration data transformation and batch data-loading operations.
• Data-warehouse concepts including dimensional data structures source-to-target mappings data reconciliation and reporting dependencies.
• Production support and incident investigation involving SQL PL/SQL ETL processes and data-warehouse workloads.
• Unit integration system regression and data-validation testing.
• Source-code management controlled deployments and standard software-development lifecycle practices.

• Minimum of seven (7) years of progressively responsible application development database programming and production-support experience including at least five (5) years of hands-on experience with Oracle databases SQL and PL/SQL.
• Senior-level experience developing maintaining troubleshooting and optimizing complex database applications and data-processing solutions.
• Experience must include work with data warehouses ETL processes production data loads performance analysis defect correction and data-quality validation.

• Medical Vision and Dental Insurance Plans
• 401k Retirement Fund

This Augusta-based public-sector employer operates in the government and community services space delivering justice education and economic development programs. Serving residents and stakeholders across Maine the organization engages professionals spanning technology program administration legal services and workforce development functions.

GTT is a minority-owned staffing firm and a subsidiary of Chenega Corporation a Native American-owned company in Alaska. We highly value diverse and inclusive workplaces and support Fortune 500 organizations across banking financial services technology life sciences biotech utilities and retail sectors throughout the U.S. and Canada.

Job Number: 26-14216 Industry: Software Engineering

#LI-Remote