Overview
Hybrid
$85 - $92
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 Month(s)
50% Travel
Skills
PL/SQL
Oracle
Job Details
Job Description
The State of Maine is looking for an experienced Senior Developer / Data
Architect who:
1. Has extensive practical experience with the modern Oracle platforms and
technologies. This includes the following:
A. Significant Senior DBA-level experience with regards to designing and
implementing enterprise class data repositories built upon Oracle on-
prem and cloud-hosted databases.
B. Practical experience developing fully automated ETL processes from a
variety of flat-file and DB sources.
C. Practical experience utilizing API calls for automated data refreshes.
D. Practical experience with Oracle Analytics Cloud (OAC)
E. Mastery of SQL and PL/SQL and the ability to develop complex
procedures, functions, views, and scripts.
2. Expertise in dimensional modeling.
3. Experience with tabular data models.
4. Proven ability to accurately capture complex business requirements and
translate those into technical solutions which are robust, performant, scalable,
reliable, and expandable.
5. Demonstrates a disciplined approach to process and error logging.
6. Maintains excellent work habits when it comes to coding comments, system
documentation, and metadata creation.
7. Ability to serve as a technical mentor to both senior and junior IT staff.
8. Ability to develop architectural diagrams and system documentation, and train
others on the content.
9. Demonstrates previous success in independently researching technical options
to find suitable solutions for evolving technical needs.
10. Works independently towards project and/or assignments goals with limited day-
to-day oversight and/or prompting.
Typical Duties: This individual will serve as a daily subject-matter expert for all Oracle
technologies and toolsets. Much of the work will focus on data modeling and
developing automated ETL processes that pull data from a variety of data
sources. However, data assignments will not be limited to these areas. They will be
expected to develop, monitor, and maintain a variety of automated DB processes. They
will be expected to research and resolve database issues as they arise. They will be
assigned a variety of database management and maintenance tasks. They will serve
as a trusted technical advisor to the Maine Department of Transportation (MDOT) and
serve as a technical mentor to other IT staff. They will collaborate with other
developers, analysts, and DBAs employed by the MDOT and MaineIT. They will work
closely with IT vendors, IT leadership, and MDOT business partners. They will play a
key role in upcoming system migrations, system expansions, and data modernization Role.
Requirements
Minimum of 5 years' experience as a Data Architect.
Practical experience developing fully automated ETL processes from a variety of flat-file and DB sources.
Significant Senior DBA-level experience with regards to designing and implementing enterprise class data repositories built upon Oracle on-prem and cloud-hosted databases.
Expertise in dimensional modeling.
Ability to act as a technical mentor to junior developers.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.