Wits Solutions Inc

Receive alerts when this company posts new jobs.

Similar Jobs

Job Details

Oracle Database Administrator

at Wits Solutions Inc

Posted: 11/5/2020
Job Reference #: 12867577
Keywords: computer, system

Job Description

Role : Oracle Database Administrator
Location : San Antonio, TX
Duration : Full Time

Essential Duties & Responsibilities:
  • Demonstrate an understanding of PL/SQL constructs (triggers, functions, packages, procedures) and their processing
  • Create, alter, and drop database users
  • Monitor and audit web server and database access
  • Develop and implement a strategy for managing security (roles, privileges, authentication)
  • Perform daily web and database server backups
  • Perform daily server health checks and log findings
  • Allocate and manage physical storage structures (e.g. datafiles, redo logs, control files)
  • Troubleshoot and resolve web and database server issues
  • Troubleshoot and resolve user connection problems
  • Troubleshoot database application issues to include reviewing applicable error logs on both web and database servers
  • Diagnose and resolve locking conflicts
  • Performance tuning
  • Use data dictionary tables and views
  • Demonstrate and understanding of the capabilities of the underlying operating system as it relates to the Oracle database and and/or any supported optional products
  • Perform complete system shutdown and startup as required
  • Track database metrics and provide to management upon request
Bachelor's degree in computer science, information technology/related discipline is required plus a minimum of 5 years of relevant experience; or Master's degree plus a minimum of 3 years of relevant experience.

Relevant Experience:
  • The ability to script in C, Bourne or Korn shells
  • Moderate level of experience using Oracle Golden Gate
  • A thorough knowledge and understanding of Oracle Label Security (OLS)
  • An intermediate level of knowledge or higher of the Apache web server functionality and configuration
  • An intermediate level of knowledge building and maintaining Storage Area Network (SAN)
  • Moderate level of experience with system networking to include knowledge of routers and switches
Security Requirements:
TS/SCI with Polygraph, obtainable within reasonable time based on requirements

Physical Requirements: This position requires employees to be willing and able to: sit, bend, reach, stoop, squat, stand, and walk.
Communication: Excellent customer service via phone and face to face conversation, excellent written and oral command of Englis