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:
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 status.
At 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 HRsupport@randstadusa.com.
Pay 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.