Logo
TALENT Software Services

Analyst, Database II

TALENT Software Services, Columbia, South Carolina, us, 29228

Save Job

Overview

Join our team in Columbia, SC, where you will have the opportunity to work on cutting-edge cloud data solutions in a vibrant and dynamic environment. Enjoy the charm of this Southern city while advancing your career with us. Responsibilities

Collaborate with stakeholders to define business and technical requirements for cloud data solutions Ensure database architectures and configurations align with enterprise cloud standards Manage and optimize cloud-hosted databases (e.g., AWS RDS, Azure SQL) Write and tune SQL queries for performance and scalability Use monitoring tools (CloudWatch, Azure Monitor) to track DB health and performance Support large-scale cloud projects with expertise in:

Data architecture Backup/DR strategies High availability

Participate in planning sessions and help prioritize analysis activities Automate routine tasks using scripting languages like Python or PowerShell Qualifications & Skills

Cloud Data Migration & Deployment

Experience in Cloud Data Migration and CI/CD pipelines Lead lift-and-shift and cloud-native deployment projects to AWS, Azure, or GCP Design and implement:

High Availability (HA) Backup/restore strategies Snapshots Disaster Recovery (DR) across multiple regions Data replication Failover configurations

Database Platforms & Management

Cloud-hosted databases: AWS: RDS, Aurora, DynamoDB, EC2-hosted DBs Azure: Azure SQL GCP: Cloud SQL Proficient in:

Provisioning, configuration, and performance tuning of cloud databases SQL performance tuning, indexing, and writing complex queries Execution plan analysis and large dataset optimization

Infrastructure Automation & DevOps

Infrastructure as Code (IaC): Tools: Terraform, ARM Templates, CloudFormation Automate infrastructure provisioning and ensure environment consistency Familiarity with CI/CD tools for deployment automation

Security & Compliance

Enforce cloud security standards:

IAM, VPC policies, data classification

Knowledge of compliance frameworks:

NIST 800-53, FedRAMP, HIPAA, PCI

Experience with data encryption, security policies, and compliance requirements

Monitoring & Performance

Tools for cloud DB monitoring:

AWS: CloudWatch, Enhanced Monitoring, Performance Insights Azure: Azure Monitor 3rd-party: SolarWinds, Redgate

Monitor performance, availability, and health of cloud databases

Agile & Collaboration Tools

Experience in Agile environments Familiarity with JIRA and Confluence for task and documentation management

Nice to Have

Experience with relational (e.g., Oracle) and non-relational databases (cloud & on-prem) Experience managing semi-structured or unstructured data in cloud-native apps Cloud Certifications (AWS, Azure, GCP) Exposure to data warehousing and analytics tools:

Redshift, QuickSight, AWS Glue

Day-to-Day Responsibilities

Collaborate with stakeholders to define business and technical requirements for cloud data solutions Ensure database architectures and configurations align with enterprise cloud standards Manage and optimize cloud-hosted databases (e.g., AWS RDS, Azure SQL) Write and tune SQL queries for performance and scalability Use monitoring tools (CloudWatch, Azure Monitor) to track DB health and performance Support large-scale cloud projects with expertise in:

Data architecture Backup/DR strategies High availability

Participate in planning sessions and help prioritize analysis activities Automate routine tasks using scripting languages like Python or PowerShell Employment type: Full-time Seniority level: Mid-Senior level Job function: Other Industries: IT Services and IT Consulting

#J-18808-Ljbffr