Job ID: OR-65096 (910591205)
Part-Time (20 hrs/wk) Remote/Local Oracle/SQL Server DBA (both must/15+) with Data Analysis/Modeling, VM, TOAD, PostgreSQL, T-SQL, PL/SQL, CI/CD, UNIX/AIX, shell scripting, CRON, Azure, legacy modernization, agile experience
Location: Salem, OR (OYA)
Duration: 12 Months
Skills:
Database Data Analysis Expert (10+ Years) Yes
Database Data Modeling Expert (10+ Years) Yes
Database DBA Expert (10+ Years) Yes
Database Microsoft SQL Server Proficient (4-6 Years) Yes
Database Oracle Expert (10+ Years) Yes
Database PostgreSQL Proficient (4-6 Years) No
Database Transact-SQL Expert (10+ Years) Yes
Languages PL/SQL Expert (10+ Years) Yes
Languages SQL Expert (10+ Years) Yes
Operating Systems Shell Proficient (4-6 Years) No
Description:
OYA is in the implementation phase of modernizing their core application, a juvenile justice information system (JJIS), used by approximately 2500 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 (DBA) staff to work part-time (fully remote; 20 hours/week; 5 days M-F; preferably 8:00 am 12:00 pm PST time zone) to support Legacy Database/environments as well as modernized efforts.
List of desired attributes of applicants
Minimum of 9 years of experience as an Oracle Database administrator (DBA) managing, tuning on-prem Oracle databases (11g, 12c, or newer)
Minimum of 9 years of experience in writing, optimizing and troubleshooting complex SQL queries, stored procedures, triggers, and modernization scripts to support conversion and application transition.
Minimum of 9 years of 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 of experience working with CI/CD pipelines
Minimum of 5 years of 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.
Top Job Duties
Design, develop and execute scripts and processes.
Understand, evaluate the impact and communicate on the changes that are needed for this project.
Review, approve and implement views, PL/SQL procedures and functions.
Participate at relevant team meetings such as technical, architecture, standup as needed.
Learn and enforce data access controls in support of JJIS data access policies. Support the data access 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 support and operational with the legacy application and modernized application, with both applications working 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 Helpdesk service tickets.
innoSoul, Inc. is an Information Technology company and offers technology solutions in various platforms to different business domains. More specifically, business solutions for Application Development, System integration, network or software installation support, Custom Web Development, Hosting solutions. Our value-added solutions leverage technology to enhance business performance, increase productivity and secure data.
...~ Proficiency with AI tools and prompt engineering to boost creativity and productivity.... ...~ Moderate noise (i.e., phone calls, online meetings, computer audio). ~ While performing... ...Applicants are considered for positions and are evaluated without regard to mental or physical...
...our customers in an incident and injury free manner. The Fuel Delivery Truck Driver (FDTD) plays a vital role in our success and has the... ...required (every three years).~Must be able to obtain a Transportation Worker Identification Card (TWIC) within sixty days of hire...
...Low As Reasonably Practicable (ALARP) and delivering assurance to all downstream maritime assets involved in the transportation of Shell cargo on the water. Additionally, the team provides security support to Upstream and Project assets in designated Maritime Security...
The Center Manager is responsible for the day-to-day operations of this retail location. He or she will open and close the center, manage productivity and ensure the centers team delivers world-class customer service to all customers, monitor cost control and expenses,...
...The International Spine, Pain & Performance Centeris currentlyseeking an Interventional Pain Medicine Physician! The International Spine, Pain & Performance... ...candidate will be expected to perform evaluation and management of acute and chronic pain patients with a robust...