Database Administrator

CAI • Little Rock, AR

2d • Onsite

About The Position

CAI is seeking a Database Administrator to develop, support, and enhance application relational databases, including standalone, client-server, and web-based databases for a client. The position is full-time, contract, and onsite in Little Rock, Arkansas. Applicants must be local and have work authorization that does not require sponsorship now or in the future.

The role includes Oracle database administration and application-server support, database development and design assistance, performance monitoring and tuning, backup and recovery, access control, documentation, technical support, and coordination with developers, support groups, and software vendors. The position also contributes to software releases and ongoing process improvement, follows quality standards, and performs other duties as assigned.

Requirements

• Bachelor’s degree in Computer Science or a related field.
• At least five years of relevant database administration experience.
• Seven years of Database Administration experience.
• Five years of Database Design experience.
• Three years of Oracle RAC experience.
• Five years of SQL Server experience.
• Seven years of backup, recovery, and performance tuning experience.
• Five years of access security and database integrity experience.
• Five years of Linux Server administration experience.
• Five years of Windows operating systems experience.
• Three years of UI/UX design experience.
• Three years of Oracle Forms experience.
• Three years of Oracle Reports experience.
• Three years of Crystal Reports experience.
• Two years of Jasper experience.
• Three years of Business Intelligence experience.
• Knowledge of database design and development methodologies, including change and version control.
• Knowledge of DataGuard, database backup and recovery procedures, access security, database integrity, database performance tuning, physical data storage design, and storage management.
• Knowledge of cloud technologies and documentation and record-keeping procedures.
• Experience supporting the application system development life cycle.
• Experience with Java, JavaScript, Windows .NET Framework, XML, JSON, C, C++, ProC, Perl, and PL/SQL.
• Experience with DevOps and Agile methodologies.
• Ability to develop, optimize, tune, and maintain Oracle databases and application servers.
• Ability to apply upgrades and patches to Oracle databases and applications.
• Ability to develop and debug stored procedures, database packages, and database views.
• Ability to write and execute database design specifications.
• Ability to work independently and as part of a team, multitask, and meet deadlines.
• Strong analytical and problem-solving skills and interpersonal skills.
• Excellent oral and written communication skills.
• Proficiency with Windows, Linux server operating systems, and Microsoft Office 365.
• Must have work authorization that does not require sponsorship now or in the future.
• Must be a local candidate.

Nice To Haves

• Advanced technical certifications.
• Experience managing Oracle, SQL Server, PostgreSQL, Amazon RDS, and Amazon Aurora databases.
• Experience managing application servers.
• Knowledge of Arkansas court systems.
• Understanding of the use of technology in court applications.
• Knowledge of Arkansas court case management practices, business processes, and procedures.

Responsibilities

• Develop and support application relational databases.
• Assist in developing and enhancing database architecture.
• Monitor, optimize, and tune application databases for maximum performance.
• Troubleshoot database issues reported by users.
• Work with support groups to provide technical assistance to application users.
• Document and report daily progress, procedures, and activities.
• Maintain database and application-server documentation.
• Perform Oracle database administration, including creation, performance tuning, backup, and recovery.
• Administer Oracle application servers.
• Install and upgrade Oracle Server, client, 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 database systems.
• Create and maintain tablespaces, tables, views, and indexes.
• Modify database structures as needed.
• Control and monitor user access to databases.
• Establish and maintain database backup and recovery policies and procedures.
• Maintain documentation and standards.
• Assist developers with data modeling and database design.
• Develop, maintain, and manage utilities for monitoring Oracle database environments.
• Assist in coordinating software releases.
• Engage in ongoing process improvement and follow quality standards.
• Provide database application support by telephone, email, and in person.
• Perform other duties as assigned.

Benefits

• Medical insurance.
• Dental insurance.
• Vision insurance.
• Access to a 401(k) retirement account.
• May be entitled to paid sick leave and/or other paid time off as provided by applicable law.

What This Job Offers

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