AOC Database Administrator 3

Wiserhunt•Little Rock, AR

2d•Onsite

About The Position

The AOC Database Administrator develops, supports, and enhances relational databases for AOC applications, including standalone, client-server, and web-based systems. The role contributes to the architecture and modernization of court management applications and requires familiarity with the applications being supported and expertise in the technologies used to develop and manage their databases. The position is part of the Administrative Office of the Courts’ Court Information Systems Division, which acquires, develops, enhances, implements, and supports technology for Arkansas courts. The division’s systems include case, jury, and attorney management; electronic filing; public access; online payments and jury interaction; and the Judiciary Website, as well as data-sharing interfaces with other agencies. The team is using Agile methods to modernize legacy applications, including systems built on Oracle databases and Oracle Forms, and to support continuous improvement and development. The DBA monitors and maintains database and application-server environments, assists developers and users, manages releases and upgrades, and maintains documentation and standards. The role regularly communicates with court officials, court staff, AOC personnel, and other state agencies. Work is onsite in Little Rock, Arkansas; interviews are onsite and limited to local candidates.

Requirements

Bachelor’s degree in Computer Science or a related field.
At least five years of relevant experience.
Strong database design knowledge and experience with Oracle RAC, Oracle single-instance databases, and SQL Server.
Knowledge of DataGuard, database backup and recovery, access security, database integrity, performance tuning, physical data storage design, and storage management.
Experience supporting application system development life cycles.
Knowledge of database design and development methodologies, including change and version control.
Knowledge of database administration on Linux and Windows server operating systems.
Ability to develop, optimize, tune, and maintain Oracle databases and application servers, and to apply Oracle database and application upgrades and patches.
Strong computer skills, including proficiency with Windows, Linux server operating systems, and Microsoft Office 365.
Knowledge of DevOps and Agile methodologies, cloud technologies, and basic documentation and record-keeping procedures.
Ability to assist with database application development using Java, JavaScript, Windows .NET Framework, XML, JSON, C, C++, Pro*C, Perl, Oracle Forms, and PL/SQL.
Ability to assist with report development using Oracle Reports, Crystal Reports, Jasper, and Business Intelligence tools.
Ability to work independently and as part of a team; multitask, work under pressure, and meet deadlines.
Strong analytical, creative, and problem-solving skills; strong interpersonal skills; and excellent oral and written communication skills with technical and non-technical audiences.
Ability to operate standard office equipment and computer software and to provide database application support to judicial branch employees.
Ability to work onsite in Little Rock; onsite interviews are limited to local candidates.
Database administration experience: 7 years.
Database design experience: 5 years.
Oracle RAC experience: 3 years.
SQL Server experience: 5 years.
Backup, recovery, and tuning experience: 7 years.
Access security and database integrity experience: 5 years.
Linux server experience: 5 years.
Windows operating-system experience: 5 years.

Nice To Haves

Relevant advanced technical certifications.
Experience managing Oracle, SQL Server, PostgreSQL, Amazon RDS, Amazon Aurora, and application servers.
Knowledge of Arkansas court systems and how technology is used in court applications.
Knowledge of Arkansas court case-management practices, business processes, and procedures.
UI/UX design experience: 3 years.
Oracle Forms, Oracle Reports, and Crystal Reports experience: 3 years.
Jasper experience: 2 years.
Business Intelligence experience: 3 years.

Responsibilities

Develop, support, and enhance AOC application relational databases, including standalone, client-server, and web-based databases.
Assist with further development and enhancement of database architecture.
Monitor, optimize, and tune application databases for performance; troubleshoot user-reported database issues.
Provide technical assistance to application users in coordination with support groups, in person, by telephone, or by email.
Perform daily Oracle database administration, including creation, performance tuning, backup, and recovery for single-instance and RAC databases.
Administer Oracle application servers; install and upgrade Oracle servers, clients, and application development programs.
Evaluate Oracle features and related products, and work with software vendors to identify and resolve technical problems.
Allocate system storage and plan future capacity requirements.
Create and modify database storage structures and objects, including tablespaces, tables, views, and indexes.
Control and monitor database user access, and maintain database security and integrity.
Establish and maintain backup and recovery policies and procedures.
Maintain database and application-server documentation, standards, and records; document and report daily progress, procedures, and activities.
Assist developers with data modeling, database design, and report development.
Develop and maintain utilities for monitoring and maintaining Oracle database environments.
Assist with software releases, follow quality standards, and participate in ongoing process improvement.
Write and execute database design specifications; develop and debug stored procedures, database packages, and views.
Support the application system development life cycle and work with technical and non-technical staff to maintain application databases.
Perform other duties as assigned.