Expedite Talent Solutions ยท 7 hours ago
Database Administrator
Expedite Talent Solutions is seeking a Database Administrator to support the modernization of their juvenile justice information system. The role involves managing and optimizing Oracle databases, developing scripts, and ensuring data access controls while working with various teams on the modernization project.
IT ManagementProfessional ServicesWarehousing
Responsibilities
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
Qualification
Required
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 In Organizational Skills, Communication Skills, And Collaboration
Preferred
Experience working within Juvenile Justice or related domain and Applications hosted on Azure cloud is a plus
Experience working within an agile methodology is a plus
Company
Expedite Talent Solutions
Expedite Talent Solutions is a minority- and woman-owned firm delivering agile staffing, project outsourcing, and professional services to clients across the Healthcare, Commercial, and Public Sectors.