Cloud Database Analyst

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.