S4 Analytics LLC

Amazon Database Administartor

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for an Amazon Database Administrator with 8+ years of experience, focusing on Amazon Redshift and Google BigQuery. Contract length and pay rate are unspecified. Onsite in Chicago for 3 days a week; strong SQL and ETL/ELT skills required.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
February 18, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
On-site
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Chicago, IL
-
🧠 - Skills detailed
#Clustering #Debugging #Data Security #Monitoring #Observability #Redshift #SQL (Structured Query Language) #Disaster Recovery #Scala #Talend #Data Modeling #Data Warehouse #"ETL (Extract #Transform #Load)" #Database Administration #Airflow #BigQuery #AWS (Amazon Web Services) #Cloud #Automation #DBA (Database Administrator) #Data Engineering #Security #Amazon Redshift #Schema Design #Database Monitoring #Storage #Compliance #GCP (Google Cloud Platform) #Deployment #dbt (data build tool)
Role description
Role : Amazon Database Administrator (DBA) with deep expertise in Amazon Redshift and Google BigQuery Location : Onsite Chicago 3 days 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. • Jr IT Recruiter | S4 Analytics • Phone: +1 (469)-429-8065 • Email: Pavan@s4analytix.com