Database Administrator

Join to apply for the Database Administrator role at Expedite Talent Solutions
.

OYA is in the implementation phase of modernizing their core application, a juvenile justice information system (JJIS) used by approximately 2,500 end users in OYA and all 36 Oregon Counties. The legacy application uses an on‑prem Oracle database. OYA is working with a vendor to modernize this legacy application into a low‑code application and is looking for experienced Database Administrator staff to work part‑time (fully remote;

20 hours/week; 5 days M‑F; preferably 8 am – 12 pm PST time zone) to support legacy database environments as well as modernized efforts.

• Minimum of 9 years experience as an Oracle Database Administrator managing, tuning on‑prem Oracle databases (11g, 12c, or newer)
• Minimum of 9 years experience writing, optimizing and troubleshooting complex SQL queries, stored procedures, triggers, and modernization scripts to support conversion and application transition
• Minimum of 9 years experience managing and working with schemas, password management, security management, data mapping, tools (e.g. TOAD, SQL Developer), virtual machines, UNIX/AIX, Shell Scripting, CRON jobs
• Minimum of 5 years experience working with CI/CD pipelines
• Minimum of 5 years experience designing, developing and maintaining data interfaces and flat‑file exchange processes for integrations with external partners
• Experience working within Juvenile Justice or related domain and applications hosted on Azure cloud is a plus
• Experience in organizational skills, communication skills, and collaboration
• Experience working within an agile methodology is a plus

• Design, develop and execute scripts and processes
• Understand, evaluate, and communicate the impact and changes needed for the project
• Review, approve and implement views, PL/SQL procedures and functions
• Participate in relevant team meetings such as technical, architecture, stand‑up as needed
• Learn and enforce data access controls in support of JJIS data access policies; support the implementation
• Evaluate, monitor, maintain and ensure security controls, user access management, auditing and adherence to security policies and standards
• Ensure the current on‑premises database still supports operation with both the legacy and modernized applications running in parallel
• Maintain the JJIS database production, reports, test, development and other environments
• Support the OYA Developers, QA, Business Integration Team and vendor team in their work with the JJIS database, especially for the modernization project; monitor and support existing data interfaces and assist with JJIS help‑desk service tickets

• Seniority level:
  Mid‑Senior level
• Employment type:
  
  Part‑time
• Job function:
  Information Technology