Job Description :

Education: Bachelor of Science degree in Computer Science, or related field, required.

Experience:

  • Five (5) years of experience installing, upgrading, and migrating Oracle 12c Business Intelligence and Oracle Security Suite.
  • Five (5) years of experience reading Entity Relationship Diagrams (ERD), dimensional models, and translating into table structures, keys, and indexes.
  • Five (5) years of experience reading and writing SQL and PL/SQL code.
  • Five (5) years of experience using Enterprise Manager to monitor system performance.
  • Five (5) years of experience writing batch programs using the alerts and scheduler features to create automatic monitoring and management processes.
  • Five (5) years of experience opening, closing, copying, importing and exporting SQL in Oracle databases.
  • Five (5) years of experience identifying and tuning both operating systems and Oracle Database Systems.
  • Five (5) years of experience with database backup and recovery.
  • Five (5) years of experience setting up and performing snapshots and replication.
  • Five (5) years of experience setting up and managing Oracle Real Application Clusters.
  • Five (5) years of experience managing and monitoring application output logs.
  • Five (5) years of experience with Oracle support filing technical assistance requests or service requests
  • Demonstrated knowledge of Oracle database management.
  • Prior senior level experience with Oracle database security and working with PII data.
  • Breadth of knowledge in database analysis.

Responsibilities:

  1. Define file organization, indexing methods, and security procedures for database and applications.
  2. Develop, implement, and maintain database back-up and recovery procedures for the processing environments, and ensure data integrity, security, and recoverability
  3. Install, manage, monitor, tune, and patch Oracle 12c databases and associated Oracle 12c products and applications.
  4. Implement, manage, and update Oracle Grid Control 12c.
  5. Monitor all servers and application environments for operation and security.
  6. Assist in the design, installation, and configuration of new and existing servers and their operating environments.
  7. Assist in the definition of best data center practices for the Oracle environment.
  8. Provide weekly status reports which include, but are not limited to:
  • Tasks Completed
  • Tasks Planned
  • Risks/Issues
  1. Perform other duties related to MLDS database administration as assigned by the Contract Manager.
             

Similar Jobs you may be interested in ..