Logo
APN Consulting, Inc

Sr. Oracle DBA

APN Consulting, Inc, Purchase, NY, United States


Direct Client Requirement
Position Title:
Sr

Oracle DBA

Location: Remote
Duration: 3-4 months

We are looking for a Sr

Oracle DBA with 8+ years' experience

Essential Duties and Responsibilities:

An Oracle database administrator (DBA) is responsible for the management, security, and operation of Oracle databases:

  • Experience developing architectural and functional process diagrams for Oracle database services
  • Strong experience with Oracle 19 architecture and database infrastructure design.
  • Proficiency in Oracle Multitenancy, including managing and maintaining Container and Pluggable databases.
  • Expertise in automating, scripting, and streamlining processes for efficiency and accuracy (Unix shell scripting or similar tools).
  • Ability to develop standardized database installation and configuration processes and procedures.
  • Strong experience in performance tuning using OEM or third-party tools, advanced stats gathering, understanding of Oracle 19c/18c optimizer behavior, and knowledge of Oracle new features.
  • Proficiency in scheduling and using ASH/AWR/ADDM reports and taking corrective actions.
  • Strong experience with Disaster Recovery environments
  • Comprehensive understanding of Oracle backup methodologies and their implementation via GUI and scripts, including RMAN backups and database restores.
  • Serves as SME for Oracle Database and provides direction and mentorship to support the success of the entire team.
  • Hands on experience with database management on AWS RDS, EC2 environments
  • Implement and maintain database security policies and procedures.
  • Ensure data is encrypted in transit and at rest.