Cloud Database Specialist
We are seeking an experienced Cloud Database Specialist to design and manage cloud-based database solutions. The ideal candidate will have a strong background in cloud database administration, with expertise in AWS RDS and experience with migration, automation, integration, performance optimization, security, and compliance.
Main Responsibilities:
* Design and manage cloud-based database solutions on AWS RDS (Oracle, PostgreSQL, SQL Server), with exposure to GCP, Azure, or OCI as a plus.
* Migrate and automate databases between on-premises and cloud, enhancing replication and automating migration processes.
* Integrate and share data between databases and external systems for analytics and reporting, leveraging tools such as AWS DMS, Snowflake, and Matillion.
* Optimize performance to ensure high availability, scalability, and reliability of cloud database solutions.
* Secure and comply with best practices and regulations (GDPR, ISO 27001), implementing encryption, IAM policies, and network segmentation.
* Prepare and execute robust backup and disaster recovery strategies to ensure business continuity.
* Monitor and troubleshoot database performance, proactively identifying and resolving issues.
Requirements:
* 5+ years of experience in database administration, focusing on cloud-based solutions.
* Expertise in AWS RDS (PostgreSQL, Oracle, SQL Server) and familiarity with DynamoDB or other cloud-native databases.
* Data migration and replication skills, including AWS DMS, Schema Conversion Tool, and cloud-native replication solutions for seamless cross-cloud data movement.
* Performance optimization expertise, covering SQL tuning, indexing, and query optimization.
* Backup and disaster recovery experience, including replication, failover, and high-availability strategies.
* Infrastructure as Code (IaC) proficiency using Terraform or CloudFormation for automated database deployments.
* Security and compliance knowledge, including IAM roles, database encryption, GDPR/ISO 27001 standards.
* Automation and monitoring skills using scripting (Python, Bash, PowerShell) and tools like CloudWatch, Dynatrace.
Nice to Have:
* Cloud certifications, such as AWS Certified Solutions Architect, AWS Certified Database, or Oracle Certified Professional (OCP).
* Experience in NoSQL, including databases like DynamoDB or MongoDB.
* Data warehousing knowledge with solutions like Snowflake, BigQuery, or Redshift.
* Ability to implement and optimize autonomous databases, such as Oracle Autonomous Database, by leveraging self-managing, self-securing, and self-repairing capabilities.
* Familiarity with Oracle Exadata, including Smart Scan, Storage Indexes, Hybrid Columnar Compression (HCC) for performance optimization; Oracle RAC, Data Guard, and RMAN for high availability and disaster recovery; automation with Ansible, Terraform, or Oracle Enterprise Manager (OEM) for Exadata management.
* Knowledge of Oracle GoldenGate for real-time replication, data integration, and cross-platform migration in hybrid/multi-cloud environments.
About the Opportunity:
* A career-defining opportunity with full exposure to leading technology.
* An international culture and environment with the opportunity to partner with an outstanding group of people and professionals who joined the company to scale and succeed.
At [Company], we value diversity and are committed to equal employment opportunities regardless of religion, age, disability, sexual orientation, gender perception or identity, ethnicity, or place of origin.