Lorgan Technologies
Amazon Database Administrator
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for an Amazon Database Administrator with 8+ years of experience, specializing in Amazon Redshift and Google BigQuery. It offers a contract length of unspecified duration, a pay rate of $60/hour, and requires onsite work in Chicago 3 days a week.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
480
-
🗓️ - Date
February 8, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
Hybrid
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Chicago, IL 60617
-
🧠 - Skills detailed
#Scala #Storage #Redshift #Schema Design #Disaster Recovery #Cloud #Database Monitoring #Observability #Airflow #Talend #GCP (Google Cloud Platform) #SQL (Structured Query Language) #Automation #BigQuery #Clustering #Data Security #Amazon Redshift #Debugging #Data Modeling #Data Warehouse #Compliance #Data Engineering #Database Administration #AWS (Amazon Web Services) #"ETL (Extract #Transform #Load)" #Monitoring #Deployment #Security #dbt (data build tool) #DBA (Database Administrator)
Role description
Role : Amazon Database Administrator (DBA) with expertise in Amazon Redshift and Google BigQuery
Location : Onsite Chicago 3 days
Rate : $60
Interview : Video call and potentially in person interview in Chicago
JD :
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.
Architecture & Design
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.
Pay: Up to $60.00 per hour
Work Location: Hybrid remote in Chicago, IL 60617
Role : Amazon Database Administrator (DBA) with expertise in Amazon Redshift and Google BigQuery
Location : Onsite Chicago 3 days
Rate : $60
Interview : Video call and potentially in person interview in Chicago
JD :
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.
Architecture & Design
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.
Pay: Up to $60.00 per hour
Work Location: Hybrid remote in Chicago, IL 60617
