Oracle Database Analyst

Job type:
Start date:
As soon as possible
6 Months
Software Specialists
South Carolina
Published at:
flag_no USA
Project ID:

This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Position: Oracle Database Analyst II

Location: Columbia, SC

Duration: 6 months (Long term need - Potential Hire)

Job Requirements:

  • Experience with Oracle 12c or higher in a Unix environment.
  • Wide range and extended knowledge and experience with SQL Server database, back-ups, recoveries, etc.
  • In-depth knowledge and experience with database performance
  • Oracle database backup and recovery(rman, datapump).
  • Oracle database installation, upgrade and patching.
  • Oracle Data Guard installation and support.
  • Light Unix Shell scripting
  • Data security technologies(encryption, masking, obfuscation....) - Nice to have
  • Experience Using Splunk for monitoring - Nice to have

Job Responsibilities:

  • Installation and maintenance of E-commerce Oracle Databases.
  • Support internal security requirements as they pertain to the Oracle databases.
  • Provide database support to Java developers.
  • Define data architecture standards for the organization, structure, attributes, and nomenclature of data elements. Design, develop, test, and implement new database objects (tables, views, indexes, databases, etc) and administer existing architectures supported for performance and maintenance related issues.
  • Analyze and recommend best practice steps to prevent potential database issues, such as performance degradation or potential loss of service and well as recommend actions to fix issues when database problems do occur (outages or potential errors). Recommend methods to recover or improve databases to include analysis/review of vendor products.
  • Provide input into complex decisions as they relate to data architecture, infrastructure and/or administration. Consult with information systems areas on database issues and proposed changes. Recommend tuning to databases and queries when they are not performing to customer requirements.
  • Analyze and recommend upgrades to database software and components based on security requirements, new technology, or evolving application system requirements. Analyze and recommend capacity planning (SAN storage) based on captured growth trends and monitoring.
  • Review database environments to ensure they meet security controls and audit requirements; continually mitigate identified risks and vulnerabilities. Ensure recoverability of databases by creating, scheduling and monitoring database backups for dependent systems.
  • Support management on enterprise wide and departmental goals and objectives. Provide education and information on security policies, practices, and awareness programs. May provide estimation on work efforts and recommendations on training plans for less experience staff.

Asir Franklin

Sr. Technical Recruiter