Database Administrator

Novalink Solutions LLC • Little Rock, AR

3d

About The Position

The Administrative Office of the Courts (AOC) Court Information Systems Division is building an Agile team to modernize court management applications and support continuous improvement and development. The Division acquires, develops, enhances, implements, and supports court technologies and related data-sharing interfaces, infrastructure, security, training, and help-desk services for the State’s courts and justice partners.

AOC Database Administrators develop and support relational databases for AOC applications, including standalone, client-server, and web-based databases, and assist with the development and enhancement of database architecture. They must be familiar with the applications they support and have expertise in the technologies used to develop and manage application databases. The role includes administration of databases and application servers, database design and performance work, application support, documentation, and collaboration with technical and non-technical colleagues and court personnel.

Requirements

• Bachelor’s degree in Computer Science or a related field.
• At least five years of relevant experience.
• At least 7 years of database administration experience.
• At least 5 years of database design experience.
• At least 3 years of Oracle RAC experience.
• At least 5 years of SQL Server experience.
• At least 7 years of backup, recovery, and tuning experience.
• At least 5 years of access security and database integrity experience.
• At least 5 years of Linux server experience.
• At least 5 years of Windows operating systems experience.
• At least 3 years of UI/UX design experience.
• At least 3 years of experience with Oracle Forms, Oracle Reports, and Crystal Reports.
• At least 2 years of Jasper experience.
• At least 3 years of Business Intelligence experience.
• Knowledge and experience with Oracle RAC, single-instance Oracle databases, and SQL Server.
• Knowledge of DataGuard, database backup and recovery, access security, database integrity, performance tuning, physical data storage design, and storage management.
• Knowledge of cloud technologies and database administration on Linux and Windows server operating systems.
• Ability to develop, optimize, tune, and maintain Oracle databases and application servers, and apply upgrades and patches to Oracle databases and applications.
• Ability to assist with report development using Oracle Reports, Crystal Reports, Jasper, and Business Intelligence tools.
• Ability to assist with database application development using Java, JavaScript, Windows .NET Framework, XML, JSON, C, C++, ProC, Perl, Oracle Forms, and PL/SQL.
• Required certifications; relevant advanced technical certifications are highly desired.
• Knowledge of database design and development methodologies, including change and version control.
• Experience supporting the application system development life cycle and familiarity with DevOps and Agile methodologies.
• Strong computer skills, including proficiency with Windows and Linux server operating systems and Microsoft Office 365.
• 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 organizational skills.
• Excellent oral and written communication skills, including the ability to communicate effectively with technical and non-technical, legal and non-legal, court and non-court personnel.
• Ability to operate standard office equipment and computer software.
• Ability to maintain a high degree of integrity, decorum, and respect when working with court personnel.

Nice To Haves

• Relevant advanced technical certifications.
• Knowledge of Arkansas court systems and understanding of technology used in court applications.
• Some knowledge of Arkansas court case-management practices, business processes, and procedures.
• Experience managing Oracle, SQL Server, PostgresDB, Amazon RDS, Amazon Aurora, and application servers.

Responsibilities

• Monitor, optimize, and tune application databases for performance; troubleshoot reported database issues.
• Provide technical assistance to application users in coordination with support groups, including in person, by telephone, or by email.
• Administer Oracle databases, including single-instance and RAC environments; create databases and perform backup, recovery, and performance tuning.
• 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 resolve technical problems.
• Allocate system storage and plan future database storage requirements.
• Create and modify database storage structures and objects, including tablespaces, tables, views, and indexes.
• Control and monitor database user access; maintain access security, database integrity, and backup and recovery policies and procedures.
• Maintain database and application server documentation, standards, progress reports, and records of procedures and activities.
• Assist developers with data modeling, database design, reports, and application development.
• Develop, debug, and maintain stored procedures, database packages, views, and utilities for monitoring and maintaining Oracle database environments.
• Support the application system development life cycle, coordinate software releases, follow quality standards, and engage in ongoing process improvement.
• Write and execute database design specifications and perform other duties as assigned.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level