Unclassified

posted about 2 months ago

Full-time - Senior

About the position

Concept Plus is seeking a Senior Database Administrator to provide networking, infrastructure, and database support services. The ideal candidate will have a minimum of 10 years of experience as an Oracle DBA and must be able to demonstrate a working knowledge of Oracle databases version 19c and higher. This role requires experience with Oracle multitenant architecture as well as other Oracle add-on components. The candidate should also possess knowledge and experience in administering databases on other DBMS platforms such as MS SQL Server, Postgres, MySQL, and other SQL-based solutions. In this position, the Senior Database Administrator will be responsible for managing various backup and recovery methods, including but not limited to datapump, RMAN, and cloning. The candidate should have experience in recovering databases due to disasters or corruption and should be adept at creating both logical and physical backups, with the knowledge to determine when to use either method. Familiarity with Linux is essential for proper navigation and minimal administration, along with experience in writing Bash scripts to monitor various aspects of all databases. The role also involves troubleshooting Oracle network issues surrounding OCI calls and listener problems, demonstrating concepts such as need to know and least privilege when configuring database access controls. The candidate should have experience with Oracle Advanced Security Option, specifically on Transparent Data Encryption, and possess in-depth knowledge of PKCS certificates, including experience with configuring and implementing certificates in Oracle wallet. Additionally, the candidate will be responsible for applying Oracle security patches and version upgrades to databases and underlying binaries, as well as the installation, configuration, and support of Oracle ORDS and APEX components. Knowledge of APEX API administrator commands for use on production systems and administering Oracle Cloud Infrastructure databases is preferred.

Responsibilities

  • Provide networking, infrastructure, and database support services.
  • Administer Oracle databases version 19c and higher.
  • Manage Oracle multitenant architecture and other Oracle add-on components.
  • Administer databases on other DBMS platforms (MS SQL Server, Postgres, MySQL, etc.).
  • Implement various backup and recovery methods including datapump, RMAN, and cloning.
  • Recover databases due to disasters or corruption.
  • Create logical and physical backups and determine when to use each.
  • Navigate and administer Linux systems effectively.
  • Write Bash scripts to monitor database aspects.
  • Troubleshoot Oracle network issues surrounding OCI calls and listener problems.
  • Configure database access controls with a focus on need to know and least privilege.
  • Implement Oracle Advanced Security Option and Transparent Data Encryption.
  • Configure and implement PKCS certificates in Oracle wallet.
  • Apply Oracle security patches and version upgrades to databases and binaries.
  • Install, configure, and support Oracle ORDS and APEX components.
  • Utilize APEX API administrator commands on production systems.
  • Administer Oracle Cloud Infrastructure databases.

Requirements

  • Minimum 10 years of experience as an Oracle DBA.
  • Working knowledge of Oracle databases version 19c and higher.
  • Experience with Oracle multitenant architecture and Oracle add-on components.
  • Knowledge and experience in administering databases on MS SQL Server, Postgres, MySQL, and other SQL-based solutions.
  • In-depth knowledge of various backup and recovery methods including datapump, RMAN, and cloning.
  • Experience in recovering databases due to disasters or corruption.
  • Experience in creating logical and physical backups and determining when to use either.
  • Experience with Linux for navigation and minimal administration.
  • Experience in writing Bash scripts for database monitoring.
  • Experience in troubleshooting Oracle network issues surrounding OCI calls and listener problems.
  • Demonstrated understanding of database access controls, including need to know and least privilege principles.
  • Experience with Oracle Advanced Security Option and Transparent Data Encryption.
  • In-depth knowledge of PKCS certificates and experience with Oracle wallet.
  • Experience with applying Oracle security patches and version upgrades.
  • Experience in the installation, configuration, and support of Oracle ORDS and APEX components.
  • Knowledge of APEX API administrator commands for production systems.
  • Knowledge in administering Oracle Cloud Infrastructure databases.

Nice-to-haves

  • Excellent documentation skills for capturing database component configuration instructions and standard operating procedures.
  • Thorough testing methodology for any database change or project.

Benefits

  • Competitive pay
  • Comprehensive health insurance
  • Dental and vision insurance
  • Paid life insurance
  • Paid time off
  • 11 paid holidays
  • Bonuses
  • Tuition reimbursement
  • Unlimited training
  • Collaborative, flexible, innovative work environment
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service