AWS Redshift DBA - Ztek Consulting INC

Job Title: AWS Redshift DBA

Location: Irvine, CA

Position Type: Full-time

Work Type: Onsite

Salary: Base salary range around 90k to 130k + relocation expenses & client approved benefits.

Job Description:

Technical/Functional Skills

1) 4+ years of hands-on experience in Amazon Redshift database administration.

2) Strong expertise in query performance tuning, including analyzing and optimizing SQL queries for Redshift.

3) In-depth knowledge of Amazon Redshift Workload Management (WLM), including queue configurations and query prioritization.

4) Experience with Redshift Serverless and understanding of its use cases and cost-benefit advantages for scalable workloads.

5) Strong understanding of Redshift architecture, including distribution keys, sort keys, and data compression techniques.

6) Ability to monitor and troubleshoot Redshift clusters using CloudWatch, Enhanced VPC Routing, and other AWS monitoring tools.

7) Familiarity with Redshift security best practices, including IAM policies, data encryption, and auditing.

8) Excellent problem-solving and communication skills, with the ability to collaborate across teams to solve database-related challenges.

AWS certifications (e.g., AWS Certified Database Specialty, AWS Certified Solutions Architect) are a plus.

Roles & Responsibilities

Administer and manage Amazon Redshift clusters and Redshift Serverless environments, ensuring performance, scalability, and availability.

Perform in-depth query tuning and optimization to improve performance, minimize latency, and optimize resource utilization in Redshift environments.

Configure and manage Redshift Workload Management (WLM) settings and queues to optimize workload performance and resource allocation.

Monitor an d manage query performance, disk space, and cluster health, ensuring optimal Redshift performance across all environments.

Troubleshoot and resolve complex performance issues, identifying bottlenecks in queries, memory usage, and CPU utilization.

Implement automation scripts for monitoring, scaling, and managing Redshift clusters and query workloads.

Collaborate with data engineers, analysts, and developers to support data ingestion, transformation, and reporting workloads on Redshift.

Implement data security best practices, including data encryption, user access control, and monitoring of security policies in Redshift.

Provide guidance and expertise on using Redshift Serverless, helping teams transition to serverless for dynamic and scalable workloads.

Maintain and update documentation for cluster configurations, query optimization techniques, and WLM settings.

ABOUT Ztek:

Website: www.ztekinc.com

Ztek Consulting Inc is a minority- and woman-owned business enterprise that leverages a unique blend of human talent, machine learning algorithms, and artificial intelligence to provide customized talent management solutions for clients. Ztek's diversity-focused hiring models have proven successful, particularly in hiring veterans. The company's veteran-focused hiring and deployment program, Z-V.E.T, matches skilled veterans with clients' needs in various areas.

Disclaimer:

Ztek is an Equal Opportunity Employer and prohibits any kind of unlawful discrimination and harassment. Ztek is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment on the basis of race, color, religion or belief, national origin, citizenship, social or ethnic origin, sex, age, physical or mental disability, veteran status, marital status, domestic partner status, sexual orientation, or any other status protected by the statutes, rules, and regulations in the locations where it operates. If you are an individual with a disability and need a reasonable accommodation to assist with your job search or application for employment, please contact us at hrd@ztekinc.com Please indicate the specifics of the assistance needed. Ztek encourages all interested and qualified candidates to apply for employment opportunities. Ztek does not discriminate against applicants based on citizenship status, immigration status, or national origin, in accordance with 8 U.S.C. 1324b.