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
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.
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.