Cloud Database Analyst

Job: Cloud Database Analyst

Location: Remote

Duration: Long Term

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.