Role : Amazon DB operation and Support Admin
Location : Remote
Rate : 60$(DoE)
We are seeking an experienced Database Administrator (DBA) with deep expertise in Amazon Redshift and Google BigQuery. The ideal candidate will bring a strong blend of hands-on administration skills, performance tuning, and an architectural mindset to support our modern data platforms. This role is critical to ensuring our data infrastructure is secure, scalable, cost-optimized, and highly available while enabling advanced analytics and business insights.
Responsibilities
- Database Administration & Operations
- Manage, monitor, and optimize Amazon Redshift and Google BigQuery environments.
- Implement robust backup, recovery, and disaster recovery strategies.
- Oversee user management, access controls, and security compliance.
- Perform capacity planning, cost monitoring, and performance tuning to ensure efficient query execution and storage usage.
- Partner with data engineering and analytics teams to design and implement scalable data warehouse architectures.
- Evaluate and recommend partitioning, clustering, and distribution strategies for optimal performance.
- Contribute to data modeling and best practices for schema design to support analytics workloads.
- Automation & Optimization
- Build scripts and automation for database monitoring, deployments, and maintenance tasks.
- Optimize ETL/ELT pipelines with a focus on query performance and cost efficiency.
- Implement observability tools for query execution and workload management.
Qualifications
- Required Skills & Experience
- 8+ years of experience as a Database Administrator, Data Engineer, or similar role.
- Proven hands-on expertise with Amazon Redshift and Google BigQuery (administration, performance tuning, workload management).
- Strong knowledge of SQL, query optimization, and data modeling techniques.
- Experience with ETL/ELT pipelines and integration with tools like dbt, Airflow, or Talend.
- Solid understanding of cloud infrastructure (AWS, GCP) and data security best practices.
- Strong problem-solving and debugging skills in complex distributed systems.
Job Type: Contract
Pay: Up to $60.00 per hour
Work Location: Remote
