Knowledge Services is seeking a remote Database Developer for a contract through the end of June 2027 (potential for extension) with the State of Maine Office of Information Technology.
- Applicants are able to work 100% remotely (Must be currently based in either the EST or CST time zones)
- Applicants must have prior experience in federal, state, or local government
- Please note that we cannot accept any candidates requiring C2C or those requiring sponsorship for a work visa.
The Database Developer Responsibilities include:
- 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.
- As a senior resource, the Programmer (Specialist) is expected to work with limited supervision and exercise sound technical judgment.
- The resource must be capable of independently analyzing complex systems and data issues, determining an appropriate course of action, and carrying work through development, testing, implementation, and production validation.
- 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.
Database Developer Required Skills:
- Minimum of 7 years application development, database programming, and production-support experience.
- Minimum of 5 years of hands-on experience with Oracle databases, SQL, and PL/SQL.
- Experience must include work with data warehouses and ETL processes.
- Experience must include work with data warehouses, ETL processes, production data loads, performance analysis, defect correction, and data-quality validation.
- Experienced with Data-warehouse concepts, including dimensional data structures, source-to-target mappings, data reconciliation, and reporting dependencies.
- Experienced with Unit, integration, system, regression, and data-validation testing.
- Previous local, state, or federal government experience (strongly preferred)
Preferred:
- The resource must demonstrate senior-level experience developing, maintaining, troubleshooting, and optimizing complex database applications and data-processing solutions.
- The resource must demonstrate 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.
- Production support and incident investigation involving SQL, PL/SQL, ETL processes, and data-warehouse workloads.
- Source-code management, controlled deployments, and standard software-development lifecycle practices.
Knowledge Services
