Database Administrator - Onsite

𝐓𝐢𝐭𝐥𝐞: Database Administrator - Onsite

 

 

 

𝐌𝐚𝐧𝐝𝐚𝐭𝐨𝐫𝐲 𝐬𝐤𝐢𝐥𝐥𝐬:

 

Database Administrator,

Arkansas court case management practices, business processes, procedures,

database design,

Oracle RAC, single instance, SQL Server,

DataGuard, database backup, recovery procedures, access security, database integrity, database performance tuning, physical data storage design, data storage management,

application system development life cycle, Cloud Technologies, database design, development methodologies, change, version control,

ongoing process improvement, coordinating software releases, quality standards, documentation, record keeping procedures,

database administration, Linux, Windows server operating system, Oracle database, application servers,

Oracle Reports, Crystal Reports, Jasper, Business Intelligence, Oracle application server administration, Oracle Server, application development programs, Oracle features, Oracle related products, Oracle Forms,

Java, JavaScript, Windows .NET framework, XML, JSON, C, C++, ProC, Perl, Oracle Forms, PL/SQL,

 

 

 

𝐃𝐞𝐬𝐜𝐫𝐢𝐩𝐭𝐢𝐨𝐧:

 

The AOC Database Administrators are responsible for developing and supporting and future development of AOC application relational databases including standalone, client-server and web-based databases.

 

The Administrative Office of the Courts (AOC) is building a team of generalizing specialists utilizing the Agile methodology to modernize a suite of court management applications.

 

The Court Information Systems (CIS) Division of the AOC is responsible for acquiring, developing, enhancing, implementing, and supporting court technologies for the client. The Division provides applications for case management, jury management, attorney management, electronic filing, online public access, online payment, online jury interaction, and the Judiciary Website.

 

In addition to the applications, CIS has worked with several client to develop data sharing interfaces with other client systems. CIS maintains the infrastructure and security to support the systems and services provided, and the Division provides training, education, and help desk support for the thousands of users of the court management systems. The client provides project management expertise to the Division and AOC to ensure successful delivery of technology projects.

 

The Division hosts an annual ACAP Systems Conference for the customers who use the AOC-provided systems. The CIS Division is continuing to roll out applications to courts around the state while working to modernize the systems upon which the courts, justice agencies, and law enforcement rely. Our mission is providing technology to ensure justice. Our vision is innovative technology supporting access to justice anytime, anywhere, on any device.

 

In support of our modernization effort, we are building an Agile team capable of modernizing our applications and building a stream of continuous improvement and continuous development. We are seeking team members experienced with UI/UX design and full-stack development in modernizing legacy applications built on Oracle databases using Oracle Forms. Team members with experience in legacy and state-of-the art technologies will be optimal candidates.

 

Summary

The AOC Database Administrators are responsible for developing and supporting AOC application relational databases including standalone, client-server and web-based databases. DBAs are also responsible for assisting in the further development and enhancement of the architecture. DBAs are required to be familiar with the applications for which they are providing database administration, and experts in the technologies used to develop and manage application databases.

 

Education/Experience

The formal education of a bachelor’s degree in Computer Science or a related field and at least five years relevant experience. Relevant advanced technical certifications, and experience managing Oracle, SQL Server databases ,PostgresDB, Amazon RDS, Amazon Aurora, and application servers are highly desired. Knowledge of client court systems and understanding of the use of technology in court applications is highly desirable. DBAs must have strong computer and communication skills, including proficiency in using Windows, and Linux server operating systems, Microsoft Office 365, strong interpersonal skills, excellent organizational skills, the ability to work independently, multitask and the ability to meet deadlines. DBAs must be familiar with industry accepted business practices, DevOps and agile methodologies.

 

 

Required Knowledge, Abilities, and Skills

Some knowledge of Arkansas court case management practices, business processes and procedures are helpful.

Expert Knowledge of database design.

Knowledge and experience in Oracle RAC, single instance and SQL Server.

Knowledge of DataGuard, database backup and recovery procedures, access security and database integrity, database performance tuning, physical data storage design and data storage management.

Experience and knowledge in supporting application system development life cycle.

Engage in ongoing process improvement.

Assist in coordinating software releases.

Follow quality standards.

Ability to work in a team.

Knowledge of Cloud Technologies.

Knowledge of basic documentation and record keeping procedures.

Knowledge of database design and development methodologies, including change and version control.

Knowledge of database administration in Linux, and Windows server operating system.

Ability to develop, optimize, tune and maintain Oracle database and application servers.

Ability to apply upgrades and patches to Oracle databases and applications.

Ability to assist programmers developing reports using Oracle Reports, Crystal Reports, Jasper, Business Intelligence.

Ability to assist programmers developing database applications using Java, JavaScript, Windows .NET framework, XML, JSON, C, C++, ProC, Perl, Oracle Forms, PL/SQL.

Ability to effectively multitask.

Ability to work independently and as part of a team.

Ability to work well under pressure and meet deadlines.

Ability to operate standard office equipment and computer software.

Ability to provide database application support in person and by telephone or e-mail to judicial branch employees.

Ability to write and execute database design specifications.

Ability to develop and debug stored procedures, database packages, and database views.

Strong analytical and creative, problem-solving skills.

Strong interpersonal skills.

Excellent oral and written communication skills including the ability to communicate effectively with court and non-court, legal and non-legal, technical and non-technical persons.

Other duties as assigned.

 

Examples of Work

Monitor, optimize and tune application databases for maximum performance.

Troubleshoot user-reported database issues.

Work with all Support Groups to provide technical assistance to application users when needed.

Document and report on daily progress, procedures and activities.

Maintain database and application server documentation.

Daily Oracle database administration, creation, performance tuning, backup and recovery of Oracle systems including single instance and multiple instance (RAC) databases.

Daily Oracle application server administration.

Install and upgrade Oracle Server, clients and application development programs.

Evaluate Oracle features and Oracle related products.

Work with software vendors to identify and resolve technical problems.

Allocate system storage and plan future storage requirements for all database systems (capacity planning).

Create primary database storage structures (tablespaces) and primary objects (tables, views, indexes).

Modifying the database and physical structure of the database, if necessary.

Control and monitor user access to the database.

Establish and maintain sound backup and recovery policies and procedures.

Setup and maintain documentation and standards.

Assist developers with data modeling and database design.

Develop, maintain and manage utilities for monitoring and maintaining the Oracle database environments.

 

Working Relationships

The DBAs have regular contact with elected court officials and court staff, department staff, other state agency/institutions personnel. As representatives of the AOC, the DBAs must maintain a high degree of integrity, decorum and respect for court personnel at all times and possess the ability to communicate with court personnel on all levels. These positions work closely with AOC technical and non-technical staff to develop and maintain application databases that will be used by members of the judiciary and the public.

 

 

 

Skill - Required / Desired - Amount of Experience

Database Administraiton - Required - 7 Years

Database Design - Required - 5 Years

Oracle RAC - Required - 3 Years

SQL Server - Required - 5 Years

Backup, Recovery, Tuning - Required - 7 Years

Access Security and Database Integrity - Required - 5 Years

Linux Server - Required - 5 Years

Windows Operating Systems - Required - 5 Years

Ui/UX Design - Required - 3 Years

Oracle Forms, Oracle Reports, Crystal Reports - Required - 3 Years

Jasper - Required - 2 Years

Business Intelliigence - Required - 3 Years

Java, JavaScript, Windows .Net Framework - Required

XML, JSON, C, C++, ProC, Perl, PL/SQL - Required

DevOps & Agile Methodologies - Required

Certifications - Required

 

 

 

VIVA USA is an equal opportunity employer and is committed to maintaining a professional working environment that is free from discrimination and unlawful harassment. The Management, contractors, and staff of VIVA USA shall respect others without regard to race, sex, religion, age, color, creed, national or ethnic origin, physical, mental or sensory disability, marital status, sexual orientation, or status as a Vietnam-era, recently separated veteran, Active war time or campaign badge veteran, Armed forces service medal veteran, or disabled veteran. Please contact us at for any complaints, comments and suggestions.

 

 

𝐂𝐨𝐧𝐭𝐚𝐜𝐭 𝐃𝐞𝐭𝐚𝐢𝐥𝐬 :

 

Account co-ordinator: Nivas Palanisamy

 

 

VIVA USA INC.

3601 Algonquin Road, Suite 425

Rolling Meadows, IL 60008