We are seeking an experienced Oracle Database Administrator (DBA) to join our IT team. The successful candidate will be responsible for the performance, integrity, and security of our Oracle databases, ensuring their optimal operation and availability.

Responsibilities

  • Database Management:
    • Install, configure, and upgrade Oracle database software and related products.
    • Create and manage database instances, storage structures, and objects.
    • Implement and maintain database backup and recovery strategies.
  • Performance Optimization:
    • Monitor and optimize database performance using tuning tools and techniques.
    • Analyze and resolve database performance issues, including query optimization and indexing strategies.
    • Implement and manage database clustering, replication, and load balancing.
  • Troubleshooting and Support:
    • Provide technical support and troubleshooting for database-related issues.
    • Resolve database incidents and problems, ensuring minimal downtime.
    • Collaborate with application developers and other IT staff to resolve complex issues.
  • Security and Compliance:
    • Implement and enforce database security measures, including user access controls and encryption.
    • Monitor database security and ensure compliance with industry standards and regulations.
    • Conduct regular security assessments and audits.
  • Data Integrity and Management:
    • Ensure data integrity and consistency through proper database design and maintenance.
    • Implement and manage data archiving, purging, and retention policies.
    • Support data migration and integration projects.
  • Documentation and Reporting:
    • Create and maintain database documentation, including configurations, procedures, and policies.
    • Prepare and maintain reports on database performance, capacity, and incidents.
  • Capacity Planning:
    • Monitor database capacity and utilization to ensure adequate resources for current and future needs.
    • Develop and implement database capacity plans and upgrades.
  • Automation and Scripting:
    • Develop and maintain scripts for database automation tasks, such as backups, monitoring, and maintenance.
    • Implement and manage database automation tools and solutions.

Qualifications

  • Education:
    • Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent work experience).
  • Experience:
    • Proven experience as an Oracle Database Administrator or similar role.
    • Hands-on experience with Oracle database software, tools, and technologies (e.g., Oracle DB, RMAN, ASM, Data Guard).
  • Skills:
    • Strong understanding of database concepts, including normalization, indexing, and transactions.
    • Proficiency in SQL and PL/SQL programming.
    • Experience with database performance tuning and optimization techniques.
    • Knowledge of database security practices and technologies.
    • Familiarity with database monitoring and management tools.
    • Excellent problem-solving and analytical skills.
    • Strong communication and interpersonal skills.
  • Certifications:
    • Relevant certifications (e.g., Oracle Certified Professional (OCP), Oracle Certified Expert (OCE)) are a plus.