Oracle database architect

Oracle database architect

Posted Today by HAN IT Staffing Inc.

Negotiable
Undetermined
Remote
Remote

Summary: The Oracle Database Architect role focuses on managing and optimizing Oracle and Azure Cloud databases, including provisioning, configuration, and performance tuning. The position requires expertise in automation, security compliance, and disaster recovery solutions. Candidates should have a strong background in database administration and experience with tools like GoldenGate. The role is remote, allowing for flexibility in work arrangements.

Key Responsibilities:

  • Provisioning and configuring database instances, including scaling and managing storage.
  • Configuring High Availability (HA) and Disaster Recovery (DR) solutions.
  • Proactively monitoring CPU, storage, and network usage for performance optimization.
  • Implementing data encryption and managing access controls for security compliance.
  • Using scripting and Infrastructure as Code (IaC) for automation of maintenance and deployments.

Key Skills:

  • Proficiency in Azure Cloud, Azure SQL, and Oracle Cloud Infrastructure (OCI).
  • Core Oracle DBA with CDB and PDB migration expertise.
  • Experience with GoldenGate Service on Cloud, including tuning and troubleshooting.
  • Familiarity with CI/CD tools, Terraform, and CLI scripting.
  • Good knowledge of physical database design and performance monitoring.
  • Bachelor's degree in Computer Science or a related field.
  • 3-5 years of database administrator experience.

Salary (Rate): undetermined

City: undetermined

Country: undetermined

Working Arrangements: remote

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:
ORACLE CLOUD DBA- Cloud should be Azure, Oracle golden gate
Provisioning & ConfigurationSetting up and scaling database instances.Managing storage.
Configuring High Availability (HA) and Disaster Recovery (DR) solutions (e.g., replication).
Performance Monitoring & TuningProactively monitoring CPU, storage, and network usage to ensure performance.
Using native tools for optimization and troubleshooting.Security & ComplianceImplementing data encryption.
Managing access controls (Identity and Access Management).
Ensuring compliance with regulations such as GDPR or HIPAA.AutomationUsing scripting (SQL, Python, Bash) and Infrastructure as Code (IaC) to automate routine maintenance and deployments.
Qualifications / RequirementsTo perform this job successfully, an individual must be able to perform each essential duty satisfactorily.
Requirements
Proficiency in Azure Cloud, Azure SQL, and Oracle Cloud Infrastructure (OCI).Core Oracle DBA with CDB and PDB migration expertise.
Experience with GoldenGate Service on Cloud, including tuning and troubleshooting.
Experience with on-premises databases and standby database expertise.
Familiarity with CI/CD tools, Terraform, and CLI scripting.Understanding of VPCs, security groups, VPNs, and firewalls.
Education & Experience
Bachelor's degree in Computer Science or a related field.
3 5 years of database administrator experience.
Good knowledge and experience working with Oracle or SQL Server.
Experience with operating system commands and scripting.
Good knowledge of physical database design.
Ability to proactively perform Oracle, SQL Server, and operating system performance monitoring.
Excellent knowledge of Oracle and SQL Server database backup and recovery scenarios.Good skills in various database monitoring tools.
Experience with cross-database replication (e.g., GoldenGate product preferred).
Good understanding of database security management.
Good knowledge of how the database acquires and manages resources.
Sound knowledge of database query optimization.