Oracle Database Administrator

Career Soft Solutions Inc; Arkansas; Presencial; USD 85.000 - 110.000; Jornada completa

Descripción de la vacante

Career Soft Solutions Inc. seeks an AOC Database Administrator 3 for on-site work in Little Rock, AR. The role focuses on developing and supporting Oracle, SQL Server, PostgreSQL databases across standalone, client-server, and web-based applications.

Candidates should have a bachelor’s degree in CS and 5+ years of experience, with expertise in Oracle RAC, DataGuard, and cloud services like Amazon RDS/Aurora. You will work with DevOps and coordinate releases.

Formación

• Bachelor's degree in Computer Science or related field and 5+ years of relevant experience.
• Advanced certifications in Oracle/SQL Server/database technologies are highly desired.
• Strong knowledge of Windows and Linux server OS, and Office 365.
• Familiarity with DevOps, agile methodologies, and cloud technologies.

Responsabilidades

• Monitor, optimize and tune application databases for maximum performance.
• Troubleshoot user-reported database issues.
• Document and report on daily progress and procedures.
• Maintain database and application server documentation.
• Daily Oracle DB administration including backups and RAC management.
• Install and upgrade Oracle Server and clients.
• Assist developers with data modeling and database design.
• Establish backup and recovery policies and procedures.
• Coordinate software releases with stakeholders.

Conocimientos

Oracle DBA

SQL Server

PostgreSQL

RDS/Aurora

Windows/Linux admin

Performance tuning

Educación

Bachelor’s degree in CS or related field

5+ years relevant experience

Herramientas

Oracle RAC

DataGuard

Oracle RMAN

Crystal Reports

JasperReports

Descripción del empleo

Job Description :

Role : AOC Database Administrator 3 (only W2)

Location : Little Rock, AR 72201 (On-Site Work, Only Locals)

Mode of Interview : On-Site Interviews (ONLY for Local 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 Arkansas 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 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.