Skip to main content

Database Developer

Technology
1 month ago
Service contractOn-site

Job description

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.
Keywords
time-and-attendancestate-local-municipallocal-governmenttraining-and-developmentyouth-organizations-resourcesplanning-and-designvisual-art-designproduct-development-and-designconstructive-feedbacktesting-and-analysiserrors-omissions-e-oerror-handlingcompliancesensors-test-measurementreporting-and-disclosureadaptive-project-management-and-reportingdata-qualityextract-transform-and-load-etlapp-developmentapplication-development

Interested in this role?