Database Administrator
Req number: R8882
Employment type: Full time
Worksite flexibility: Onsite
Who we are
CAI is a global services firm with over 9,000 associates worldwide and a yearly revenue of $1.3 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right-whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.
Job Summary
As a Database Administrator, you will develop, support and enhance application related databases for our client. This is an onsite position in Little Rock, AR.
Job Description
We are looking for a Database Administrator to develop, support, and enhance application relational databases, including standalone, client-server, and web-based databases. This position will be full-time contract and onsite in Little Rock, AR. Only candidates with work authorization that does not require sponsorship now or in the future will be considered. Local candidates only, please.
What You'll Do
- Develop and support application relational databases
- Assist in the development and enhancement of database architecture
- Monitor, optimize, and tune application databases for maximum performance
- Troubleshoot user-reported database issues
- Work with support groups to provide technical assistance to application users
- Document and report on daily progress, procedures, and activities
- Maintain database and application server documentation
- Perform Oracle database administration including creation, performance tuning, backup, and recovery of Oracle systems
- 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 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
- Follow quality standards
- Provide database application support by telephone, email, and in person
- Perform other duties as assigned
What You'll Need
- Required: Bachelor's degree in Computer Science or a related field
- At least five years of relevant database administration experience
- 7 years of Database Administration experience
- 5 years of Database Design experience
- 3 years of Oracle RAC experience
- 5 years of SQL Server experience
- 7 years of backup, recovery, and performance tuning experience
- 5 years of access security and database integrity experience
- 5 years of Linux Server administration experience
- 5 years of Windows operating systems experience
- 3 years of UI/UX design experience
- 3 years of Oracle Forms experience
- 3 years of Oracle Reports experience
- 3 years of Crystal Reports experience
- 2 years of Jasper experience
- 3 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
- Knowledge of documentation and record-keeping procedures
- Experience supporting the application system development life cycle
- Experience with Java, JavaScript, Windows .NET Framework, XML, JSON, C, C++, Pro*C, 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
- Ability to multitask and meet deadlines
- Strong analytical and problem-solving skills
- Strong interpersonal skills
- Excellent oral and written communication skills
- Proficiency with Windows, Linux server operating systems, and Microsoft Office 365
- Preferred: Advanced technical certifications
- Preferred: Experience managing Oracle, SQL Server, PostgreSQL, Amazon RDS, and Amazon Aurora databases
- Preferred: Experience managing application servers
- Preferred: Knowledge of Arkansas court systems
- Preferred: Understanding of the use of technology in court applications
- Preferred: Knowledge of Arkansas court case management practices, business processes, and procedures