job summary: Our enterprise client has a consulting opportunity in Central New Jersey Hybrid or possible remote. Candidate will be a highly skilled AWS RedShift Database Expert with deep expertise in RedShift architecture, performance tuning, and database design. This role is pivotal in maintaining and optimizing our data infrastructure to ensure maximum efficiency, reliability, and scalability. Experience with Performance Tuning and Design are requir
[
"
Responsibilities:
\n\n
Database Architecture and Design:
\n\n
Design, implement, and maintain AWS RedShift databases.
\n\n
Optimize database schemas for performance and scalability.
\n\n
Implement best practices in data modeling and database design.
\n\n
Must have, Performance Tuning and Design and Optimization
\n\n
Monitor and optimize query performance using tools and tuning parameters.
\n\n
Identify and resolve performance bottlenecks in queries, ETL processes, and data loading.
\n\n
Implement caching strategies and indexing to improve query performance.
\n\n
Data Security and Integrity:
\n\n
Implement and maintain database security policies and procedures.
\n\n
Ensure data integrity and reliability through proper backup and recovery processes.
\n\n
Monitor database logs and alerts to proactively identify and mitigate issues.
\n\n
Collaboration and Documentation:
\n\n
Work closely with developers, data engineers, and analysts to understand data requirements and optimize database performance.
\n\n
Document database architecture, processes, and procedures.
\n\n
Provide guidance and support to team members on database-related issues.
\n\n
Requirements:
\n\n
Proven experience as a Database Administrator or similar role with a focus on AWS RedShift.
\n\n
In-depth knowledge of AWS RedShift architecture, configuration, and performance tuning.
\n\n
Experience in database design, data modeling, and implementation of ETL processes.
\n\n
SQL skills and proficiency in scripting languages (e.g., Python, Bash) for automation.
\n\n
Excellent problem-solving and analytical skills.
\n\n
Ability to work independently and collaboratively in a fast-paced environment.
\n\n
communication skills with the ability to explain complex technical concepts to non-technical stakeholders.
\n\n
Preferred Qualifications:
\n\n
AWS certifications related to database technologies (e.g., AWS Certified Database - Specialty).
\n\n
Experience with data warehousing concepts and methodologies.
\n\n
\n
"
]