Negotiable
Outside
Remote
USA
Summary: The Cloud Database Analyst role focuses on migrating databases and data pipelines to cloud environments while ensuring minimal downtime. The position requires collaboration with various teams to gather data requirements and involves database administration, monitoring, and automation tasks. The analyst will also contribute to data architecture and participate in Agile methodologies to enhance operational efficiencies. Proficiency in cloud database platforms and security compliance is essential for success in this role.
Key Responsibilities:
- Engage with business and technical teams to gather and clarify data requirements.
- Provision, configure, and maintain cloud-hosted relational databases.
- Perform performance tuning, query optimization, and capacity planning.
- Utilize monitoring tools to proactively resolve database health and performance issues.
- Contribute to the design of data backup and recovery strategies.
- Develop scripts to automate routine operational tasks.
- Participate in Agile ceremonies and assist in prioritizing workload.
- Collaborate with infrastructure, DevOps, and application teams to implement database solutions.
Key Skills:
- Proven experience in cloud data migration.
- Working knowledge of Agile methodologies and tools like Jira and Confluence.
- Expertise in writing complex SQL queries and optimizing database performance.
- Practical experience with Infrastructure as Code (IaC) tools like Terraform.
- Familiarity with security standards such as NIST 800-53 and FedRAMP.
- Hands-on experience with database monitoring tools.
- Proficiency in cloud database platforms like AWS RDS and Azure SQL Database.
- Experience with relational and non-relational databases.
- Preferred cloud certifications (AWS, Azure, Google Cloud).
Salary (Rate): undetermined
City: undetermined
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
Role: Cloud Database Analyst
Required Skills & Experience
Cloud Data Migration: Proven experience in migrating databases and data pipelines to cloud environments with minimal downtime.
Agile Methodologies: Working knowledge of Agile frameworks with hands-on experience using Jira and Confluence to manage tasks and collaborate with cross-functional teams.
SQL & Database Query Optimization:
o Expertise in writing complex SQL queries for large-scale data sets.
o Ability to analyze and optimize query execution plans and enhance overall database performance.
Infrastructure as Code (IaC): Practical experience with Terraform, ARM Templates, or CloudFormation to automate database infrastructure deployment and management.
Security & Compliance Frameworks: Familiarity with security standards and regulatory frameworks such as NIST 800-53 and FedRAMP, ensuring compliance in database solutions.
Database Monitoring & Management:
o Hands-on experience with monitoring tools such as AWS CloudWatch, Azure Monitor, or third-party tools like SolarWinds and Redgate to oversee database health, performance, and uptime.
Cloud Database Platforms:
o Proficiency in provisioning, configuring, and optimizing cloud-hosted databases including AWS RDS, Azure SQL Database, or Google Cloud SQL.
o Experience managing high-availability, backup and restore, and performance tuning in cloud environments.
Nice to Have
Multi-Platform Database Experience:
o Experience working with relational databases (Oracle) and non-relational databases for semi-structured or unstructured data, across both cloud and on-premises environments.
Cloud Certifications:
o AWS, Azure, or Google Cloud certifications are preferred, showcasing validated expertise in cloud platforms.
Day-to-Day Responsibilities
As a Cloud Database Analyst, your primary role will include:
Stakeholder Collaboration: Engage with business and technical teams to gather and clarify data requirements, ensuring alignment with enterprise cloud architecture standards and customer objectives.
Database Administration:
o Provision, configure, and maintain cloud-hosted relational databases (AWS RDS, Azure SQL, Google Cloud Platform Cloud SQL).
o Perform performance tuning, query optimization, and capacity planning.
Monitoring and Troubleshooting:
o Utilize tools like CloudWatch, Azure Monitor, or equivalent to proactively monitor and resolve database health and performance issues.
Data Architecture Support:
o Contribute to the design of data backup and recovery strategies, replication, and high-availability configurations.
o Provide architectural input for large-scale cloud IT projects.
Automation and Scripting:
o Develop scripts (e.g., Python, PowerShell) to automate routine operational tasks and enforce configuration consistency.
Agile Participation:
o Actively participate in Agile ceremonies, backlog grooming, and planning sessions.
o Assist in prioritizing workload and driving operational efficiencies.
Cross-Team Communication:
o Collaborate with infrastructure, DevOps, and application teams to implement robust and secure database solutions.
o Communicate complex technical topics clearly to both technical and non-technical stakeholders.