• aws redshift database expert nj hybrid or remote

    Randstad USEdison, NJ 08899

    Job #2710942580

  • aws redshift database expert nj hybrid or remote.

    • edison , new jersey

    • posted 2 days ago

    job details

    summary

    • $65 - $88 per hour

    • contract

    • bachelor degree

    • category computer and mathematical occupations

    • reference1056433

    job details

    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 required.

    location: Edison, New Jersey

    job type: Contract

    salary: $65 - 88 per hour

    work hours: 8am to 4pm

    education: Bachelors

    responsibilities

    Responsibilities

    Database Architecture and Design

    Design, implement, and maintain AWS RedShift databases.

    Optimize database schemas for performance and scalability.

    Implement best practices in data modeling and database design.

    Must have, Performance Tuning and Design and Optimization

    Monitor and optimize query performance using tools and tuning parameters.

    Identify and resolve performance bottlenecks in queries, ETL processes, and data loading.

    Implement caching strategies and indexing to improve query performance.

    Data Security and Integrity

    Implement and maintain database security policies and procedures.

    Ensure data integrity and reliability through proper backup and recovery processes.

    Monitor database logs and alerts to proactively identify and mitigate issues.

    Collaboration and Documentation

    Work closely with developers, data engineers, and analysts to understand data requirements and optimize database performance.

    Document database architecture, processes, and procedures.

    Provide guidance and support to team members on database-related issues.

    Requirements

    Proven experience as a Database Administrator or similar role with a focus on AWS RedShift.

    In-depth knowledge of AWS RedShift architecture, configuration, and performance tuning.

    Experience in database design, data modeling, and implementation of ETL processes.

    SQL skills and proficiency in scripting languages (e.g., Python, Bash) for automation.

    Excellent problem-solving and analytical skills.

    Ability to work independently and collaboratively in a fast-paced environment.

    communication skills with the ability to explain complex technical concepts to non-technical stakeholders.

    Preferred Qualifications

    AWS certifications related to database technologies (e.g., AWS Certified Database - Specialty).

    Experience with data warehousing concepts and methodologies.

    qualifications

    • Experience level: Experienced

    • Minimum 6 years of experience

    • Education: Bachelors

    skills

    • AWS CloudWatch

    • Amazon Web Services (AWS)

    • Amazon Web Services (AWS)Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group ~~~ Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact ~~~ offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).Applications accepted on ongoing basis until filled.